Setup Remote MySQL server

Maxence · Apr 26, 2010

Hello there,

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 sql server via my cpanel WHM
I got this :

Code:

trace ouput :
[email protected]'s password: ==sshcontroloutput==
Using xxx.xxx.xxx.xxx as the access ip
Sync Source: http://httpupdate.cpanel.net/RELEASE/Cpanel
Fetching http://httpupdate.cpanel.net/cpanels...panelsync.lock (0)[email protected] ......Done
Fetching http://httpupdate.cpanel.net/cpanels...cpanelsync.bz2 (1)[email protected] ...100%......Done
Can't exec "bzip2": No such file or directory at /scripts/cpanelsync line 512, <$__ANONIO__> line 18.
Sync Source: http://httpupdate.cpanel.net/RELEASE/scripts
Fetching http://httpupdate.cpanel.net/cpanels...panelsync.lock (0)[email protected] ......Done
Fetching http://httpupdate.cpanel.net/cpanels...cpanelsync.bz2 (1)[email protected] ...100%......Done
Can't exec "bzip2": No such file or directory at /scripts/cpanelsync line 512, <$__ANONIO__> line 18.
Sync Source: http://httpupdate.cpanel.net/RELEASE/Cpanel
Fetching http://httpupdate.cpanel.net/cpanels...panelsync.lock (0)[email protected] ......Done
Fetching http://httpupdate.cpanel.net/cpanels...cpanelsync.bz2 (1)[email protected] ...100%......Done
Can't exec "bzip2": No such file or directory at /scripts/cpanelsync line 512, <$__ANONIO__> line 18.
Sync Source: http://httpupdate.cpanel.net/RELEASE/scripts
Fetching http://httpupdate.cpanel.net/cpanels...panelsync.lock (0)[email protected] ......Done
Fetching http://httpupdate.cpanel.net/cpanels...cpanelsync.bz2 (1)[email protected] ...100%......Done
Can't exec "bzip2": No such file or directory at /scripts/cpanelsync line 512, <$__ANONIO__> line 18.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Waiting for mysql to restart..............finished.

[2010-04-26 17:11:01 +0200] info [restartsrv_mysql] BSD::Resource not available. Resource Limits not adjusted
mysqld_safe (/bin/sh /usr/bin/mysqld_safe) running as root with PID 8463
mysqld_safe (logger -p daemon.err -t mysqld_safe -i -t mysqld) running as root with PID 8501
mysqld (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock) running as mysql with PID 8500

[2010-04-26 17:11:06 +0200] info [restartsrv_mysql] BSD::Resource not available. Resource Limits not adjusted
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

Any help will be appreciated

thewebhostingdi · Apr 26, 2010

Kindly refer to below mentioned URL which might helps you to solve your issue:

http://forums.cpanel.net/f5/remote-mysql-server-142657.html
http://forums.cpanel.net/f5/setting-up-remote-mysql-114669.html

cPanelDavidG · Apr 27, 2010

You mentioned using Debian. You may want to consider using an OS currently supported by cPanel/WHM for a better experience:

System Requirements - cPanel Inc.

Maxence · May 8, 2010

Thanks for your anwsers, I use debian for my mysql server not for cpanel. But I tested with centOS, got the same problem :/

I read your link but I don't know how to solve it

Using Remote mySQL Server
Fetching password from remote mysql server.... Copying mysql configuration from remote host.....0%.. ..100%.. ...Done
...password set in /root/.my.cnf on remote server, it will be used...Done
Generating Setup Script....Done

Copying MySQL Script.....0%.. ..100%.. ...Done
Running MySQL Script...

Using XXX.XXX.XXX.XXX as the access ip
Sync Source: http://httpupdate.cpanel.net/RELEASE/Cpanel
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/Cpanel/.cpanelsync.lock (0)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/Cpanel/.cpanelsync.bz2 (1)[email protected]%......Done
Sync Source: http://httpupdate.cpanel.net/RELEASE/scripts
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.lock (0)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.bz2 (1)[email protected]%......Done
Sync Source: http://httpupdate.cpanel.net/RELEASE/Cpanel
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/Cpanel/.cpanelsync.lock (0)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/Cpanel/.cpanelsync.bz2 (1)[email protected]%......Done
Sync Source: http://httpupdate.cpanel.net/RELEASE/scripts
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.lock (0)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/scripts/.cpanelsync.bz2 (1)[email protected]%......Done
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Waiting for mysql to restart..............finished.

[2010-05-08 22:21:12 +0400] info [restartsrv_mysql] BSD::Resource not available. Resource Limits not adjusted
mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --user=mysql) running as root with PID 1673
mysqld (/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock) running as mysql with PID 1723

