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?
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.
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?