CODEWITHSUNDEEP
phpmysqlphpmyadmin
user866190
user866190

Reputation: 863

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 that I have no privelidges.

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

Upvotes: 0

Views: 60

Answers (2)

user1934587390
user1934587390

Reputation: 461

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.

Upvotes: 1

genesis
genesis

Reputation: 50966

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

This isn't programmatically question though

Upvotes: 0

Related Questions