Installation configuration and common operations for Mysql without installation _ MySQL

The installation configuration and common operations of Mysql without installation version are a type of relational database. mysql is emerging because of its small memory usage and open source features. the following briefly introduces mysql configuration and simple operations.

Mysql configuration 1. download the installation file

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

The downloaded file is a compressed file, which can be decompressed and placed in the desired location. it is recommended to be close to the root directory.

2. configure environment variables

2.1 you can create a new mysqlhome or something. The value is the decompressed directory in the previous step.

2.2 put mysqlhome in the Path directory.

In fact, you can directly put this bin file under path. create an independent environment variable for independent operations so that you do not need to modify the path when you change the mysql installation directory next time. the path contains many directories for installing software. frequent operations may lead to misoperations. this is equivalent to decoupling in our software, independent changes, and less modifications.

3. start the mysql service

D: mouth. user ID,> cd "La =" "SQL statement =" "s =" "BU 5 =" "1 =" "1 =" "in =" "6 Xi advise inid: = "" SQL = "" SQL 1 5 = "" 6 = "" 19 1 = "" placement = "" 4 = "" sqld 1 install = "" ih = "" ser = "" ic = "" dlredd = "" xist = "mesh Cup in Spring =" "ithe =" "u =" "re =" "t =" "r coding = "" rin = "" ta1led = "" c = "inch rogra =" "full 1 7 write less Hook SQL Ming =" "sqlseru =" "5 = "" 6. Jia = "" qld = ""-l Ding default = "" 1 file = "D" ft "are advising e" e10P training, SQL item, 'ql-5-6-1, "inx64 city, a default-ini", sqlLl "l": Laxi SQL Xi SQL-5. 6. 19 One public inx64 in>. Evening sqld renoueeruicesuccessfull, renoued. L In addition to service D: Laxi SQL Xi SQL 5. 6. 19 One public inx64 in>. Xi sqld one installSer Miao icesuccessfull Xi installed. Service installation successful D: training Xi SQL Xi SQL 1 5. 6. 19 A public inx64 game in "/> netstart kiss fishing L service is starting-kiss SQL service has been started successfully. ", SQL startup service: Laxi SQL Weixi SQL 1 5. 6. 19 Yi Gong inx64 nan in> Sheng: "/>

At the beginning, because I installed an installed version of mysql, I was prompted when installing the mysql service that I already existed. execute mysqld-remove to delete the existing service. Run mysqld-install for the second time and prompt that the installation is successful. Then start the service!

List these commands:

A. install the service

Mysqld-install

B. delete a service

Mysqld-remove

C. start the service

Net start mysql

When the service is started, the installation and configuration of mysql is basically over.

Common operations

After mysql is installed, the default password of the root user of the software is blank.

1. enter mysql

2. create a database

3. create a table

4. Insert data

5. Display database and table information

In summary, the deployment and configuration of mysql are similar to those of mongdb, which we previously understood. With mongdb configuration

Here, we are no stranger to the dos interface. The configuration process is still smooth, and there are some other operations

After the permission issue, go to understand. There is also the Navicat Premium client, which configures the visual interface for the operation.