mysql newbie, mac related

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jrough
Forum Newbie
Posts: 14
Joined: Thu Jun 10, 2004 5:17 pm

mysql newbie, mac related

Post by jrough »

I want to learn mysql. i have installed mysql client on my Mac. in the terminal window I have a mysql process running but I don't know how to shut it down or access it. I want to try out select queries. do you need to have a server? I downloaded the world.sql database. I'm reading the manual tutorial but it seems like you need a server. for example it says you have to connect to the server to load the
I type mysql -u root -p and it says "mysql command not found". I want to issue the SOURCE world.sql command or show tables etc. Do I need access to a server or can I use the local mysql client? and if I can use the mysql client how do I access it?

thankx, :?:
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

Post by kettle_drum »

Try issuing the command './mysql' from the folder where it is install as it wot be linked in the bin directory and so no globably known in other directories.

You could also install a front end to mysql so you dont have to keep playing in the consol. Try using phpMyAdmin or something similar - check out http://www.versiontracker.com for a list of gui sql managers.
jrough
Forum Newbie
Posts: 14
Joined: Thu Jun 10, 2004 5:17 pm

Post by jrough »

I did the command ./mysql inside the mysql folder. Does that mean it didn't get installed properly? I installed the version from MySQL for the MacOS X.2.8. I just installed it from the install package icon.

In the directory above where I am trying this the folder is named mysql. Inside this folder there is a INSTALL-BINARY file, a lib directory and a configure file.

One thing is different I didn't notice before. In the same directory of the mysql folder it says:
mysql-standard-4.0.20-apple-darwin6.8-powerpc
It doesn't seem to be a file or a directory. Was that written to the directory when mysql was installed?

thankx,
Post Reply