Tag Archive for 'mysql'

LAMP (Linux, Apache, MySQL and PHP) is an open source Web development platform that uses Linux as operating system, Apache as the Web server, MySQL as the relational database management system and PHP as the object-oriented scripting language.

This instruction will install the basic components for a dynmaic, database-driven web site. We use apt-get 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.

sudo apt-get install apache2 php5 mysql-client mysql-server phpmyadmin libapache2-mod-php5 libapache2-mod-auth-mysql php5-mysql

2. 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]

3. 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;

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

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

<?php phpinfo(); ?>

5. 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’;