WP MySQL Console

WP MySQL Console is a web shell to operate databases such as mysql command shell for developers. Its most original way to operate DBs, you should try.

Author:Özgür Koca (profile at wordpress.org)
WordPress version required:3.1
WordPress version tested:3.2.1
Plugin version:0.2
Added to WordPress repository:04-09-2011
Last updated:04-09-2011
Warning! This plugin has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.
Rating, %:0
Rated by:0
Plugin URI:http://www.tankado.com/wp-mysql-console/
Total downloads:10 260
Active installs:100+
plugin download
Click to start download

WP MySQL Console (WPMC) is a web based MySQL command shell. WPMC aims to be a web shell has same functionalites of real MySQL Shell. Integrating of WPMC to any web application such as WP is very easy because dont need any firewall construction. Its completly http based. I ported WPMC from phpMySQLConsole.

WPMC consist of 2 important part, javascript console and PHP command interpreter. Javascript console provide a MySQL command prompt for user to type their commands with some usefull functionalities such as *nix like select-copy and command history which can be used arrow keys. Then other important part is PHP command interpeter run on server side. This is a PHP script run on PHP and MySQL supported server. The script interperets commands which coming from javascript console via XMLHttp request and print out results to javascript console via XMLHttp.

Benefits

  • Dont require shell account on server.
  • Not any construction on firewall configuration to cause posible security weakness.
  • It is platform independent.
  • It can operate on all operation systems and web browsers that support javascript.

Features

  • Support for all posible SQL query sentences.
  • Fastest command interaction with server. Thanks to AJAX.
  • Auto select&copy function similar to behaviour of *nix terminal window.
  • Command history. Remembers previously entered commands (use up/down arrow keys).

In the Future

  • Its usefull for dump and load operations on large databases. (in next release)
  • Detailed help for console commands (type help command)
  • Full customizable interface with CSS support.
  • Allows to log commands to text file.

Keywords: phpMySQLConsole, WP MySQL Console, MySQL Console

More can be read on the phpMySQLConsole also write any issue as comment from there.

Check out my other plugins: