Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Duckie on May 10, 2005, 12:43:25 AM

Title: Remote Access To MYSQL
Post by: Duckie on May 10, 2005, 12:43:25 AM

Hi

Would i use the following commands if i wanted to allow access to MYSQL from another server.

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

Then configure the remote server to point to the server hosting the MYSQL database.

I am using SME7.0 alpha 5 with MYSQL upgraded to MYSQL4

Title: Re: Remote Access To MYSQL
Post by: CharlieBrady on May 11, 2005, 05:00:32 AM

Quote from: "Duckie"

Hi

Would i use the following commands if i wanted to allow access to MYSQL from another server.

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

That will only allow access to mysql from other machines on your LAN. It won't allow access from the Internet. You probably don't want to allow access from the Internet anyway.

Quote

I am using SME7.0 alpha 5 with MYSQL upgraded to MYSQL4

I don't know whether the above tweak will affect mysql4. Do you have a particular reason for using mysql4?

Title: Re: Remote Access To MYSQL
Post by: Duckie on May 11, 2005, 05:08:22 AM

Thank you for your reply:

Quote

That will only allow access to mysql from other machines on your LAN. It won't allow access from the Internet. You probably don't want to allow access from the Internet anyway.

The remote server is on the same public IP range so this should work.

Quote

I don't know whether the above tweak will affect mysql4. Do you have a particular reason for using mysql4?

The applications on my server require MYSQL4

Title: Connect to MYSQL
Post by: Duckie on May 12, 2005, 06:05:43 AM

Hi

I tried the commands and it still refuses access to the other server on the same ip range and subnet.

Anyone have any ideas

Please!!!!!!!

Title: Remote Access To MYSQL
Post by: jazbokes on May 13, 2005, 01:06:37 PM

getting the same error, using sme7 alpha12

[root@ipbx7 /]# /sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
[root@ipbx7 /]# /sbin/e-smith/expand-template /etc/my.cnf
[root@ipbx7 /]# /etc/rc.d/init.d/mysqld restart
Stopping MySQL:                                            [  OK  ]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]

john

Title: Remote Access To MYSQL
Post by: Duckie on May 18, 2005, 12:16:58 AM

Quote from: "jazbokes"

getting the same error, using sme7 alpha12

[root@ipbx7 /]# /sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
[root@ipbx7 /]# /sbin/e-smith/expand-template /etc/my.cnf
[root@ipbx7 /]# /etc/rc.d/init.d/mysqld restart
Stopping MySQL:                                            [  OK  ]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]

john

I did a system reboot aftr seeing that error then logged into mysql.

mysql -u root -p ******

Then i did this:

GRANT ALL ON *.* to username@***.***.***.*** IDENTIFIED BY "password";

All is working now