CentOS6.2 deploy the MySQL Environment

Built-in startup: centos6.2 comes with mysql5.1 installed, root identity Logon (mysql-uroot-p) no password;

Built-in startup: centos6.2 comes with mysql5.1 installed, root identity Logon (mysql-u root-p) no password;

1. Command installation: yum install mysql-server

2. built-in startup: CentOS6.2 comes with mysql5.1 installed, and the root identity (mysql-u root-p) has no password;

System-> Management-> service, select mysqld, and set auto start and start the service;

3. Related commands:

1) start the service: service mysqld start

2) Change Password: mysql

Enter the mysql command and execute the following statement:

UPDATE mysql. user SET password = PASSWORD ('000000') WHERE user = 'root ';

Flush privileges;

3) SQL File Import command: source file path;

4) enter the mysql command: mysql-u username-p, and then enter the password to enter the mysql execution environment;

5) export the database or table: mysqldump-u username-p dataname> dataname. SQL;

4. mysql graphical tool workbench installation:

1 ):

2) Select Oralce linux6 to download the mysql-workbench-gpl-5.2.37-1el6.i686.rpm

3) yum installation: yum install rpm package name

Yum uninstall: yum-y remove rpm package name