[2010-05-08 22:21:17 +0400] info [restartsrv_mysql] BSD::Resource not available. Resource Limits not adjusted
/usr/bin/mysqladmin: connect to server at 'localhost' failed

error: 'Access denied for user 'root'@'localhost' (using password: YES)'

cPanelJamyn · May 10, 2010

Maxence said:
/usr/bin/mysqladmin: connect to server at 'localhost' failed

The core problem here is that the mysql password you are providing to the script appears to be incorrect.

Maxence · Aug 7, 2010

Trying to solve it but it's still doesn't work :/

Anyone can help me please ? Fresh install with a clean cPanel VPS Optimized (CentOS)

arunsv84 · Aug 7, 2010

Are you getting the same error message as mentioned above? Please paste the exact error message here...

Maxence · Aug 7, 2010

Sql server 111.222.333.444
Cpanel server : 111.222.333.555

Using Remote mySQL Server
Fetching password from remote mysql server.... Copying mysql configuration from remote host.....0%.. ..100%.. ...Done
...password set in /root/.my.cnf on remote server, it will be used...Done
Generating Setup Script....Done

Copying MySQL Script.....0%.. ..100%.. ...Done
Running MySQL Script...

Using 111.222.333.555 as the access ip
Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/Cpanel
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/Cpanel/.cpanelsync.lock (0)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/Cpanel/.cpanelsync.bz2 (1)[email protected]%......Done
Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/scripts
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/scripts/.cpanelsync.lock (0)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/scripts/.cpanelsync.bz2 (1)[email protected]%......Done
Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/Cpanel
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/Cpanel/.cpanelsync.lock (0)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/Cpanel/.cpanelsync.bz2 (1)[email protected]%......Done
Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/scripts
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/scripts/.cpanelsync.lock (0)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/scripts/.cpanelsync.bz2 (1)[email protected]%......Done
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Waiting for mysql to restart..............finished.

[2010-08-07 06:11:27 +0000] info [restartsrv_mysql] BSD::Resource not available. Resource Limits not adjusted
mysqld_safe (/bin/sh /usr/bin/mysqld_safe) running as root with PID 10735
mysqld (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306) running as mysql with PID 10846

[2010-08-07 06:11:32 +0000] info [restartsrv_mysql] BSD::Resource not available. Resource Limits not adjusted
/usr/bin/mysqladmin: connect to server at 'localhost' failed

error: 'Access denied for user 'root'@'localhost' (using password: YES)'

Trace ouput :

[email protected]'s password:
Linux sql1 2.6.24-11-pve #1 SMP PREEMPT Fri May 14 09:28:08 CEST 2010 x86_64

The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Sat Aug 7 05:37:54 2010 from 356.free.fr

[email protected]:~# export LANG=C ; setenv LANG C ; echo ${LANG}_SSH_CLIENT=${SSH_CL
<; setenv LANG C ; echo ${LANG}_SSH_CLIENT=${SSH_CLI ENT}
-bash: setenv: command not found
C_SSH_CLIENT=111.222.333.555 41461 22
[email protected]:~# sudo su
-bash: sudo: command not found
[email protected]:~# setenv SSH_CLIENT 111.222.333.555 ; export SSH_CLIENT=111.222.333.
<ENT 111.222.333.555 ; export SSH_CLIENT=111.222.333.555
-bash: setenv: command not found
[email protected]:~# set TERM dumb ; export TERM=dumb
[email protected]:~# stty columns 80
[email protected]:~# stty columns 80
[email protected]:~# perl -e 'print "\t==sshcontroloutput==\n"';sh ~root/.mysqlscript
< "\t==sshcontroloutput==\n"';sh ~root/.mysqlscript ; rm -f ~root/.mysqlscrip
<"';sh ~root/.mysqlscript ; rm -f ~root/.mysqlscript ;echo;perl -e 'print "\t=
< rm -f ~root/.mysqlscript;echo;perl -e 'print "\t== sshcontroloutput==\n"'
==sshcontroloutput==
Using 111.222.333.555 as the access ip
Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/Cpanel
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/Cpanel/.cpanelsync.lock (0)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/Cpanel/.cpanelsync.bz2 (1)[email protected]%......Done
Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/scripts
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/scripts/.cpanelsync.lock (0)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/scripts/.cpanelsync.bz2 (1)[email protected]%......Done
Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/Cpanel
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/Cpanel/.cpanelsync.lock (0)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/Cpanel/.cpanelsync.bz2 (1)[email protected]%......Done
Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/scripts
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/scripts/.cpanelsync.lock (0)[email protected]
Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE-x86_64/scripts/.cpanelsync.bz2 (1)[email protected]%......Done
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Waiting for mysql to restart..............finished.

