Setting up and Testing MySQL Server

Okay, last step. Installing MySQL. Pretty straightforward:

The observant reader may have noticed that the above command installs two packages at once. That may lead one to ask, could we have just installed everything with one command? The answer is yes. Something like this would have installed everything needed all in one shot:

aptitude install openssh-server mysql-server mysql-client phpmyadmin

But that would have broken up the flow of the tutorial here, so I didn’t do it that way. Feel free though, of course.

Once MySQL is installed, it will automatically prompt you to create a password for MySQL’s root account. Note that this is independent of the system’s root account.

Once you’ve entered and confirmed the password, MySQL is all set up. If you like, you can administer your MySQL server with the mysql-client, but if you prefer not to do it all from the command line, install phpMyAdmin…

…and select “apache2″ as the server that will run it.

Log in via your favourite browser to verify that things are up and running…

All Done.

…and that’s it! All set up. Now it’s up to you to create your databases and web content. Your LAMP server is up and running and ready to go.

I hope this guide has been helpful, please feel free to comment with any difficulties or errors, typos, etc. in my guide.