Page 1 of 1

mysql newbie, mac related

Posted: Tue Aug 03, 2004 11:39 am
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, :?:

Posted: Tue Aug 03, 2004 12:41 pm
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.

Posted: Wed Aug 04, 2004 8:00 pm
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,