RE: can't log in mysql server

2004-08-02 Thread Jean Zhong
> only allow access from a specific host subnet or > single ip address. > > John A. McCaskey > > > -----Original Message- > From: Jean Zhong [mailto:[EMAIL PROTECTED] > Sent: Monday, August 02, 2004 1:27 PM > To: [EMAIL PROTECTED] > Subject: can't log in

can't log in mysql server

2004-08-02 Thread Jean Zhong
Hello everyone, I met a strange problem. I can't log in mysql server using my password suddently. I check the modified date of user.MYD & user.MYI in /usr/local/mysql/data/mysql/ folder. Both of them were not modified recently. That means I didn't change the password for mysql server. Did anyone

Re: "show table status" problem

2004-06-10 Thread Jean Zhong
Hello, Thank you very much, everyone. Yes, I want to know the table "jean1" status. I tried: show table status like "jean1" It works. Thanks a lot. Jean --- mos <[EMAIL PROTECTED]> wrote: > Jean, > The "from jean1" is looking for a database > named "jean1", it is > not the table n

"show table status" problem

2004-06-10 Thread Jean Zhong
Hello, everyone I am new on MySQL. I created several tables by command: %mysql jeandatabase -u root -h localhost -p < jean1.sql and jean1.sql is as follows: use jeandatabase; drop table if exists jean1; create table jean1( id int not null, field1 char(9), primary key(id) ); But, when