Mysql服务无法启动的问题求助

li410426 2015-11-04 05:02:36
前提是： 我的Mysql是免安装版的，前段时间是按照指导很顺利完成了配置，今天出现了一些小问题，慌乱之中就把解压文件删除 了，然后在原来的地方又解压配置了一个相同版本的Mysql。
现在的问题是：如图，不能启动服务。

想完全把mysql清除再安装配置一次，有害怕清除不干净留下后遗症
...全文
297 8 打赏 收藏 转发到动态 举报
写回复
用AI写文章
8 条回复
切换为时间正序
请发表友善的回复…
发表回复
rick-he 2015-11-05
  • 打赏
  • 举报
 回复

打上双引号试下
li410426 2015-11-05
  • 打赏
  • 举报
 回复
的确是没有，我就自己新建了一个data文件夹，然后里面就

引用 6 楼 u011575570 的回复:
[quote=引用 5 楼 u011575570 的回复:]
http://www.oschina.net/question/1244397_2138435

http://bbs.csdn.net/topics/391849032?page=1
这个也可以看看[/quote]

谢谢您 ，现在可以按照老师们的方法已经可以启动mysql服务了，但是有一个问题是，在其中以一个步骤需要输入临时密码，但是产生的临时密码很奇怪，竟然还有问号，我全部输入就发生错误。
rick-he 2015-11-04
  • 打赏
  • 举报
 回复
引用 5 楼 u011575570 的回复:
http://www.oschina.net/question/1244397_2138435
http://bbs.csdn.net/topics/391849032?page=1 这个也可以看看
rick-he 2015-11-04
  • 打赏
  • 举报
 回复
http://www.oschina.net/question/1244397_2138435
rick-he 2015-11-04
  • 打赏
  • 举报
 回复
数据库版本是：mysql-5.7.9-winx64 问题：Table 'mysql.plugin' doesn't exist 查看下有没有mysql/data文件夹，好像window的5.7.9版本好多人多说没有mysql/data这个文件夹
ACMAIN_CHM 2015-11-04
  • 打赏
  • 举报
 回复
找一下MYSQL的DATA目录下是否有 mysql文件夹及的相关的表文件。 如果有，再检查一下文件夹权限。
li410426 2015-11-04
  • 打赏
  • 举报
 回复
mysql-5.7.9-winx64的版本：我将最近的启动的错误日志截下来了，您帮着看一下？我看不懂

2015-11-04T10:04:04.333674Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-04T10:04:04.333674Z 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.
2015-11-04T10:04:04.333674Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2015-11-04T10:04:04.333674Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2015-11-04T10:04:04.333674Z 0 [Note] MySQL (mysqld 5.7.9) starting as process 12264 ...
2015-11-04T10:04:04.359274Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-04T10:04:04.359274Z 0 [Note] InnoDB: Uses event mutexes
2015-11-04T10:04:04.359274Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2015-11-04T10:04:04.359274Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-04T10:04:04.361774Z 0 [Note] InnoDB: Number of pools: 1
2015-11-04T10:04:04.361774Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-04T10:04:04.555275Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2015-11-04T10:04:04.570875Z 0 [Note] InnoDB: Completed initialization of buffer pool
2015-11-04T10:04:04.664475Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-04T10:04:04.825475Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2015-11-04T10:04:04.841075Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2015-11-04T10:04:05.123776Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2015-11-04T10:04:05.123776Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2015-11-04T10:04:05.123776Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2015-11-04T10:04:05.141876Z 0 [Note] InnoDB: Waiting for purge to start
2015-11-04T10:04:05.193076Z 0 [Note] InnoDB: 5.7.9 started; log sequence number 1210189
2015-11-04T10:04:05.193076Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\mysql-5.7.9-winx64\data\ib_buffer_pool
2015-11-04T10:04:05.193076Z 0 [Note] InnoDB: not started
2015-11-04T10:04:05.193076Z 0 [Note] InnoDB: Buffer pool(s) load completed at 151104 18:04:05
2015-11-04T10:04:05.193076Z 0 [Note] Plugin 'FEDERATED' is disabled.
MySQL: Table 'mysql.plugin' doesn't exist
2015-11-04T10:04:05.193076Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-11-04T10:04:05.193076Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2015-11-04T10:04:05.208676Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2015-11-04T10:04:05.208676Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2015-11-04T10:04:05.208676Z 0 [Note] IPv6 is available.
2015-11-04T10:04:05.208676Z 0 [Note] - '::' resolves to '::';
2015-11-04T10:04:05.208676Z 0 [Note] Server socket created on IP: '::'.
2015-11-04T10:04:05.224276Z 0 [Warning] Failed to open optimizer cost constant tables

2015-11-04T10:04:05.224276Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2015-11-04T10:04:05.239877Z 0 [ERROR] Aborting

rick-he 2015-11-04
  • 打赏
  • 举报
 回复
什么版本？看下错误日志。my.ini
CentOS 7下MySQL服务启动失败的快速解决方法
今天，启动MySQL服务器失败，如下所示： [root@spark01 ~]# /etc/init.d/mysqld start Starting mysqld (via systemctl): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. [FAILED] 根据提示，分别使
MySQL无法启动的解决办法
MySQL无法启动的解决办法 MySQL无法启动 在停止mysql之后，执行了一些操作（如修改主机名），重新启动 mysql，发现起不来。  [root@www ~]$ service mysql start Starting MySQL..^[[A.................................................................................................. ERROR! The server quit without updating PID file (/disk/mysql/www.pid). [
mysql学习笔记
mysql的学习笔记,没什么技术含量!!
登录失败解决方案.pdf
。。。
win10下mysql 5.7.17 zip压缩包版安装教程
主要为大家详细介绍了win10下mysql 5.7.17 zip压缩包版安装教程，具有一定的参考价值，感兴趣的小伙伴们可以参考一下
MySQL

57,062

社区成员

56,762

社区内容

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章