dbTalk Databases Forums  

change the password of root

comp.databases.mysql comp.databases.mysql


Discuss change the password of root in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Mr. X.
 
Posts: n/a

Default Re: change the password of root - 03-05-2010 , 08:35 AM






I'll do another threads, for my future question ...

Reply With Quote
  #12  
Old   
Mr. X.
 
Posts: n/a

Default Re: change the password of root - 03-05-2010 , 08:54 AM






According to the example.
I stopped the service, and write on the command line :
(there was not mysqld-nt.exe, so I suppose it is mysqld.exe
C:\mysql\bin\mysqld --init-file=C:\mysql-init.txt
mysql-init.txt includes the lines :
UPDATE mysql.user SET Password=PASSWORD('root') WHERE User='root';
FLUSH PRIVILEGES;

After running I got the message :
100305 15:48:41 [Warning] The syntax '--default-character-set' is deprecated
and
will be removed in a future release. Please use --character-set-server
instead.

100305 15:48:41 [Note] Plugin 'FEDERATED' is disabled.
100305 15:48:41 InnoDB: Operating system error number 5 in a file
operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.


Thanks

Reply With Quote
  #13  
Old   
Mr. X.
 
Posts: n/a

Default Re: change the password of root - 03-05-2010 , 09:15 AM



OK.
I see solution on workbrench.

Thanks

Reply With Quote
  #14  
Old   
Jerry Stuckle
 
Posts: n/a

Default Re: change the password of root - 03-05-2010 , 09:16 AM



Mr. X. wrote:
Quote:
According to the example.
I stopped the service, and write on the command line :
(there was not mysqld-nt.exe, so I suppose it is mysqld.exe
C:\mysql\bin\mysqld --init-file=C:\mysql-init.txt
mysql-init.txt includes the lines :
UPDATE mysql.user SET Password=PASSWORD('root') WHERE User='root';
FLUSH PRIVILEGES;

After running I got the message :
100305 15:48:41 [Warning] The syntax '--default-character-set' is
deprecated and
will be removed in a future release. Please use --character-set-server
instead.

100305 15:48:41 [Note] Plugin 'FEDERATED' is disabled.
100305 15:48:41 InnoDB: Operating system error number 5 in a file
operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.


Thanks
Did you look into the error messages, or just post them here? They are
pretty clear, and we don't have access to your system.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.