Welcome to WebmasterWorld Guest from 54.226.110.143

Forum Moderators: phranque

Message Too Old, No Replies

Getting server ready for mysql

     
4:45 am on Jul 9, 2009 (gmt 0)

Junior Member

10+ Year Member

joined:May 18, 2005
posts: 117
votes: 0


Hello,

This is the first time I will be using a server for only mysql.

The server has CentOS 5 installed.

What else do I need to install? I just installed mysql with the yum command. I need apache right?

Anything else?

What is the best way to take an existing database from another server and put it on this server? Then how do I make so that the site on web server is able to connect to the database on the mysql server?

What security measures do I need to take?

Thank you!

12:31 pm on July 9, 2009 (gmt 0)

Administrator

WebmasterWorld Administrator phranque is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Aug 10, 2004
posts:10563
votes: 16


What else do I need to install? I just installed mysql with the yum command. I need apache right?

only if you are also running a web server there.
the mysql server access from your web server is not using the http port or protocol.

Anything else?

ftp server

What is the best way to take an existing database from another server and put it on this server?

mysqldump, ftp the sql file, load into database

Then how do I make so that the site on web server is able to connect to the database on the mysql server?

this will show you how to connect from the command line but to connect from your script on the web server you will have to look at the documentation for the api you are using:
MySQL :: MySQL 5.1 Reference Manual :: 4.2.2 Connecting to the MySQL Server [dev.mysql.com]

What security measures do I need to take?

MySQL 5.0 Reference Manual :: 5.3 General Security Issues [dev.mysql.com]
7:54 am on July 27, 2009 (gmt 0)

Senior Member from LK 

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:Nov 16, 2005
posts:2523
votes: 37


ftp server

Unless you and the server are on a completely trusted local network, install ssh instead of ftp.

It gives you a secure command line and secure file transfers (using sftp or rsync).

What security measures do I need to take?

One thing you need is to have a firewall configured so only your webserver can connect to MySQL remotely, and the only other open port is ssh.