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
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
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 .
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
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
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:
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
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
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