Some development with the initial problem.
I have two OS X OS's running 10.2.6
My main one I installed the mySQL on and am having trouble with is still not working.
As a test I installed mySQL on my second on and went through the configuration straight after installation. Everything this time worked I could run it set the password, etc. I went into mysql and tried setting the following as described in Larry Ullman's book:
CREATE DATABASE alpacas; (this worked fine)
CREATE DATABASE movies; (this worked fine)
Then the book says to create a new user with the following:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX, FILE ON alpacas.* TO <user_name>@localhost IDENTIFIED BY '<password>';
(this then stated that the wrong syntax was being used, ?)
Even though: GRANT SELECT ON alpacas.* TO webuser@'%' IDENTIFIED BY 'BroWs1ng';
worked fine. So I seem to have two problems.
1) Even though I deleted all the obvious files for mysql on the original system, it is still recognising the original install and not giving my access. How can I clear all the install, and/or delete the server that is using the sock? The only other option I can think of is reinstalling my entire os and starting again, as any re-install of mysql has the same result.)
2) I have looked at the manual for mysql and the syntax that Larry Ullman gives seems to be correct, so why doesn't the grant command above work, do I need to append it with the -uroot -p command so what?
Yours (close and frustrated)
Rob Rob Snow "Space may be the final frontier But its made in a Hollywood basement" RHCP 'Californiacation - Californiacation 1999'
[EMAIL PROTECTED] http://homepage.mac.com/robsnow
