Centos6.5 installing MySQL with yum

Yum install MySQL

1 yum-y Install Mysql-server

2 Setting up start-up management

Chkconfig mysqld on

3 starting the MySQL service

Service mysqld Start

4 Setting up a MySQL user admin password

Mysql-u Root

Set password for [email protected]=password (' root ');

5 Login with a new password account

Mysql-u root-p

6 using the basic MySQL database command

show databases; To view a database that already exists on the system
Use Databasesname; Select the database you want to use
Drop database databasename; Delete the selected database
Exit//Disconnect from database
Create Database test01; To create a database named Test
Show tables; List the tables under the current database
Other basic additions and deletions using standard SQL

7 Open Remote login access, set authorization information

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

Don't forget to refresh permissions

FLUSH privileges;

Centos6.5 installing MySQL with yum