centos7.6上安装mysql

2019-10-24  本文已影响0人  青岛大桥_Android到后端

https://blog.csdn.net/xyang81/article/details/51759200
MySQL5.7安装与配置(YUM)

如果安装遇到问题别忘了

https://blog.csdn.net/qq_38417808/article/details/81291588

开放远程连接mysql (navicat或mysql workbench等)
GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;


关于安装mysql另一篇正规文章

https://www.cnblogs.com/Guhongying/p/10908553.html


关于开放远程连接


关于刚安装好,linux下一定要忽略大小写
/usr/sbin/mysqld --initialize --user=mysql --lower-case-table-names=1


关于改root密码
重新操作一遍:

vim /etc/my.cnf

【mysql】
添加skip-grant-table

systemctl stop mysqld.service

systemctl start mysqld.service

mysql –u root

[敲回车进入]
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> alter user 'root'@'localhost'IDENTIFIED BY 'MyNewPass';

ERROR 1819 (HY000): Your password does notsatisfy the current policy requirements

mysql> alter user 'root'@'localhost'IDENTIFIED BY 'MyNewPass@123';

ERROR 1396 (HY000): Operation ALTER USERfailed for 'root'@'localhost'

mysql> alter user'root'@'%' IDENTIFIED BY 'MyNewPass@123';

mysql8.0以上密码策略限制必须要大小写加数字特殊符号,我之前用mysqladmin,set,update,参考修改root密码的前人http://www.cnblogs.com/liufei88866/p/5619215.html

Query OK, 0 rows affected (0.05 sec)

退出,把Skip-grant-table语句删除,重新启动数据库

[root@localhost ~]# vim /etc/my.cnf【删除省略】

[root@localhost ~]# systemctl stopmysqld.service

[root@localhost ~]# systemctl startmysqld.service

[root@localhost ~]# mysql -uroot –p

上一篇 下一篇

猜你喜欢

热点阅读