Hi I am new to MySQL
I have installed MySQL on windows 200 swerver and installed MyODBC.
I created a db and added a user with the grant command and added
select,insert,delete,update privileges for the user.
mysql> show grants for www;
+---------------------------------------------------------------------------
+
| Grants for www@%
|
+---------------------------------------------------------------------------
+
| GRANT USAGE ON *.* TO 'www'@'%' IDENTIFIED BY PASSWORD '51d140c5511d64c5'
|
| GRANT ALL PRIVILEGES ON mycomax.* TO 'www'@'%'
|
+---------------------------------------------------------------------------
+
2 rows in set (0.00 sec)
mysql> show grants for www@'localhost';
+---------------------------------------------------------------------------
----
----+
| Grants for www@localhost
|
+---------------------------------------------------------------------------
----
----+
| GRANT USAGE ON *.* TO 'www'@'localhost' IDENTIFIED BY PASSWORD
'51d140c5511d64
c5' |
| GRANT ALL PRIVILEGES ON mycomax.* TO 'www'@'localhost'
|
+---------------------------------------------------------------------------
----
----+
2 rows in set (0.00 sec)
I have added a DSN for the DB.
Now when I try to connect to the db via ODBC it gives me access denied
***********************************************************
[TCX][MyODBC] Acces denied for user: 'www@localhost' to database Mycomax
***********************************************************
if i don't insert a username and password it works - this must be the
anonymous user.
What am I doing wrong here?
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
<a href="http://www.mycomax.com";>www.mycomax.com</a>
**********************************************************************
---------------------------------------------------------------------
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
