安装MYSQL的时候一直卡在starting server这里,求破
之前在网上看到过一个帖子说是到这里的时候禁用某个服务就可以了,然后当时也成功了
但是现在找不到这个帖子了
求破 先谢谢了
详情请看截图
之前在网上看到过一个帖子说是到这里的时候禁用某个服务就可以了,然后当时也成功了
但是现在找不到这个帖子了
求破 先谢谢了
详情请看截图
解决方案 »
- Mysql频繁Crash挂掉,求助
- 执行show processlist时候,state是end代表什么意思
- 求助。。plsql和存储过程
- 查询表中某个字段规定长度
- 急:为什么创建视图的时候有UNION就提示语句有错误
- mysql中有类似oracle的sequence功能吗?急啊!!!!!!!!
- 各位大侠,怎么把二进制的文件中的数据放进mysql中MEDIUMBLOB字段中阿?
- linux下mysql的my.cnf文件存放在什么地方
- mysql5.6版本,使用mysqldump导出数据库报错,求助
- 【在线等】这条查询语句如何优化
- mysql跨schema之间建立trigger同步更新两张表的trigger写法
- 求一个MySQL的递归查询,大神帮帮忙啊
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 fileBeginning configuration step: Updating firewall
Adding firewall rule for MYSQL56 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewallBeginning 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: Starting Server
Starting MySQL as a service
同求
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 fileBeginning configuration step: Updating firewall
Adding firewall rule for MySQL56 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewallBeginning 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: Starting Server
Starting MySQL as a service
150318 10:33:48 [Note] Plugin 'FEDERATED' is disabled.
150318 10:33:48 InnoDB: The InnoDB memory heap is disabled
150318 10:33:48 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150318 10:33:48 InnoDB: Compressed tables use zlib 1.2.3
150318 10:33:48 InnoDB: Error: unable to create temporary file; errno: 2
150318 10:33:48 [ERROR] Plugin 'InnoDB' init function returned error.
150318 10:33:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150318 10:33:48 [ERROR] Unknown/unsupported storage engine: INNODB
150318 10:33:48 [ERROR] Aborting
如果是的话,那就在C:\ProgramData\MySQL\MySQL Server 5.5下面的my.ini最后加入一句:
tmpdir="E:/MySqltemp"
这个文件夹必须是已经建好的,然后再配置或者再装,再弄的时候就修改my.ini文件就可以成功执行了!
就是等他出现,然后在最后一行改!
就是等他出现,然后在最后一行改!
这样还是会卡住,这时可以手动开启服务,在服务中查找mysql然后启动即可。
若发现后面还是会卡主,就取消,重新打开安装程序,点击Reconfigure等待my.ini出现后再重新配置,然后再手动启动服务即可
就是等他出现,然后在最后一行改!
这样还是会卡住,这时可以手动开启服务,在服务中查找mysql然后启动即可。
若发现后面还是会卡主,就取消,重新打开安装程序,点击Reconfigure等待my.ini出现后再重新配置,然后再手动启动服务即可
再顺便提一下,这样启动后root账号是不需要密码的
2016-07-23T21:39:38.820672Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-07-23T21:39:39.307969Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-07-23T21:39:39.558646Z 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: f5786c18-511d-11e6-bbe7-4ccc6a3caba9.
2016-07-23T21:39:39.629853Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-07-23T21:39:39.715077Z 1 [Note] A temporary password is generated for root@localhost: uy!Ch+eHv0wo
Ended configuration step: Stopping Server [if necessary]Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration fileBeginning configuration step: Updating firewall
Adding firewall rule for MySQL57 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewallBeginning 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 Data folder shipped
Attempting to run MySQL Server with --Initialize-insecure
Running process: C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
Waiting for the server stops: C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
2016-10-19T12:53:56.992807Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-10-19T12:53:56.992807Z 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.
2016-10-19T12:54:03.080116Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-10-19T12:54:04.660279Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
mysqld: File '.\鏉庡€?slow.log' not found (Errcode: 2 - No such file or directory)
2016-10-19T12:54:04.905418Z 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.
2016-10-19T12:54:04.923429Z 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: 1db6cdae-95fb-11e6-832b-40167e95efb6.
2016-10-19T12:54:05.033505Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-10-19T12:54:05.073536Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
Finished initialize database
Ended configuration step: Initializing Database [if necessary]Beginning configuration step: Starting Server
Starting MySQL as a service
这个也是卡在这里
Ended configuration step: Stopping Server [if necessary]Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration fileBeginning configuration step: Updating firewall
Adding firewall rule for MySQL57 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewallBeginning 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 Data folder shipped
Attempting to run MySQL Server with --Initialize-insecure
Running process: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
Waiting for the server stops: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
2016-12-05T05:01:21.331782Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-12-05T05:01:21.331782Z 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.
2016-12-05T05:01:24.644370Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-12-05T05:01:25.488084Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
mysqld: File '.\鍛嗙惔鐞?slow.log' not found (Errcode: 2 - No such file or directory)
2016-12-05T05:01:25.675634Z 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.
2016-12-05T05:01:25.691205Z 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: dfb744d7-baa7-11e6-8b42-28d2442fc148.
2016-12-05T05:01:25.753757Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-12-05T05:01:25.753757Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
Finished initialize database
Ended configuration step: Initializing Database [if necessary]Beginning configuration step: Starting Server
Starting MySQL as a service
大神们,怎么解决啊,欲哭无泪
百度资料了一个半小时,重装了3次,在windows设置里切换到'开发者模式'后,一次性通过。