Managing MySQL55 with phpMyAdmin:
In Part 1 of this article, Apache24 Server and PHP5 were installed and configured. The next step towards having a functional FAMP (FreeBSD, Apache, MySQL, PHP) Stack is to install mysql and phpmyadmin.
MySQL55:
# cd /usr/ports/databases/mysql55-server # make install clean
After installation perform the following:
# echo 'mysql_enable'="YES" >> /etc/rc.conf # /usr/local/etc/rc.d/mysql-server start # /usr/local/bin/mysqladmin -u root password 'your-password-here'
Note: In the future, if you are required to upgrade the current version to the next release, the following must be performed:
# mysql_upgrade -u root -p
phpMyAdmin:
# cd /usr/ports/databases/phpmyadmin # make install clean
Before configuring phpMyAdmin, the Apache24 config file httpd.conf file needs editing:
Add the following lines to the very bottom of /usr/local/etc/apache24/httpd.conf file:
Alias /phpmyadmin "/usr/local/www/phpMyAdmin" <Directory "/usr/local/www/phpMyAdmin"> Options None AllowOverride None Require all granted </Directory>
As good measure, restart apache:
# apachectl restart
Next, start configuring phpMyAdmin:
# cp /usr/local/etc/php.ini-production /usr/local/etc/php.ini # mkdir /usr/local/www/phpMyAdmin/config # chmod 757 /usr/local/www/phpMyAdmin/config # chmod 644 /usr/local/www/phpMyAdmin/config.inc.php
Start your web browser and direct it towards:
http://your-web-site-ip/phpmyadmin/setup/
Next, following these steps:
- Select New Server, then select the Authentication Tab
- Under Authentication Tab, choose “cookie” and remove “root” from the “User for config auth”
- Apply and save
After a successful login, let’s perform some clean up:
# mv /usr/local/www/phpMyAdmin/config/config.inc.php /usr/local/www/phpMyAdmin # rm -r /usr/local/www/phpMyAdmin/config # chmod 600 /usr/local/www/phpMyAdmin/config.inc.php # apachectl restart # /usr/local/etc/rc.d/mysql-server restart
Open your browser and go to the following: http://your-web-site/phpmyadmin/ and login as “root”
Summary:
Installing and configuring mysql and phpMyAdmin is not tough, however, it can be tedious. Part III of this article will focus on the final part of our FAMP Stack – Drupal 7. As always, if you see any errors or areas of need of clarification, please send in your comments.