Topic: Remote Access To MYSQL

[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

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

[CharlieBrady]

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.

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?

[Duckie]

Thank you for your reply:

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.

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

[Duckie]

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!!!!!!!

[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

[Duckie]

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