Re: Grant all on my mysql.*
mysql Paul, Sure you did clear up the whole thing... :) - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, March 24, 2002 10:31 PM Subject: Re: Grant all on my mysql.* At 21:32 -0500 3/24/02, alan4100 wrote: mysql Michael, It is clear now after typing in p-a-s-s-w-o-r-d into the password for the user root. It then went through fine, but I never set up the password for the root user. Sure you did: At 18:09 -0500 3/24/02, alan4100 wrote: mysql Grant all on mysql.* to 'root'@'localhost' identified by password; Query OK, 0 rows affected (0.00 sec) That statement specifies that the password for root is password. Hope it will be clear later how the password had been stored for the user root. It had to occur before or during the installation. Nope. *You* specified it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Grant all on my mysql.*
Michael, Paul explained. - Original Message - From: Michael Stassen [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED] Sent: Sunday, March 24, 2002 11:31 PM Subject: Re: Grant all on my mysql.* On Sun, 24 Mar 2002, alan4100 wrote: mysql Michael, This time it went through fine only when I typed in mysql -u alan -h localhost -p It went through fine because I already set up alan for username as well as the pasword for (alan). You said I could only use mysql -u root -p to go through! No, I said nothing about other users (including alan). What I said was that, having set a password for root using the grant command (as Paul has now explained), you have to use it to get in as root. Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Grant all on my mysql.*
You set a password for root, so you must use it to connect as root. That is, you must use -p, like this: C:\mysql\binmysql -u root -h localhost -p You'll then be prompted for the password. This is covered in the manual. Michael On Sun, 24 Mar 2002, alan4100 wrote: mysql mysql Grant all on mysql.* to 'root'@'localhost' identified by password; Query OK, 0 rows affected (0.00 sec) == At this point the priveleges are granted to root@localhost. mysql \q Bye I had to type \q to quit and type in the following: But . see what happened when I then typed in below.. = C:\mysql\binmysql -u root -h localhost ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) I am asking why my access is still denied after I was GRANTED in the beginning!!! C:\mysql\bin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Grant all on my mysql.*
mysql Michael, This time it went through fine only when I typed in mysql -u alan -h localhost -p It went through fine because I already set up alan for username as well as the pasword for (alan). You said I could only use mysql -u root -p to go through! Perhaps, it will go through even thou I never set up password for the root. I think all I may have to do is to skip the password, but use -p for the root. From now on I will just use alanand the password as long as possible. Thanks for the reply.
Re: Grant all on my mysql.*
mysql Michael, You can look at the results after the dash lines. You will notice mysql -u root -h localhost -p does not help at all. I clicked enter to by pass the password;it is acceptable for the root, but look at the results. C:\mysql\binmysql -u alan -h localhost -p Enter password: ** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 28 to server version: 3.23.49-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. === mysql grant all on mysql.* to root@localhost identified bypassword; Query OK, 0 rows affected (0.00 sec) mysql \q Bye C:\mysql\binmysql -u root -h localhost -p Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) That is why I stayed with alan as the user instead of the root until the solution is fixed.
Re: Grant all on my mysql.*
mysql Michael, It is clear now after typing in p-a-s-s-w-o-r-d into the password for the user root. It then went through fine, but I never set up the password for the root user. Hope it will be clear later how the password had been stored for the user root. It had to occur before or during the installation.
Re: Grant all on my mysql.*
At 18:09 -0500 3/24/02, alan4100 wrote: mysql mysql Grant all on mysql.* to 'root'@'localhost' identified by password; Query OK, 0 rows affected (0.00 sec) == At this point the priveleges are granted to root@localhost. mysql \q Bye I had to type \q to quit and type in the following: But . see what happened when I then typed in below.. = C:\mysql\binmysql -u root -h localhost ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) I am asking why my access is still denied after I was GRANTED in the beginning!!! C:\mysql\bin In the GRANT statement, you specified that from that point on root would need to specify a password in order to connect. In the subsequent mysql command, you attempted to connect as root, but you specified no password. You see why those actions are self-contradictory? :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Grant all on my mysql.*
At 21:32 -0500 3/24/02, alan4100 wrote: mysql Michael, It is clear now after typing in p-a-s-s-w-o-r-d into the password for the user root. It then went through fine, but I never set up the password for the root user. Sure you did: At 18:09 -0500 3/24/02, alan4100 wrote: mysql Grant all on mysql.* to 'root'@'localhost' identified by password; Query OK, 0 rows affected (0.00 sec) That statement specifies that the password for root is password. Hope it will be clear later how the password had been stored for the user root. It had to occur before or during the installation. Nope. *You* specified it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
