blocks|key|2404886|text|手动删除MySQL服务器上的所有文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2404887|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Manualy remove all file of MySQL server

blocks|key|3581313|text|似乎mysql-server现在被mariadb取代了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3581314|安装maridb-server解决了这个问题。|3581315|sudo+apt-get+install+mariadb-server|3581316|注意：-你不会得到你的数据库。使用mysql_secure_installation命令重置mysql密码|3581317|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Seems mysql-server is now replaced with mariadb

Installing maridb-server fixed the issue.

sudo apt-get install mariadb-server

Note:- You won't get your databases. Reset mysql password using command mysql_secure_installation

blocks|key|3581335|text|我找到了解决方案here|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3581336|删除mysql的所有文件：rm+-r+/var/lib/mysql*|style|CODE|3581337|Install+mysql+self+|unordered-list-item|3581338|
|3581339|：mysql_install_db+-u+mysql+(可能不适用于较新的系统，但不用担心)|3581340|3581341|启用systemd：systemctl+unmask+mysql.service|3581342|3581343|Then启动mysql+service+service+mysql+start|3581344|3581345|entityMap|0|LINK|mutability|MUTABLE|url|http://mokoetle.blogspot.com.ng/2015/05/failed-to-restart-mysqlservice-unit.html^0|8|4|0|0|D|L|0|0|0|1|P|0|0|A|U|0|0|C|R|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@$A|14|B|15|1|16]]|C|$]]|$1|D|3|E|5|6|7|17|8|@$A|18|B|19|F|G]]|9|@]|C|$]]|$1|H|3|I|5|J|7|1A|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|1B|8|@]|9|@]|C|$]]|$1|M|3|N|5|J|7|1C|8|@$A|1D|B|1E|F|G]]|9|@]|C|$]]|$1|O|3|L|5|6|7|1F|8|@]|9|@]|C|$]]|$1|P|3|Q|5|J|7|1G|8|@$A|1H|B|1I|F|G]]|9|@]|C|$]]|$1|R|3|L|5|6|7|1J|8|@]|9|@]|C|$]]|$1|S|3|T|5|J|7|1K|8|@$A|1L|B|1M|F|G]]|9|@]|C|$]]|$1|U|3|-4|5|6|7|1N|8|@]|9|@]|C|$]]|$1|V|3|-4|5|6|7|1O|8|@]|9|@]|C|$]]]|W|$X|$5|Y|Z|10|C|$11|12]]]]

I found the solution <a href="http://mokoetle.blogspot.com.ng/2015/05/failed-to-restart-mysqlservice-unit.html" rel="nofollow">here</a> 

