Configuring and Maintaining Your Server 75
Setting Up Remote Database Hosting
If you are going to use a Plesk-managed server as a remote database server, you do
not need to install MySQL software: Plesk comes with MySQL software, which is
automatically installed during installation of Plesk. In this case, you only need to enable
network access to this database server and then register it with Plesk.
To set up a MySQL database server:
1 Copy to your server a MySQL distribution package from your
operating system distribution disk, or download it from
www.mysql.com site and save it on your server.
2 Log in as root to your server and change to the directory where you
saved the RPM distribution. Type the following command at the
prompt:
rpm -ivh mysql_file_name.rpm
3 Set the database server administrator‘s password. Type the following
command at the prompt:
mysqladmin -u root password your_desired_password
Change your_desired_password to anything you like.
4 Now proceed to the instructions on registering your database server
with Plesk.
To set up a PostgreSQL database server:
1 Copy to your server a PostgreSQL distribution package from your
operating system distribution disk, or download it from
www.postgresql.org site and save it on your server.
2 Log in as root to the server where you want to host databases, and
change to the directory where you saved the distribution package.
3 Install the package in a way suitable for your operating system.
For RPM based Linux systems, type the following command at the prompt: rpm
-ivh postgresql_file_name.rpm
For deb package based Linux systems, issue the command:
apt-get install package_name
For FreeBSD systems, to install from a package, issue the following command:
pkg_add pgsql-<version>.tgz
To install from ports, issue the following commands:
cd /usr/ports/databases/postgresql<version>-server
make install package clean
