Problems seting up remote MySQL

Sergiu Tot · Nov 22, 2007

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.
Click to expand...

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
Click to expand...

Forums

The Community Forums

Interact with an entire community of cPanel & WHM users!

Problems seting up remote MySQL

Sergiu Tot Well-Known Member

LTS 62.0.42 ends Upgrade problems?

Django app configuration problems

cPanel Update Problems

FIltering Problems

Problems setting up multiple domains with one physical server

Share This Page

Useful Searches

The Community Forums

Interact with an entire community of cPanel & WHM users!

Problems seting up remote MySQL

Sergiu Tot Well-Known Member

LTS 62.0.42 ends Upgrade problems?

Django app configuration problems

cPanel Update Problems

FIltering Problems

Problems setting up multiple domains with one physical server

Share This Page