Installing My. SQL and Apache with PHP support on Linux. Building a LAMP Serverby Bruce Timberlake. Centos Install Php As Apache Module Mod_Dir' title='Centos Install Php As Apache Module Mod_Dir' />phpphpmysql. Crazy Advanced Web Development for server admins, WordPress, and hackers with online tools and articles on Htaccess Rewrites, Linux, and PHP. This document will walk you through the installation of what is known as a LAMP system. Linux, Apache, My. SQL and PHP. Depending on who you talk to, the P also stands for Perl or. Python, but in general, it is assumed to be PHP. I run Cent. OS. on my servers these directions were written for Cent. Centos Install Php As Apache Module Mod_Dir' title='Centos Install Php As Apache Module Mod_Dir' />OSRed HatFedora. I have had requests. Su. SE another RPM based distribution as well as Debian based systems, so I will work on. The main difference between the distributions is in the paths to the startup scripts. Red Hat. systems used etcrc. LAMP howto install MySQL and a PHPenabled Apache webserver on Linux httpwww. Su. SE uses etcinit. If you need an SSL enabled server, I have a LAMP with SSL howto as well. I designed this document so you can just copypaste each line or block of commands. This avoids tedious typing, and. These commands work properly. If you are having problems and you are not using copypaste, please. It doesnt work. Text in a command box like this one is a literal Linux commandline. One note many many people have followed these directions as written. If you are having a problem, chances are its something you are doing or not doing, something differentabout your computer, etc. It is probably NOT this procedure. Initial Steps. PLEASE BE AWARE THAT A SOURCE BASED INSTALLATION LIKE THIS. ONE IS NOT NEEDED FOR A BASIC LAMP SERVER You should only be doing a source based. LAMP stack e. g., you need a feature in PHP that isnt in the default RPM. If you are just getting started with LAMP, use the binaries provided by your. Most out of the box Red Hat Linux installations will have one or more of the LAMP. RPM files. I personally believe in installing things like this from. I get the most control over whats compiled in, whats left out, etc. But. source code installs can wreak havoc if overlaid on top of RPM installs, as the two most. If you have not yet installed your Linux OS, or just for future reference, do not choose. Apache, PHP, or My. Pepsi Man Game Xp'>Pepsi Man Game Xp. SQL during the system installation. Then you can immediately. Note to install applications from source code, you will need a C compiler gcc installed. This is generally taken care of, but Ive had enough queries about it that Ive added this. You can use your distributions install CDs to get the proper. Or, if you are using an RPM based distro, you can use a site like. RPM. version for your system. You will obviously not be able to userebuild a source RPM to get. RPM On a Fedora. Log in as root. Because we will be installing software to directories that regular users dont have. RPM versions of some applications, well. The only steps that needroot access are the actual. If you do not have direct access via keyboard to the server, PLEASE use. Secure Shell SSH to access the server and not telnetWhenever you use telnet or plain FTP for that matter, you are transmitting your username. This means that anyone who can access. PC and your server can snoop your session and get your info. Use encryption wherever possible Remove RPM Versions of the Applications. Before we start with our source code install, we need to remove all the existing RPM files. To find out what RPMs are already installed, use the RPM query command rpm qain conjunction with grep to filter your results. The httpd search is in case you have Apache. RPM. To remove the RPMs generated by these commands, dorpm e filenamefor each RPM you found in the query. If you have any content in your My. SQL database. already, the RPM removal step should not delete the database files. When you reinstall. My. SQL, you should be able to move all those files to your new My. SQL data directory and. Get the Source Code for all Applications. We want to put all our source code someplace central, so its not getting mixed up in someones. One way application source code is distributed is in what are known as tarballs. The tar command. Tape ARchive. Its also a handy way to pack up multiple files for easy distribution. Use the man tar command to. At the time of updating this, the current versions of all the components well use are. My. SQL 4. 1. 2. Apache 1. PHP 4. 4. 6. Please note these are the only versions of these that I have. If you use another version of. HOWTO may not be accurate, and I. Paid support and. There may be an Apache mirror closer to you check their mirror. Then insert the URL you get in place of the above for the wget. For My. SQL, go to http www. My. SQL version v. Unpack the Source Code. This should leave you with the following directories. Build and Install My. SQLFirst, we create the group and user that owns My. SQL. For security purposes. My. SQL running as root on the system. To be able to easily. My. SQL processes in top or a ps list, well make a user. My. SQL Server mysql. If you get any messages about the group or user already existing, thats fine. The goal is just to make sure we have them on the system. What the useradd command is doing is creating a user mysql. My. SQL Server. This way when its. Now well change to the working directory where the source code is. The configure command has many options you can specify. I have listed some fairly common ones if youd like to see others, do. Read the documentation. My. SQL website for a more detailed explanation of each option. R root. root make clean. Jul 2. 00. 5 If you are installing My. SQL 4. 0. x on Fedora Core 4, there is a. Linux. Threads that prevents My. SQL from compiling properly. Installing on Fedora Core 3 works fine though. Thanks to Kevin Spencer for bringing. There is a workaround listed at. Thanks to Collin Campbell for that link. Another solution can be. Thanks to Kaloyan Raev for that one. Now comes the long part, where the source code is actually compiled and then installed. Plan to get some coffee or take a break while this step runs. It could be 1. 0 1. Configure My. SQLMy. SQL is installed but we have a few more steps until its actually done. First run the script which actually sets up My. SQLs. internal database named, oddly enough, mysql. Then we want to set the proper ownership for the My. SQL directories and data files, so that. My. SQL and root can do anything with them. R root mysql usrlocalmysqlchown R mysql mysql usrlocalmysqldata. Copy the default configuration file for the expected size of the database small, medium, large, huge. If you get an error message about the data directory not existing, etc., something went. Go back and review that make sure you didnt. Now we have to tell the system where to find some of the dynamic libraries that. My. SQL will need to run. We use dynamic libraries instead of static to keep the memory. My. SQL program itself to a minimum. Cisco Ip Phone Firmware Files. Now create a startup script, which enables My. SQL auto start each. Then set up symlinks for all the My. SQL binaries, so they can be run. My. SQL Security Issues. First, we will assume that only applications on the same server. So well tell My. SQL not to even. TCP connections like it does by default. Edit etcmy. cnf and uncomment the skip networkingline delete the leading. For more security info, check out this. My. SQL security tutorial. Start My. SQLFirst, test the linked copy of the startup script in the normal server runlevel. S9. 0mysql start.