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

This article mainly introduces the mysql installation and configuration process brief analysis, the content of the article is carefully selected and edited by the author, with a certain pertinence, for everyone's reference significance is still relatively great, the following with the author to understand the next topic content.

Mysql installation and configuration:

1. Install Mysql:

Upload the Mysql server and client to Linux. Install the server first and then the client.

Download address: http://down.51cto.com/data/2222065

Installation execution command: rpm-ivh installation package

two。 Set password

Mysqladmin-u Zhang San password password

3. Change the password:

Mysqladmin-u Zhang San-p old password password new password

3. Log in to mysql:

Mysql-u root-p password

4. Add users (Mysql is case sensitive):

Mysql > insert into mysql.user (Host,User,Password) values ('localhost',' Zhang San', password ('123456'))

Mysql > flush privileges

5. Give users permission to operate databases and tables (combined according to actual needs)

Mysql > grant all privileges on *. * to Zhang San identified by 'access database password'

Mysql > grant all privileges on *. * to Zhang San @ 192.168.0.1 identified by 'access database password'

Mysql > grant all privileges on a database. * to Zhang San identified by 'access database password'

Mysql > grant all privileges on *. A table to Zhang San identified by 'access database password'

6. Show database

Show databases

7. Show database tables

Use mysql;// enters mysql database

Show tables

8. Build a database

Use library name

Create databases library name

9. Build a table

Use table name

Create table table name (field 1 (field properties), field 2 (field properties),.)

Create table user (id int (3) auto_increment not null primary key, name char (8), sex char (2), age char (2))

10. Show table structure

Describe user

After reading the above brief analysis of mysql installation and configuration process, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to follow our industry information column.

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.