1 官网下载 mysql-5.7.34-winx64 (目前到8了,但项目使用的是5)
2 解压缩
3 设置环境变量D:\work\mysql-5.7.34-winx64
4 启动服务
遇到个错误:mysql 安装问题:由于找不到MSVCP120.dll,无法继续执行代码.重新安装程序可能会解决此问题。 - 烈焰与暖阳 - 博客园 (cnblogs.com)
-- 注意:管理员身份启动命令行,定位到msyql的安装目录下
d:\work\mysql-5.7.34-winx64\bin>mysqld -install
Service successfully installed.
--启动server
d:\work\mysql-5.7.34-winx64\bin>net start MySQl
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
-- 默认root ,无密码,修改为root
d:\work\mysql-5.7.34-winx64\bin>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.34 MySQL Community Server (GPL)
mysql> select host,user,authentication_string from mysql.user;
+-----------+---------------+-------------------------------------------+
| host | user | authentication_string |
+-----------+---------------+-------------------------------------------+
| localhost | root | |
| localhost | mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
+-----------+---------------+-------------------------------------------+
3 rows in set (0.00 sec)
mysql> use mysql;
Database changed
-- 修改密码
mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'root';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
d:\work\mysql-5.7.34-winx64\bin>mysql -uroot -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.34 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>
如何查看服务启动时加载配置文件在何处?
my.ini
通过help,查看ini所在位置
C:\Windows\system32>mysqld --verbose --help >test1.txt
C:\Windows\system32>more test1.txt
...
Default options are read from the following files in the given order:
C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf D:\work\mysql-5.7.34-winx64\my.ini D:\work\mysql-5.7.34-winx64\my.cnf
...
安装,移除服务
C:\Windows\system32>mysqld --install mysql
Service successfully removed.
C:\Windows\system32>mysqld --remove mysql
Service successfully removed.
启动,停止服务
C:\Windows\system32>net start mysql
请求的服务已经启动。
C:\Windows\system32>net stop mysql
进入mysql客户端
C:\Windows\system32>mysql -uroot -proot
--查看binlog相关配置
mysql> show variables like 'log%';
查看服务启动失败日志
D:\work\mysql-5.7.34-winx64\bin>mysqld --console
默认不指定my.ini,如果指定的话,copy了配置模板后,改名为my.ini
这个文件不是即刻就能使用的,里面有一些配置留空了,需要挨个配置上值才可。