Alan Williamson wrote: >>I have made a user with the following command: >>GRANT ALL ON *.* TO 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r' > > Silly question Morten, and I am sure you have probably done it, but > you are definitely running: > > % mysql> FLUSH PRIVILEGES;
You only need to FLUSH PRIVILEGES if you directly edit the mysql db tables. It is not needed with GRANT, REVOKE, or SET PASSWORD. See the manual for the details <http://dev.mysql.com/doc/mysql/en/privilege-changes.html>. Michael Strange, because it work after i did a FLUSH PRIVILEGES. thank you alan. Morten