Hi Philip,

> then mysqladmin -u root -p create sample_db

This is probably the best way to go, the password you created will
most likely be for the root user.

>>mysqladmin: connect to server at 'local host' failed
>>error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'

>>Does it appear that I need to install an ODBC driver?

It's telling you that it cannot log you on as user "ODBC" with a
password.

As Daniel wrote, you can use
   mysql -u root -p
to specify root user, or create a ODBC user, which will allow you to
log in without specifying the user.

Personally, I've created a ODBC user with root privileges on my
windows dev server, so that I do not "confuse myself" when switching
from my unix shell to my windows command prompt.

Hope this explains why the error occurred.

Ben


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

Reply via email to