MySql错误:Starting MySQL...The server quit without updating PID file(服务器学习十一)

centos7 首次  mysql安装成功后,服务启动执行

/usr/local/mysql/support-files/mysql.server start

报错这个信息

Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/web-20200325.pid).

试过添加了所有的权限,然并无卵用    

编辑/etc/init.d/mysql,找到start模块,添加--user=root到mysqld_safe 即可


 

发布了89 篇原创文章 · 获赞 26 · 访问量 13万+
展开阅读全文

MySql安装一直卡在starting serverq 求解答 贴上log

09-19

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 Adding firewall rule for MySQL57 on port 3306. 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 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 2017-09-19T18:14:08.853281Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-09-19T18:14:08.853281Z 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. 2017-09-19T18:14:14.079270Z 0 [Warning] InnoDB: New log files created, LSN=45790 2017-09-19T18:14:15.654948Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. mysqld: File '.\绁栧帤涔?slow.log' not found (Errcode: 2 - No such file or directory) 2017-09-19T18:14:15.951298Z 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. 2017-09-19T18:14:15.966926Z 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: 58c698a0-9d66-11e7-ab89-201a06371a86. 2017-09-19T18:14:16.138545Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2017-09-19T18:14:16.388094Z 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 问答

没有更多推荐了,返回首页

©️2019 CSDN 皮肤主题: 大白 设计师: CSDN官方博客

分享到微信朋友圈

×

扫一扫,手机浏览