By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,144 Members | 1,286 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,144 IT Pros & Developers. It's quick & easy.

mysql on mandrake 10 problems

P: n/a
Hi,

This started as a phpmyadmin problem, but has somehow morphed into a
mysql problem. I don't know how to fix it. I am posting the
conversation from a php newsgroup since it started there. Thanks for
any help you might be able to give.

-Kirk

Ok, in the midst of fixing this problem I have somehow managed to create
new problems. I can't even get into mysql with any shell commands any
more. Now when I do, I get this error message:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!

mysql.sock is there. When I try to shut the server down using the GUI
tool or the command line, it still does not find the mysql.sock. I am
not sure what to do. I want to just reset everything to defaults and
start over, but I have no idea is this is a good idea or doable. Tell
me what info you might need in order to help me out and I will give it
to you. Thanks for all the help you have given so far!

-Kirk

Savut wrote:
You may had messed with the database mysql by setting another password for root and users without using mysql PASSWORD() function.
This can also be juste a mistapped password when you modified it.
Also PhpMyAdmin had some problem with MySQL 4.1 since they had changed they password length to a longer hash. * Prior to MySQL 4.1, password hashes computed by the PASSWORD() function are 16 bytes long. * As of MySQL 4.1, the PASSWORD() function has been modified to produce a longer 41-byte hash
It seem like mysql was compiled to use the old-password way, but the function PASSWORD() create the long password hash.
Solution :
First you need to reset mysql password, since you have lost root access, fallow this easy step to do it.
http://dev.mysql.com/doc/mysql/en/Re...rmissions.html Then use OLD_PASSWORD() on a query on the database mysql: UPDATE users SET password=OLD_PASWORD("mynewpassword") WHERE user='myuser'
References :
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
http://dev.mysql.com/doc/mysql/en/Re...rmissions.html

Savut
http://www.savut.com

"Kirk Soodhalter" <ne************@sbcglobal.net> wrote in message news:g2******************@newssvr23.news.prodigy.c om...
Hi,

I set up and configured phpmyadmin a few days ago. It worked well and I built some databases, etc. Then I went to bed. The next day,
when I tried to log in, it did not accept my username/password which had
worked the day before. I figure I have done something wrong, but I
don't know where to start in figuring out how do rectify this. Can
someone point me in the right direction as to what to try? I appreciate
any help you give. Thanks.
-Kirk


Jul 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Kirk Soodhalter wrote:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!


http://dev.mysql.com/doc/mysql/en/Ca...to_server.html
Jul 20 '05 #2

P: n/a
Okay,

What I figured out from that page is that even though mysqld says I am
starting up when I invoke the start from the command line, it is not
really starting up. I am not sure where to go though to diagnose the
reason for this.

-Kirk

Aggro wrote:
Kirk Soodhalter wrote:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!

http://dev.mysql.com/doc/mysql/en/Ca...to_server.html

Jul 20 '05 #3

P: n/a
Kirk Soodhalter wrote:
What I figured out from that page is that even though mysqld says I am
starting up when I invoke the start from the command line, it is not
really starting up. I am not sure where to go though to diagnose the
reason for this.


http://dev.mysql.com/doc/mysql/en/Starting_server.html
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.