January 08, 2006 Archives

08-01-2006 16:25

MySQL user access

I have learnt this before, but have since forgotten and thus need to blog this one. To access MySQL locally you need a user that has local access allowed. To then access this same MySQL server remotely with the same user name, you need to in fact create a new user with access from the specified network, or simple from any "Host". If you simply change the one and only user name to allow from any and thats it, then your in turn blocking the account from remote AND local access. I am guessing its a compiled in security feature that could possibly be disabled at the --configure part of the compile but I dont want to recompile the whole server.

Posted by DaveQB | Permanent Link | Categories: IT