[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 ser
On Wednesday, 3. July 2002 07:51, Page Works Web Solutions wrote:
Hi,
>
> 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>
1) select the database with "u
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
[admi
Hi shawn,
You have probably have % in the user and host of the user table, so mysql
client let you in without a username. To be able to use mysql database, you
have to login as the root user. Just type, mysql -u root -p and see if you
can login in that way.
Besides, you have to restart mysqld fr
Hi
Not sure here, but you have logged in as 'admin' on the system. Unless you
su to root mysql will use the same user.
try either
[admin admin]$ su -l
to log in to the system as root and then 'mysql -p' to log into mysql
or stay as admin but log into mysql as root, under mysql
[admin admin]$
