Koozali.org: home of the SME Server

phpmyadmin access to mysql

abe

phpmyadmin access to mysql
« 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.

cosy

Same SQL Error
« Reply #1 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.

rishi

Is MySQL service running?
« Reply #2 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!

gbaird

phpmyadmin use
« Reply #3 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

Offline dayhat

  • ***
  • 45
  • +0/-0
    • http://dayhat.com
MySQL Control Center can't connect to MySQL on a SME 6.0.01
« Reply #4 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
...