Hi Kevin, try this:
1) stop the mysql server 2) mysqld_safe --skip-grant-tables 3) mysql -u root 4) mysql> SHOW GRANTS FOR root; 5) GRANT ALL ON *.* TO 'root'@'%'; 6) restart the server (without --skip-grant-table option) and try to login Best regards Nils Valentin Tokyo/Japan 2003年 7月 5日 土曜日 00:29、Victoria Reznichenko さんは書きました: > "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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
