I can log on to the mysql monitor as root but can't creat databases, can't change passwords, can't grant privileges, can't select hosts, can't seem to do anything.
I'm getting Errors 1044 & 2003. Here's some of the output:
[EMAIL PROTECTED] root]# mysql -u root mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 4.0.13-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE DATABASE <mydatabase>; ERROR 1044: Access denied for user: '@localhost' to database '<mydatabase>' mysql> \q Bye [EMAIL PROTECTED] root]# mysql -u root -h 127.0.0.1 ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (111) [EMAIL PROTECTED] root]# mysql -u root mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 to server version: 4.0.13-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SHOW GRANTS FOR root; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql>
This may have been covered before. If so, I apologize for the repition.
Thanks very much. You may e-mail me directly if you wish.
Kevin Phillips
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
