1045 Cannot log in to the MySQL server

Posted: 6p in MySQL

1045 Cannot log in to the MySQL server

Today I have faced an error while accessing phpMyAdmin from cPanel.

Logs:-
PHP Fatal error: Call to undefined function PMA_generate_common_url() in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/plugins/auth/AuthenticationCpanel.class.php on line 611
PHP Fatal error: Call to undefined function PMA_generate_common_hidden_inputs() in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/plugins/auth/AuthenticationCpanel.class.php on line 213

Fix : reset the cPanel password from WHM (click the option Allow MySQL password change)

If the issue is still not resolved check the “skip-name-resolve” parameter in my.cnf file. You need to comment it and restart the mysql service.

[root~]# grep skip-name-resolve /etc/my.cnf
#skip-name-resolve

Issue is fixed 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s