"Kevin H. Phillips" <[EMAIL PROTECTED]> 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: > > [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.
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 / /|_/ / // /\ \/ /_/ / /__ [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]