Administrator
发布于 2020-02-12 / 1 阅读
0
0

mysql zip安装教程

### 1.下载MySQLzip包,并解压到你要安装的地方。 mysql下载地址[https://dev.mysql.com/downloads/mysql/](https://dev.mysql.com/downloads/mysql/) ![mysqlzipinstall01.png](http://file.itmtr.cn/itmtr/mysql-zip-install-01_1588589865086.png) 注意:data目录是我创建的 ### 2.在这个目录下创建my.ini文件,并输入以下内容 ```properties # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. [mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. # 设置mysql的安装目录 basedir = D:\\soft\mysql\mysql-5.7.29 # 设置mysql数据库的数据的存放目录 datadir = D:\\soft\mysql\mysql-5.7.29\data # 设置3306端口 port = 3306 # server_id = ..... # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES # 允许最大连接数 max_connections = 200 # 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统 max_connect_errors = 10 # 服务端使用的字符集默认为UTF8 character-set-server = utf8mb4 # 创建新表时将使用的默认存储引擎 default-storage-engine = INNODB # 默认使用“mysql_native_password”插件认证 default_authentication_plugin = mysql_native_password [mysql] # 设置mysql客户端默认字符集 default-character-set = utf8mb4 [client] # 设置mysql客户端连接服务端时默认使用的端口 port=3306 default-character-set = utf8mb4 ``` 注意:里面的 basedir 是我本地的安装目录,datadir 是我数据库数据文件要存放的位置,各项配置需要根据自己的环境进行配置。 查看所有的配置项,可参考:[https://dev.mysql.com/doc/refman/8.0/en/mysqld-option-tables.html](https://dev.mysql.com/doc/refman/8.0/en/mysqld-option-tables.html) ### 3.初始化数据库 输入cmd,以管理员身份运行控制台,进入MySQL路径(D:\\soft\mysql\mysql-5.7.29\bin)下,运行`mysqld --initialize --console`命令。进行初始化,如下: ![mysqlzipinstall02.png](http://file.itmtr.cn/itmtr/mysql-zip-install-02_1588590183590.png) 这里的 `Gr1j87?

评论