it's in the docs.
use mysql;
or
update databasename.tablename ...
----- Original Message -----
From: "Page Works Web Solutions" <[EMAIL PROTECTED]>
To: "MySql mailing list (E-mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 1:51 PM
Subject: Root pass
Hi,
any ideas on this one
[admin admin]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 3.23.37
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> UPDATE user SET Password=PASSWORD(testpassword)
-> WHERE User='root';
ERROR 1046: No Database Selected
mysql>
Shawn
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
