Sounds like the same problem I'm having (for which I'm still stumped and don't know what has caused it): table mysql.user is read only.
Test this by logging into mysql and using the GRANT or REVOKE statements. -- Loren McDonald <AKA MisterrMac> Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com > ... > shell>mysqladmin -u root password 'new-password' > shell>mysqladmin -u root -h hostname password 'new-password' > mysqladmin: connect to server at 'hostname' failed > error: 'Can't connect to MySQL server on 'hostname' (110)' > Check that mysqld is running on hostname and that the port is 3306. > You can check this by doing 'telnet hostname 3306' > shell>telnet hostname 3306 > Trying IP_address... > telnet: connect to address IP_address: Connection timed out > > > shell>mysqladmin -u root password 'new-password' > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > > I can only use mysql with mysql user: > shell>mysql -u mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 9 to server version: 3.23.54 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
