Install mysql in windows and windowsmysql

Install mysql in windows and windowsmysql
1. First, we need to download a mysql instance. Find the official elasticsearch download page and click the link to open it. Then we can find several types of data:MySQL Enterprise Edition,MySQL Cluster CGE,MySQL Community Edition (GPL), one of the first two is the Enterprise Edition, one is the cluster type, the last is the Community version, the first two are paid, of course, we choose to connect to the Community version, then we found that there are still many options, of course, they are free of charge. We chose "MySQL Community Server (GPL)", and then we chose the microsoft windows operating system, there are three versions available for us to choose, mySQL Installer versions, and then click Download. There is nothing to say. 2. decompress and configure 3 install start open command line, cd to the decompressed bin directory, then run mysqld-install, and then prompt "service successfully installed", indicating that the installation is successful. Then, net start mysql prompts "MySQL service is starting MySQL service successfully ". 4. Perform basic operations on the command line cd to the bin directory, and then input mysql to access the command line for operations. A. enter> mysql-u root-p press Enter (prompt) Enter password: Press Enter (Enter password blank) mysql> (wait for input, it indicates it has entered) B. view the Configuration port: mysql> show variables like 'Port'; datadir (data storage directory): mysql> show variables like 'datadir ': c. the database displays mysql> show databases; create mysql> create database db1; (prompt) query OK, 1 row affected (0.06sec)