MySQL

Installing MySQL on Mac OS X

[WGXD105 San Juan]

Hi, Everyone. I'm trying to install MySql on a PowerPC G5 running Mac OS X 10.4. The problem is every time I have installed it (which has been a few times already) the directory or the server does not show up under the command line. In fact I don't even know where that directory. Does anybody know what or where this /usr/local/mysql/bin directory might be?
I keep checking user account folder which is inside the user folder but there seems to be no mysql.

I am looking for a way to verify if the files are actually there. I made a search on my HD but I could not find any of the files. Also if anyone could tell me what would be a good location to change those files to and save them as well when I re-install.

Thanks

[nobody]

I don't know the direct answer to your problem, but I've used MAMP to install MySQL (and Apache/Php) in one.

[mamp.info...]

Will install into /Applications/MAMP (by default). You'll also get phpmyadmin installed to administer the database.

[WGXD105 San Juan]

Thanks but my Mac already has Apache installed. Anyways, I just figured out how to log into MySQL so I know that it's also installed. I'm trying to use CocoaMySQL for administering my databases through a GUI but I have no idea on how to connect the database to it.

It's asking me for all sorts of things:
Host - I don't know what to write here.
User - I'm guessing this is the user account
Database - database name?
Password - database access password?
Socket - I don't even know what this means
Port - I'm guessing this would be port 8080?

Also what's SSH tunnel?

[nobody]

OS X comes with Apache and MySQL as default, but getting them to play together can be a PITA, hence the MAMP suggestion.

Host - I don't know what to write here.

localhost

User - I'm guessing this is the user account

yes - probably your administrator account.

Database - database name?

yup, although you can probably leave it blank

Password - database access password?

yup - probably your administrator account password.

Socket - I don't even know what this means.

You can probably leave this blank (3306 is the default port for MySQL to be listening on). If you don't know what a socket is, again, I'll point you in the direction of MAMP, it'll just make your life easier.

[WGXD105 San Juan]

I will give it a shot. Thanx a lot, by the way.

Also do I need to uninstall my already installed versions of Apache and MySQL before I do MAMP thing? Or can I just go ahead and install everything on top of everything?

[jshen]

if you installed it from mysql.com it's probably in /usr/local/mysql

On the command line you can run this command to see it:
$ ls /usr/local

If you see mysql in there then you have it. The finder hides of bunch of the unfriendly unixy folders so you won't see it in hte finder by default.

The installer also comes with a thing for the system preferences. That will let you start in stop it from there instead of the command line (I use the command line myself).

I wouldn't move the files or reinstall. Let me know what you are trying to do and I can help you out. I'd suggest learning more about the command line, it'll make everything much easier.

[jshen]

"Also do I need to uninstall my already installed versions of Apache and MySQL before I do MAMP thing? Or can I just go ahead and install everything on top of everything? "

I wouldn't do that yet. See if you can get it working from the install you already did. Having two different versions and locations of mysql can cause many many headaches.

[jshen]

I should read all the comments before I respond :) I use cocoamysql everyday so I can help you out with that as well.

Before we get to cocoamysql there is something important. Mysql has only one user (root) after you install. By default it doesn't have a password. You should really really set a password for root. Do it like this.

$ /usr/local/mysql/bin/mysqladmin -u root password 'new-password'

replace new-password with whatever you want your password to be. Now you are ready to use cocoamysql

Host - localhost
User - root
Password - whatever you used

The following are optional. LEAVE THEM BLANK.
Database - database name?
Password - database access password?
Socket - I don't even know what this means
Port - I'm guessing this would be port 8080?