homepage Welcome to WebmasterWorld Guest from 54.145.238.55
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / WebmasterWorld / Webmaster General
Forum Library, Charter, Moderators: phranque

Webmaster General Forum

    
Getting server ready for mysql
Emilio

5+ Year Member



 
Msg#: 3948938 posted 4:45 am on Jul 9, 2009 (gmt 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!

 

phranque

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



 
Msg#: 3948938 posted 12:31 pm on Jul 9, 2009 (gmt 0)

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]

graeme_p

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 3948938 posted 7:54 am on Jul 27, 2009 (gmt 0)

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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Webmaster General
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved