blocks|key|10195|text|假设您正在运行一个最新的Ubuntu，并且您已经是root用户，正如您所提到的，下面的命令是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|10196|service+mysql+stop|offset|length|style|CODE|10197|或|10198|/etc/init.d/mysql+stop|10199|由于您的安装，您应该尝试如下：|10200|sudo+-u+mysql+/usr/local/mysql/bin/mysqld+stop|entityMap^0|0|0|I|0|0|0|M|0|0|0|1A^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|U|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|V|8|@$D|W|E|X|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|Y|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Z|8|@$D|10|E|11|F|G]]|9|@]|A|$]]]|P|$]]

Assuming that you are running an up-to-date Ubuntu and you are already root, as you mentioned, the command is: 

<code>service mysql stop</code> 

or 

<code>/etc/init.d/mysql stop</code>

Because of your installation, you should try this:

<code>sudo -u mysql /usr/local/mysql/bin/mysqld stop</code>

blocks|key|10125|text|使用sudo+mysqld+stop作为根用户停止它。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|10126|希望能帮上忙。|entityMap^0|2|G|0^^$0|@$1|2|3|4|5|6|7|I|8|@$9|J|A|K|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|L|8|@]|D|@]|E|$]]]|H|$]]

Use <code>sudo mysqld stop</code> to stop it as root. 

hope it helped.

blocks|key|5261627|text|sudo+/etc/init.d/mysqld+stop|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|5261628|应该这么做。|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|I|8|@]|9|@]|A|$]]]|G|$]]

<pre><code>sudo /etc/init.d/mysqld stop
</code></pre>

should do it.

blocks|key|10316|text|您已经选择不安装由Ubuntu提供的mysql包，而是手动将一个版本安装到/usr/local中--因此，您没有按照正常的"Ubuntu“方式进行操作，您在这里得到的建议可能会受到影响。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|10317|在Ubuntu中安装MySQL的正常方法是使用类似于sudo+apt-get+install+mysql-server的工具安装Ubuntu提供的包。使用make或install脚本手动将某些东西安装到/usr/local中，应该是在您有特定原因并且拥有更高水平的技术技能和知识，并且愿意自己正确地设置它时才会这样做。您还需要手动进行更新和安全补丁，因为它不会由Ubuntu完成。|10318|根据您对Ubuntu的技术知识水平，我不认为手动将某些东西安装到/usr/local中是适合您的。除非您有充分的理由不能使用Ubuntu中包含的Ubuntu，而且您真的想了解更多，否则我建议删除该MySQL并使用sudo+apt-get+install+mysql-server安装Ubuntu。|10319|完成此操作后，您将能够遵循在Ubuntu和howtos上找到的所有正常指令。|entityMap^0|11|A|0|Q|X|2T|A|0|W|A|2Y|X|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$]]

You have elected not to install the mysql package provided by Ubuntu and have instead manually installed a version into <code>/usr/local</code> - as such you are not doing things the normal "Ubuntu" way and the advice you get here may be affected.

The normal way of install MySQL in Ubuntu is by installing the package provided by Ubuntu using something like <code>sudo apt-get install mysql-server</code>. Installing something manually into <code>/usr/local</code> with a make or install script should be something done only when you have a specific reason to do so and you have a greater level of technical skill and knowledge, and willingness to set it up correctly yourself. You'll also need to do updates and security patches manually because it won't be done by Ubuntu.

Based on your level of technical knowledge of Ubuntu I don't think installing something manually into <code>/usr/local</code> is for you. Unless you respond with a good reason for not being able to use the one included with Ubuntu and you really want to learn more, I'd advise removing that MySQL and installing the Ubuntu one with <code>sudo apt-get install mysql-server</code>.

After doing this, you'll be able to follow all the normal instructions you find on the Ubuntu wikis and howtos.

blocks|key|10220|text|尝试以下几点：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|10221|退出；|10222|这对me...then有效--我刚收到消息：“再见”。然后，它再次显示输入一个comand作为USER@user>，而不是MYSQL>。帮帮忙！|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|H|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|I|8|@]|9|@]|A|$]]]|F|$]]

try the following:

quit;

this worked for me...then i just got the msg: "bye". then it was showing again to enter a comand as the USER@user>, not as MYSQL>. Help this works!

How can i stop mysql server (installed using binary installation under <code>/usr/local/mysql</code>)?

When i go in <code>/usr/local/mysql/bin</code> and execute command 

<code>mysqld stop</code> i get following error message : 

<pre><code>[ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
[ERROR] Aborting
[Note] mysqld: Shutdown complete
</code></pre>

and i can still see process for mysql server.

same happens when i try to do it with mysqld in <code>/etc/init.d</code>.

how to stop mysql server with root

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

如何停止mysql服务器(使用/usr/local/mysql下的二进制安装安装)？当我进入/usr/local/mysql/bin并执行命令时mysqld stop我得到以下错误消息：[ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root![ER

问如何用root停止mysql服务器
EN

回答 5

Ask Ubuntu用户

Ask Ubuntu用户

Ask Ubuntu用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用root停止mysql服务器EN

回答 5

Ask Ubuntu用户

Ask Ubuntu用户

Ask Ubuntu用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用root停止mysql服务器
EN