Randall R Schulz wrote:
Jim,
On Sunday 18 June 2006 07:03, jim tate wrote:
...
you should type in:
mysql -u root -p
then you'll be asked for a password.
Marcus
mysql> SET PASSWORD FOR 'root'@'linux' = PASSWORD('mary');
Error 1133 (42000) : Can't find any matching row in the user table
I get the above Error message, what does it mean? What table? Where?
Internally, MySQL uses a special set of (otherwise ordinary) tables to
store much of its configuration information, including user names and
passwords. The table that holds that information is what it's referring
to.
Have you already created the user 'mary'? You must first create each
user with the GRANT command.
When I was starting out, I found the "MySQL
Tutorial" (<http://www.amazon.com/gp/product/0672325845>) to have about
the right level of detail and scope to get me going. If your needs are
more sophisticated, then the "MySQL Administrator's
Manual" (<http://www.amazon.com/gp/product/0672326345>) might be more
appropriate.
Jim
Randall Schulz
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
'mary' is example of a PASSWORD.
The computer hostname in Suse is 'linux' , that's why I put in [EMAIL PROTECTED]
Jim
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
