Installing New MySQL Admin

The new [URL=http://www.sitepoint.com/blog-post-view.php?id=151673]MySQL Administrator[/URL] is looking to be more robust and very enterprise friendly with its tools for managing multiple database servers, replication and disaster recovery tools. Getting this installed is pretty straightforward, however, remember, as MySQL is reminding everyone, that this is an alpha release and hence not intended for production environments. Please backup your data prior to installing on your machine.

Getting the binary download installed for Linux is very simple. Get the file from MySQL at this url –>
http://www.mysql.com/downloads/administrator.html and issue the following commands (recommendations from MySQL):

gzip -dc mysql-administrator-1.0.1a-alpha-linux.tar.gz | tar xv -C /opt

MySQL Administrator’s binary will be installed in /opt/mysql-administrator/bin,
from where you can execute ‘mysql-administrator’ to start the application.

The GUI is also available for Windows if you are administering your MySQL database servers from the Microsoft platform, and can be found on the same link above.

Finally, to build from source please follow these instructions from the MySQL FAQ included with the MySQL Administrator.

============================
From MySQL Administrator FAQ.txt
============================

Q: Which versions of Linux are supported by MySQL Administrator?

A: MySQL Administrator has been tested on:
– Debian unstable
– Fedora core 1
– SuSE 9

Most libraries, including Gtk+ are statically linked, except for the
following standard libraries:
glibc 2.3.2
libX11 6.2
libstdc++ 5.0.5

Q: What do I need to build MySQL Administrator?

A: Apart from the g++ development suite, you will need the following
libraries and corresponding development packages:

- gtk-2.x
– gtkmm-2.x
– libglade-2.x

Q: How can I build MySQL Administrator myself?

A: The following BitKeeper modules can be downloaded from
http://mysql.bkbits.net, using the BitKeeper version management system:

- mysqlxlibrary
– mysqladministratorlibrary
– mysqlcommonguiparts
– mysqladministrator

For each directory, execute the following commands:

sh autogen.sh
./configure
make
make install

If everything went well, you should have the mysql-administrator binary
built and installed in /usr/local/bin.

Free book: Jump Start HTML5 Basics

Grab a free copy of one our latest ebooks! Packed with hints and tips on HTML5's most powerful new features.

  • Shoan

    I am trying to install MysqlAdmin on my Gentoo box. I downloaded the binaries, but on executing it I get the following error:

    /opt/mysql-administrator/bin/mysql-administrator
    /opt/mysql-administrator/bin/mysql-administrator-bin: error while loading shared libraries: libsigc-1.2.so.5: cannot open shared object file: No such file or directory

    Would you know how to resolve it?

    Peace,
    Shoan.

  • http://www.practicalapplications.net bwarrene

    MySQL is stating they only bench tested the alpha release on Fedora 1 (Red Hat 9 plus some basically) which is why I probably did not get this error. A similar error was recently posted to the MySQL Admin list (http://lists.mysql.com/mysql/165175) with the same issue. This was on a SUSE 8 system.

    MySQL also notes that the Admin should end up in /usr/local/bin if built from source – so the source build may offer more success.

    You may want to try building from source also – see my original blog post above.

  • Scott

    I got this error after installing the stripped tgz distribution. Try again, but download the normal, now beta tgz.