Window下mysql环境配置问题整理
Window下mysql环境配置问题整理
参考如下链接。
启动服务错误信息
管理员模式打开cmd
mysqld install
net start mysql
MYSql服务正在启动
MYSql服务无法启动
解决办法
删除mysql安装主目录下的data目录下所有文件
mysqld --initialize --console
C:\WINDOWS\system32> mysqld --initizlize --console mysqld: Can't change dir to 'D:\Program Files\mysql-8.0.12-winx64\data\' (OS errno 2 - No such file or directory) 2018-08-17T01:54:27.145772Z 0 [System] [MY-010116] [Server] D:\Program Files\mysql-8.0.12-winx64\bin\mysqld.exe (mysqld 8.0.12) starting as process 17876 2018-08-17T01:54:27.148482Z 0 [Warning] [MY-010091] [Server] Can't create test file D:\Program Files\mysql-8.0.12-winx64\data\DESKTOP-SET72RE.lower-test 2018-08-17T01:54:27.148571Z 0 [Warning] [MY-010091] [Server] Can't create test file D:\Program Files\mysql-8.0.12-winx64\data\DESKTOP-SET72RE.lower-test 2018-08-17T01:54:27.149798Z 0 [ERROR] [MY-010172] [Server] failed to set datadir to D:\Program Files\mysql-8.0.12-winx64\data\ 2018-08-17T01:54:27.169994Z 0 [ERROR] [MY-010119] [Server] Aborting 2018-08-17T01:54:27.172048Z 0 [System] [MY-010910] [Server] D:\Program Files\mysql-8.0.12-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.12) MySQL Community Server - GPL.
如上述报错的话,加上user,并记录初始密码
mysqld --initialize --user=root --console
C:\WINDOWS\system32>mysqld --initialize --user=root --console 2018-08-17T03:06:51.636920Z 0 [System] [MY-013169] [Server] D:\Program Files\mysql-8.0.12-winx64\bin\mysqld.exe (mysqld 8.0.12) initializing of server in progress as process 7832 2018-08-17T03:06:54.218851Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: yacuOdqg/6Mn 2018-08-17T03:06:55.288246Z 0 [System] [MY-013170] [Server] D:\Program Files\mysql-8.0.12-winx64\bin\mysqld.exe (mysqld 8.0.12) initializing of server has completed
安装服务
mysqld install
C:\WINDOWS\system32>mysqld install Service successfully installed.
启动服务
net start mysql
C:\WINDOWS\system32>net start mysql MySQL 服务正在启动 . MySQL 服务已经启动成功。
登陆系统
如登陆不上,需要运行net stop mysql,
然后重新运行下mysqld --initialize --user=root --console
mysql -u root -p
C:\WINDOWS\system32>mysql -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.12 Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. 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 'root'@'localhost' IDENTIFIED BY 'fjdoe13232'; mysql执行语句一定要以;结尾。切记。
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'fjdoe13232 '; Query OK, 0 rows affected (0.11 sec)
常用命令
show databases;
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.01 sec) mysql>
create database 数据库;
mysql> create database ustest; Query OK, 1 row affected (0.03 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | | ustest | +--------------------+ 5 rows in set (0.00 sec) mysql> use ustest; Database changed
以上是简单环境配置。
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· 单线程的Redis速度为什么快?
· 展开说说关于C#中ORM框架的用法!
· SQL Server 2025 AI相关能力初探
· AI编程工具终极对决:字节Trae VS Cursor,谁才是开发者新宠?