1. Check whether the MYSQL is running or not by the following command:
# /etc/init.d/mysqld status # pidof mysqld # netstat -plan | grep :3306
# /etc/init.d/mysqld status mysqld (pid 23832) is running... #pidof mysqld 23832 # netstat -plan | grep :3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 23832/mysqld
#/etc/init.d/mysqld start
- First check the installation directory of PhpMyAdmin and open config.inc.php file in text editor.
- Here you have to search for MYSQL username and password field. The code look like below, you just need to enter the MYSQL password to set the login:
$cfg['Servers'][$i]['user'] = 'root'; // enter mysql username here $cfg['Servers'][$i]['password'] = 'password'; // enter mysql password here
- Now try to login into PhpMyAdmin.
