One feature alone make this an oustanding plugin. There is an option to rename your database prefix. I just used the default one when i installed Joomla, this is a bad thing. It leaves you more oopen to SQL Injection attacks. This is because hackers will know what the joomla default table prefix is.

This plugin stop me having to do this the old fashioned way.

thanks

Very good extension for quick and easy manipulation of tables, e.g. prices in VirtueMart. Also complex queries can be executed.

One drawback is deletion of HTML's code. This leads to deletion of hyperlinks in column defined as 'mediumtext'.

This may a an omission in the extension unless i'm doing something wrong !

I too was a bit skittish with everything being in Russian on the home page, but this is an excellent tool.

My only gripe is the default semi-colon delimiter instead of using a comma for CSV's, but that's easily fixed (see the earlier reviews on changing the variable for that).

Thanks!

Must have!
You can add a hundred articles with this script!

Fantastic component.
Is it possible to use comma (,) instead of semicolon as separator?

This is a great little component for simple management of the mysql database. It got me out of a tricky little spot on a site where I don't have access to myPHPAdmin and I didn't want to go through the hassle of setting it up myself.

Beautiful!

Allows me to give clients and staff access to their database tables without giving them control panel access to my servers.

We sell Support to our users for each of our components, and oftentimes this involves logging into the user's website and modifying tables on their database. EasySQL has made that process as simple as asking the user for Super Admin access. Bravo for such a wonderful tool.

A very handy tool, especially when providing support to clients - you only have to ask for access to Joomla administrator, without needing separate database access. Nowhere near as powerful or complex as phpMyAdmin, but the essential features are there and it is dead easy to use.

This has been the single most useful extension I've installed on my site.

Whenever I'm developing, it's painful for me to maintain a phpMyAdmin page open alongside an admin page...it just IS...especially when you're running 2 different admin panels for 2 sites on the same database.

With this extension, I can query all the tables in the database across both sites - I can manually execute queries as well - to insert items, alter tables, etc.

On top of that, I'm sometimes behind a firewall that blocks port 8585 (which is what my phpMyAdmin runs out of on my web server) - so I don't get access to phpMyAdmin (painful, yes)...

With this extension, I don't need to. I can run everything simply and efficiently, all from the comfort of my Joomla! Admin console.

This component works fine but i need to change a line to make CSV export compatible with queries using quotes.

In administrator\components\com_easysql\admin.easysql.php
I change
$sql = mosGetParam( $_POST, 'easysql_query', null );

to

$sql = stripslashes(mosGetParam( $_POST, 'easysql_query', null ));

I this tool is really easy to install and use. I had trouble with data fields that content lists with returns in them like:

path=1
user=3
cont=4

and so on. The "to CSV" button did not use a text delimiter to contain field data like this. So I modified line 125 in admin.easysql.php to read:

$csv_values .= '"'.$val.'"'.$comma;

it was:

$csv_values .= $val.$comma;

Great Component.

I needed some way besides phpMyAdmin to load records into jos_content.

I was hoping this would be it, but it inserts every record twice.

Its OK for SELECT queries though

Why i cann't install it on J1.5 stable?
It says to me that i must enable the System - Legacy Plugin in the Plugin Manager but you said that you didn't have any problem?

Installed on J1.5 stable without a hitch. Works as advertised so far. Would love to see CREATE TABLE supported.

[I found that I could create tables by entering the full command in the free text area. It gives an error message but the tables were created exactly as specified. I don't recommend it but it worked for me.]

this component is so great as it's simple :)
Whenever you have some problem with other components/modules or whatever it is great help for debuging

I'm serious, this component is a lifesaver!! I've been needing to delete the tables from fireboard to do a clean install. Without phpmyadmin or any clue how to query a sql database, this program did it.

There is a dropdown list which doesn't list the command "drop", but it works fine if you throw the command into the blank window and hit execute.

Thanks for putting this together :)

This component is very simple, and surely could be expanded with other features, for example view / edit / create table structure, but it's a valid and useful alternative for sysadmin if phpMyAdmin is not available, to have a basic control of records. In fact, with this extension you can easily list, edit, delete and create records; in addiction there are also some useful queries like "SHOW STATUS" and "SHOW CREATE TABLE".

To use at best this extension, you should have a minimum SQL knowledge.

When I first checked this out and went to the home page and discovered it was Russian I thought bugger. Downloaded the component and unzipped and there was no help documentation either, again thought bugger. However, ever adventurous I uploaded it to my test site and it could not be easier. 95% of all the mysql functions have been predefined and you can very simply right your own query and see the results and then click a button and they are exported to a csv. Magic component.It is not quite as powerful as phpmyadmin but comes close.

Just 10 minutes after this tool comes up in the New Extensions category and here I go! Just what I was looking for! A _simple_ way to query SQL tables and get results displayed. I'll rate it after some serious testing. KRUTO!!!