If you're still not able to connect, you'll have to reset the MySQL root password. Change the line $cfg = 'tcp' to $cfg = 'socket' and/or use mysql -protocol=socket -u root -p at the command line to try this different account if that works you can fix the other user's password without resorting to brute force. In MySQL, the host field % is different from localhost so since you're connecting via the TCP/IP networking to 127.0.0.1, the account you're authenticating against is the one with either '127.0.0.1' or '%' as the host, not 'localhost' - though you can try connecting via sockets to see if that changes things. Try logging in from the command-line client something like mysql -u root -p should be close. This can be a bit confusing since they're both called root. Make sure you're using the MySQL root user's password, not the system root user. Is there a chance you set a password earlier? Many package managers ask you for a password during installation. You say you're trying to use a blank password, but I don't see the configuration directive $cfg = true which is required for logging in with blank passwords.Īlso note that, with auth_type = 'http', you do not need the $cfg or $cfg directives at all they are only used with auth_type = 'config'. Try logging in from the command line client. $cfg = '' // Verbose name for this host - leave blank to show the hostname It may also be an array of db-names, where sorting order is relevant. $cfg = 'http' // Authentication method (config, http or cookie based)? $cfg = FALSE // Use compressed protocol for the MySQL connection

$cfg = 'mysql' // The php MySQL extension to use ('mysql' or 'mysqli') $cfg = 'tcp' // How to connect to MySQL server ('tcp' or 'socket') $cfg = '' // Path to the socket - leave blank for default socket $cfg = '' // MySQL port - leave blank for default port The following is : $cfg = '127.0.0.1' // MySQL hostname or IP address So how can I get access to phpmyadmin as root? Or how can I raise privilege when I log in as admin? But there is another issue, it shows that admin has no previlege to create a database. However, when I try to use admin as username and leave the password blank, it works. I try to use root as username and leave the password blank, it doesn't work. Every time when I try to get access to phpMyAdmin, it pops up a dialog requiring username and password.

127.0 0.1 localhost phpmyadmin