homepage Welcome to WebmasterWorld Guest from 54.227.11.45
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / WebmasterWorld / New To Web Development
Forum Library, Charter, Moderators: brotherhood of lan & mack

New To Web Development Forum

    
MySQL
Installing MySQL on Mac OS X
WGXD105 San Juan




msg:3397018
 2:11 pm on Jul 17, 2007 (gmt 0)

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




msg:3397036
 2:23 pm on Jul 17, 2007 (gmt 0)

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




msg:3397105
 3:12 pm on Jul 17, 2007 (gmt 0)

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




msg:3397188
 4:38 pm on Jul 17, 2007 (gmt 0)

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




msg:3397412
 8:05 pm on Jul 17, 2007 (gmt 0)

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




msg:3399528
 10:29 pm on Jul 19, 2007 (gmt 0)

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




msg:3399530
 10:30 pm on Jul 19, 2007 (gmt 0)

"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




msg:3399535
 10:36 pm on Jul 19, 2007 (gmt 0)

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?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / New To Web Development
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved