我有一段时间没有使用 PHP MySQL，现在我需要再次使用它.但问题是我忘记了 MySQL 控制台的密码.并在尝试登录 PHPMyAdmin 时出现错误 #1045.
在 MySQL 站点我看到一篇文章如何重置 root 密码(
在 Ubuntu 16 上，文件位置通常是 /etc/mysql/mysql.conf.d/mysqld.cnf
使用以下命令编辑配置文件:$ sudo nano/etc/mysql/mysql.conf.d/mysqld.cnf
在 [mysqld] 块下添加 skip-grant-tables 并保存更改.
使用以下命令重启 MySQL 服务:sudo service mysql restart
检查 MySQL 服务状态:sudo service mysql status
登录mysql:$ mysql -u root
并更改root密码:
<块引用>
mysql> 刷新特权；
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITHmysql_native_password BY 'MyNewPass';
通过删除 skip-grant-tables 行或用 #(哈希)注释来恢复 MySQL 配置文件更改.
最后重启 MySQL 服务，一切顺利.
I did not use PHP MySQL for quite a while and now I need to use it again. But the problem is I forget the password for the MySQL console. and getting error #1045 when trying to login in to PHPMyAdmin.
In the MySQL site I saw an article how to reset root password( http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-windows)
Steps are
create a mysql-init.txt file containing UPDATE mysql.user SET Password=PASSWORD('newpass') WHERE User='root';
FLUSH PRIVILEGES;
I saved it as C:\me\mysql-init
and in command prompt I wrote--
C:\wamp\bin\mysql\mysql5.5.8\bin\mysqld --init-file=C:\me\mysql-init.txt
I tried with double backslashes also..but it is not working. MySQL console is asking for a password and it's not taking the new-one. What am I doing wrong? I have several tables there.what to do?
Thanks in advance.
Here are the steps to be followed:
$ mysql --help | grep -A 1 "Default options"On Ubuntu 16, the file location is typically /etc/mysql/mysql.conf.d/mysqld.cnf
Edit the configuration file using: $ sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
Add skip-grant-tables under [mysqld] block and save the changes.
Restart MySQL service using: sudo service mysql restart
Check MySQL service status: sudo service mysql status
Login to mysql with: $ mysql -u root
And change the root password:
mysql> FLUSH PRIVILEGES;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MyNewPass';
Revert back the MySQL configuration file changes by removing skip-grant-tables line or commenting it with a # (hash).
Finally restart the MySQL service and you are good to go.
这篇关于mysql root密码忘记了的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！