phpmyadmin mysql root user no privileges error

Run mysql server using “mysqld_safe –skip-grant-tables &” from command prompt.

or update mysql config with mysql/my.cnf or my.ini with

[mysqld]
skip-grant-tables

Now create a new user with mysqladmin -u USERNAME password ‘password’

Then login to mysql with mysql -u USERNAME -p

Enter password

Enter command “flush privileges;”

Then enter command “GRANT ALL on *.* to ‘USERNAME’@’localhost’ identified by ‘password’;”

Restart the server.

Now login to phpmyadmin with created user.

Update config.inc.php with

$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
$cfg[‘Servers’][$i][‘user’] = ‘USERNAME’;
$cfg[‘Servers’][$i][‘password’] = ”;

Restart mysql server

Login to Phpmyadmin with the created new user.