Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Malkouix on October 22, 2001, 02:51:10 PM

Title: Can't acces mysql
Post by: Malkouix on October 22, 2001, 02:51:10 PM

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.

Title: Re: Can't acces mysql
Post by: guestFF on October 22, 2001, 08:10:24 PM

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.

Title: Re: Can't acces mysql
Post by: Malkouix on October 22, 2001, 08:20:17 PM

Thanks for your help.

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

Title: Re: Can't acces mysql
Post by: Dan Brown on October 22, 2001, 08:52:31 PM

What makes you think it's encrypted?

Title: Re: Can't acces mysql
Post by: Malkouix on October 22, 2001, 08:55:47 PM

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 ;)

Title: Re: Can't acces mysql
Post by: herbert freitag on October 22, 2001, 09:06:17 PM

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'

Title: Re: Can't acces mysql
Post by: Malkouix on October 22, 2001, 09:14:55 PM

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?

Title: Re: Can't acces mysql
Post by: Dan Brown on October 22, 2001, 09:21:52 PM

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.

Title: Re: Can't acces mysql
Post by: guestFF on October 23, 2001, 03:10:05 AM

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