1.下载mysql源安装包命令:
wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
2. 安装mysql源命令:
yum localinstall mysql80-community-release-el7-1.noarch.rpm
直到出现complete! 说明MySQL源安装完成。
3.检测mysql是否安装完成:
yum repolist enabled | grep "mysql.*-community.*"
4.安装mysql: yum install mysql-community-server
yum -y install mysql-community-server --nogpgcheck
5。设置开启启动mysql服务:
systemctl enable mysqld
6.查看安装的mysql版本:
rpm -aq | grep -i mysql
7.启动MySQL服务:
systemctl start mysqld
8.查看MySQL初始密码:
grep 'A temporary password' /var/log/mysqld.log
9.使用已经获得到的临时密码登陆:
mysql: mysql -u root -p
若出现以下错误:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
则在/etc/my.cnf文件中加入以下内容:
skip-grant-tables(登录时跳过权限检查)
保存文件,并重新启动mysql服务:systemctl restart mysqld
修改密码认证强度:set global validate_password.policy=0;
修改mysql密码: ALTER USER "root"@"localhost" IDENTIFIED BY '你的新密码'; 需要有引号!
设置的新密码需要有包含 数字,字母,特殊字符
修改之后登陆显示数据库: show databases;
10.开放3306端口:
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
11.navicat远程连接:
12.解决1251问题:
数据库mysql相关异常:ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'_牛人NR的博客-CSDN博客