免费房屋建设图纸网站有哪些,网站宝 西部数码网站管理助手,献县做网站价格,焦作河南网站建设通过zip方式安装mysql服务 Mysql安装包下载mysql安装及环境配置1.解压缩配置环境变量初始化mysql配置安装mysql服务启动MySQL服务连接mysql修改root用户密码 Mysql安装包下载
通过访问mysql官网下载#xff1a;mysql下载地址
mysql安装及环境配置
1.解压缩
下载完成后mysql下载地址
mysql安装及环境配置
1.解压缩
下载完成后解压到合适的安装位置E:\servers\mysql-8.0.37-winx64
配置环境变量
复制解压的位置来配置环境变量 右键此电脑-属性-高级系统设置-高级-环境变量-新建系统变量
新建MYSQL_HOME新增PATH配置本来就有 %MYSQL_HOME%\bin
初始化mysql配置
配置文件在mysql安装路径下新建文件my.ini进行一些默认配置,注意basedir是mysql安装位置datadir是数据存放地址可以手动新建data文件夹
[client]
port3306
default-character-setutf8
[mysqld]
bind-address127.0.0.1
skip-networking0
basedirE:/servers/mysql-8.0.37-winx64
datadirE:/servers/mysql-8.0.37-winx64/data
port3306
character_set_serverutf8mb4
sql_modeSTRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
explicit_defaults_for_timestamptrue通过管理员权限启动cmdmysqld --initialize --usermysql --console **注意在输出的最后一行提供了mysql的初始密码不要忘了保存 我的是7hgRquaQkM)n **
C:\Windows\System32mysqld --initialize --usermysql --console
2024-10-08T01:40:50.701999Z 0 [System] [MY-013169] [Server] E:\servers\mysql-8.0.37-winx64\bin\mysqld.exe (mysqld 8.0.37) initializing of server in progress as process 15404
2024-10-08T01:40:50.715118Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-10-08T01:40:50.993325Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-10-08T01:40:51.990600Z 6 [Note] [MY-010454] [Server] A temporary password is generated for rootlocalhost: 7hgRquaQkM)n安装mysql服务
继续在cmd窗口输入命令mysqld --install
C:\Windows\System32mysqld --install
Service successfully installed.
启动MySQL服务
看到上面的安装成功提示就可以启动了继续在cmd窗口键入net start mysql
C:\Windows\System32net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
连接mysql
看到启动成功提示输入命令 mysql -u root -p然后输入刚才的密码
C:\Windows\System32mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.37Copyright (c) 2000, 2024, 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
修改root用户密码
成功进入mysql命令行后在mysql命令行输入命令alter user rootlocalhost identified by root
mysql alter user rootlocalhost identified by root;
Query OK, 0 rows affected (0.02 sec)mysql
密码就被修改为root了 下次登陆使用新密码就可以了
