MySQL ERROR 1045 (28000): Access denied for user workaround

Source: Internet
Author: User

Windows:

1. Admin login system, stop MySQL service or end mysqld-nt process
2. Go to the command line and come to the MySQL installation directory. Assuming that the installation directory is d:\mysql\, CMD enters the command line
3. Run d:\mysql\bin\mysqld-nt--skip-grant-tables start MySQL, turn off check of permissions
4. Run d:\mysql\bin\mysqladmin-u root flush-privileges password "newpassword" Reset root password
5. Restart the MySQL service, net stop MySQL then net start MySQL, and then mysql-u Root-p enter the password to log in

This verification succeeds, MySQL runs again normal

Linux Systems
method One:
#/etc/init.d/mysql Stop
# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# mysql-u Root MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
#/etc/init.d/mysql Restart
# mysql-uroot-p
Enter Password: < Enter the newly set password newpassword>
Mysql>
Method Two:
Use the user name and password provided directly in the [client] section of the/etc/mysql/debian.cnf file:
# mysql-udebian-sys-maint-p
Enter Password: < Enter the password for the [client] section >
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
# mysql-uroot-p
Enter Password: < Enter the newly set password newpassword>
Mysql>

MySQL ERROR 1045 (28000): Access denied for user workaround

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.