remote mysql

I'm trying to set up a remote mysql server and am having issues getting WHM to key into the remote server and su (i can do it manually from putty from one server to the other root -> user) but whm doesn't want to. But anyway, is SSH only for the initial setup of the remote server or is it...

Hello, I configured remote MySQL server in WHM (11.24.5), and I've a problem to restart mysql service. When I do this (Restart Services -> SQL (MySQL), LOCAL mysql server is restarted and not REMOTE mysql server. Any idea? Guilherme

I saw that WHM has a remote mysql server option. I am thinking about using it, only question I have is... if I use it, and everyone has the mysql server set to localhost, will that kill the mysql websites? If so, what can I do to fix this? Other than have all my customers go into the script...

Hi All, I have been reading some threads on setting up remote mysql. I really would like to do this to relieve some load on the cpanel server. From what I gather, I will install a second network card in the cpanel server and assign the interface a lan address. The new mysql server will...

I'm having an issue setting up my cpanel server to use an existing remote MySQL server. I have created a MySQL user on the remote server and given it the appropriate GRANTS. I can ssh to the remote server from the cpanel server. I can also connect to mysql on the remote server with the...

Hi, Is possible to setup one remote mysql server to use with three web server? I know cpanel supports one web, one remote mysql server via "Setup Remote MySQL server". Thanks

Hi there! I'm trying to set up remote mysql server, and got stuck. All my clients are using "localhost" as mysql address ( mysql_connect('localhost', 'user', 'pass'); ). New mysql server address would be sql.domain.com, so how am I supposed to redirect all "localhost" connections to...

OK I've got two problems here. I currently have web/DB on a single server. I just purchased 2 new servers, one for DB only one for cPanel/Web only. Well I configured the remote SQL. IP: IP of the machine Port: Non standard ssh port but I changed it Root Password. On the first...

Hi. I searched for this but found nothing unfortunately. I wonder if there is a way to use a php script (or built my own using some existing API) to add an IP in the Remote Database Access Hosts. I have to connect with a special software from different ip's on my database and wish not to add...

Hello, I'm going to update my remote MySQL server to MySQL 5.0.xx, but, I just want to know, the local MySQL-Client of WHM will stay 4.1.22, do I need to update manually (via yum or rpm) or I need (or can) do it the cPanel way ? Brief : I'm running currently cPanel/WHM on CentoS 4.7 with...

Hello, I was checking the Remote MySQL setting on cPanel that allows automagical clusterization for the mysql, but I would like to know if there's any posibility to... a) Use the same MySQL server to multiple cPanel servers (especially if the servers have repited users in between...

When setting this up - will it automatically copy all of the databases or do we need to do this one by one? ? We are looking to take all mysql databases onto a monster db server cluster (3 db servers using htproxy. Anyhow - my concern is if we will need to copy each database manually...

Any tips on getting this to work? I'm doing a update now http://rafb.net/p/GYrBa959.html thats my error, hopefully the update gets these files. Any other reason on a new cpanel/whm install this would happen? I've given proper permissions... =3

Hello, How would i remove a remote mysql setup i created few time ago? Seems i cant to find it. Thank you.

Hello, Sorry for my English, i'm French. I'm trying to install a remote mysql server but I have multiple errors : Using Remote mySQL Server Copying MySQL Script.....0%.. ..100%.. ...Done Running MySQL Script... Using 91.121.xx.xx as the access ip Sync Source...

Hi there, How do I delete a remote mysql host? Set one up accidentally and now I can't delete. Thanks! Aaron

If we setup cpanel to have the mysql work remotely, would the cpanel backups on that individual server also grab the mysql data from the mysql server and put it in that cpanel backup?

how can I setup it with mysql 5.0.45 ? I m using mysqlup but you know it is working on local. what can I do ?

Remote MySQL Host Setup Using Remote mySQL Server Copying MySQL Script.....0%.. ..100%.. ...Done Running MySQL Script... Using xx.xx.xx.xx as the access ip /scripts/cpanelsync.static: No such file or directory /root/.mysqlscript: line 14: curl: command not found...

How can be disabled remote access for MySQL for all users? I mean wich is the name of that icon in Feature Manager List?