[2010-08-07 06:11:27 +0000] info [restartsrv_mysql] BSD::Resource not available. Resource Limits not adjusted
mysqld_safe (/bin/sh /usr/bin/mysqld_safe) running as root with PID 10735
mysqld (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306) running as mysql with PID 10846

[2010-08-07 06:11:32 +0000] info [restartsrv_mysql] BSD::Resource not available. Resource Limits not adjusted
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

Maxence · Aug 10, 2010

I don't understand why this feature doesn't work, I saw a lot of topic about remote mysql server, and no one is solved ...

cPanel don't support it anymore ?

asent · Aug 10, 2010

Create another root user with the host to match the cpanel server ip address you're connecting from? Looks like a auth failure to me.

nilesh_kolte · Aug 10, 2010

Hello,

Try following..

1. Login to WHM
2. Click on Additional MySQL Access Hosts
3. Enter the Debian Servers IP there.
4. Click on Setup Remote MySQL server
5. Enter Debian server Hostname, Port,
6. Login as Root,Enter root password
And click on setup.

Make sure you have add Debian server IP to WHM server allow list and WHM server IP in Debian server allow list.

Regards,

cPanelDon · Aug 11, 2010

Maxence said:
I don't understand why this feature doesn't work, I saw a lot of topic about remote mysql server, and no one is solved ...

cPanel don't support it anymore ?

Please consider submitting a support request directly to us so that we may assist with investigating the difficulty being experienced. When available, please send me a private message referencing this thread and including the ticket ID number of your support request so that we may follow-up internally. If you have submitted a support request about this in the past, please also let me know your earlier ticket ID number(s) so that we may review the prior communication.

wescb · Sep 16, 2010

FYI, since accessing cPanel support was such a nightmare, the key to this issue (for me at least) was in the first few lines:

...password set in /root/.my.cnf on remote server, it will be used...Done

Looking at this file it appeared to have a long hash of my password, I changed it to the cleartext MySQL password (leaving the quotes), restarted mysql and I was able to add the remote MySQL server to WHM.

Hope that helps,
Wes

cPanelDon · Sep 16, 2010

wescb said:
FYI, since accessing cPanel support was such a nightmare, the key to this issue (for me at least) was in the first few lines:

...password set in /root/.my.cnf on remote server, it will be used...Done

Looking at this file it appeared to have a long hash of my password, I changed it to the cleartext MySQL password (leaving the quotes), restarted mysql and I was able to add the remote MySQL server to WHM.

Hope that helps,
Wes

So that we may more accurately diagnose the root cause, please let us know the OS and OS version of both servers and the full cPanel version number of the system that was used to setup the remote MySQL server via WebHost Manager. Knowing this information will help us to identify possible circumstances and attempt to reproduce the difficulty.

For reference, the cPanel version is displayed in the upper-right corner of WHM, but it can also be obtained via root SSH access; the following command will output the cPanel version and environment type:

Code:

# grep -H '' /usr/local/cpanel/version /var/cpanel/envtype

If using CentOS or RHEL, the OS version can be obtained using the following command via root SSH access:

Code:

# cat /etc/redhat-release

sohahm · Sep 3, 2011

cPanelJamyn said:
The core problem here is that the mysql password you are providing to the script appears to be incorrect.

It solved the issue I was having, thank you. I had saved the password in HeidiSQL client and forgot to recheck it.

Thread starter	Similar threads	Forum	Replies	Date
V	Can't setup remote mysql profile	Databases	3	Oct 19, 2022
S	SOLVED Setup Remote MySQL - WHM 68	Databases	3	Apr 16, 2018
	How to setup remote mysql server to decrease RAM usage on source server?	Databases	1	Jul 12, 2016
M	setup remote mysql manually	Databases	3	Oct 16, 2015
M	Setup Remote MySQL Server - public or private ip?	Databases	3	Sep 27, 2015

Search

Search

Setup Remote MySQL server

Maxence

Member

thewebhostingdi

Well-Known Member

cPanelDavidG

Technical Product Specialist

Maxence

Member

cPanelJamyn

Social Engineer

Maxence

Member

arunsv84

Well-Known Member

Maxence

Member

Maxence

Member

asent

Active Member

nilesh_kolte

Well-Known Member

cPanelDon

cPanel Quality Assurance Analyst

wescb

Registered

cPanelDon

cPanel Quality Assurance Analyst

sohahm

Registered