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:
LE:
I also noticed something interesting. When I run /scripts/mysqlup I get the following message:
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:
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 ?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.
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: