Chapter 24 . (Dedicated web hosting) Running a Linux, Apache, MySQL,
Chapter 24 . Running a Linux, Apache, MySQL, and PHP (LAMP) Server 659 Installing a Web Application: Coppermine Photo Gallery Once your LAMP server is operational, you can begin installing or creating applications to run on it. One such application is Coppermine Photo Gallery (CPG), the installation of which is demonstrated in this section. CPG is a Web-based photo gallery management system written in PHP. Through its Web interface, you can upload pictures to your own photo galleries, which will be available on the Web through your LAMP server. You can install CPG under a virtual host or under a user s home directory on your main host. A single server can easily support many CPG installations using either of these methods. To install CPG on the Debian system described in this chapter, follow these steps: 1. Install the unzip and imagemagick programs. Unzip is used to unpack the CPG program after downloading, and imagemagick is used to resize images and create thumbnails: # apt-get install unzip imagemagick 2. Create a MySQL database for CPG. You can use a database name other than cpg if you wish. The database username (the part before the @ localhost in the GRANT statement) and the database name do not need to match. Be sure to replace mypassword with something different: # mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 8 to server version: 4.0.24_Debian-10-log Type help; or h for help. Type c to clear the buffer. mysql> CREATE DATABASE cpg; Query OK, 1 row affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON cpg.* TO cpg @ localhost IDENTIFIED BY mypassword ; Query OK, 0 rows affected (0.00 sec) mysql> q Bye
If you are searching for cheap webhost for your web application, please visit MySQL5 Web Hosting services.