blocks|key|223218|text|好吧，我非常怀疑你会找到任何解决方案来做你所要求的一切，特别是如果你想所有的都是免费的。但我会带你去phpMyAdmin。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|223219|如果你还没有见过它，它是一个基于web的MySQL数据库前端(在php服务器上运行)。它易于部署，并且可以维护多个用户登录。它在ajax部门不是很强大，我从来没有听说过像调度任务或电子邮件这样的东西，但这些东西都可以用不同的方式完成。|223220|把phpMyAdmin想象成web上的一个数据库编辑器，你不会想要把它交给客户去摆弄的。|223221|entityMap|0|LINK|mutability|MUTABLE|url|http://phpmyadmin.net/^0|1E|A|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

Well I highly doubt you are going to find any solution that does ALL of what you are asking, especially if you want it all to be free. But I will point you to <a href="http://phpmyadmin.net" rel="noreferrer">phpMyAdmin</a>.

If you haven't come across it yet, it is a web-based front end for a MySQL database (runs on a php server). It is easy to deploy and can maintain multiple user logins. It's not too strong in the ajax department and I've never heard of anything like scheduled jobs or email for it but that stuff can all be done in different ways. 

Think of phpMyAdmin as a database editor on the web, it's not going to be something you're going to want to hand over to clients to mess around with though.

blocks|key|226537|text|有一个较新的工具可以满足您的许多需求。你可以在这里查看：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|226538|Eliacom+Enhanced+SQL+Portal+(ESP)|offset|length|226539|这里还有一个演示，您可以使用它登录到任何数据库服务器(请注意，要使用它，它将在您的数据库中安装几个额外的表，以保存您在前端设置的格式信息)：|226540|Eliacom+ESP+Demo|226541|下面是它是如何按照你的标准分解的：|226542|database|226543|It是一个图形用户界面|unordered-list-item|style|BOLD|226544|It's+free|226545|It's，它基本上和一样容易用于行内编辑。|226546|It‘s+free|226547|It’s是用php+编写的，可以在php服务器上运行。在树中组织你的表，布局和重命名列，所有这些都是从GUI.|226548|It做的比CRUD更多，这可能是它的强项。你几乎可以创建任何东西。对于真正奇特的东西，你需要了解一些HTML。你绝对可以很容易地删除多条记录。插入多条记录可以通过过去的函数(或上载)来完成。|226549|It's完全是ajax，它看起来相当现代|226550|It处理登录和会话处理(它也会在一段时间后锁定会话)使用单个实例您可以登录到任何服务器(您可以通过course).|226551|You访问该服务器不需要任何编程。如果您想要制作非常简洁的表单，你需要知道一些超文本标记语言(表单看起来很好，即使没有that).|226552|It's完全基于网络和控制通过一个browser|226553|The基础系统没有日程安排/电子邮件，但你可以购买一个附加组件，具有日程安排作业/电子邮件等我相信他们已经有这个，如果他们是为你托管的。只是不是在一般版本中。在一般的版本中，如果你了解一点PHP，你可以在修改表格时添加监听器，并做像发送电子邮件这样的事情(你从前端的end).|226554|The基础产品添加这些东西是为了数据库管理，但也有购买的附加组件。他们有一个购买应用程序，让你能够把控制权交给其他用户(有很多权限设置，他们可以/不能做什么，所以他们不能破坏东西)。他们也有一个发布者应用程序，您可以创建一个链接，允许将表单/表格发布到开放的internet+(对于公共数据viewing/entering).|226555|Coffee...，他们接受用户的请求，因此如果您有要素请求，您可以与他们联系。|226556|226557|226558|226559|entityMap|0|LINK|mutability|MUTABLE|url|http://www.eliacom.com/|1|http://www.eliacom.com/esp/^0|0|0|X|0|0|0|0|G|1|0|0|0|0|B|0|0|9|0|0|L|1|0|9|1|0|1J|1|0|2N|1|0|K|1|0|1L|1|0|1T|1|0|O|1|0|3U|1|0|4J|1|0|14|1|0|0|0^^$0|@$1|2|3|4|5|6|7|1T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1U|8|@]|9|@$D|1V|E|1W|1|1X]]|A|$]]|$1|F|3|G|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1Z|8|@]|9|@$D|20|E|21|1|22]]|A|$]]|$1|J|3|K|5|6|7|23|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|24|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|25|8|@$D|26|E|27|Q|R]]|9|@]|A|$]]|$1|S|3|T|5|P|7|28|8|@$D|29|E|2A|Q|R]]|9|@]|A|$]]|$1|U|3|V|5|P|7|2B|8|@$D|2C|E|2D|Q|R]]|9|@]|A|$]]|$1|W|3|X|5|P|7|2E|8|@$D|2F|E|2G|Q|R]]|9|@]|A|$]]|$1|Y|3|Z|5|P|7|2H|8|@$D|2I|E|2J|Q|R]]|9|@]|A|$]]|$1|10|3|11|5|P|7|2K|8|@$D|2L|E|2M|Q|R]]|9|@]|A|$]]|$1|12|3|13|5|P|7|2N|8|@$D|2O|E|2P|Q|R]]|9|@]|A|$]]|$1|14|3|15|5|P|7|2Q|8|@$D|2R|E|2S|Q|R]]|9|@]|A|$]]|$1|16|3|17|5|P|7|2T|8|@$D|2U|E|2V|Q|R]]|9|@]|A|$]]|$1|18|3|19|5|P|7|2W|8|@$D|2X|E|2Y|Q|R]]|9|@]|A|$]]|$1|1A|3|1B|5|P|7|2Z|8|@$D|30|E|31|Q|R]]|9|@]|A|$]]|$1|1C|3|1D|5|P|7|32|8|@$D|33|E|34|Q|R]]|9|@]|A|$]]|$1|1E|3|1F|5|P|7|35|8|@$D|36|E|37|Q|R]]|9|@]|A|$]]|$1|1G|3|-4|5|6|7|38|8|@]|9|@]|A|$]]|$1|1H|3|-4|5|6|7|39|8|@]|9|@]|A|$]]|$1|1I|3|-4|5|6|7|3A|8|@]|9|@]|A|$]]|$1|1J|3|-4|5|6|7|3B|8|@]|9|@]|A|$]]]|1K|$1L|$5|1M|1N|1O|A|$1P|1Q]]|1R|$5|1M|1N|1O|A|$1P|1S]]]]

