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:
[color=blue]
> You may had messed with the database mysql by setting another[/color]
password for root and users without using mysql PASSWORD() function.
This can also be juste a mistapped password when you modified it.[color=blue]
>
> Also PhpMyAdmin had some problem with MySQL 4.1 since they had[/color]
changed they password length to a longer hash.[color=blue]
> * Prior to MySQL 4.1, password hashes computed by the PASSWORD()[/color]
function are 16 bytes long.[color=blue]
> * As of MySQL 4.1, the PASSWORD() function has been modified to[/color]
produce a longer 41-byte hash[color=blue]
>
> It seem like mysql was compiled to use the old-password way, but the[/color]
function PASSWORD() create the long password hash.[color=blue]
>
> Solution :
> First you need to reset mysql password, since you have lost root[/color]
access, fallow this easy step to do it.
http://dev.mysql.com/doc/mysql/en/Re...rmissions.html[color=blue]
> Then use OLD_PASSWORD() on a query on the database mysql: UPDATE[/color]
users SET password=OLD_PASWORD("mynewpassword") WHERE user='myuser'[color=blue]
>
> 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@sbcglobal.net> wrote in message[/color]
news:g2OLc.17926$bM4.7396@newssvr23.news.prodigy.c om...[color=blue]
>[color=green]
>> Hi,
>>
>> I set up and configured phpmyadmin a few days ago. It worked well[/color][/color]
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.[color=blue][color=green]
>>
>> -Kirk[/color]
>
>[/color]
