Installing Apache, PHP, and MySQL on Fedora Core

Installing Apache, PHP, and MySQL on Fedora Core

This will install the basic components for a dynmaic, database-driven web site. We use yum to handle dependencies and gather all of the required packages.

1. Install Apache (httpd), PHP, MySQL (server and client), and the component that allows php to talk to mysql.

 yum -y install httpd php mysql mysql-server php-mysql wordpress phpMyAdmin 

2. Configure the new services to start automatically

 /sbin/chkconfig httpd on
 /sbin/chkconfig --add mysqld [this is not required with FC4 and above]
 /sbin/chkconfig mysqld on

/sbin/service httpd start
 /sbin/service mysqld start

3. IMPORTANT! Set up the mysql database root password. Without a password, ANY user on the box can login to mysql as database root. The mysql root account is a separate password from the machine root account.

 mysqladmin -u root password 'new-password' [quotes are required]

4. Make additional security-related changes to mysql.

 mysql -u root -p

mysql> DROP DATABASE test; [removes the test database]
 mysql> DELETE FROM mysql.user WHERE user = ''; [Removes anonymous access]
 mysql> FLUSH PRIVILEGES;

5. Following the above steps, the document root for Apache is /var/www/html/

Create a test PHP script (such as phpinfo.php) and place it in the document root. A useful test script sample:

 <?php
 phpinfo();
 ?>

6. Create a database and database user for your data. You will use this database and user name in your database connection string. The GRANT statement actually creates a new MySQL user account.

 mysql> CREATE DATABASE web_db; 
 mysql> GRANT ALL PRIVILEGES ON web_db.* TO 'web_user'@'localhost' IDENTIFIED BY 'thepassword'; 

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 httpd                   i386       2.2.3-8          development       1.1 M
 mysql                   i386       5.0.33-1.fc7     development       3.4 M
 mysql-server            i386       5.0.33-1.fc7     development        10 M
 php                     i386       5.2.1-2          development       1.3 M
 php-mysql               i386       5.2.1-2          development        72 k
Installing for dependencies:
 perl-DBD-MySQL          i386       3.0008-1.fc7     development       148 k
 php-cli                 i386       5.2.1-2          development       2.1 M
 php-common              i386       5.2.1-2          development       197 k
 php-pdo                 i386       5.2.1-2          development        53 k

Transaction Summary
=============================================================================
Install      9 Package(s)         
Update       0 Package(s)         
Remove       0 Package(s)         

Total download size: 18 M

>>>>>>http://www.flmnh.ufl.edu/linux/install_apache.htm