1. Downloadfirst we want to download a MySQL, find the official download page of Oracel Click on the Open link, and then we found that there are several:
MySQL Enterprise Edition,
MySQL Cluster CGE,MySQL Community Edition (GPL), the first two are Enterprise Edition, a cluster, the last is the community version, the first two are paid, we are of course choose the community version connected to, and then found that there are still many choices, of course, are free, we choose "MySQL Community Server (GPL) "And then go in we choose Microsoft Windows operating system, then there are 3 versions for us to choose from, MySQL Installer Msi,mysql-5.6.22-win32.zip, Mysql-5.6.22-win64.zip, my side of the choice is in line with my classic notebook win32.zip version, and then click to download, this has nothing to say. 2. Unzip and configure3 Installation Start-upOpen the command line, CD to the extracted bin directory, and then run Mysqld-install, then prompt for "service successfully installed", stating that the installation was successful. Then is net start MySQL, which indicates that the MySQL service is starting the MySQL service has started successfully. 4. Command-line basic operationsCD to the bin directory, and then enter MySQL, you can go to the command line to operate. A. Access >mysql-u root-p EnterEnter Password: Enter (indicates that the password is empty)mysql> (wait for input, description already entered) B. View the configuration Port:mysql>show variables like ' port '; datadir (Data storage directory): mysql>show variables like ' datadir ': c. Database Show mysql>show databases; CreateMysql>create database db1; (hint) query ok,1 row affected (0.06sec)
MySQL installation under Windows
