mysql database access denied for user root
I mistakenly imported a dump file from openshift 2 for my project in openshift3 , which contains script that removes the root user from users file (mysql.user) and replace it with the user and host that was used in openshift.
Now the mysql57 image cant access the mysql database and the very important that we have. it doesn't response to environment variables that controls user name and password . can you help.
Responses
If you can access the system/VM that runs the database at the operating system level, you'll need to perform the MySQL lost root password recovery procedure: https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
After that, it's time to see what else might have been erased by the restoration of the wrong dump, and restore from backups if necessary and possible.
If you don't have OS-level access, it's time to make a support request.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.