mysql grant problem

Mike Nixon miguel.nixon at gmail.com
Fri Sep 28 08:49:16 UTC 2007


After issuing a GRANT .... statement, you should always
FLUSH PRIVILEGES;
If the user is going to be connecting to your mysql server from a
different pc/ip address, then you could create a similar user with the
same grants:
.......'zendtest'@'%' IDENTIFIED BY 'zendtest';
Followed with FLUSH PRIVILEGES;
This would allow the user to connect from *anywhere* - not always a good
idea from a security standpoint.  You could of course specify an ip
address instead of '%'......
Hope this helps.

        





More information about the ubuntu-users mailing list