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" <[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 -- --- 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]
