From: Date: July 4 2003 1:17am
Subject: Error 1044 & Error 2003 on 4.0.13 and RH9
List-Archive: http://lists.mysql.com/mysql/144395
Message-Id: <3F04B973.7030604@9-5usa.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

I am trying to set up mysql 4.0.13 on my RedHat 9 machine.  I rebuilt 
the source rpm. (I had a previous installation which I deleted first).

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:

[root@mail 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
[root@mail root]# mysql -u root -h 127.0.0.1
ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (111)
[root@mail 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