Nicer MySQL administration with SQL Buddy

I hate using PHPMyAdmin to adminstrate MySQL databases. It looks ugly, it’s unintuitive and simply not user friendly. And still it was still the tool I used to do this very task. I thought there was no good alternative. SQL Buddy seems to offer just that. A nicer way of administrating your MySQL databases.

SQL Buddy is AJAX enabled and refreshes only the portion of the page that needs it. This alone makes for some reduced loading times. However it does play nice with bookmarks and the back button (in the same way that GMail does). When browsing your data you can resize the table columns and sort the data on the fly. One other thing I really like is that it allows you to hardcode your MySQL password in the config file. This shouldn’t be used in a production environment ofcourse, but it’s pretty nice when you’re on your local testing machine. It also doesn’t log out after 15 minutes of inactivity like PHPMyAdmin does.

I’m sure there are some features that PHPMyAdmin has and SQL Buddy doesn’t. But still, it can’t hurt to try it out and you can always run the two side by side ofcourse!

3 thoughts on “Nicer MySQL administration with SQL Buddy

  1. I also like SQL Buddy! I used to use phpMyAdmin on my shared hosting just because it was default until I found SQL Buddy. I really adore it for its cute UI. But one difference is that I use SQL Buddy with CUBRID Database now. Recently SQL Buddy was adopted by the CUBRID Database (http://www.cubrid.org/about_cubrid_web_query) as well. I think it says a lot about trust to SQL Buddy. CUBRID modified SQL Buddy to work with its database and called it CUBRID WebQuery. There is no difference at all in code, as I checked, except for the SQL statements and php funciton calls optimized for CUBRID. So, overall, I am quite satisfied with SQL Buddy’s instant work.

  2. how to use sqlbuddy ?
    i have installed wamp server and sqlbuddy is asking for password.
    please tell what to enter there.
    thanks in advance

    1. Hi Ankur,

      It depends on what you have set as MySQL username and password but I believe that usually for wamp the username is root and there is no password (just leave it blank). If you’ve used phpmyadmin in the past, the username and password are the same. They don’t depend on the tool you use to manage MySQL.

      – Walter

Leave a Reply

Your email address will not be published. Required fields are marked *