I need to enable remote access for a specific user on a mysql server, running debian oldstable.
Bear in mind I'm no SQL expert nor a real sysadmin.
Logging in phpmyadmin and looking at the Privileges page, I notice two odd things:
- an "Any" user, with host
%, no password, and global
USAGEprivilege. No idea what does that mean or imply. If I "edit" that user, I see it has a lot of privileges on a table called
testand on a
test\_%, whatever that means - please notice I have no such tables in my database, at least they do not appear in the phpmyadmin list.
- root both have a line for "localhost" host, and for "127.0.0.1" host.
Point 2 is fine, just odd, seems a bit redundant and senseless to me. Point 1 is what worries me, what am I supposed to do about that?