[admin admin]$ mysql mysql
or once you have the mysql prompt type: use mysql then issue the command Curtis Page Works Web Solutions said: > 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