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;

or
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


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 <mysql-thread113665@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-terencel=sunway.edu.my@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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