Shulou(Shulou.com)06/01 Report--

Yum install MYSQL

1 yum-y install mysql-server

2 set up self-boot management

Chkconfig mysqld on

3 start the MYSQL service

Service mysqld start

4 set the user management password for MYSQL

Mysql-u root

Set password for root@localhost=password ('root')

5 log in with a new password account

Mysql-u root-p

6 use basic mysql database commands

Show databases; / / View the existing database of the system

Use databasesname; / / Select the database you want to use

Drop database databasename; / / Delete selected database

Exit / / exit the connection to the database

Create database test01; / / set up a database named test

Show tables; / / lists the tables under the current database

Other basic additions, deletions, changes and queries can be done by using standard SQL.

7 enable remote login access and set authorization information

GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' root' WITH GRANT OPTION

Don't forget to refresh permissions

FLUSH PRIVILEGES

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.