"Kevin H. Phillips" <kh-phillips@stripped> wrote:
> 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.
What is the output of SELECT USER()?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
