How to install and run mysql

author: admin Post: August 26, 2023 30read 0Comment

How to install and run mysql: first download and decompress Mysql; then enter the bin directory and open cmd; then execute the command “mysqld -install” to install; finally initialize and pass the command “net start mysql” Just start mysql.

D:\soft\mysql\mysql-8.0.11-winx64

New file my.ini, my.ini file content :

############################  #################################
   [client]
   port=3306
   default-character-set=utf8
   [mysqld]
   port=3306
   character_set_server=utf8
   #installation path
   basedir=D:\\soft\mysql\mysql-8.0.11-winx64
   # data path
   datadir=D:\\soft\mysql\mysql-8.0.11-winx64\data
   sql_mode=NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES
   [WinMySQLAdmin]
   Server=D:\\soft\mysql\mysql-8.0.11-winx64\bin\mysqld.exe
 ####################################################  #######

Enter the bin directory, open cmd
The above is the detailed content of how to install and run mysql, please pay attention to other related articles on 1024programmer.com for more information!

This article is from the internet and does not represent1024programmerPosition, please indicate the source when reprinting:https://www.1024programmer.com/how-to-install-and-run-mysql/