1.下载

  1. cd /user/local
  2. wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
  4. #删掉mariadb
  5. rpm -qa | grep mariadb
  6. yum remove mariadb-xxx
  8. tar -zxvf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz 
  10. mv mysql-5.7.31-linux-glibc2.12-x86_64 mysql
  12. #创建mysql用户组和用户并修改权限
  13. groupadd mysql
  14. useradd -r -g mysql mysql
  16. #配置mysql
  17. vim /etc/my.cnf
  18. #写入
  19. [mysqld]
  20. bind-address=0.0.0.0
  21. port=3306
  22. user=mysql
  23. basedir=/usr/local/mysql
  24. datadir=/data/mysql
  25. socket=/tmp/mysql.sock
  26. log-error=/data/mysql/mysql.err
  27. pid-file=/data/mysql/mysql.pid
  28. #character config
  29. character_set_server=utf8mb4
  30. symbolic-links=0
  31. explicit_defaults_for_timestamp=true
  33. cd /usr/local/mysql/bin/
  35. #初始化
  36. ./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize
  38. #查看密码
  39. cat /data/mysql/mysql.err
  41. cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
  43. #启动mysql
  44. service mysql start
  46. ps -ef|grep mysql
  48. ./mysql -u root -p
  50. SET PASSWORD = PASSWORD('gaoshuai@123');
  51. ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
  52. FLUSH PRIVILEGES;                                 
  54. use mysql                                            #访问mysql库
  55. update user set host = '%' where user = 'root';      #使root能再任何host访问
  56. FLUSH PRIVILEGES;                                    #刷新
  58. #软连接 可以在/usr/bin 下执行mysql
  59. ln -s  /usr/local/mysql/bin/mysql    /usr/bin