MySQL Database installation and configuration

1. (Access Account rights Control) dql-query (SELECT) dml-(insert update Delete) ddl-(CREATE table CREATE VIEW) dcl-(Grant)

2. (Access address permission control) sudo yum-y in

3. Installing Mysql:sudo yum-y Install Mysql-server, open/etc/my.cnf join: Default-character-set = UTF8

4. Set up MySQL with system autostart: sudo chkconfig mysqld on and then check under: sudo chkconfig--list mysqld if 2~5 are on for success

5. Start Mysql:sudo service mysqld start

Starting mysqld: [OK]

Startup success

6. User Login under: mysql-u root (the first login does not require a password not added-p)

7. View users: Select User,host from Mysql.user;

8. Firewall open 3306 interface, MySQL use; Restart firewall: sudo service iptables restart

9. Unable to see MYSQL.USR table after initializing MySQL database solution: Reset Password

******

MySQL common command: Service mysqld restart- Restart

MySQL Database installation and configuration