mysql免安装版下载配置需要注意的问题

下载地址：https://dev.mysql.com/downloads/mysql/ mysql-8.0.19-winx64.zip

解压、配置环境变量

path 后面增加：D:\app\developTools\mysql\mysql-8.0.19-winx64\bin；

cmd 管理员运行 mysqld --install

如果mysqld无此命令，需要安装一个V C++ VC_redist.x64.exe 然后重新运行mysqld --install 发现安装成功

然后再在cmd中执行 mysqld --initialize --console 初始化，产生一个初始化密码，类似下面这种

2021-06-21T15:25:29.156715Z 0 [System] [MY-013169] [Server] D:\app\developTools\

mysql\mysql-8.0.19-winx64\bin\mysqld.exe (mysqld 8.0.19) initializing of server

in progress as process 10140

2021-06-21T15:25:34.318008Z 5 [Note] [MY-010454] [Server] A temporary password i

s generated for root@localhost: 3jAZ7:!9iV,h

然后再在cmd中执行 net start mysql 启动mysql服务

然后再在cmd中执行 mysql -u root -p 打开mysql数据库 要求输入用户名跟密码 用户名：root 密码：3jAZ7:!9iV,h

连接成功后修改密码：mysql> alter user 'root'@'localhost' identified by 'yinl';

mysql>exit; 退出重新用新密码登录

下载一个免安装版的navicat数据库管理设计工具 navicatformysql.zip

然后解压，注册，连接mysql数据库，会发现报错提示：consider upgrading mysql client

需要重新cmd登录上去，修改另外一个密码：

mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'yinl'

然后重新连接navicat就可以成功了！

执行SQL时会出现以下报错：

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

只需要修改数据库的sql_mode就可以了

-- 查看SQL_MODE SELECT @@sql_mode; -- 修改SQL_MODE SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));