Topic: Can't acces mysql

[Malkouix]

Hello,

I just installed SME, and I try to access my MySql database with phpMyAdmin.
But I can't. MySql answer taht I haven't access with this logging/password.

My login is 'admin' and my password is correct.

So what happen?

Thanks a lot to mail me any idea.

[guestFF]

Are yu sure the password is correct? Do a search on PHP in these forum and you will see a link to the /root/.my.conf file

Try to use this root password instead you use now.

[Malkouix]

Thanks for your help.

Is there anyway to uncrypt the password in /root/.my.cnf?
Thanks again.

[Dan Brown]

What makes you think it's encrypted?

[Malkouix]

It looks like that: ehfidkdlw415dffjjkdkks (it isn't exactelly that), so I think it's encrypted.

Can you tell me which difference there are between admin and root account?
What about their passwords?

Thanks

[herbert freitag]

the password in /root/.my.cnf is not encryptet its the plain text password
but you can delet it and add your root password. aditional you must edit
config.inc.php in /opt/administration/phpmyadmin line 49 like the user root
between 'passwd'

[Malkouix]

Ok, I replaced the password in /root/.my.cnf by a text/plain password that is the same that the one I mentioned in the phpMyAdmin config file.

The error message is now that:

"Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)"

What happen?

[Dan Brown]

At least part of what happened is that you fed mysql a bogus password.  Try either reading the MySQL docs, or doing a search here on mysql password; it's only been discussed about a zillion times.

[guestFF]

Dan is right....

Please do multiple searches on subject with different subjects or keywords.
Most of the questions are already answered.

Make sure you set the 'last 30 day's' to 'all dates' if you perform a search.

HFW