Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: abe on March 19, 2004, 12:28:01 PM

Title: phpmyadmin access to mysql
Post by: abe on March 19, 2004, 12:28:01 PM

Could anyone please give me a clue why phpmyadmin still reports

#2003 - Can't connect to MySQL server on '192.168.1.2' (111)

I've done the following steps, as described in another thread here at contribs:

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no (enable remote
access)
/sbin/e-smith/expand-template /root/.my.cnf
/etc/rc.d/init.d/mysqld restart

Furthermore I have grantet a dummyuser all priviliges to the mysql, using the GRANT-statement.

At last I have tried ANY possible combination of usernames and passwords in config.inc.php.

I'm stuck!
abe.

Title: Same SQL Error
Post by: cosy on March 19, 2004, 09:24:20 PM

Hi,

  I got the same error try evrything couldn't fix, After that just run the SME Upgrade to install MySql.

Title: Is MySQL service running?
Post by: rishi on March 30, 2004, 03:58:10 AM

Looking at that last post, it may be a good idea to check if the MySQL service is actually running / installed properly. Try to SSH into your server and run the MySQL command line interface (see MySQL docs). Check that that works, check that the service is running properly and hopefully that will find your problem. Good Luck!

Title: phpmyadmin use
Post by: gbaird on March 31, 2004, 12:24:27 AM

Hello

the phpmyadmin contrib for sme
e-smith-phpmyadmin-2.5.5-4.noarch.rpm

works right out of the box just install it
and it works on your local network
 https://domain-name-or- ip-address.com/phpmyadmin

note the https

use admin for login and your admin password to login

you don't need to enable the localnetworking command
to use the phpmyadmin contrib

hope this helps

Title: MySQL Control Center can't connect to MySQL on a SME 6.0.01
Post by: dayhat on March 31, 2004, 05:36:25 AM

I get the same error
"ERROR 2003: Can't connect to MySQL Server on "192.168.1.2" (10061)

I have created a user and flush privileges

I can connect to my SME 5.6.

Any answers

Thanks in advance :-x