How to setup MYSQL and phpMyAdmin

This process can be complicated to some people but its very easy as if you use ports to install both programs and follow my simple instructions. First you will need to pick a mysql version that is right for you in /usr/ports/databases/. I would suggest you find the recommended version online that most people use. You can use sites such as google.com to find out what most people are using. Once you find the correct version you would like to use then cd to the port that you wish to install and type “make install”. If any options come up you won’t need to make any changes unless you know for sure that you will need to. I do recommend you do some reading again on particular applications that you will be running and their requirements. Once this is installed you will need to install PHP. Again, its important to read up on which version of PHP is right for you. The best way to install PHP is to install it from php-extentions in ports. Once you figure out which PHP is right for you cd to /usr/ports/lang/php[X]-extentions where [X] = the PHP you want to use. Be sure that you don’t already have PHP installed before you complete this step. When the options pop up for PHP you just want to make sure you have the mysql options checked (both of them). Proceed with the install until its complete. Finally we install phpMyAdmin. Type “cd /usr/ports/databases/phpmyadmin ; make install”. When that completes installing we will move on to the next step.

First we need to start mysql by typing:

Perhaps the most important step is after you install mysql you will want to set a root password for it so go ahead and do that by typing (at the root prompt):

Something that is smart to do for security is to change the user root to something else. We’ll do that in this next step by typing the following:

Once you have done this you are ready to move on to the phpmyadmin step. If you have an apache webserver you will want to put the following in the config file where the other Aliases are or in your vhost file where your main site is:

This particular method will enable .htpasswd to hold the password to access the phpmyadmin site. This is essential to the security of your server if you are going to set it up this way.

Go ahead and “cd /usr/local/www/phpMyAdmin/” then you want to create an .htpasswd with your username and password decrypted. To do this type the following:

Once you have done this you will need to put your root username and root password in a file that phpmyadmin needs to access all the databases. To do this type:

Go ahead and make the two lines below read with your passwords in place of mine:

You can exit and save this file and go ahead and pull up phpmyadmin on your site by typing http://www.yoursite.com/phpmyadmin in your browser.