Win10 安装 MySQL5.7.36 数据库记录

本文参考前文 win10安装mysql5.7MySQL 5.7.36 国内 阿里云 下载地址https://mirrors.aliyun.com/mysql/MySQL-5.7/mysql-5.7.36-winx64.msi安装 mysql-5.7.36-winx64.msi 时我选择的 custom 自定义安装安装目录 D:\software\MySQL\MySQL-Server-5.7安装完成后在 D:\software\MySQL\MySQL-Server-5.7 这个目录下 创建 data 目录、新建 my.ini 文件my.ini 文件就是 MySQL 数据库的具体配置[mysql] # 设置mysql客户端默认字符集 default_character_setutf8mb4 [mysqld] #设置3306端口 port 3306 # 设置mysql的安装目录 basedirD:\\software\\MySQL\\MySQL-Server-5.7 # 设置mysql数据库的数据的存放目录 datadirD:\\software\\MySQL\\MySQL-Server-5.7\\data # 允许最大连接数 max_connections200 # 服务端使用的字符集默认为8比特编码的latin1字符集 character_set_serverutf8mb4 # 创建新表时将使用的默认存储引擎 default_storage_engineINNODB # 设置日志时间为系统时间 log_timestampsSYSTEM然后去配置 环境变量然后去配置环境变量系统变量MYSQL_HOME把解压目录配置进去D:\software\MySQL\MySQL-Server-5.7然后Path%MYSQL_HOME%\bin然后 win r -- cmd --ctrlshiftenter– 进入控制台管理员模式C:\Users\Administratorcd /d %MYSQL_HOME%\bin D:\software\MySQL\MySQL-Server-5.7\bin D:\software\MySQL\MySQL-Server-5.7\binmysqld -install Service successfully installed. D:\software\MySQL\MySQL-Server-5.7\binmysqld --initialize-insecure --usermysql D:\software\MySQL\MySQL-Server-5.7\binnet start mysql MySQL 服务正在启动 . MySQL 服务已经启动成功。 D:\software\MySQL\MySQL-Server-5.7\binmysql -V mysql Ver 14.14 Distrib 5.7.36, for Win64 (x86_64) D:\software\MySQL\MySQL-Server-5.7\binmysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.36 MySQL Community Server (GPL) Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type help; or \h for help. Type \c to clear the current input statement. mysql ALTER USER rootlocalhost IDENTIFIED BY 123456; Query OK, 0 rows affected (0.00 sec) mysql flush privileges; Query OK, 0 rows affected (0.00 sec) mysql SELECT DISTINCT CONCAT(User: ,user,,host,;) AS query FROM mysql.user; ------------------------------------ | query | ------------------------------------ | User: mysql.sessionlocalhost; | | User: mysql.syslocalhost; | | User: rootlocalhost; | ------------------------------------ 3 rows in set (0.00 sec) mysql show databases; -------------------- | Database | -------------------- | information_schema | | mysql | | performance_schema | | sys | -------------------- 4 rows in set (0.00 sec) mysql exit Bye D:\software\MySQL\MySQL-Server-5.7\binmysql -uroot -p123456 mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.7.36 MySQL Community Server (GPL) Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type help; or \h for help. Type \c to clear the current input statement. mysql exit Bye D:\software\MySQL\MySQL-Server-5.7\bin去看 data 目录下 err 日志默认初始化是没设置密码密码为空所以首次登录直接回车然后重新设置密码即可数据库连接信息主机localhost 端口3306 账户root 口令123456我们下期见拜拜