We have a cpanel server with a local MySQL server.
We have a separate MySQL database server that we have successfully connected as a remote MySQL profile within WHM.
How do we / can we assign the second MySQL profile to be used by a specific account?
We want specific accounts to operate on...
We don't allow remote MySQL on shared servers so we would like to remove the remote MySQL icon from cPanel to eliminate confusion.
I'm looking in the feature request section but it only lists MySQL not just the remote MySQL option.
Currently I have to whitelist each of my customers IP's for remote mysql access on 3306. However, we have dynamic IP's in our country and so adding/updating IP's on the firewalls allow every day is a real pain. Looking to open up port 3306; but what measures should I take to ensure the...
Does the WHM Backup function backup the MySQL databases if the server is configured via WHM to use Remote MySQL Server?
If not, then any recommendations on how to back it up in line with the account backups?
I am running into a bit of a snag setting up a remote MySQL server, I've read the setup instructions line for line.
**Note this is not Remote SQL as in white-listing IP addresses to access a database but rather off loading the MySQL work load to another server.**
Our Web Server has tried to upgrade to WHM 11.44 but failed and is showing the yellow error box message in WHM stating that "The last attempt to update cPanel & WHM was blocked. " - "Please correct these issues and rerun updates.
fatal: Newer releases of cPanel & WHM are not compatible...
I have two servers, and I recently upgraded one of them. The one that has been upgraded hosts the main MySQL database.
The other server has several sites that access this database. They all worked fine when accessing the old server, but now I'm getting this error:
Can't connect to MySQL...
I have my WordPress installations configured to use a remote MySQL server. I couldn't find where I can set this in the cPanel install of WordPress.
I know I can / have installed WordPress manually via FTP but I was hoping to save a little time
Could someone confirm to me if it is expected behavior that when you stop using the "remote mysql server" option and revert back to using the local install it removes all databases that are currently installed.
If this is the case (as I have just found out), where is this documented.
When I create a new mysql database + user (trough wizard) in cPanel on a newly created account (in WHM) remote mysql connections are blocked.
BUT, when i visit the remote mysql page in cPanel this somehow resets and remote mysql connections ARE allowed.
I have setup additional access hosts in...
This is probably quite the "n00b" question; if I activate remote mysql on a production server, will it automatically move the sql databases off the main server, and onto the new remote sql server?
I'm looking for ways to reduce disk i/o one of my older servers, and it seems that MySQL is...
When using 'Setup Remote MySQL server', is it exclusive or inclusive? I would like to offload a few heavy hitters to a dedicated MySQL server and want to know if this features allows the use of both localhost and a remote host.
I have read mixed information on this forum about how this should actually work.
Hopefully someone can give me the right answer :)
We started with server1 and at some point a previous admin decided it would be a good idea to use a remote server just for mySql. So we ended up with server2...
I have Server ONE current handle MySQL, I want use Server TWO handle all this MySQL and Server one only handle APACHE only. Both Server Install Cpanel (Centos). Anyone can tell me step by step to do this via WHM. Thank :D
[email protected]'s password: ==sshcontroloutput==
Using 126.96.36.199 as the access ip
Sync Source: http://httpupdate.cpanel.net/RELEASE/Cpanel
I saw a lot of threads about this feature, but no succes. I can't connect to my sql server.
There we go :
I got a vm with Debian & mysql 5.0, I can connect via my vm with cpanel (centOS)
#mysql -u root -p -h sql.domain.com
it works nice.
But if I try to setup a remote...
I try to setup a remote mysql server on a standard centos installation. I installed already mysql and perl on this server and then tried the function in WHM to setup the remote server. But I get the following error message:
Using Remote mySQL Server
Fetching password from remote...
I'm trying to setup a remote mysql server, and it is returning the following once I have input all the server details:
[email protected]******* password: ==sshcontroloutput==
Using ********* as the access ip
Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/scripts