coldfission Posted July 17, 2007 Share Posted July 17, 2007 Our mysql server is currently only letting us access it through a localhost connection. I need to be able to access it over the internet with other applications. Do i need to change something in the config file to do this? thanks Link to comment https://forums.phpfreaks.com/topic/60427-allow-connections-other-than-localhost/ Share on other sites More sharing options...
jvrothjr Posted July 17, 2007 Share Posted July 17, 2007 change HOST in the user ID to % this will allow user connection remotelly Link to comment https://forums.phpfreaks.com/topic/60427-allow-connections-other-than-localhost/#findComment-300580 Share on other sites More sharing options...
coldfission Posted July 17, 2007 Author Share Posted July 17, 2007 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid that is my config. what will it look like after i change this setting? Link to comment https://forums.phpfreaks.com/topic/60427-allow-connections-other-than-localhost/#findComment-300588 Share on other sites More sharing options...
jvrothjr Posted July 17, 2007 Share Posted July 17, 2007 Its defined when the user is set in mysql not in the config file Link to comment https://forums.phpfreaks.com/topic/60427-allow-connections-other-than-localhost/#findComment-300603 Share on other sites More sharing options...
coldfission Posted July 17, 2007 Author Share Posted July 17, 2007 Query failed: Can't connect to MySQL server on... At one time i was able to connect to the server remotely with this username and password i am using for localhost. Then, some settings were changed or something and now i can't get in remotely. Link to comment https://forums.phpfreaks.com/topic/60427-allow-connections-other-than-localhost/#findComment-300616 Share on other sites More sharing options...
jvrothjr Posted July 17, 2007 Share Posted July 17, 2007 check your user at the server valid information Link to comment https://forums.phpfreaks.com/topic/60427-allow-connections-other-than-localhost/#findComment-300627 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.