允许我的客户像filezilla一样访问他们的数据库 [英] Allow my customer to access their database like filezilla

问题描述

我为我的客户开发了一个WordPress网站，并在我的linux共享主机上托管它。我的客户想要访问所有文件以及database.I给他一个ftp帐户来管理文件，但我现在不知道如何给他数据库帐户。所以，有没有办法只给他phpmyadmin访问他们的数据库。



我的尝试：



我想给客户端数据库访问，如www.domainname.com/phpmyadmin。

i have developed one WordPress website for my client and host it on my linux shared hosting. My client want to access for all the files as well as database.I give him one ftp account for managing files but i dont now how to give him database account.So, is there any way to give him phpmyadmin access for their database only.

What I have tried:

i'm trying to give client database access like www.domainname.com/phpmyadmin .

推荐答案

您不能访问这样的数据库：您需要一个应用程序来访问数据。对于MySql，可能是 MySQL Workbench [ ^ ]或 HeidiSQL [ ^ ] - 对于SQL Server，它的SSMS最近可单独下载：下载SQL Server Management Studio（SSMS） Microsoft Docs [ ^ ]但这不适用于MySQL IIRC。

但这并不能解决整个问题：你需要为他们创建一个具有合适权限的帐户，确保数据库远程可用： mysql远程访问 - Google搜索 [ ^ ]然后给他们用户名和密码组合。



再做其他两件事：

1）经常回复那个傻瓜！

2 ）开始希望他们不会破坏数据库，因为它可能会崩溃你的si te他们会责怪你......

You don't access a database like that: you need an application to access the data. For MySql, that would probably be MySQL Workbench[^] or HeidiSQL[^] - for SQL Server, it's SSMS which is available as a separate download these days: Download SQL Server Management Studio (SSMS) | Microsoft Docs[^] but that won't work with MySQL IIRC.
That doesn't solve the whole problem though: you need to create an account for them with suitable permissions and make sure that the DB is available remotely: mysql remote access - Google Search[^] then give them the username and password combination.

And then do two other things:
1) Back that sucker up frequently!
2) Start hoping they don't muck the DB up as it'll probably crash your site and they will blame you...

这篇关于允许我的客户像filezilla一样访问他们的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！