CODEWITHSUNDEEP
mysql
khan
khan

Reputation: 373

mysql phpMyAdmin Privileges

I have a new host provider and when I went into phpmyadmin under privileges

I saw

User = Any
Host = %
Password = --
Global privileges = USAGE
Grant = No

What exactly does this mean? Anyone can access the database from anywhere without password?!?!

There is also a root@localhost user

thanks

Upvotes: 1

Views: 2129

Answers (1)

Brad Mace
Brad Mace

Reputation: 27916

From the manual:

The USAGE privilege specifier stands for “no privileges.” It is used at the global level with GRANT to modify account attributes such as resource limits or SSL characteristics without affecting existing account privileges.

It might let you make open a connection, but you wouldn't be able to do anything with it.

Upvotes: 1

Related Questions