Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Tim Cabana on July 28, 2001, 01:54:08 AM

Title: Access to mysql database
Post by: Tim Cabana on July 28, 2001, 01:54:08 AM: I installed e-smith 4.1.2 , service-control and phpmysql. Everything works great.
Then I decided to install IRM - http://irm.schoenefeld.org/ - , an IT resource management project. I created an ibay, enabled cgi-bin, dropped all the files in it.
Edited the 2 config files and created the database using the e-smith phpMyAdmin module.

Now, here's the problem the main config file needs the user and password to connect to mysql. The user listed in /etc/my.cnf is mysql, but I have no idea what the passwod should be. I have tried several combinations and always get the same error message - access denided for user mysql@localhost (Using password yes (or no)) ....

The combinations tried are:

user password

root none
root e-smith admin
mysql none
mysql e-smith admin

It would be greatly appreciated if someone could report the proper user pass combination to connect to a database created with the phpMyAdmin module (if that maks a difference).

I thought about just changing the password, but I wasn't sure if that would cause problems for other program connecting to sql (ie. IMP).

In exchange for a solution to this problem I will contribute a mini-howto for those wishing to try / use IRM.

Thanks in avance to all replies.
Title: Re: Access to mysql database
Post by: Tim Cabana on July 28, 2001, 02:28:48 AM: Well, I've been slowlybrowsing through all the topics and found another reference to mysql. It had the answer that I was looking for - /root/.my.cnf - holds the root password for mysql!

Thanks for the pointer and as promised I will write a short (oops did I say it would be short?) howto on setting up IRM.

Now I'm off to change that password!! I suggest you do the same, since everyone that installs the sam version as you will know what it is!
Title: Re: Access to mysql database
Post by: Bobby Wright on July 28, 2001, 03:20:26 AM: Actually I think the install generates the password. During my testing phase I installed E-Smith several times and each time the password for MySQL was different.

Regards;
-BobbyW
Title: Re: Access to mysql database
Post by: Dan Brown on July 28, 2001, 04:59:14 PM: As Bobby said, the mysql root password is randomly generated at install time. However, it's also a good idea to set up a database user for each application. That way, if a security hole somehow makes the password available, a malicious user can't hose all your databases.
Title: Re: Access to mysql database
Post by: Poul Erik Lovskov on August 02, 2001, 08:42:55 PM: Im having problems too.
Can anyone tell me: What to do if I want to use phpadmin on mu e-smith-server. I need to make som databases for different applications. I get error like this "Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /home/e-smith/files/ibays/sommerhus/html/php-adm/lib.inc.php on line 308". It must be because it need user and pssword.

Please help

Poul Erik Lovskov
Denmark
Title: Re: Access to mysql database
Post by: Dan Brown on August 03, 2001, 12:14:58 AM: You know, if you actually read all the messages in the thread you were responding to, you'd know how to find the mysql root password. For more information about how mysql works, try checking out the docs at www.mysql.com.
Title: Re: Access to mysql database
Post by: Poul Erik Lovskov on August 03, 2001, 03:38:24 AM: Thank you

Next time i will use my looking glasses.

Poul Erik
Title: Re: Access to mysql database
Post by: Phuwadol on August 10, 2001, 08:02:32 PM: I have successfully installed myphpnuke. The root password (user) is at /root/.my.conf ......I think
Title: Re: Access to mysql database
Post by: steve mac on August 13, 2001, 08:03:31 AM: which folder did you unzip everything into in the primary? files, html, or cgi-bin?

thanks

steve