Question #6401
Submitted by Answiki
on 07/22/2022 at 05:54:31 PM UTC
How to solve this problem: "mysql_upgrade: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO)" ?
Merged questions
Answer
Submitted by Answiki
on 07/22/2022 at 05:56:16 PM UTC
The following steps will solve the MySQL 1045 error (in most cases):
1. Stop MySQL manually:
sudo /etc/init.d/mysql stop
2. Restart MySQL without privileges:
sudo /usr/bin/mysqld_safe --skip-grant-tables&
3. Run the update:
mysql_upgrade
4. Restart MySQL normally:
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
Answer by Answiki on 07/22/2022 at 05:56:16 PM
The following steps will solve the MySQL 1045 error (in most cases):
1. Stop MySQL manually:
sudo /etc/init.d/mysql stop
2. Restart MySQL without privileges:
sudo /usr/bin/mysqld_safe --skip-grant-tables&
3. Run the update:
mysql_upgrade
4. Restart MySQL normally:
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
Question by Answiki 07/22/2022 at 05:54:31 PM
How to solve this problem: "mysql_upgrade: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO)" ?
| # | ID | Query | URL | Count |
|---|
Icons proudly provided by Friconix.