安装时候到启动服务时候,服务启动不了,
Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]
Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file
Beginning configuration step: Updating firewall
Attempting to create firewall rule with command: netsh.exe firewall delete portopening protocol=TCP port=3306 profile=ALL
Adding firewall rule for MySQL on port 3306.
Attempting to create firewall rule with command: netsh.exe firewall add portopening protocol=TCP port=3306 profile=ALL name=MySQL mode=ENABLE scope=ALL
Successfully added firewall rule.
Ended configuration step: Updating firewall
Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]
Beginning configuration step: Initializing Database [if necessary]
Deleting the data directory from a previous (failed) configuration...
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 5.7.21...
Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console --initialize-insecure=on...
2018-02-23T09:51:19.100633Z 0 [Warning] option 'read_buffer_size': unsigned value 0 adjusted to 8192
2018-02-23T09:51:19.100738Z 0 [Warning] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1
2018-02-23T09:51:19.100841Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-02-23T09:51:19.100862Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-02-23T09:51:21.155766Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-02-23T09:51:21.636909Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
mysqld: File '.\鍒樹繆宀?slow.log' not found (Errcode: 2 - No such file or directory)
2018-02-23T09:51:21.886656Z 0 [ERROR] Could not use 鍒樹繆宀?slow.log for logging (error 2 - No such file or directory). Turning logging off for the server process. To turn it on again: fix the cause, then either restart the query logging by using "SET GLOBAL SLOW_QUERY_LOG=ON" or restart the MySQL server.
2018-02-23T09:51:21.892115Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 1a7a0638-187f-11e8-b26e-3417eb5b6dd1.
2018-02-23T09:51:21.951880Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-02-23T09:51:21.954100Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
Process for mysqld, with ID 952, was started successfully and exited with code 0.
MySQL Server 5.7.21 intialized the database successfully.
Ended configuration step: Initializing Database [if necessary]
Beginning configuration step: Starting Server
Attempting to start service MySQL
你是不是在什么位置配置汉字的路径了。
mysqld: File '.\鍒樹繆宀?slow.log' not found (Errcode: 2 - No such file or directory)
这个是报错。
最好建议默认安装c盘,用不了多少内存的,你如果改路径的话把c直接改成d或者其他的就行了,后面默认的不要动应该就差不错了
新疆人民用不了百度网盘,要不可以给你一个我自己写的免安装部署包
我先试试能不能传到下载区,回头给你地址
你这个错误是路径问题,含有中文路径
http://download.csdn.net/download/no000on/10256217
刚刚上传的,要是打不开资源应该还在审核中
最少只能需要2个积分下载,没法设置0积分了
安装路径问题,不要出现中文目录中
安装路径问题,不要出现中文目录中 同时将之前安装的卸载 清除干净
安装时默认安装即可,路径中不要有中文。
谢谢大家,问题解决了,是我的电脑名称为中文,然后再安装的时候一些日志文件名称自动设置为中文的,我把电脑名称改为英文的就没一点问题了。另外说一下我装的是MySQL 5.7.21非解压安装
路径不能有中文字符。
所有人都可能扯淡~如果你之前安装卸载过的,非常有可能卸载不干净,用360卫士(非打广告而是技巧)删掉多余注册表残留,然后再重新安装,信我
mysqld: File '.\鍒樹繆宀?slow.log' not found (Errcode: 2 - No such file or directory)
安装路径应为全英文,不能使用中文