centos中mysql 安装以及配置
- 下载mysql的rpm包
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
- 安装mysql源
yum localinstall mysql57-community-release-el7-8.noarch.rpm
- 安装
mysql yum install -y mysql-community-server
- 查询mysql版本
mysql -V
- 启动mysql服务
systemctl start mysqld
- mysql开启启动
systemctl enable mysqld
- 查看mysql密码
grep 'temporary password' /var/log/mysqld.log
- 登陆mysql
mysql -uroot -p
- 修改密码
1、设置安全级别 set global validate_password_policy=0;
2、默认密码为8,可以设置为其他值,最小4位 set global validate_password_length=4;
3、设置root密码 set password for root@localhost = password(‘新密码’);
- 进入
mysql use mysql;
- 修改root远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
- 更新数据库
FLUSH PRIVILEGES;
常见问题:
-
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
密码安全性不够
解决办法:1、查看 mysql 初始的密码
SHOW VARIABLES LIKE 'validate_password%';
进行查看,2、设置密码的验证强度等级
set global validate_password_policy=LOW;
3、设置密码的长度
set global validate_password_length=6;
4、修改密码
update user set authentication_string = password ( '123456' ) where user = 'root' ;
5、退出,重启mysql
-
远程连接mysql 提示 Access denied for user ‘root’@‘xxx.xxx.x.xxx’ (using password: YES)
远程连接权限问题,默认root用户是不能进行远程访问连接的。
如果忘记密码-
找到my.ini 文件、在[mysqld] 下 加上
skip-grant-tables
-
重新进入mysql,
mysql -uroot -p
,无密码登陆, -
修改密码
update user set authentication_string = password ( '123456' ) where user = 'root' ;
然后把my.ini文件恢复,重新登陆 -
进入mysql
use mysql;
-
开放权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
-