Douglass,
Saturday, February 23, 2002, 9:02:05 AM, you wrote:
DP> I am brand new to MySQL, and trying to get up to speed as fast as possible.
DP> I have successfully installed both MySQL 3.23.47 and MyODBC 2.50.39. I am
DP> using VB6 and ADO in combination with MyODBC to connect to a database I have
DP> already created. However, I keep getting the following message:
DP> "[TCX][MyODBC]Access denied for user: 'IDSIUser@localhost' (Using password:
^^^^^^^^^^^
DP> YES)".
[skip]
DP> I created the User IDSIUser with the following command:
DP> GRANT ALL ON FECData.* TO IDSIUser@'%' INDENTIFIED BY 'excalibur'
^^^^^^
You created user for connection via TCP/IP ('%'), but you tried to
connect via Unix socket ('localhost') - because connecting to "localhost" is
done via Unix sockets..
DP> Can anyone possibly tell me what I have left out or what I am doing wrong,
DP> or just point me to some documentation that will help me sort out the
DP> problem?
Look at:
http://www.mysql.com/doc/G/R/GRANT.html
DP> Thanks for the help.
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
