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
网友评论