I've used phpMyAdmin for a while now - it gets the job done but it is very clunky and outdated, and has many features that I don't need. I'm looking for either a web based or (preferably) an OS X native alternative that is easy to use and isn't heavy on features.
我已经使用了phpMyAdmin一段时间了 - 它完成了工作,但它非常笨重和过时,并且具有许多我不需要的功能。我正在寻找一个基于Web或(最好)OS X本机替代品,它易于使用且功能不重。
Is there any programs out there that fit the bill?
有没有适合该法案的程序?
8 个解决方案
#1
12
I think you will be very impressed with SQL Buddy. That is very similar to phpMyAdmin but with a vastly improved user interface! SQL Buddy is another web interface just like phpMyAdmin. Setup is simply providing a username and password... thats it!
我想你会对SQL Buddy印象深刻。这与phpMyAdmin非常相似,但用户界面大大改善了! SQL Buddy是另一个像phpMyAdmin一样的Web界面。安装程序只是提供用户名和密码......就是这样!
#2
7
The OS X port of mysql comes with a native mysql administration gui utility suite called the "MySQL Administrator" and "MySQL Query Browser"
mysql的OS X端口附带一个名为“MySQL Administrator”和“MySQL Query Browser”的本机mysql管理gui实用程序套件
http://www.mysql.com/products/tools/administrator/
http://www.mysql.com/products/tools/query-browser/
Additionally there is a dashboard widget you can install that will monitor the MySQL server performance. It's called MySQLHealth.
此外,还有一个可以安装的仪表板小部件,用于监控MySQL服务器的性能。它叫做MySQLHealth。
#3
7
For MySQL, CocoaMySQL is pretty good - it concentrates more on database usage rather than server administration.
对于MySQL,CocoaMySQL非常好 - 它更专注于数据库使用而不是服务器管理。
EDIT: It's now called Sequel Pro and is available at http://www.sequelpro.com/
编辑:它现在称为Sequel Pro,可在http://www.sequelpro.com/上找到
#4
2
MySQL itself has also released a number of tools. One of them is MySQL Administrator. You can also use this in combination with the MySQL Query Browser.
MySQL本身也发布了许多工具。其中一个是MySQL Administrator。您也可以将它与MySQL Query Browser结合使用。
These tools are all cross-platform
这些工具都是跨平台的
#5
1
I've used adminer before with some success. It's only a single php file, so very easy to throw on a server when you need it, and easy to remove when you are done, as well.
我之前使用过adminer取得了一些成功。它只是一个单独的php文件,因此在您需要时非常容易在服务器上投放,并且在您完成后也很容易删除。
#6
1
I use Sequel Pro on Mac Osx : http://www.sequelpro.com/
我在Mac Osx上使用Sequel Pro:http://www.sequelpro.com/
I can create database rapidly for development and export or import SQL data, copy one or multiple row and paste them on PhpMyAdmin on the production server. I can make SQL query and save them.
我可以快速创建数据库以进行开发和导出或导入SQL数据,复制一行或多行并将其粘贴到生产服务器上的PhpMyAdmin上。我可以进行SQL查询并保存它们。
I think it's a good option, it's a native osx application, i don't know the others solutions…
我认为这是一个不错的选择,它是一个原生的osx应用程序,我不知道其他解决方案......
#7
0
Another useful tool is "SQL Manager Lite for MySQL" from EMS(www.sqlmanager.net). They also have versions for other databases so if you land up using multiple databases (PostgreSQL, FirebirdSQL, MS SQL) this is one way to have a consistent user interface for each database system.
另一个有用的工具是来自EMS(www.sqlmanager.net)的“SQL Manager Lite for MySQL”。它们还有其他数据库的版本,所以如果你使用多个数据库(PostgreSQL,FirebirdSQL,MS SQL),这是为每个数据库系统提供一致用户界面的一种方法。
#8
0
try out SQL Yog also....its also light weight and pretty useful
尝试SQL Yog也....它也很轻,非常实用
#1
12
I think you will be very impressed with SQL Buddy. That is very similar to phpMyAdmin but with a vastly improved user interface! SQL Buddy is another web interface just like phpMyAdmin. Setup is simply providing a username and password... thats it!
我想你会对SQL Buddy印象深刻。这与phpMyAdmin非常相似,但用户界面大大改善了! SQL Buddy是另一个像phpMyAdmin一样的Web界面。安装程序只是提供用户名和密码......就是这样!
#2
7
The OS X port of mysql comes with a native mysql administration gui utility suite called the "MySQL Administrator" and "MySQL Query Browser"
mysql的OS X端口附带一个名为“MySQL Administrator”和“MySQL Query Browser”的本机mysql管理gui实用程序套件
http://www.mysql.com/products/tools/administrator/
http://www.mysql.com/products/tools/query-browser/
Additionally there is a dashboard widget you can install that will monitor the MySQL server performance. It's called MySQLHealth.
此外,还有一个可以安装的仪表板小部件,用于监控MySQL服务器的性能。它叫做MySQLHealth。
#3
7
For MySQL, CocoaMySQL is pretty good - it concentrates more on database usage rather than server administration.
对于MySQL,CocoaMySQL非常好 - 它更专注于数据库使用而不是服务器管理。
EDIT: It's now called Sequel Pro and is available at http://www.sequelpro.com/
编辑:它现在称为Sequel Pro,可在http://www.sequelpro.com/上找到
#4
2
MySQL itself has also released a number of tools. One of them is MySQL Administrator. You can also use this in combination with the MySQL Query Browser.
MySQL本身也发布了许多工具。其中一个是MySQL Administrator。您也可以将它与MySQL Query Browser结合使用。
These tools are all cross-platform
这些工具都是跨平台的
#5
1
I've used adminer before with some success. It's only a single php file, so very easy to throw on a server when you need it, and easy to remove when you are done, as well.
我之前使用过adminer取得了一些成功。它只是一个单独的php文件,因此在您需要时非常容易在服务器上投放,并且在您完成后也很容易删除。
#6
1
I use Sequel Pro on Mac Osx : http://www.sequelpro.com/
我在Mac Osx上使用Sequel Pro:http://www.sequelpro.com/
I can create database rapidly for development and export or import SQL data, copy one or multiple row and paste them on PhpMyAdmin on the production server. I can make SQL query and save them.
我可以快速创建数据库以进行开发和导出或导入SQL数据,复制一行或多行并将其粘贴到生产服务器上的PhpMyAdmin上。我可以进行SQL查询并保存它们。
I think it's a good option, it's a native osx application, i don't know the others solutions…
我认为这是一个不错的选择,它是一个原生的osx应用程序,我不知道其他解决方案......
#7
0
Another useful tool is "SQL Manager Lite for MySQL" from EMS(www.sqlmanager.net). They also have versions for other databases so if you land up using multiple databases (PostgreSQL, FirebirdSQL, MS SQL) this is one way to have a consistent user interface for each database system.
另一个有用的工具是来自EMS(www.sqlmanager.net)的“SQL Manager Lite for MySQL”。它们还有其他数据库的版本,所以如果你使用多个数据库(PostgreSQL,FirebirdSQL,MS SQL),这是为每个数据库系统提供一致用户界面的一种方法。
#8
0
try out SQL Yog also....its also light weight and pretty useful
尝试SQL Yog也....它也很轻,非常实用