Help With PHPmyAdmin Install - No User Privildeges

Using PHPMyAdmin in a Ubuntu desktop test server box that I have just installed with the rest of LAMP stack and when I use PHPmyAdmin and it says 开发者_如何学Pythonthat I have no privelidges.

Is there any thing that I can do to get over this problem.?

You can use the MySQL command line to grant permissions to a given user if you know at least the root password.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

You can check out the Ubuntu community docs about how to do this and other configuration for a LAMP server. About halfway down the page they discuss MySQL specifically and how to set it up/configure it via command line.

Check/reset user's permissions and don't forgot to flush their cache.

This isn't programmatically question though