MySQL database management

db.optThe main function of the file is to record information such as the default character set and Word Fu She of the current database. If you want to modify the character set of a database, directly edit the database corresponding to theoptfiles, usingMySQLcommand "ALTER DATABASE Choose character Set UTF8; "You can also set the database's character set, and the result of the command will be saved tooptfile.

In themysqldoption Group of the my.ini configuration file, the parameter datadir configures the path where the mysql database file is stored, using the command "show variable Like ' DataDir '; View the value of the parameter datadir .

650) this.width=650; "src=" http://blog.itpub.net/attachment/201408/1/29272216_1406872105uUE7.jpg "width=" 689 " "Height=" style= "border:0px;"/>

In the "mysqld" option group of the my.ini configuration file, the parameter basedir is configured with the MySQL installation path (in general , the The same directory as the Bin directory).

View Database

650) this.width=650; "src=" Http://blog.itpub.net/attachment/201408/1/29272216_1406872150yo82.jpg "width=" 247 " height= "213" style= "border:0px;"/>

The information_schema system database defines the metadata information for all database objects, such as the resulting database, tables, fields, indexes, constraints, permissions, storage engines, character sets, and triggers, all stored in the information_ Schema database.

The Choose database is the newly created database

MySQL system database records the account information of MySQL and the access rights of MySQL account, in order to realize the identity authentication and authorization authentication of MySQL account, to avoid illegal user ' exceeding authority ' execution.

The Performance_schema system database collects the performance parameters of the MySQL server so that the data Manager understands why the performance bottleneck is causing it.

Note: Metadata is used to define data (also called a data dictionary), metadata defines the field names used in the database, field types and other information, the data in the database to play a role in the constraints, to avoid the occurrence of ' typos ' data.

Show database structure

Show CREATE DATABASE database_name; View the structure of the command database_name databases.

Show CREATE DATABASE choose; You can view information about choose databases.

650) this.width=650; "src=" http://blog.itpub.net/attachment/201408/1/29272216_1406872297Ux5O.jpg "width=" 700 " height= "331" style= "border:0px;"/>

Mysql Table Management

In a Mysql database, typical database objects include tables, views, indexes, stored procedures, functions, triggers, and so on. Which represents the most important database object in the database. Use the SQL statement 'create table name ' to create a database table.