LAMP is  an acronym for a website development stack (LAMP - Linux Apache MySQL PHP). Since I moved my PC from Fedora 16 to 17 my LAMP stack needs rebuilding so I figured I'd create some notes for future reference as MySQL doesn't seem to be behaving straight out the box.

Install appropriate packages using yum:
  • Apache - httpd
  • PHP - php, php-mysql
  • MySQL - mysql, mysql-server, phpMyAdmin
Make sure services get started at boot time (personal preference):
[root@bigfoot ~]# systemctl enable httpd.service
[root@bigfoot ~]# systemctl enable mysqld.service

Once you have started the mysqld service (either during bootup or manually) you will need to set the mysql root passwd. Probably not a good idea to use the same password as your system root password!

[root@bigfoot ~]# mysqladmin -u root password 'my new root password'

Make any edits required to vi /etc/phpMyAdmin/

Restart httpd.service:
[root@bigfoot ~]# systemctl restart httpd.service

You should now be able to use mysqladmin or phpMyAdmin to administer your database server. 

Use localhost/phpMyAdmin to administer your database, use the root user and password you created earlier to login and manage your MySQL users. Don't forget if you allow external traffic to view your http server, they may be able to access phpMyAdmin, so make sure your passwords are good!

While this article was written using Fedora 17, the process for setting up LAMP on  later versions of Fedora will be similar.