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

Mysql needn't talk about the theory, the document writes about the installation process, as well as the basic additions, deletions, modifications and queries.

1. Preparatory work

Confirm that mysql-server and mysql are not installed using RPM.

two。 Before installing mysql, you need to install the software development package. If you check "Software Development" when installing the operating system, you do not need to install it.

3. Mount the CD of the mysql, cmake software package.

4.Mysql5.5 needs to be installed with cmake compilation, so install the cmakepackage first.

5. Create a running user

6. Configuration, compilation and installation

7. Other adjustments after installation

-- permission settin

-- create a configuration file

-- initialize database files

-- set environment variables

8. Add system services

9. Enable the mysql service

10. Access to mysql database

11. Basic commands (see what databases are available on the current server)

twelve。 Basic command (see which tables are in the current mysql database)

13. View the structure of the users table

14. Create a new database auth and table users

15. Delete users table and auth database

16. Insert data

17. Query data

The sentence of addition, deletion, modification and query is exactly the same as that of sqlserver. You can refer to the landlord's sqlserver blog.

18. User authorization of the database

1) create a new user xiaoqi and grant select permissions to all tables in the auth database

2) Log in to the server using xiaoqi

3) create a new database beijing and authorize a host connection from the ip address 192.168.1.100 with the user name zhangsan and password pwd@123, allowing any operation in the beijing database

4) View permissions

5) execute the order to revoke the authority

19. Backup and recovery of database (backup table, backup database, backup all databases respectively)

20. Delete table recovery

21. If the complete database information is already included in the backup file, you do not need to specify the library name when performing the import operation, for example, restoring the auth library from the backup file auth.sql

First go to the database storage directory: Cd / usr/local/mysql/data, and then execute the following command

-- use graphical tools to manage mysql (naviate for mysql)

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.