homepage Welcome to WebmasterWorld Guest from 54.243.17.133
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / WebmasterWorld / Webmaster General
Forum Library, Charter, Moderators: phranque & physics

Webmaster General Forum

    
Getting server ready for mysql
Emilio




msg:3948940
 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




msg:3949141
 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




msg:3960133
 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