安装

  1. # 先卸载mariadb
  2. rpm -qa | grep mariadb
  3. sudo rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
  5. # 检测系统是否自带安装mysql
  6. yum list installed | grep mysql
  8. # 如果发现有系统自带mysql
  9. yum -y remove mysql-libs.x86_64
  11. # 下载源文件（repo）
  12. wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
  14. # 安装（repo）
  15. sudo rpm -ivh mysql-community-release-el6-5.noarch.rpm
  16. # 安装mysql
  17. sudo yum install -y mysql-community-server && rm mysql-community-release-el6-5.noarch.rpm
  20. # 启动服务
  21. service mysqld start
  23. # 初始化设置
  24. mysql -u root
  25. use mysql;
  26. update user set password=PASSWORD("tianyunali") where User='root';
  27. grant all privileges on *.* to 'root'@'%' identified by 'tianyunali' with grant option;
  28. flush privileges; 
  30. # 开机启动
  31. sudo chkconfig --add mysqld && 
  32. sudo chkconfig mysqld on
  34. mysql安全设置（必须！！！）
  35. mysql_secure_installation
  37. # 防火墙：
  38. #开放3306端口
  39. /sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
  40. service iptables save

配置

内存会在100M以内

  1. sudo vim /etc/my.cnf
  3. innodb_buffer_pool_size=128M
  4. query_cache_size=16M
  5. tmp_table_size=64M
  6. key_buffer_size=32m
  7. performance_schema_max_table_instances=400
  8. table_definition_cache=400
  9. table_open_cache=256
  11. [client]
  12. default-character-set = utf8mb4
  13. [mysql]
  14. default-character-set = utf8mb4
  15. [mysqld]
  16. character-set-client-handshake = FALSE
  17. character-set-server = utf8mb4
  18. collation-server = utf8mb4_unicode_ci
  20. service mysqld restart

卸载

  1. # 先关闭服务
  2. systemctl stop mysqld
  4. # 关闭相关进程
  5. ps -ef |grep -i mysql
  6. # kill -9 pid
  8. # 删除自启动
  9. chkconfig --del mysqld
  11. yum remove  mysql mysql-server mysql-libs mysql-server;
  12. rpm -qa|grep -i mysql | xargs yum -y remove
  13. rm -rf /usr/lib/mysql
  14. rm -rf /usr/share/mysql
  15. rm -rf /usr/my.cnf
  16. rm -rf /etc/my.cnf
  18. # 删除其他文件
  19. find / -name mysql