phpMyAdmin being the most used tool for managing MySQL databases comes as a package with Debian and works out of the box with “apt-get” along with apache, php and mysql.

But, when switching over to suPHP from the apache mod_php plugin, even if every other things work, phpMyAdmin fails.

The error looks like:

File does not exist: /usr/share/phpmyadmin/navigation.php<, referer: http://localhost/phpmyadmin/

This is because its configured to work only for mod_php. The configuration file is located at “/etc/phpmyadmin/apache2.conf”, which is symbolically linked at “/etc/apache2/conf.d/phpmyadmin.conf”

The easier option is to enable “mod_php” by typing in “a2enmod php5” as described at Sysadmin World.

We @ DayScholars finally managed to arrange a good PC to setup as a centralized server for our code and databases. The server is running a customized Debian Squeeze distribution with MySQL Version 5.1. So the next requirement is to allow MySQL access for all of us. This is how we managed it. You must login as root user or must have root privilege to do this.

Edit the MySQL configuration file, located at /etc/mysql/my.cnf.

We prefer using vim. You can use any others like nano or even gedit.

Today, I completed the configuration of sms section of Bizzard.info. It is my first completed using PHP and MySQL database. The database structure is very simple and each category of short messages uses individual tables. So, further categories can be created easily by just adding a new table and a few changes in the PHP files. Its currently under testing and contains only few sms’s.

The sms section can be reached at http://www.bizzard.info/sms/