mysql on mandrake 10 problems

#1

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:

Quote:

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.

Quote:

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

Quote:

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" <newsgroupkirky (AT) sbcglobal (DOT) net> wrote

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.

Quote:

-Kirk

#2

Kirk Soodhalter wrote:

Quote:

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

#3

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:

Quote:

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

#4

Kirk Soodhalter wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

mysql on mandrake 10 problems

mailing.database.mysql mailing.database.mysql

mysql on mandrake 10 problems - 07-25-2004 , 09:39 AM

Re: mysql on mandrake 10 problems - 07-25-2004 , 10:07 AM

Re: mysql on mandrake 10 problems - 07-25-2004 , 01:13 PM

Re: mysql on mandrake 10 problems - 07-25-2004 , 01:42 PM