MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jean Zhong Date:August 2 2004 8:59pm
Subject:RE: can't log in mysql server
View as plain text  
Hi, John

Thank you for the response.

I chmod for all database files under ./data/, and now
I can update the password for the root user. 

Thanks a lot.
Jean


--- John McCaskey <johnm@stripped> wrote:

> Did your client side host change?  The user/pass are
> sometimes setup to
> only allow access from a specific host subnet or
> single ip address.
> 
> John A. McCaskey
> 
> 
> -----Original Message-----
> From: Jean Zhong [mailto:to_jeanzh@stripped] 
> Sent: Monday, August 02, 2004 1:27 PM
> To: mysql@stripped
> Subject: can't log in mysql server
> 
> 
> 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 meet the same problem before? Does anyone
> know how to deal with it? Thank you very much.
> 
> I still tried to reset the password following the
> mysql manual:
> 
> > mysqld_safe --skip-grant-tables &
> or
> > safe_mysqld --skip-grant-tables &
> 
> But it gave me the following errors in the
> localhost.err:
> 
> 040802 16:08:02  mysqld started
> Warning: One can only use the --user switch if
> running
> as root
> 040802 16:08:03  InnoDB: Started
> 040802 16:08:03  /usr/local/mysql/bin/mysqld: Can't
> create/write to file
> '/usr/local/mysql/data/localhost.pid' (Errcode: 13)
> /usr/local/mysql/bin/mysqld: ready for connections.
> Version: '4.0.18-debug-debug'  socket:
> '/tmp/mysql.sock'  port: 3306
> 
> And, when I tried to connect to the mysql server:
> > mysql -u root
> 
> and update the password, use:
> > UPDATE mysql.user SET Password=PASSWORD('newpwd')
> ->                   WHERE User='root';
> 
> I got the following error:
> 
> ERROR 1017: Can't find file: './mysql/user.frm'
> (errno: 13)
> 
> 
> Does anyone have any idea about this?
> 
> I really appreciate your help and looking forward to
> your reply.
> 
> Jean
> 
> 
>  
> 
> 
> 		
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail Address AutoComplete - You start. We
> finish.
> http://promotions.yahoo.com/new_mail 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/mysql?unsub=1
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/mysql?unsub=1
> 
> 


		
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail 
Thread
MaxDB and clusterjschung20 Jul
  • Re: MaxDB and clusterJeremy Zawodny2 Aug
    • can't log in mysql serverJean Zhong2 Aug
RE: can't log in mysql serverJohn McCaskey2 Aug
  • RE: can't log in mysql serverJean Zhong2 Aug