RE: MysqlDump question

Thanks Loren,
I've been checking this... it appears that when I do assign a password to
root and try MySQLDump I get this error
mysqldump: Got error: 1146: Table 'dbname.--user=myuser' doesn't exist when
doing LOCK TABLES

when I remove the password, I get no error
the command I use is:

E:\mysql\bin>mysqldump --opt dbname  --user=myuser --password=mypword
1>e:\ib-data\backups\dbname.sql

Any more clues / comments here?

thanks again
Alan

-----Original Message-----
From: Loren McDonald [mailto:MySQL-ML@xxxxxxxxxxxxxx]
Sent: Tuesday, 18 February 2003 11:26 AM
To: 'Alan McDonald'; win32@xxxxxxxxxxxxxxx
Subject: RE: MysqlDump question


Did you password protect all variations of root?

And for web access, you don't need to give public read access.  You plug
a user name and password into the page code where you build the
connection.

-- 
Loren McDonald
mysql-ml@xxxxxxxxxxxxxx

-----Original Message-----
From: Alan McDonald [mailto:alan@xxxxxxxxxxx] 
Sent: Monday, February 17, 2003 6:09 PM
To: win32@xxxxxxxxxxxxxxx
Subject: MysqlDump question

MySQL MySQLDump

What does it mean if I can successfully run a mysqldump command to dump
a
database without having to supply a username or password switch.
I am sure I have created the correct users/priveleges..
Does it just mean that I have given public read access to the database
(as
you would need to do for a website db)? or is there something else I
need to
have done?
thanks
alan





---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10559@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.




---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10562@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.