MySQL Server

1. MySQL Server

$ sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql

$ sudo apt-get install php5

$ sudo mysql -u user_name -p

mysql> CREATE DATABASE register_db;

mysql> USE register_db;

mysql> CREATE TABLE `register_tb` (
        `id` int(10) unsigned NOT NULL auto_increment,
        `name` varchar(40) NOT NULL,
        `email` varchar(40) default NULL,
        PRIMARY KEY  (`id`)
        ) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

mysql> INSERT INTO `register_tb` VALUES (1,'peter lee','[email protected]'),(2,'jason lee','[email protected]');

$ /etc/init.d/mysql start


2. Change MySQL root Password

$ sudo dpkg-reconfigure mysql-server-5.0  ## mysql-server-5.1


3. Recover MySQL root Password

$ /etc/init.d/mysql stop

$ mysqld_safe --skip-grant-tables &

## Go to MySQL in webmin

$ mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("123abc") where User='root';
mysql> flush privileges;
mysql> quit

$ /etc/init.d/mysql stop

$ /etc/init.d/mysql start