Topic: Access to mysql database

[Tim Cabana]

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.

[Tim Cabana]

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!

[Bobby Wright]

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

[Dan Brown]

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.

[Poul Erik Lovskov]

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

[Dan Brown]

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.

[Poul Erik Lovskov]

Thank you

Next time i will use my looking glasses.

Poul Erik

[Phuwadol]

I have successfully installed myphpnuke. The root password (user) is at /root/.my.conf ......I think

[steve mac]

which folder did you unzip everything into in the primary? files, html, or cgi-bin?

thanks

steve