<ol>
<li>Remove all of mysql's files: 
<code>rm -r /var/lib/mysql*</code></li>
<li>Install mysql self database: 
<code>mysql_install_db -u mysql</code> 
(might not work for newer systems, but don't worry)</li>
<li>Enable the service for systemd: <code>systemctl unmask mysql.service</code></li>
<li>Then start the mysql <code>service service mysql start</code></li>
</ol>

blocks|key|5693289|text|在我的例子中，我可以通过更改apparmor+(在kubuntu16.04上使用等离子)来解决这个问题。按照安装错误消息的建议，我查看了journalctl+-xe：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5693290|[....]+Starting+mysql+(via+systemctl):+mysql.serviceJob+for+mysql.service+failed+because+the+control+process+exited+with+error+code.+See+"systemctl+status+mysql.service"+and+"journalctl+-xe"+for+details.|code-block|syntax|javascript|5693291|在那里我发现了apparmor拒绝的消息：|5693292|AVC+apparmor="DENIED"+operation="open"+profile="/usr/sbin/mysqld"+name="/home/system/var/log/mysql/error.log"+pid=32610+comm="mysqld"+request|5693293|实际上，基目录/home/system/...是存在的，但是/etc/apparmor.d/usr.sbin.mysqld不允许访问。|5693294|因此，在/etc/apparmor.d/local/usr.sbin.mysqld中添加以下代码行解决了我的问题：|5693295|#+For+more+details,+please+see+/etc/apparmor.d/local/README.

#+Allow+log+file+access
++/home/system/var/log/mysql.err+rw,
++/home/system/var/log/mysql.log+rw,
++/home/system/var/log/mysql/+r,
++/home/system/var/log/mysql/**+rw,|5693296|别忘了重启apparmor，然后重启mysql安装(例如apt-get+install+--reinstall+mysql-common+mysql-server或者其他你想安装它的方式)。|5693297|我根本不知道为什么(从什么时候开始)目录/home/system存在，为什么mysql指向那里。但总有一天会有希望弄清楚...+;)|5693298|entityMap^0|E|8|1W|E|0|0|0|0|7|G|U|V|0|4|11|0|0|S|1H|0|K|C|0^^$0|@$1|2|3|4|5|6|7|10|8|@$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|15|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|16|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|17|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|18|8|@$9|19|A|1A|B|C]|$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1D|8|@$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|S|3|T|5|H|7|1G|8|@]|D|@]|E|$I|J]]|$1|U|3|V|5|6|7|1H|8|@$9|1I|A|1J|B|C]]|D|@]|E|$]]|$1|W|3|X|5|6|7|1K|8|@$9|1L|A|1M|B|C]]|D|@]|E|$]]|$1|Y|3|-4|5|6|7|1N|8|@]|D|@]|E|$]]]|Z|$]]

In my case I could solve the problem by changing <code>apparmor</code> (on kubuntu 16.04 using plasma).
I took a look at <code>journalctl -xe</code> as suggested by the installation error message:

<pre><code>[....] Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
</code></pre>

In there I found apparmor DENIED messages:

<pre><code>AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/home/system/var/log/mysql/error.log" pid=32610 comm="mysqld" request
</code></pre>

In deed, the base directory <code>/home/system/...</code> exists, but access is not allowed by <code>/etc/apparmor.d/usr.sbin.mysqld</code>.

So adding the following lines to <code>/etc/apparmor.d/local/usr.sbin.mysqld</code> solved my problem:

<pre><code># For more details, please see /etc/apparmor.d/local/README.

# Allow log file access
 /home/system/var/log/mysql.err rw,
 /home/system/var/log/mysql.log rw,
 /home/system/var/log/mysql/ r,
 /home/system/var/log/mysql/** rw,
</code></pre>

Don't forget to restart apparmor, and restart mysql installation (e.g. <code>apt-get install --reinstall mysql-common mysql-server</code> or whatever is your way to install it.)

I don't know at all why (and since when) the directory <code>/home/system</code> exists and why mysql points in there. But some day a hopefully figure out ... ;)

blocks|key|2404966|text|对我来说完全一样:运行级警告和mysql_upgrade错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2404967|我猜是因为我禁用了mysql服务，启用它可以解决问题：|2404968|sudo+systemctl+enable+mysql|offset|length|style|CODE|2404969|entityMap^0|0|0|0|R|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@$F|O|G|P|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

It was exactly same for me: runlevel warnings and mysql_upgrade error.

I guess it was because I disabled mysql service, enabling it fixes the problem:

<code>sudo systemctl enable mysql</code>

blocks|key|5693326|text|下面对我很有效，找到了解决方案-+here|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5693327|删除服务sudo更新-替代方案--删除/etc/mysql/my.cnf.migrated|5693328|sudo+|unordered-list-item|5693329|+mysql+my.cnf+|ordered-list-item|5693330|5693331|5693332|entityMap|0|LINK|mutability|MUTABLE|url|https://bugs.launchpad.net/ubuntu/%2Bsource/mysql-5.7/%2Bbug/1571865^0|H|4|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@$A|W|B|X|1|Y]]|C|$]]|$1|D|3|E|5|6|7|Z|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|10|8|@]|9|@]|C|$]]|$1|I|3|J|5|K|7|11|8|@]|9|@]|C|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|13|8|@]|9|@]|C|$]]|$1|N|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|O|$P|$5|Q|R|S|C|$T|U]]]]

Below worked for me, found solution - <a href="https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1571865" rel="nofollow" title="here">here</a>

<ol>
<li>sudo update-alternatives --remove my.cnf /etc/mysql/my.cnf.migrated</li>
<li>sudo service mysql start</li>
</ol>

blocks|key|3581515|text|我刚刚遇到了这个问题，这里有一个非常类似的错误报告：https://bugs.launchpad.net/ubuntu/%2Bsource/mysql-5.7/%2Bbug/1584287|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3581516|在我的例子中，我将mysql.service设置为disabled，并且在这种情况下，mysql_upgrade脚本似乎无法启动服务器。我启用了该服务(不需要启动它)，并重新运行了升级。工作后，我停止了服务，并再次禁用它。|style|CODE|3581517|我不确定还有什么原因会导致这种情况，但如果有人在禁用该服务的情况下遇到这种情况，只需启用它进行升级即可。|3581518|entityMap|0|LINK|mutability|MUTABLE|url|https://bugs.launchpad.net/ubuntu/%2Bsource/mysql-5.7/%2Bbug/1584287^0|Q|1S|0|0|9|D|17|D|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@$A|W|B|X|F|G]|$A|Y|B|Z|F|G]]|9|@]|C|$]]|$1|H|3|I|5|6|7|10|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]]]

I've just encountered this problem, there's a bug report that is quite similar here: <a href="https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1584287" rel="nofollow">https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1584287</a>

In my case I had the <code>mysql.service</code> set to disabled and the <code>mysql_upgrade</code> script seemed incapable of starting the server in this case. I enabled the service (didn't need to start it) and re-ran the upgrade. After that worked I stopped the service and disabled it again.

I'm not sure what else might cause this, but if someone encounters this with the service disabled, just enable it for the upgrade.

<pre><code>Configuring mysql-server-5.7 (5.7.11-0ubuntu6) … 
insserv: warning: current start runlevel(s) (empty) of script `mysql' overrides LSB defaults (2 3 4 5). 
insserv: warning: current stop runlevel(s) (0 1 2 3 4 5 6) of script `mysql' overrides LSB defaults (0 1 6).
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while connecting to the MySQL server 
Upgrade process encountered error and will not continue. 
mysql_upgrade failed with exit status 11 
dpkg: error with
 mysql-server-5.7 (--configure):
</code></pre>

apt-get remove return the same result.

This error come in with upgrade from 15.10 to 16.04

MySQl 5.7 installation failed on Kubuntu 16.04

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

Configuring mysql-server-5.7 (5.7.11-0ubuntu6) … insserv: warning: current start runlevel(s) (empty) of script `mysql' overrides LSB defaults (2 3 4 5). insserv...

问在Kubuntu16.04上安装MySQl 5.7失败
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Kubuntu16.04上安装MySQl 5.7失败EN