Mysql Reset Password

Support section for FREESCO v0.3.x 3rd Party Packages

Postby Poomsag » Tue Mar 20, 2007 11:27 pm

I changed root password without password function
now I cannot access database
how to reset root password
User avatar
Poomsag
Newbie
 
Posts: 7
Joined: Tue Dec 21, 2004 9:21 pm

Postby Marc » Wed Mar 21, 2007 6:27 am

Hi,

Code: Select all
[Linux] rc_mySQL stop
[Linux] fork /path/to/safe_mysqld --skip-grant-tables
[Linux] mysql -uroot mysql
mysql> update user set password=PASSWORD('your_new_password') where user='root';
Query OK, 2 rows affected (0.13 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> exit;
Bye
[Linux] rc_mySQL restart



For mysql-4.1.7a-lightning, the safe_mysqld is replaced by mysqld_safe
So use
Code: Select all
fork /path/to/mysqld_safe --skip-grant-tables


instead of
Code: Select all
fork /path/to/safe_mysqld --skip-grant-tables


in the howto above.
Remark :
with this package : /path/to = /usr/local/mysql/bin (all lower case).
Marc
pc1mh.nl.eu.org
User avatar
Marc
Senior Member
 
Posts: 85
Joined: Fri May 17, 2002 3:42 pm
Location: The kingdom of the Netherlands, Twente

Postby Poomsag » Wed Mar 21, 2007 11:21 pm

Thank you :)
User avatar
Poomsag
Newbie
 
Posts: 7
Joined: Tue Dec 21, 2004 9:21 pm

Postby Poomsag » Wed Mar 21, 2007 11:33 pm

I cannot access mysql by phpmyadmin after assign root password and another user password too.
How to solve this problem.
User avatar
Poomsag
Newbie
 
Posts: 7
Joined: Tue Dec 21, 2004 9:21 pm

Postby giotec » Tue Jul 17, 2007 9:53 am

Poomsag wrote:I cannot access mysql by phpmyadmin after assign root password and another user password too.
How to solve this problem.

Friends! :D

I am with the same problem. :(

They can help me?
Giovani Dias - T?cnico em Eletr?nica e Inform?tica.<br><a href='http://www.centraldossites.com' target='_blank'>http://www.centraldossites.com</a><br><a href='ftp://giotec.homeftp.net' target='_blank'>ftp://giotec.homeftp.net</a><br>giovanirj@superig.com.br<br>o_duende@yahoo.com.br<br>Linux User#273456<br>A Capacidade Supera o Conhecimento<br>"Free your mind"
User avatar
giotec
Newbie
 
Posts: 8
Joined: Wed Apr 02, 2003 1:06 pm
Location: Rio de Janeiro - Brasil

Postby dRB » Tue Jul 17, 2007 3:19 pm

I cannot access mysql by phpmyadmin after assign root password and another user password too. How to solve this problem.

This link may address the problem:
<a href='http://www.freesco.org/support-forum200607/index.php?showtopic=13630&hl=old+password' target='_blank'>..forum archive</a>

-dRB
Please bear with me ... I seemed to have lost my marbles.
User avatar
dRB
Junior Advanced Member
 
Posts: 196
Joined: Tue Apr 30, 2002 2:08 am
Location: Dryden, Ontario. CANADA


Return to 3rd Party Package Support for FREESCO v0.3.x

Who is online

Users browsing this forum: No registered users and 1 guest