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