I have discovered that to make the command '/usr/local/bin/mysql' or '/usr/local/bin/mysql -u root' do something "start MySQL" that MySQL should not be running or nothing will happen so the problem before must have been that it was up and running.
I took a look at the link
http://www.mysql.org but see that it is for OSX prior to Jaguar, I am only learning at this so who am I to know but I read and followed instructions from:
http://www.entropy.ch/software/macosx/mysql/ where it states two different types of installers for OSX and Jaguar, also a slightly different way of setting each up, for example there is no need to set up a user "on your computer" with Jaguar as you must do for OSX 10.1, after the installer has been run and a couple of commands have been entered they tell the user to type in the following:
mysqladmin -u root password new_password_here
which I did as instructed on the install and nothing happened (I don't know if anything was meant to happen?) anyway I have just tried starting MySQL with:
/usr/local/bin/mysql -u root password 'a_new_password'
and termial sprung to life as never before with:
./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc)
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Usage: ./bin/mysql [OPTIONS] [database]
[SHORTCUTS]
Default options are read from the following files in the given order:
/etc/my.cnf /usr/local/mysql/data/my.cnf ~/.my.cnf
The following groups are read: mysql client
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
--defaults-file=# Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read
Possible variables for option --set-variable (-O) are:
connect_timeout current value: 0
max_allowed_packet current value: 16777216
net_buffer_length current value: 16384
select_limit current value: 1000
max_join_size current value: 1000000
now I have discovered with a bit of trial and error that I must open a database which it seems I have just done by entering:
/usr/local/bin/mysql test_holding;
(a database I created earlier) then I entered the same line from before:
LOAD DATA INFILE "/Users/user/Linux_sales.sql" INTO TABLE linux_sales;
and again got the error:
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
Is there any way of getting a list of passwords or users from MySQL when using on localhost?
Mike