There's a newer tool that fits a lot of your needs. You can check it out here:

<a href="http://www.eliacom.com/" rel="nofollow">Eliacom Enhanced SQL Portal (ESP)</a>

There is also a demo that you can use to login to any database server here (note that to use it, it will install a few extra tables into your database to hold formatting information that you set in the front end):

<a href="http://www.eliacom.com/esp/" rel="nofollow">Eliacom ESP Demo</a>

Here's how it breaks down with your criteria:

<ul>
<li>It's free</li>
<li>It's written in PHP To run on a php server with a
MySql database</li>
<li>It is a GUI It's basically as easy to use as Excel for inline editing. Organize your tables in trees, layout and rename columns, all from the GUI.</li>
<li>It does more that CRUD This probably its strongest point. You can create pretty much anything. For really fancy stuff you need to know a little HTML. You can definitely delete multiple records very easily. Inserting multiple records can be done via a past function (or upload). </li>
<li>It's completely ajax and it looks pretty modern </li>
<li>It deals with logging in and session handling (it locks sessions after a while too) With a single instance you can log into any server (that you have access to of course).</li>
<li>You don't need any programming. If you want to make very snappy forms, you need to know some HTML (the forms look pretty good even without that).</li>
<li>It's completely web-based and controlled via a browser</li>
<li>The base system doesn't have scheduling/email, but you can purchase an add-on that has scheduling of jobs/emailing, etc. I believe they already have this if they are hosting it for you. Just not in the general release. In the general release, if you know a little PHP, you can add listeners to when tables are modified and do things like send emails (you add these from the front end).</li>
<li>The base product is meant for database administration, but there are add-ons for purchase. They have an app for purchase that gives you the ability to give control to other users (with a lot of permission settings of what they can/can't do so they can't break stuff). They also have a Publisher app that you can create a link that will allow forms/tables to be published to the open internet (for public data viewing/entering).</li>
<li>Coffee... They take requests from users, so if you have a feature request, you can contact them.</li>
</ul>

blocks|key|226043|text|信不信由你，尽管这些产品已于2009年12月18日停产，但最新版本的MySQL查询浏览器和MySQL管理器仍然可以完全免费下载。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|226044|嘿，我现在还在用呢。|226045|它只满足了几个需求|226046|226047|可免费使用(在小型企业中)|unordered-list-item|226048|可作为图形用户界面数据库前端|226049|自动(某种程度上)处理所有登录|226050|226051|226052|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|U|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|I|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|I|7|X|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|Q|$]]

