blocks|key|3992524|text|拥有数据库访问并不意味着您有shell访问权限。我在工作中有一个数据库，许多同事都可以通过一些用户/密码组合访问数据库。但是，他们没有一个shell登录，因为他们不需要它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

Having database access doesn't imply that you have shell access. I have a a database at work to which many co-workers have access with some user/password combination. However, none of them have a shell login, because they don't need it.

blocks|key|5994233|text|一个MySQL连接和一个"shell“连接是完全独立的，即使它们看起来是同一个地址。您不能直接从一个切换到另一个；您必须退出MySQL客户机并在其位置启动一个SSH客户端。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

A MySQL connection and a "shell" connection are completely independent, even if they appear to go to the same address. You can't switch from one to other directly; you have to exit the MySQL client and start a SSH client in its place.

blocks|key|3992564|text|mysql+-u用户-p传递-h远程主机|type|blockquote|depth|inlineStyleRanges|entityRanges|data|3992565|我认为你是通过在你自己的机器上运行上面的命令来连接的。|unstyled|3992566|无法从mysql+shell中获得远程系统shell访问权限，因此，除非没有为远程主机提供系统登录帐户，否则您可能运气不佳。|3992567|提供一个登录帐户，您通常可以使用SSH或telnet访问远程主机。|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|K|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|M|8|@]|9|@]|A|$]]]|I|$]]

<blockquote>
 mysql -u user -p pass -h remotehost
</blockquote>

I take it you connecting by running the above command from your own machine.. 

There is no way to gain remote system shell access from within the mysql shell, so unless you have not been provided with a system login account for the remote host you are probably out of luck. 

Provided a login account you could typically use SSH or telnet to access the remote host.

blocks|key|5994118|text|您没有描述您是如何“获得数据库访问权限”的。如果是通过从shell提示符执行mysql客户端，那么只需退出mysql控制台就可以将您送回shell。但是，如果您的数据库访问是通过web进行的(例如phpmyadmin)，您就不能“切换到shell”。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5994119|需要更多的信息。|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|E|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|F|8|@]|9|@]|A|$]]]|D|$]]

You fail to describe how you "got database access". If it was by executing the mysql client from a shell prompt, then simply exiting the mysql console will drop you back to the shell. However, if your database access is over the web (e.g. phpmyadmin), you can't just "switch to shell".

More info needed.

blocks|key|5994301|text|出于安全原因，您无法从MySQL监视器访问shell。除非系统使用pam_mysql对数据库进行身份验证，而且可以添加新的数据库用户(由于安全考虑，这两者都不太可能是真的)，否则您就倒霉了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

You cannot get to a shell from the MySQL monitor, for security reasons. Unless the system authenticates against the database using pam_mysql, and you can add new database users (it's ridiculously unlikely that both would be true, due to security concerns), you are out of luck.

blocks|key|5994325|text|实际上，如果mysql是以根用户的身份运行，并且您拥有特定的权限，那么您可以这样做，但它也会让您陷入麻烦，因为它会授予您与mysql帐户相同的用户访问权限。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5994326|因为你甚至会做我想做的事情的唯一原因是进入一个你没有特权或权利的系统，我不会说为什么，因为这是不道德的，但我可以肯定有一个方法。|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|E|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|F|8|@]|9|@]|A|$]]]|D|$]]

Actually if the mysql is run as a root user and you have specific privileges, then you could but it would also get you in a boat load of trouble considering it would grant you the same user access as the mysql account itself.

Because the only reason you would even do what I am think is to gain access to a system you don't have the privileges or rights to, I won't say how because that would be unethical but I can say for sure there is a way.

<pre><code>mysql -u user -p pass -h remotehost
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 96
Server version: 5.1.36-community-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql&gt; 
</code></pre>

Suppose the remotehost's OS is linux,

how do I switch to shell mode?

UPDATE

I get access to database via shell prompt.

I meant to access shell prompt of remotehost,typing <code>exit</code> will return to my own shell prompt.

How do I switch to shell access if I've already got database access?

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

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

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

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

社区新版编辑器体验调研

mysql -u user -p pass -h remotehostWelcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 96Server version: 5.1.36-community-log MySQL Community Server (GPL)Type 'help;' 

问如果我已经有了数据库访问权限，如何切换到shell访问？
EN

更新

回答 6

Server Fault用户

Server Fault用户

Server Fault用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如果我已经有了数据库访问权限，如何切换到shell访问？EN

更新

回答 6

Server Fault用户

Server Fault用户

Server Fault用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如果我已经有了数据库访问权限，如何切换到shell访问？
EN