mysql 8.0.13 安装配置方法图文教程
程序员文章站
2022-05-24 14:56:02
本文为大家分享了mysql 8.0.13 安装配置教程,供大家参考,具体内容如下
下载
下载
解压
解压之后没有my.ini文件(我的端口设置的3308),...
本文为大家分享了mysql 8.0.13 安装配置教程,供大家参考,具体内容如下
下载
下载
解压
解压之后没有my.ini文件(我的端口设置的3308),截图中是我增加的
[client] port = 3308 default-character-set = utf8 [mysqld] port = 3308 character_set_server = utf8 basedir=d:\mysql\mysql-8.0.13-winx64 datadir=d:\mysql\mysql-8.0.13-winx64\data group_concat_max_len=20000 [winmysqladmin] d:\mysql\mysql-8.0.13-winx64\bin\mysqld.exe
管理员命令行
在mysql安装目录的 bin 目录下执行命令:
mysqld --initialize --console
得到如下结果
d:\mysql\mysql-8.0.13-winx64\bin>mysqld --initialize --console 2018-10-24t05:32:45.732454z 0 [system] [my-013169] [server] d:\mysql\mysql-8.0.13-winx64\bin\mysqld.exe (mysqld 8.0.13) initializing of server in progress as process 43080 2018-10-24t05:32:45.870611z 0 [warning] [my-013242] [server] --character-set-server: 'utf8' is currently an alias for the character set utf8mb3, but will be an alias for utf8mb4 in a future release. please consider using utf8mb4 in order to be unambiguous. 2018-10-24t05:33:14.879343z 5 [note] [my-010454] [server] a temporary password is generated for root@localhost: mmqp.yfcy5xy 2018-10-24t05:33:37.812581z 0 [system] [my-013170] [server] d:\mysql\mysql-8.0.13-winx64\bin\mysqld.exe (mysqld 8.0.13) initializing of server has completed d:\mysql\mysql-8.0.13-winx64\bin>
看到有个警告,查了一下mysql建议使用utf8mb4
修改my.ini文件
[client] port = 3308 default-character-set = utf8mb4 [mysqld] port = 3308 character-set-server = utf8mb4 basedir=d:\mysql\mysql-8.0.13-winx64 datadir=d:\mysql\mysql-8.0.13-winx64\data group_concat_max_len=20000 [winmysqladmin] d:\mysql\mysql-8.0.13-winx64\bin\mysqld.exe
警告没有了
d:\mysql\mysql-8.0.13-winx64\bin>mysqld --initialize --console 2018-10-24t06:06:51.100372z 0 [system] [my-013169] [server] d:\mysql\mysql-8.0.13-winx64\bin\mysqld.exe (mysqld 8.0.13) initializing of server in progress as process 47804 2018-10-24t06:07:18.372699z 5 [note] [my-010454] [server] a temporary password is generated for root@localhost: nj>uujkph4/i 2018-10-24t06:07:36.024435z 0 [system] [my-013170] [server] d:\mysql\mysql-8.0.13-winx64\bin\mysqld.exe (mysqld 8.0.13) initializing of server has completed d:\mysql\mysql-8.0.13-winx64\bin>
上面打印了默认密码:nj>uujkph4/i
安装服务
mysqld --install mysql8.0
因为这是电脑上第二个mysql 所以服务名改成了 mysql8.0
启动服务
net start mysql8.0
修改初始密码
登录mysql之后执行
alter user 'root'@'localhost' identified with mysql_native_password by '123456';
精彩专题分享:
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持。
上一篇: nginx服务器搭建和配置详解
下一篇: Nginx安装及配置详细分析
推荐阅读
-
CorePlex的安装、配置和使用图文教程
-
JDK1.6的下载、安装与配置图文详细教程 推荐
-
mysql installer community 8.0.16.0安装配置图文教程
-
MySQL8.x msi版安装教程图文详解
-
mysql 5.7.21 解压版安装配置图文教程
-
Autodesk MotionBuilder怎么安装?MotionBuilder 2014安装+破解方法详细图文教程
-
Vmware10上MAC OS 10.9安装配置方法图文教程
-
mysql 5.5.56免安装版配置方法
-
Win10下免安装版MySQL8.0.16的安装和配置教程图解
-
Win8.1系统电脑安装补丁失败提示此更新不适合计算机的解决方法图文教程