Sergiu Tot

Well-Known Member
Jul 17, 2007
65
0
56
Cluj, Romania
cPanel Access Level
Root Administrator
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 trying to set it so that it will use the remote MySQL server. I set up the remote MySQL server by the book but it seems that it doesn't want to work properly. After seting everything up I get the following message:
Remote MySQL Host Setup
Using Remote mySQL Server
Copying MySQL Script.....0%.. ..100%.. ...Done
Running MySQL Script...

Using 89.x.x.x as the access ip
Could not execute updatenow: No such file or directory at /scripts/updatenow.static line 532.
Could not execute updatenow: No such file or directory at /scripts/updatenow.static line 532.
/home/stat/.mysqlscript: /usr/bin/mysql: not found
Waiting for mysql to restart..............finished.

mysql 1744 0.0 0.1 1728 1376 ?? S 11:43PM 0:00.02 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/databasehost.com.pid
mysql 1784 0.0 8.2 605452 85124 ?? S 11:43PM 0:00.42 /usr/local/libexec/mysqld --defaults-extra-file=/var/db/mysql/my.cnf --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/mysql/databasehost.com.pid --port=3306 --socket=/var/db/mysql/mysql.sock

mysql started ok


Done

databasehost.com is now configured for use as the remote mySQL server.
The remote MySQL is not set up. Can anyone tell me why is this happening ? Should I do something else before trying to set up the remote MySQL server ?

LE:
I also noticed something interesting. When I run /scripts/mysqlup I get the following message:
MySQL Setup Script Version 7.0
This is the MySQL installer for OS FreeBSD
mysql-client-5.0 (5.0.27) is already installed.
mysql-server-5.0 (5.0.27) is already installed.
open3: exec of rpm -ql MySQL-shared failed at /scripts/cPScript/SafeRun.pm line 158
Install Complete
 
Last edited: