• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Host name for mysql ???

T

tnobs

Guest
Hi

I want to store weather data form a weather station in my mysql database on the server. The weather software (weather display) tries to connect to the mysql databse, without any success.

It tells me:
Unknown mysql server host

What do I have to type in for hostname:
is that just the domain, where I setup the database?

host: ????
user: xxxx
password: xxxx
database_name: xxxx
table: xxxx

thanks, tnobs
 
Try the main IP address of the server. And you may also need to turn on the option to allow remote connections to the database.
 
I always thought there was a way to do it within the plesk cp, but perhaps that was before plesk 8.

That looks about right. Give it a shot and let us know.
 
oje

First I tried to use the IP for the host name, didn't work.

I opened the file
/etc/mysql/my.cnf


I was looking for the:
# bind-address = 10.10.0.1
# skip-networking

I found the bind-address line, but the skip-networking isn't there. Instead it says:
skip-external-locking

For me, it would be logical to not disable this line, since it says skip locking or?

I'm definitly not a pro on linux, and I don't want to screw the server. Maybe someone can tell me what to do?

Tnobs
 
Back
Top