MySQL free installation configuration and common operation

as a type of relational database , MySQL arise due to its low memory footprint and open source features . The following is a brief introduction to MySQL configuration and simple operations .

mysql configuration
1.download of installation files

Free installation :http://dev.mysql.com/downloads/file.php?id=452189

after download is a compressed file , unzip it and put it where you want it to be. . recommended or close to the root directory is better .

2.Configuring environment Variables

2.1 Create a new Mysqlhome or whatever it is . . The uncompressed directory with the value of the previous step

2.2 will be Mysqlhome placed in Path the catalogue is ready.

In fact, this can also be directly bin files are placed in Path below . Create a standalone environment variable to operate independently so that the next change in the installation MySQL The directory is not to be modified Path the , Path it contains a lot of directories for installing software. . frequent operations can lead to mis-operation . This is the equivalent of decoupling in our software. , Independent Change , reduced modification of .

3.StartMySQLService

, at the beginning because I installed a version of MySQL, I was prompted to install the MySQL service I already exist . Execution Mysqld-remove, Delete a service that already exists. The second execution of the mysqld-install prompts for successful installation. And then the service is started!

List these commands:

A. Installation Services

Mysqld-install

B. Delete Service

Mysqld-remove

c. Start the service

net start MySQL

When the service starts, the whole MySQL The installation configuration work is basically over.

Common operations

in the installation of good MySQL software, the default Root The user's password is empty.

1. Go to MySQL

2. Create a database

3. Create a table

4. Inserting data

5. Display database, table information

To summarize, the deployment and configuration of MySQL is quite similar to the mongdb of the previous simple understanding. With the previous configuration in Mongdb

Experience, here for DOS interface is not a stranger before. The configuration process is pretty smooth, and there are some other operations about

permissions, and then get to know the problem. There is also the Navicat Premium client, which configures the visual interface for the operation.