Believe it or not, although the products went EOL December 18, 2009, the last versions of MySQL Query Browser and MySQL Administrator are still available for download totally for free. 

Hey, I still use them today.

It only fulfills a few needs

<ul>
<li>To be free to use (in a small business)</li>
<li>To be a GUI database front end</li>
<li>To deal with all the logins automatically (sort of)</li>
</ul>

<a href="http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-gui-tools-noinstall-5.0-r17-win32.zip/from/http://mirror.trouble-free.net/mysql_mirror/" rel="nofollow">Click here and get it while Oracle isn't looking ... QUICK !!!</a>

blocks|key|2880344|text|对于OP来说，这几乎满足了你所有的需求，包括Ajax，面向客户端，基于web的构建，不需要适当的编码，等等。除了它不煮咖啡，而且不是免费的，但它的一次性价格只有48美元，这不是一个破坏交易的因素：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2880345|PHP+MYSQL+Form+Maker+http://mysqlreports.com/|offset|length|2880346|entityMap|0|LINK|mutability|MUTABLE|url|http://mysqlreports.com/^0|0|L|O|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

To the OP, this meets almost all of your requirements, including Ajax, Client facing, web based build, no proper coding required, etc... except it does not make coffee, and is not free, but at only $48 one-time, it's not a deal breaker:

PHP MYSQL Form Maker
<a href="http://mysqlreports.com/" rel="nofollow">http://mysqlreports.com/</a>

blocks|key|226654|text|那呢？它在GPL许可下提供。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|226655|226656|+MySQL工作台为DBA和开发人员提供了一个集成的工具环境，用于：|blockquote|226657|226658|226659|SQL+Development|226660|Database+Administration|unordered-list-item|226661|
|226662|Database+|226663|226664|的迁移数据库设计和建模|226665|226666|​|226667|📷|atomic|226668|226669|它可以直接在视窗，Linux(Ubuntu，Rad+Hat+Enterprise，Fedora)和OS从Download页面！(请参阅源代码)。|226670|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/64ee65e128b3dfbeeb660a397079dd29.png|imageAlt|1|LINK|MUTABLE|url|http://dev.mysql.com/downloads/workbench/^0|5|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|1G|8|1|0^^$0|@$1|2|3|4|5|6|7|1K|8|@$9|1L|A|1M|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|1N|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|1O|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|1P|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|1R|8|@]|D|@]|E|$]]|$1|N|3|O|5|P|7|1S|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1T|8|@]|D|@]|E|$]]|$1|S|3|T|5|P|7|1U|8|@]|D|@]|E|$]]|$1|U|3|-4|5|P|7|1V|8|@]|D|@]|E|$]]|$1|V|3|W|5|6|7|1W|8|@]|D|@]|E|$]]|$1|X|3|-4|5|6|7|1X|8|@]|D|@]|E|$]]|$1|Y|3|Z|5|6|7|1Y|8|@]|D|@]|E|$]]|$1|10|3|11|5|12|7|1Z|8|@]|D|@$9|20|A|21|1|22]]|E|$]]|$1|13|3|Z|5|6|7|23|8|@]|D|@]|E|$]]|$1|14|3|15|5|6|7|24|8|@]|D|@$9|25|A|26|1|27]]|E|$]]|$1|16|3|-4|5|6|7|28|8|@]|D|@]|E|$]]]|17|$18|$5|19|1A|1B|E|$1C|1D|1E|-4]]|1F|$5|1G|1A|1H|E|$1I|1J]]]]

What about <a href="http://dev.mysql.com/doc/workbench/en/index.html" rel="nofollow noreferrer">MySQL Workbench</a>? It is provided under GPL License 

<blockquote>
 MySQL Workbench provides DBAs and developers an integrated tools
 environment for:
 
 <ul>
 <li>Database Design &amp; Modeling</li>
 <li>SQL Development</li>
 <li>Database Administration</li>
 <li>Database Migration</li>
 </ul>
</blockquote>

<img src="https://i.stack.imgur.com/7Mmax.png" alt="screen0">

It is directly available for Windows, Linux(Ubuntu, Rad Hat Enterprise, Fedora) &amp; OS X from <a href="http://dev.mysql.com/downloads/workbench/" rel="nofollow noreferrer">Download</a> page! (Source Code also).

