MySQL and JDK installation under Linux

Allow local access port: Iptables-p OUTPUT ACCEPT
1. Yum install MySQL

2. Yum Install Mysql-server

3, delete the user table in the MySQL database user is empty records;

4. Execute the following SQL statement
Use MySQL;
mysql> UPDATE user SET Password=password ("root") WHERE user= ' root ';
mysql> flush Privileges;
Mysql> exit;

5. Create DATABASE and table information

CREATE DATABASE ' websitedb '/*!40100 DEFAULT CHARACTER SET UTF8 */;

CREATE TABLE ' website ' (
' id ' int (one) is not NULL,
' url ' varchar (DEFAULT NULL),
' IP ' varchar DEFAULT NULL,
PRIMARY KEY (' id ')
) Engine=innodb DEFAULT Charset=utf8;

CREATE TABLE ' Monitor_website ' (
' id ' int (one) is not NULL,
' IP ' varchar DEFAULT NULL,
' url ' varchar DEFAULT NULL,
' desc ' varchar DEFAULT NULL,
' Check_inteval ' int (one) DEFAULT NULL,
PRIMARY KEY (' id ')
) Engine=innodb DEFAULT Charset=utf8;

CREATE TABLE ' Task ' (
' id ' int (one) is not NULL,
' begin_time ' varchar DEFAULT NULL,
' end_time ' varchar DEFAULT NULL,
' Feedback_inteval ' int (one) DEFAULT NULL,
' Task_name ' varchar (+) DEFAULT NULL,
' Task_status ' int (one) DEFAULT NULL,
' Task_type ' int (one) DEFAULT NULL,
' user_id ' int (one) DEFAULT NULL,
PRIMARY KEY (' id ')
) Engine=innodb DEFAULT Charset=utf8;

The following is the execution statement to uninstall MySQL

Rm-fr/usr/lib/mysql
Rm-fr/usr/include/mysql
Rm-f/etc/my.cnf
Rm-fr/var/lib/mysql

The following permissions are assigned:
GRANT all privileges on * * to ' myuser ' @ ' percent ' identified by ' MyPassword ' with GRANT OPTION;
Flush privileges;

GRANT all privileges on * * to ' root ' @ '% ' identified by ' root ' with GRANT OPTION;

The following is the installation of JDK

Yum Install Java

MySQL and JDK installation under Linux