Hello.
Right. No need to FLUSH PRIVILEGES after GRANT. My fault, sorry. Michael Stassen <[EMAIL PROTECTED]> wrote: > > Gleb Paharenko wrote: >> Hello. >> >> Execute FLUSH PRIVILEGES after granting. >> See: >> http://dev.mysql.com/doc/mysql/en/flush.html >> http://dev.mysql.com/doc/mysql/en/privilege-changes.html > > Yes, please read this one. FLUSH PRIVILEGES is NOT needed after GRANT, > REVOKE, or SET PASSWORD. You only need to FLUSH if you directly edit the > grant tables (INSERT, UPDATE, DELETE). Since he/she is using GRANT, FLUSH > PRIVILEGES is unlikely to be relevant. > >> http://dev.mysql.com/doc/mysql/en/access-denied.html >> http://dev.mysql.com/doc/mysql/en/user-resources.html >> >> Connect to the server using mysql command line client using specified in >> GRANT statement >> username and password to check that the problem not in MySQL server. What >> output does the >> following statement produce: >> >> SHOW GRANTS FOR 'metal-host'@'localhost'; > > Run this when it works, and then again when it doesn't. If the result is > different, then something is changing the privileges assigned to > [EMAIL PROTECTED], so the solution will involve finding what is doing > that. If the privs are the same, then we need to look elsewhere. From the > (not entirely clear) description, I expect the first case. > >> What exact version of MySQL server do you use? >> >> [snip] >> >> Hello Gleb, no i m not doing flush..i dont even know what flush is. >> do u have anything in mind ? >> >> [snip] >> > > Michael > > > Metal Host Contact wrote: > > > I have installed in a single user called "metal-host" more than 10 > > databases all with different names and in different php scripts (phpbb > > phpnuke mambo etc). > > the problem is that they only work as I install them,after some hour later > > all the scripts show me that error : Access denied for user: > > '[EMAIL PROTECTED]' (Using password: YES) .... > > then im trying to do : GRANT ALL PRIVILEGES ON somethign.* TO > > [EMAIL PROTECTED] IDENTIFIED BY "password"; and then each database that > > i re-give the GRANT all command works perfectly..but for 1 minute > > only,then it gives me the same : Access denied for user: > > '[EMAIL PROTECTED]' (Using password: YES) .... So is there any > > limitation for the number of DBases that each user should > > run ? > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
