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.
# 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
# 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:
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”
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.