MySQL 如何在远程服务器上访问 phpMyAdmin

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/735022/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 13:05:14  来源:igfitidea点击:

How to access phpMyAdmin on remote server

mysqldatabasephpmyadmin

提问by Mike McLin

For my websites I use Dreamhost. Dreamhost requires you to create a hostname (ex: mysql.mclindigital.com) that the database will reside on. For me it's simple, if I want to access phpMyAdmin, I simply navigate to mysql.mclindigital.com, and it enters into phpMyAdmin automatically.

对于我的网站,我使用 Dreamhost。Dreamhost 要求您创建一个主机名(例如:mysql.mclindigital.com)以供数据库驻留。对我来说很简单,如果我想访问 phpMyAdmin,我只需导航到mysql.mclindigital.com,它就会自动进入 phpMyAdmin。

Apparently Dreamhost is in the minority using this method, because most people seem to use "localhost". So, how do I access phpMyAdmin for these websites? Will I need to get their Web Panel login info to browse around for this info?

显然 Dreamhost 是少数使用这种方法的,因为大多数人似乎都使用“localhost”。那么,如何访问这些网站的 phpMyAdmin?我是否需要获取他们的 Web 面板登录信息才能浏览这些信息?

As an example, I had a past client and I had to go here: http://216.120.237.104:2082/3rdparty/phpMyAdmin/index.phpto get into their phpMyAdmin. I never really understood what I was doing, but it just worked. Now I am in the same situation, but this time the client isn't as tech-savvy and is unable to give me the URL I need to go to.

例如,我有一个过去的客户,我不得不去这里:http: //216.120.237.104: 2082/3rdparty/phpMyAdmin / index.php进入他们的 phpMyAdmin。我从来没有真正理解我在做什么,但它只是奏效了。现在我处于同样的情况,但这次客户不是那么精通技术,无法给我我需要访问的 URL。

Also, I should point out I am not 100% certain that they have phpMyAdmin installed. I do know they have a database however, because they are running a Wordpress Blog.

另外,我应该指出我不是 100% 确定他们安装了 phpMyAdmin。我确实知道他们有一个数据库,因为他们正在运行一个 Wordpress 博客。

回答by Martin Tilsted

There is nothing magic or special about phpMyAdmin. It is just a bunch of php scripts.

phpMyAdmin 没有什么神奇或特别之处。它只是一堆 php 脚本。

Some webhosts(Such as dreamhost) may install it as standard similary to formmail and a bunch of other tools they may install.

一些虚拟主机(如 Dreamhost)可能会像 formmail 和其他一些他们可能会安装的工具一样安装它作为标准。

Your problem is most likely that you client don't have phpMyAdmin installed, and the easy solution(If you have ftp access) is to go to http://www.phpmyadmin.net/home_page/index.phpdownload phpMyAdmin, configure it and then just upload it to their ftp server your self. Then you can acces it similary to any other php script.

您的问题很可能是您的客户端没有安装phpMyAdmin,简单的解决方案(如果您有ftp访问权限)是去http://www.phpmyadmin.net/home_page/index.php下载phpMyAdmin,配置它然后只需将其上传到您自己的 ftp 服务器。然后你可以像任何其他 php 脚本一样访问它。