Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Nils Valentin]

2003年 7月 7日 月曜日 10:28、Nils Valentin さんは書きました:
> 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'@'%';

 GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;


sorry for the mistake.

Best regards

Nils Valentin
Tokyo/Japan

>
> 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" <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
>
> --
> ---
> Valentin Nils
> Internet Technology
>
>  E-Mail: nils@stripped
>  URL: http://www.knowd.co.jp
>  Personal URL: http://www.knowd.co.jp/staff/nils

-- 
---
Valentin Nils
Internet Technology

 E-Mail: nils@stripped
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils