Tuesday, October 9, 2007

LAMP on Feisty Fawn

LAMP is: Linux, Apache, MySQL and PHP.
I've escaped from database in the past but now I can't.

Actually the document Installing LAMP On Ubuntu For Newbies is good enough to make LAMP correctly.
In addition to my process of setup a LAMP referencing the document, I write how to configure MySQL and phpMyAdmin, application to administrate MySQL remotely.

You need install following pack

  • Apache
    • apache2
  • PHP
    • php5
    • libapache2-mod-php5
  • MySQL
    • mysql-server
Instead of Synaptic, I use command line as the document.

First, install apache.

$ sudo apt-get install apache2

Next, PHP.

$ sudo apt-get install php5 libapache2-mod-php5
Restart Apache.
$ sudo /etc/init.d/apache2 restart
Test PHP.

Write on /var/www/testphp.php following line

<? php phpinfo(); ?> 

Access http://[server's IP address]/testphp.php with your browser to ensure that it shows PHP information.

Next, MySQL.

$ sudo apt-get install mysql-server
Now I start MySQL setting.

If you want to allow other computer to connect to your SQL server, you need to change [Bind Address] in /etc/mysql/my.cnf from to your IP address.

$ sudo vi /etc/mysql/my.cnf
bind-address =
bind-address = [server's IP address]

Create password for MySQL
$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04 distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('[パスワード]');
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Install PHPMyAdmin.
$ sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin
To give a permission to administrate MySQL from PHP, configure /etc/php5/apache2/php.ini.
$ sudo vi /etc/php5/apache2/php.ini
remove ";".

Restart Apache.

$ sudo /etc/init.d/apache2 restart

Now you can login PHPMyAdmin by accessing http://[server's IP address]/phpmyadmin/.


No comments: