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 Quote 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 Quote 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? Quote 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 Quote 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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.