[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: R
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 U
from your unix shell prompt, you can't
do it inside the mysql client ..
I hope this helps,
Gurhan
- Original Message -
From: "Page Works Web Solutions" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 30, 2002 3:14 AM
Subject: Root pass
> Hi a
MAIL PROTECTED]]
> Sent: 30 June 2002 08:14
> To: [EMAIL PROTECTED]
> Subject: Root pass
>
>
> Hi all,
>Yet another 3am night and I still can't get my MySql to work. I
> installed MySql on a cobalt Raq 4 server running Linux. I can telnet into
> the mysql dire
Hi all,
Yet another 3am night and I still can't get my MySql to work. I
installed MySql on a cobalt Raq 4 server running Linux. I can telnet into
the mysql directory, but can not seem to change the root pass. I've
searched every place except the one that as the answer to my ques
> Ye, that did the trick. I was able to get the daemon restarted using the
> --skip-grant-tables & option, however now I can't connect to the
> monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try
> using /usr/bin/mysql -h hostname mysql
>
> Anyone know why I can't get
> Ye, that did the trick. I was able to get the daemon restarted using the
> --skip-grant-tables & option, however now I can't connect to the
> monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try
> using /usr/bin/mysql -h hostname mysql
>
> Anyone know why I can't get
Amendment to that last post
I don't think the daemon is starting properly, because I can't run a
mysqladmin version - I just get a hung cursor.
Does anyone know if there's something that would be stopping mysqld from
loading with the --skip-grant-tables option? When I do a ps I can see th
Ye, that did the trick. I was able to get the daemon restarted using the
--skip-grant-tables & option, however now I can't connect to the
monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try
using /usr/bin/mysql -h hostname mysql
Anyone know why I can't get the monitor
11 matches
Mail list logo
