LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 04-07-2012, 05:14 AM   #1
yariboy
LQ Newbie
 
Registered: Apr 2012
Posts: 6

Rep: Reputation: Disabled
Advice needed setting up a MySQL server


Hello.

Firstly, I'll note I'm quite new to Linux.

My two friends and my self are developing a small Python application (client side). It will connect to a remote DB Server.

I've done some research and chose a CentOS 6.2 distro. It Will run MySQL. I'll use phpMyAdmin for management.

Does this sound reasonable? (I realize it's quite a broad question..)

Are there any alternatives I should consider?

What are the pre-requisites for MySQL running properly on the server?

What's easier for programming the logic in the server side - Python or PHP?

Do I need to configure Apache in order for my MySQL to work?

I'll probably have some more questions as I advance.

Thank You.
 
Old 04-07-2012, 05:40 AM   #2
saif_always
LQ Newbie
 
Registered: Jun 2010
Posts: 1

Rep: Reputation: 1
Cool

Hello there
I have no knowledge on python.
But regarding MySQL, you may use CentOS its good.
Install MySQL and configure it to run on startup. MySQL does not need Apache

phpMyAdmin requires 'Php' and 'apache' (or any other web server- Apache is the best)to run
 
1 members found this post helpful.
Old 04-07-2012, 05:49 AM   #3
yariboy
LQ Newbie
 
Registered: Apr 2012
Posts: 6

Original Poster
Rep: Reputation: Disabled
Thank you for your reply.

Are PHP and Apache run in startup by default?
Do I have to change permissions to either of the two?

Thanks again.
 
Old 04-07-2012, 07:22 AM   #4
ricstirato
Member
 
Registered: Jan 2004
Location: Gießen, Germany
Distribution: Xubuntu 12.04, Mythbuntu, Ubuntu Server 12.04
Posts: 174

Rep: Reputation: 24
Quote:
Originally Posted by yariboy View Post
Are PHP and Apache run in startup by default?
I don't know CentOS in detail, but usually they will when installed through the distro's mechanisms.

Quote:
Originally Posted by yariboy View Post
Do I have to change permissions to either of the two?
This is normally not necessary on the system level. However, you should add a MySQL user for your application that has limited access, i.e. permission only to the application's database and only INSERT/UPDATE/DELETE/whatever you need, no CREATE or ALTER permissions.
 
1 members found this post helpful.
Old 04-07-2012, 08:09 AM   #5
linuxlover.chaitanya
Senior Member
 
Registered: Apr 2008
Location: Gurgaon, India
Distribution: Cent OS 6/7
Posts: 4,631

Rep: Reputation: Disabled
Normally as I have seen, Apache wont be enabled to start on boot in Cent OS. You need to enable it using chkconfig. MySQL is good, but I have seen PostgreSQL to perform very nicely. You may want to look into it. PHP is easier to learn if you know C/C++. I have no idea about Python. But if you are looking at building a web application PHP is a good choice. PHP and apache work together very well. Apache, PHP and MySQL is I suppose most preferred combination for web applications.
 
1 members found this post helpful.
Old 04-07-2012, 08:44 AM   #6
Satyaveer Arya
Senior Member
 
Registered: May 2010
Location: Palm Island
Distribution: RHEL, CentOS, Debian, Oracle Solaris 10
Posts: 1,420

Rep: Reputation: 305Reputation: 305Reputation: 305Reputation: 305
For all you asked, you need to setup LAMP server.

Quote:
What's easier for programming the logic in the server side - Python or PHP?
PHP would be the better option.

And you'll find lots of material for setting up LAMP server on google.
 
1 members found this post helpful.
Old 04-07-2012, 10:49 AM   #7
yariboy
LQ Newbie
 
Registered: Apr 2012
Posts: 6

Original Poster
Rep: Reputation: Disabled
Thank you all, I'll look into it.

moves to solved.
 
Old 04-07-2012, 02:01 PM   #8
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,803
Blog Entries: 1

Rep: Reputation: 422Reputation: 422Reputation: 422Reputation: 422Reputation: 422
Are MySQL and the web server going to be on two separate machines? If so, how do you plan on securing the connection?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL cluster - advice for setting up deadeyes Linux - Server 1 10-27-2007 05:00 AM
Server Advice Needed tsk Linux - Hardware 3 11-08-2004 01:54 PM
Advice needed on setting up security on Fedora installation gevers1 Linux - Security 1 01-21-2004 09:31 AM
ColdFusion and MySQL - Advice Needed Zychior Linux - General 1 02-03-2002 09:59 PM
MYSQL advice needed. d3funct General 1 12-12-2001 12:48 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 03:49 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration