Gossamer Forum
Home : Products : Others : MySQLMan :

Want to edit database on another server

Quote Reply
Want to edit database on another server
Hi

I want to use MySQLMan on one server to edit a MySql database on a different server.
So i changed in msql.cfg "direct_host" from 'localhost' to '213.196.37.50'

I got the following Error Message:
connection failed: Host 'reaktie10.reaktie.com' is not allowed to connect to this MySQL server

how can i solve this problem? Please help.

Hans Heerings




Hans
Quote Reply
Re: Want to edit database on another server In reply to
You have to tell mysql about the changes as well - you can't just change the setting in mysqlman and hope it works.

Try reading here.....

http://www.mysql.com/doc/C/o/Connecting.html

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Quote Reply
Re: Want to edit database on another server In reply to
Hello Paul

I am not sure what you mean by "You have to tell mysql about the changes as well - you can't just change the setting in mysqlman and hope it works."

I am able to access (with MySQLMan installed on server "B") the database in server "B". So mysql knows username and password. All works fine.

I cannot access with MySQLMan (now installed on server "A") the database in server B. although I supplied the host name of Server B. and my user name, and my password for the database in the file mysql.cfg (on server A).

Thanks for answering

Hans Heerings


Hans
Quote Reply
Re: Want to edit database on another server In reply to
As I said, you need to setup MYSQL to accept remote connections......setting up MySQLMan to do this doesn't configure MySQL also.

Try reading the URL I gave you.

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/