一、问题描述
原文链接:https://blog.csdn.net/learner_lps/article/details/62887343
配置文件/etc/mysql/my.cnf下没有[mysqld]这一段啊
后来,笔者又在网上折腾了许久,终于在/etc/mysql/mysql.conf.d/mysqld.cnf 这个文件里找到了[mysqld]这一段,感动啊
至此笔者认为,mysql5.7.17将原先意义的my.cnf改为mysqld.cnf,并放在/etc/mysql/mysql.conf.d/路径下。
到此,笔者遇到问题总算解决了,真是开心呀!
下面笔者介绍自己的mysql安装过程和问题的具体解决过程。
二、mysql安装过程
在ubuntu终端下依次输入命令:
$ sudo apt update
$ sudo apt-get install mysql-server mysql-client
三、问题解决过程
1.打开/etc/mysql/mysql.conf.d/mysqld.cnf 文件,命令如下
$ sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
2.找到[mysqld]段,并加入一行“skip-grant-tables”,如下图,
3 重启mysql服务,sudo service mysql restart
4.,用空密码进入mysql管理命令行,切换到mysql库,操作命令如下,
$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update mysql.user set authentication_string=password('newpass') where user='root' and Host ='localhost';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> update user set plugin="mysql_native_password";
Query OK, 0 rows affected (0.00 sec)
Rows matched: 3 Changed: 0 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> quit;
Bye
4.回到sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf,把刚才加入的那一行“skip-grant-tables”注释或删除掉。
5.再次重启mysql服务sudo service mysql restart,使用新的密码登陆,修改成功。
$ mysql -u root -p new_pass
Welcome to the MySQL monitor. Commands end with ; or \g.
mysql>
6.至此,问题解决
网友评论