Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: YES)

carolinef

carolinef

Verified User
Joined
Sep 2, 2021
Messages
25
After update MySQL Government I have problem with MySQL.
When I try open MySQL I get the information:

"Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: YES)
I tried to apply the instruction from this link: https://help.directadmin.com/item.php?id=45, but still this same."

I can open MySQL when I set "--skip-grant-tables", but then I can't import backup database becouse:
Database: Unable to add user xxxxxxxxxxxxx The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
I'm stuck...
 
[root@server ~]# /usr/local/directadmin/scripts/reset_da_admin_password.sh --password 'xxxxxxxxxxxxxxx'
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
Could not find any working logins for localhost
Could not find a working root/da_admin login to use for the reset. Aborting
[root@server ~]# systemctl stop mysqld
[root@server ~]# systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
[root@server ~]# systemctl start mysqld
[root@server ~]# /usr/local/directadmin/scripts/reset_da_admin_password.sh --password 'xxxxxxxxxxxxxxx'
Using 'mysql=' root pass from /usr/local/directadmin/scripts/setup.txt
ERROR 1290 (HY000) at line 1: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Error running password update for da_admin@localhost

I do not know what's going on
 
You must log in or register to reply here.
Back
Top