MySQL Administrator

[seachen]

hi, may i know how do I use this application to connect my DA server mysql database?

Or any other program allow to connect mysql database remotely?

 

[vovaNux]

You should add your IP to the list of allowed IPs to connect from at your mysql tab and then you're welcome to use any software you like (I prefer Mysql Front)

 

[seachen]

how to add ip to allow to connect?

 

[vovaNux]

Click on the database name in MySQL section, then add an access hist - your IP there

 

[seachen]

thank you sir.

but may i know if i want to access da_admin

how to add on ip?

 

[vovaNux]

Don't quite get you - where do you want to add your IP to?

 

[Atlas]

I'm also trying to access the DA from a remote computer, but just don't know what port to find the MySQL on. Default for MySQL is 3306 but I do not get any connection thru that one. What is the default port for DA MySQL?

I have added my remote computer IP in to the access list.

I'm not the administrator of the webhost, I'm just renting space there but I do have access to the DA for my account. To access the DA I connect to xxx.xx.xx.xx:2222, is that any clue?

I have talked to the administrator but he does not seem to know what port to access. I asked him to open up port 3306 in his firewall and he has but still no luck.

Any ideas?

Edit: Is there a way how I can tip the host administrator on how to find what port to use for MySQL?

 

[vovaNux]

Triple check your IP address added to allowed hosts to connect from. I think the problem is there.

 

[Atlas]

I have tripple checked the IP and now even 2 times more since your post. It is the correct one.

When creating a user for the database that I intend to use I get the following message:

User added to database
Details
User atlas_hls has been added to your database. Use the following values:

Database:	atlas_e107
Host:	localhost
Username:	atlas_hls
Password:	******

Could the Host: localhost have anything to do with it? That the user is only permitted local access?

 

[vovaNux]

Check Access hosts:

Access Hosts Select
localhost

Is your IP there?

 

[Atlas]

Yes it is:

Access Hosts Select
83.249.98.93
localhost

 

[Atlas]

*BUMP*
Anyone that have any suggestions how so solve this problem?

 

[snk]

Did you use any firewall on your pc ?
check if 3306 port are open at server where you want to connect and your local pc.

 

[Atlas]

Yup, open and ready.

 

[ktizo]

check that your skip-networking is commented in my.cnf
#skip-networking