Linux system installation MySQL and related configuration

2. Installation
   1. Server installation. Use command: sudo yum-y install Mysql-server
   2. Client Installation. Use command: sudo yum-y install MySQL
4. Set boot up
   1. Sudo/sbin/chkconfig--add mysqld
   2. Sudo/sbin/chkconfig mysqld on
   3. Sudo/sbin/service mysqld Start
6. Set Root password
   1. sudo mysqladmin-u root password ' test123 '
8. Connect to MySQL
   1. Mysql-u root-p test123
10. Modify root Remote access permissions
    1. Close mysqld Service: Sudo/sbin/service mysqld stop
    2. Safe Mode login: sudo mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
    3. Execute current permission Query command: show grants; (This step is optional)
    4. Add Permission: Grant all privileges on *. * to ' root ' @ ' * ' identified by ' 123456 ' with Grant option;
    5. Refresh Permissions table: Flush privileges;
    6. Exit Mysql:quit
    7. Restart MySQL service: Sudo/sbin/service mysqld start
    8. Iptables Open 3306 Service:

       #/sbin/iptables-i input-p TCP--dport 3306-j ACCEPT
       #/etc/rc.d/init.d/iptables Save:

       # Service Iptables Restart restart effective

    9. Or shut down the firewall: sudo service iptables stop
    10. Connect using a remote DB tool such as Navicat
12. Creating databases: Create Database XXX;
14. Enter the database: use XXX;

Linux system installation MySQL and related configuration