|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
February 20th, 2004, 04:25 AM
|
|||
|
|||
Removing root password on mysql useing RedHat
Hello
I have a problem with mysql server. I am runing mysql on RedHat9 Linux server. By mistake I made a stuping thing. I tried to change root password useing phpmyadmin. When I did this I can'd connect to mysql. The message apear: mysql -u mysql -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Bine ai venit la phpMyAdmin 2.5.6-dev phpMyAdmin a incercat sa se conecteze la serverul de MySQL dar acesta a respins conexiunea. Ar trebui verificat daca datele din config.inc.php sunt corecte. Warning: Cannot add header information - headers already sent by (output started at /var/www/html/poseidon/phpMyadmin/libraries/auth/config.auth.lib.php:96) in /var/www/html/poseidon/phpMyadmin/libraries/ob.lib.php on line 61 Warning: Cannot add header information - headers already sent by (output started at /var/www/html/poseidon/phpMyadmin/libraries/auth/config.auth.lib.php:96) in /var/www/html/poseidon/phpMyadmin/libraries/header_http.inc.php on line 14 Warning: Cannot add header information - headers already sent by (output started at /var/www/html/poseidon/phpMyadmin/libraries/auth/config.auth.lib.php:96) in /var/www/html/poseidon/phpMyadmin/libraries/header_http.inc.php on line 15 Warning: Cannot add header information - headers already sent by (output started at /var/www/html/poseidon/phpMyadmin/libraries/auth/config.auth.lib.php:96) in /var/www/html/poseidon/phpMyadmin/libraries/header_http.inc.php on line 16 Warning: Cannot add header information - headers already sent by (output started at /var/www/html/poseidon/phpMyadmin/libraries/auth/config.auth.lib.php:96) in /var/www/html/poseidon/phpMyadmin/libraries/header_http.inc.php on line 17 Warning: Cannot add header information - headers already sent by (output started at /var/www/html/poseidon/phpMyadmin/libraries/auth/config.auth.lib.php:96) in /var/www/html/poseidon/phpMyadmin/libraries/header_http.inc.php on line 20 Server localhost Fatal error: Call to undefined function: pma_sqp_iserror() in /var/www/html/poseidon/phpMyadmin/libraries/common.lib.php on line 488 What can I do to make mysql working again? Many thanks, Bogdan P.S. I saw the simmilar articles on the forum but nothing worked so far!
|
|
#2
February 21st, 2004, 08:16 PM
|
||||
|
||||
|
Try this:
Code:
login to mysql, then
USE mysql
UPDATE user SET password=PASSWORD('yournewpass') WHERE user='root' ;
FLUSH privileges
However, in the past I've found when you lose your root password its best to simply re-install mysql... Back up your data directory and re-install... =)
|
|
#3
February 23rd, 2004, 10:09 AM
|
||||
|
||||
|
Or go into the phpmyadmin config file and change the root password there as well. I imagine phpmyadmin allowed you to change the password, but if phpmyadmin is running as root and you changed the password on the server but not in the config, well, you see the dilemma.
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Removing root password on mysql useing RedHat |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
