MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Terence Date:July 3 2002 5:56am
Subject:Re: Root pass
View as plain text  
it's in the docs.

use mysql;

update databasename.tablename ...

----- Original Message -----
From: "Page Works Web Solutions" <ceo@stripped>
To: "MySql mailing list (E-mail)" <mysql@stripped>
Sent: Wednesday, July 03, 2002 1:51 PM
Subject: Root pass


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


Before posting, please check:   (the manual)           (the list archive)

To request this thread, e-mail <mysql-thread113665@stripped>
To unsubscribe, e-mail
Trouble unsubscribing? Try:

Root passPage Works Web Solutions3 Jul
  • Re: Root passTerence3 Jul
  • Re: Root passGeorg Richter3 Jul
  • Re: Root passCurtis Maurand3 Jul