List:General Discussion« Previous MessageNext Message »
From:Kevin H. Phillips Date:July 4 2003 1:17am
Subject:Error 1044 & Error 2003 on 4.0.13 and RH9
View as plain text  
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

Thread
Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips4 Jul
  • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Victoria Reznichenko4 Jul
    • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips4 Jul
    • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin7 Jul
      • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin7 Jul
        • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips7 Jul
          • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin7 Jul
            • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips8 Jul
              • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin8 Jul
                • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips8 Jul
                  • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin8 Jul
                    • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips8 Jul
                    • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips8 Jul
              • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Victoria Reznichenko8 Jul
        • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Paul DuBois9 Jul
          • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin9 Jul
            • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips10 Jul
              • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin10 Jul
                • Re: Error 1044 & Error 2003 on 4.0.13 and RH9Kevin H. Phillips10 Jul
  • "select * from table where field=hex" doesnt workKoh Swee Meng8 Jul
    • Re: "select * from table where field=hex" doesnt workNils Valentin8 Jul
      • Re: "select * from table where field=hex" doesnt workPaul DuBois9 Jul
        • Re: "select * from table where field=hex" doesnt workNils Valentin9 Jul
  • Re: "select * from table where field=hex" doesnt workKoh Swee Meng8 Jul
    • RE: "select * from table where field=hex" doesnt workMikko Noromaa8 Jul
Re: Error 1044 & Error 2003 on 4.0.13 and RH9Nils Valentin8 Jul