blocks|key|226109|text|VFront是否值得一提？我自己还没有用过它，但正在寻找类似的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|226110|http://www.vfront.org/|offset|length|226111|以下是其网站的摘录：|226112|226113|VFront适用于使用MySQL或PostgreSQL的公司、品牌或组织，这些公司、品牌或组织需要自己的员工方便地咨询或修改对数据库的访问，而无需开发特定的客户端，而只需使用web浏览器。|unordered-list-item|226114|认为VFront是一种数据库接口工具，其某些功能类似于MS+access，但通过web.VFront进行轻松访问并不是像phpMyAdmin那样的数据库管理工具，它也不会取代它:界面是为处理数据的基本用户创建的。|226115|VFront是为能够使用直观的图形interface.|226116|VFront安全地处理数据的非专业用户创建的，在不同和/或多个用户必须使用不同的权限访问数据库时特别有用:高度可定制的组和权限系统使各种用户可以访问特定的表或视图，显示/隐藏特定的字段。设置输入验证规则并控制所有数据库activities.|226117|VFront具有导出数据模块，基于xml、xsl和xsl的统计和报告管理protocols.|226118|VFront对于那些通常需要一个易于安装和配置的数据库前端的人也很有用。|226119|226120|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|M|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@$D|15|E|16|1|17]]|A|$]]|$1|F|3|G|5|6|7|18|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|1A|8|@]|9|@]|A|$]]|$1|L|3|M|5|K|7|1B|8|@]|9|@]|A|$]]|$1|N|3|O|5|K|7|1C|8|@]|9|@]|A|$]]|$1|P|3|Q|5|K|7|1D|8|@]|9|@]|A|$]]|$1|R|3|S|5|K|7|1E|8|@]|9|@]|A|$]]|$1|T|3|U|5|K|7|1F|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|C]]]]

Would VFront worth a mention? I haven't used it myself but was looking for similar solutions: 

<a href="http://www.vfront.org/" rel="nofollow">http://www.vfront.org/</a>

Here's an excerpt from its website: 

<ul>
<li>VFront is useful for companies,brands or organizations, which use MySQL or PostgreSQL, in need of an easy consulting or modyfing access to database by their own employed whithout developing a specific client for that but simply using a web browser.</li>
<li>Think about VFront as an interface tool for database, similar for some functions to MS access, but taking the lead with an easy access via web.VFront is not a database administration tool like phpMyAdmin and it's not replacing it : interface is for basic user working on data.</li>
<li>VFront is created for non-expert users capable to work safely on data using an intuitive graphic interface.</li>
<li>VFront is particularly useful when various and/or several users have to access to database using different privileges: a highly customizable system of groups and privileges makes access possible for various employed to specific tables or views, shows/hides specific fields, sets rules for input validation and keeps under control all the database activities.</li>
<li>VFront has export data modules, statistics and report management based on xml, xsl and xsl-fo protocols.</li>
<li>VFront can be useful too for those who, generically, are in need of an easy to install and configure database front-end.</li>
</ul>

I have a slightly hopeless wish list for a piece of software, and I don't know if it exists. 

What it needs:

<ul>
<li>To be free to use (in a small business)</li>
<li>To run on a php server with a MySql database</li>
<li>To be a GUI database front end</li>
<li>To do more that CRUD. In particular I need to be able to create custom forms, and insert and delete multiple records from multiple tables in one action. This sort of process building is the main criteria I am looking for.</li>
<li>To have some ajax support so it looks good</li>
<li>To deal with all the logins automatically</li>
<li>To not require any proper programming. The whole project can be built in the browser</li>
<li>Hopefully have some advanced features like sending email, scheduled jobs, etc.</li>
<li>The end product has to be client-facing, so it can't be an administrator tool where someone who doesn't know what they are doing can break it</li>
<li>To make you a cup of coffee if you want one.</li>
</ul>

Can you tell me if it does exist?

GUI MySQL database frontend

我对一款软件有一个有点绝望的愿望清单，但我不知道它是否存在。它需要什么：可以免费使用(在小型企业中)，可以运行在php服务器上，带有MySql数据库可以作为图形用户界面数据库前端来做更多的CRUD。特别是，我需要能够创建自定义表单，并插入和删除多个表中的多个记录在一个行动。这种类型的过程建设是我正在寻找的主要标准。有一...

问GUI MySQL数据库前端
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问GUI MySQL数据库前端EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问GUI MySQL数据库前端
EN