remote mysql

I have just ordered a second server for my setup, this new server will be used exclusively for MySQL. I have just recently noticed that in WHM there is an option for Remote MySQL in there. My question is what does it do exactly? I want to make sure I don't screw anything up by using it...

I am trying to set CPanel to use an existing remote mysql server I have set up. The reason for it being existing is I all ready have another web server using the same server with the databases in place, but I am having troubles when setting it up. I go to WHM and run through the remote mysql...

I am trying to setup a site to use a database from another server. The setup is as follows: Server 1) contains the database I want to use Server 2) contains the wordpress script I have added the IP from Server 2 in cPanel under "Add Access Host" on Server 1 I have configured the...

Here is my situation, I run a free hosting company and we have about 15,000 accounts spread across three servers. I was thinking about getting an additional server to handle just MySQL. Would this be a viable option for me? To have a single database server and have the other three computers...

Hello ! I am trying to set up a remote MySQL server. I have both hosting and MySQL server as a blank installation. I installed MySQL 5.0.45 on the MySQL and I configured so that it works fine and can be accessed local & remote. I set up the other server, I installed cPanel on it and now I am...

Hi, running latest stable cPanel/WHM on CentOS 4.5 Some time ago I set up a remote MySQL server via WHM SQL Services which worked fine. Since 3 days the WHM no longer sees the remote mysql server and the created databases/usernames in cPanel aren't seen either. Absolutly nothing was...

Hello, I've tried to setup MySQL on a naked CentOS. I've only installed via "yum" mysql, mysql-server. I've saw in the MySQL Remote setup that I also need Perl. I've tried to install "perl", then "perl-DBI", then perl-mysql and some other.. but everytime I do te setup, I'm getting this ...

Hello ! I have one server that is in a situation that the hardware cannot be upgraded. My company doesn't want to buy another big server yet, so I was thinking of buying a smaller server to use it just for MySQL. The investment will be very small for a P3 (1000MHz, 512MB RAM) used as a...

i have a big problem on my end. i have 2 servers as i want to use as web front end, 1 site, 1 db. and 1 db server. i setup the first server to use remote mysql. now. when i setup the second server to use remote mysql, doesn't work. i mean the server is still set as localhost. any ideas?

Hi, I set a remote server additional mysql db, I set IP remote server, I set password root of remote server and I try connect to this: $db_host = "IPREMOTESERVER"; $db_user = "usernamerootserver"; $db_password = "passwordrootserver"; $db_name = "databasename"; But I get a error permission...

Hey, I have a question. I went to www.whatismyip.com and put in that ip into cpanel to allow for me to connect to it, but it didn't work. And I also added % and %.%.%.% because I'm making a program that uses my server's sql with the program. And since the program is going to be used by...

hi, i have done all the setup to make the remote mysql server: changed the /root/.my.cnf to the relative data updated the horde, phpMyAdmin, eximstats went to the WHM > SQL Services > Setup Remote MySQL server filled all everything change from sudo to su and inputed my root and procced...

In WHM if set a remote mysql server (with Remote mySQL Host Setup option) I can also continue to use the mysql localhost?

Hi, I'm ready to plunge into 2 server setup. I'm planning to get another dedicated server for MySQL server alone. My questions is 1. When i setup remote MYSQL server on WHHM do i need to move the database manually to the new MYSQL server? 2. Will the WHM and CPANEL includes the DB...

I'm trying to remotely access a mysql database on server 111.111.111.111 from server 222.222.222.222. I've logged into the cPanel account on server 111.111.111.111 and added 222.222.222.222 to the Remote Database Access Hosts. (As well as %.domain.com where domain .com.is the actual domain...

The port that needs to be open for remote mysql, does the firewall on the file server need to have the port open for incoming or outgoing or both. Even better with cfs how can only allow access to that port from one or two ip's? :p

Hello, I am thinking of using 2cpanel servers i currenly have and then using another server for mysql. Is it possible to put the port in for each server or do they have to be on the default port? If it isnt possibe what you you recommend we do?

I have 2 servers, one for the Web (Server 1) and one for the DB (Server 2). Aside from the web, server1 also host whm/cpanel and DB for phpadsnew and roundcube. While server 2 host the main DB of the site (no cpanel). Everything was running smoothly before. Since cpanel can only add DB on...

Hi there, I am thinking about using Remote MySql from within whm but not sure if it will give me the reults I am looking for. If I use the Remote MySql Setu from within whm what exaclty will this do? Will this turn off / disable mysql on the server and only use mysql from the one that...

Any idea how to check if a database is not used and remove it for free space?