How do I connect to a MySql server using a web address?

[usalabs3]

after setting up MySql server to use TCP/IP on a select port, for some reason I can only use localhost as the host at home, I would like to be able to access my server using something like MySql Manager across TCP/IP remotely, using a web address or an IP address, but I can't, how do I name the server's host to a web address? and not localhost.

 

[jemminger]

not really sure... using the host name or ip works for me using mysql administrator:

http://dev.mysql.com/downloads/administrator/index.html

perhaps your host has configured mysql to only accept connections from localhost?


-jeff

http://www.jeffemminger.com

try { succeed(); } catch(E) { tryAgain(); } finally { rtfm(); }
i like your sleeves...they're real big

 

[usalabs3]

The host is run from home, how do I configure mysql to accept connections from the internet?. I have enabled TCP/IP on a chosen port, but, no dice, when I enter either my ip address or a web address (which has a DNS record pointing to my IP address) into MySql Administrator with the same port as the server, I get an error 'Unknown MySql server host [mydomain name/ip address] (11004)', but if I entered 'localhost' I get access.

 

[jemminger]

you or your ISP might have a firewall blocking requests?

-jeff

http://www.jeffemminger.com

try { succeed(); } catch(E) { tryAgain(); } finally { rtfm(); }
i like your sleeves...they're real big

 

[tchatzi]

are you sure the port is correct?
do

mysql> show variables;

and check the list for the port varaible

and

are you sure that your router is forwarding that port to your pc's ip ?

Try also to access your server from the command line like this

# mysql -hxxx.xxx.xxx.xxx -umyuser -pmypassword

First be sure that when you do

mysql> use mysql;
mysql>select user,password,host from user;

gives you something like this

+-------------+------------------+-----------+
| user        | password         | host      |
+-------------+------------------+-----------+
| root        | jhgf788734y34bf7 | localhost |
| internet    | 36355hc8838323gd | %         |
+-------------+------------------+-----------+

and you access the server with user name 'internet'


``The wise man doesn't give the right answers,
he poses the right questions.''
TIMTOWTDI

 

[usalabs3]

the mysql command always shows the variables, regardless of any commands, following it, EG. from the command prompt mysql [enter] shows the variables, from the command prompt mysql use mysql; shows the variables, and from the command prompt mysql use mysql; shows the variables, it doesn't matter what I place after the mysql command it will always display the variables.