Home | About Chris Hope | Contact Chris Hope | Search:

MySQL Control Center - Installing on Linux

Posted December 10th, 2003 (Updated August 19th, 2004)

The MySQL Control Center can be downloaded from the MySQL website in either binary or source form. Thinking it would be easier to use the precompiled binary form, I downloaded that but also downloaded the source version just in case; I generally compile all my own software but figured it would be faster to just use the binary version and hey, I could always compile it myself if it didn't work.

And it didn't work.

Sure it ran and I was able to set up the server information, but I kept getting segmentation faults. I wasn't really expecting that it would run but it was worth a try. And that's the downside of using Linux sometimes; a lot of things don't work easily! (But despite some issues, I still much prefer using Linux/KDE over Windows).

So it was down to a source install. Source installs don't really bother me too much and I generally prefer to do it this way. I just have a lot of experience with MySQL and expected the compile to take a while and was impatient, wanting to try out this new tool. Anyway, it was just a matter of extracting the source files from the compressed archive, running "configure" and "make" (and yes, it did take a while to compile). "make install" surprisingly didn't work as it doesn't seem to have been set up yet (this is a beta release, after all) so you can either run it from the location you compiled it at, or copy the relevant files over to where you want them.

If you have mysql installed in an odd location (like me) then you'll need to set the configure options appropriately so it knows where to find the MySQL include and library files, for example:

./configure \
--with-mysql-lib=/opt/mysql/lib/mysql \
--with-mysql-include=/opt/mysql/include/mysql

After running configure (and assuming you didn't have any errors) all you need to do now is run make and then copy the binary to somewhere in your path (in my case /usr/local/bin - need to be logged in as root to copy it there):

make
cp mysqlcc /usr/local/bin

You need to have the QT libraries 3.0.5 and MySQL 4.0.3 or higher installed to do a source install. Since I already had both of these installed it wasn't a problem. Hopefully it won't be for you either, or the binary version worked :)

The install text file from the source distribution is on the next page, if you want to check that out before downloading the files. This installation file is accurate as at version 0.9.3 of the MySQL Control Center.

Note that there's no separate page in this article for a Windows install because it's a no-brainer. Download the installer, extract the files, run the installer and follow the instructions. You're then good to go! The application works the same on Windows as it done on Linux and Unix.

Please note that MySQL have ceased development work on the MySQL Control Center to concentrate on development of the MySQL Administrator and MySQL Query Browser. I will create a review of these products at some point in the coming weeks.

Comments

blog comments powered by Disqus