Loren
Firstly thanks heaps for your reply. I will try and be as specific as possible to not waste your time.
If indeed the connection is defaulting to the user ODBC and it is set in one of the my.* files, where can I see this? Fix this?
You could try putting these lines in C:\my.cnf:
[client] user=user_name
I should go back a bit and mention that as I was working through my book, the first hurdle I encountered was setting up the initial grant tables. When I typed c:\mysql\scripts\mysql_install_db I got the error message:
'mysql_intall_db' is not recognized as an internal or external command, operable program or batch file.
I uninstalled mysql, resintalled and still got the same message.
I gather this should have worked?
No. mysql_install_db is for Unix installations. It's not needed for Windows, because the data directory (including the mysql and test databases) comes preinitialized with Windows distributions.
I did this by opening 'run' from the start bar, typing in cmd to open the command line, cd \ to change to the root directory, cd mysql to change to the mysql folder, cd scripts to change to the scripts folder and then mysql_install_db to run this. No luck.
Yours Sincerely
Philip McCarthy Australia
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
