Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Rien on May 12, 2005, 05:37:11 PM

Title: Can't connect to MySQL on SME 6.0.1-1 (Mysqld not running?)
Post by: Rien on May 12, 2005, 05:37:11 PM
I've tried to make a connection between my WinXP client and MySQL on my SME 6.0.1-1 server.

After I did:
Code: [Select]
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart


I tried again, but it simply don't work.

To find out what went wrong I checked te following:

Code: [Select]

[root@mlkserver root]# mysqladmin variables
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!


The file /var/lib/mysql/mysql.sock doesn't exist on my server!

Code: [Select]

[root@mlkserver root]# mysqladmin -h mlkserver version variables
mysqladmin: connect to server at 'mlkserver' failed
error: 'Can't connect to MySQL server on 'mlkserver' (111)'
Check that mysqld is running on mlkserver and that the port is 3306.
You can check this by doing 'telnet mlkserver 3306'


Code: [Select]

[root@mlkserver root]# mysqladmin -h mlkserver --port=3306 version
mysqladmin: connect to server at 'mlkserver' failed
error: 'Can't connect to MySQL server on 'mlkserver' (111)'
Check that mysqld is running on mlkserver and that the port is 3306.
You can check this by doing 'telnet mlkserver 3306'


Code: [Select]

[root@mlkserver root]# mysqladmin -h 192.168.10.10 version
mysqladmin: connect to server at '192.168.10.10' failed
error: 'Can't connect to MySQL server on '192.168.10.10' (111)'
Check that mysqld is running on 192.168.10.10 and that the port is 3306.
You can check this by doing 'telnet 192.168.10.10 3306'


It seems to me that Mysld is not running. Any suggestions how can I fix this?
Title: phpmyadmin
Post by: treyh on May 14, 2005, 08:20:58 AM
For everything I do with MYSQL I use phpmyadmin

Instructions:
1. wget http://mirror.contribs.org/smeserver/contribs/nightspirit/e-smith-phpmyadmin/e-smith-phpmyadmin-2.6.0-12.noarch.rpm

2. rpm -Uvh e-smith-phpmyadmin-2.6.0-12.noarch.rpm

3. go to https://yourdomain.com/phpmyadmin
**don't forget to put https:// instead of http://**

From there it's self explanatory if you have a general understanding of php and MYSQL