LAMP

#how to install lamp - apache2 , mysql , php

sudo apt-get install apache2

#test if http://localhost/  has been works.

_________________________________________________

#install php5 and dependecy

sudo apt-get install php5 libapache2-mod-php5

sudo /etc/init.d/apache2 restart

_________________________________________________

#install mysql

sudo apt-get install mysql-server

#set mysql root password

_________________________________________________

Then get phpmyadmin to control you MySQL by browser

follow instruction in such sample.config file

and rename to erase 'sample'

It should be put in /var/www/

ps.

if  http://localhost/phpmyadmin is not found

check /etc/apache2/apache2.conf

remember restart

PS
if phpmyadmin has something wrong
remove all php5
install php5 / php5-mysql / php5-mcrypt at same time

SQL-add user

add a newuser in mysql by SQL below:


CREATE USER 'cfg'@'%' IDENTIFIED BY '***';

GRANT ALL PRIVILEGES ON * . * TO 'cfg'@'%' IDENTIFIED BY '***' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0MAX_USER_CONNECTIONS 0 ;

GRANT ALL PRIVILEGES ON `mysql` . * TO 'cfg'@'%';