GUI for database management and jdbc

[axel_vogelsang]

I'm a new with mySQL and PHP but I've made the first steps with it on OSX and I've successfully installed everything. Now i want to control my databases with a GUI. I've donwloaded JaneSQL as well as DBVisualizer. What else is there around and what would you guys recommend. The other thing: DBVisualizer asks for the JDBC-driver of my database. What is this, do I need and where do I put it, after downloading it? Thanks for your help, Axel

[sao]

You can download from the following site a free JDBC Driver for MySQL:

http://mmmysql.sourceforge.net/

as explained about MM.MySQL in the above page:

<<I developed this driver in hopes of having a stable, full-featured JDBC driver for MySQL. I put it under the GNU LGPL to hopefully allow the MySQL developer community to add to the utility of the driver. >>

Also check the following page :

http://www.entropy.ch/software/MacOSx/mysql/

in the section "additional information".

Cheers...

[sao]

If you are looking for freeware, have you tried Webmin, current version 0.93:

http://www.webmin.com/

But,

<<Webmin is a web-based interface for system administration for Unix. Using any browser that supports tables and forms (and Java for the File Manager module), you can setup user accounts, Apache, DNS, file sharing and so on.

Webmin consists of a simple web server, and a number of CGI programs which directly update system files like /etc/inetd.conf and /etc/passwd. The web server and all CGI programs are written in Perl version 5, and use no non-standard Perl modules.>>

For Aqua GUI for MySQL , you can try SQL4X Manager - MySQL Edition *-* 2.0, (commercial)
check it out at:

http://www.versiontracker.com/moreinfo.fcgi?id=11421&db=mac

Cheers...

[bluehz]

I 2nd that vote for Webmin - not only will it let you admin MySQL but 100's of other *nix processes. I learned more about OS X in a week poking around with Webmin than 6 months of reading, etc.

[axel_vogelsang]

thanks a lot sao and bluehz for your help, but being an osx- and unix-newbie this isn't very easy at all for me: first of all i did not know which version to download. they don't tell you at webmin.com which version fits for os x. i then downloaded the tar.gz file, hoping it's the right one.

second: they tell me to put the unpacked file into the user/local folder. i do not have a user/local directory!?

third thing: they tell me to run the setup.sh. how do i do that? i open the terminal, go to the directory where setup.sh is in and then?...

to be honest i would need an "instruction for dummies" to install webmin. can you help me?

[bluehz]

Sure - take it easy and you'll make it. I am by no means a guru - but I learn as I go.

You do actually have a /usr/local/ directory it is just invisible. Here's what you want to do:

Open the terminal and type in:

open /usr/local

you should then see a window open up in the Finder, notice that it is your /usr/local dir. So see you really do have a /usr/local.

Ok - to take their instructions step by step. The first thing you want to do is copy the file you downloaded into your /usr/local directory. You d/l the proper one - it should end in "...tar.gz". There instructions use the command below to copy the file you downloaded into that dir.

cp webmin-0.93.tar.gz /usr/local

All this is saying is copy (cp) the file (webmin-0.9.3.tar.gz) into your /usr/local directory. Easy...ehhh... Since you already have the /usr/local window open though - you can simply do the old drag and drop Mac-style and move the webmin-0.9.3.tar/gz into your /usr/local. Got it.

Ok - now you have successfully move the archive into the proper location it is time to decompress it. The .tar and .gz are just unix forms of compression just like stuffit or zip compression. The first thing you want to do is change the terminal to point to the /usr/local directory since that is where you will be working. So type this into the terminal:

cd /usr/local

All that is saying is change directories (cd) to the /usr/local directory. Got it....now you are in the correct directory it is time to decompress. Type this into the terminal:

gunzip webmin-0.93.tar.gz

some stuff will probably fly by in the terminal and when it finishes you will then need to type this in:

tar xf webmin-0.93.tar

Ok - all decompressed and ready to start installing. If you look in your /usr/local window that is open in the Finder you should now see a new folder called "webmin-0.93". Now you need to switch the terminal so it is now pointing INSIDE that newly created folder. Type this in the terminal:

cd webmin-0.93

Ok - you are locked and loaded. Now for that setup.sh command. All you need to do is type this into your terminal:

sudo setup.sh

you will be asked for your OS X password and then the install process will begin. It will ask you some question that seem complicated - just choose the default answers. When it gets to the question about what system you are using it gives you a list of systems with numbers beside them. I can't remember the exact number - but I know there are two OS X's listed one in the left column and one directly across in the right column. You want to pick the one in the right column. You will get some more question - choose the default. At some point you wil be asked for a username and password to access webmin - WRITE THEM DOWN!

That's it - you are all installed. Point your browser to - http://localhost:10000 and you should see the webmin login - enter the username and password you entered in the setup and away you go.

It can be a bit intimidating at first when you get logged in - lots of info here. But thats actually a good thing - like I said I discovered more in poking around with Webmin than in 6 months of reading. In particular the MySQL stuff you want is located in the Servers section.

Hope that helps.

[xchanyazy]

It's possible that sudo setup.sh won't work for you - if so try giving it the full path: sudo /usr/local/webmin-0.93/setup.sh . This might just be caused by something else that's screwy on my computer, or it could be something wrong with tcsh, or the Terminal is just playing mean jokes on me.

[axel_vogelsang]

hey guys,
thanks a lot. the people on this forum are really amazing. haven't installed webmin yet, but i'll get at it soon. thanks a lot for your help!!!:)

[axel_vogelsang]

sorry guys, i'll bet you'll have a big laugh now, but i still managed to make some mistakes. in general the installation worked out but....

first of all i don't have access: the reason is, going through the setup process i always went for the default as told, so i also typed returns when asked for password and login. i thought it would then take my login that i use to access my user directory. the result is: I have a login page for the webmin server, but no valid login and password. is there any file where i can configure password and login. i went into several files like passwd or useradmin with the sudo pico, but there was no way to change it.

the second thing: i could not just put the whole tar.gz file into the usr/local folder. access was denied. i had to do it in the shell and i had to use the sudo command.

[ppmax]

once youve gotten mysql and php installed properly, id check out PHPMyAdmin. its a php based front end that allows you to create, drop, edit all your db's and tables. its awesome.

go to http://phpmyadmin.sourceforge.net/download.html

its a cakewalk to install and configure