
正文
CentOS 6.8 32位 安装mysql8
提示:扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
1.清理掉之前安装过的mysql
rpm -qa | grep mysql
mysql-libs-5.1.52-1.el6_0.1.x86_64
yum remove mysql-libs-5.1.52-1.el6_0.1.x86_64
rm -fr /var/lib/mysql/*
rm /var/lock/subsys/mysqld
killall mysqld
2.yum源安装MYSQL
wget https://repo.mysql.com//mysql80-community-release-el6-1.noarch.rpm
rpm -ivh mysql80-community-release-el6-1.noarch.rpm
yum clean all
yum makecache
yum install mysql-community-server
3.启动MySQL
/etc/init.d/mysqld start
4.如果启动成功请忽略,如果启动mysql报错 mysqld:unrecognized service
可能是mysql-server没有安装
rpm -q mysql
安装mysql的server端
yum install mysql-server
然后再输入/etc/init.d/mysqld start 启动成功
5.登录前先找到默认登陆密码
grep "password" /var/log/mysqld.log
6.登陆
mysql -u root -p
然后输入默认的登陆密码
7.navicat 连接阿里云服务器上的MySQL
修改密码,mysql8.0以上密码策略限制必须要大小字母写加数字特殊符号
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码要复杂';
修改root的host为%
update user set Host='%' where User='root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '数据库密码';
FLUSH PRIVILEGES;
设置安全组规则:

(觉得图片看不清,请Ctrl+鼠标滚动)
然后navicat数据用户名和密码 就可以登录了
CentOs防火墙 https://blog.csdn.net/u014110320/article/details/82977627
参考https://blog.csdn.net/zzzgd_666/article/details/81458630








