Python3学习笔记 - MySQL Installation

安装MySQL

  1. Download .zip file from MySQL website.

  2. Create a file named my.ini, then Configure my.ini file.

[mysqld]
basedir = D:\mysql-8.0.24-winx64
datadir = D:\mysql-8.0.24-winx64\data
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
character-set-server = utf8mb4
performance_schema_max_table_instances = 600
table_definition_cache = 400
table_open_cache = 256
[mysql]
default-character-set = utf8mb4
[client]
default-character-set = utf8mb4

  1. Don't create folder /data

  2. Add environment paths, both base and /bin need to be added.

image
  1. Run cmd as Administrator
image

  1. The data folder and other files will be created. No password generated for user root.
    The whole process will be logged in xxx.err in the data folder.

  2. install

image
  1. start service
image
  1. Change password
image
©著作权归作者所有,转载或内容合作请联系作者
【社区内容提示】社区部分内容疑似由AI辅助生成，浏览时请结合常识与多方信息审慎甄别。
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。

相关阅读更多精彩内容

友情链接更多精彩内容