1.rpm -qa | grep mysql #查看是否安装mysql
2.rpm -e --nodeps 名称 #将上面查询的东西能删除都删掉
3.rpm -ivh http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
4.yum install -y mysql-server #安装 mysql,显示Complete!代表成功
5.systemctl enable mysqld.service #设置开机启动
6.systemctl start mysqld.service #运行mysql
有些人到6部的时候会卡住,此时:#查看日志文件 tail -f /var/log/mysqld.log
错误一:error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
解决一:yum install -y libaio
错误二:Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
解决二:执行 mysql_install_db --user=mysql 命令初始化数据库
然后一定要ps -aux | grep mysql ,杀掉当前的mysql
7.systemctl start mysqld.service #执行后应该会瞬间完成
8.mysql #登入mysql 此版本默认一般没有密码
9.mysql>set password for root@localhost=password('P@ssw0rd1!'); #创建账号密码
10.vim /etc/my.cnf #在里面输入bind-address=127.0.0.1 (本地连接)或 bind-address = 0.0.0.0(远程连接,任意用户)保存后kill当前mysql
11.systemctl start mysqld.service #重新启动mysql