Mysql not working and show access denied?

How to solve the issue related to Mysql not starting when I’m trying to switch the user from root to root2 ? Access denied.
I tried

grant all privileges on dumup_com.* to 'user_dumup_com'@'localhost';

You are trying to access the database as root2, but granting privileges to user_dumup_com. You need to grant privileges to the user you are trying to connect as.

1 Like