1. yum install mysql, yum install mysql-server, service mysqld start ( port : 3306), chkconfig mysqld on
2. mysql > create database episode;
mysql > use episode;
mysql > source ****.sql (sql file path)
3. service mysqld stop
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
mysql -u root mysql
mysql> update user set password=password('newpassword') where user='root';
mysql> flush privileges;
mysql> quit
4. service mysqld restart
5. check table data in database: ok
6. allow remote host to connect database:
mysql -uroot -proot
mysq > use mysql;
mysql > grant all on *.* to 'root'@'%' identified by 'root' with grant option;
mysql > select host,user,password,select_priv from user; (password is not empty == > ok)
