-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi SanTa,
I think i may have an idea, have just tested this on my server. Granting
'USAGE' on all databases allows my 'testuser' account to connect to the
server through the mysql cli.
HOWEVER, if i try and issue a 'USE {database}' command I get access
denied because the user has only 'USAGE' privileges on all databases.
Since MyODBC connects to a single database, it would get an access denied
error with the USAGE priv.
issuing a 'GRANT SELECT ON *.* TO testuser@'%' IDENTIFIED BY "password"'
allows access for that user and my testuser can use any database.
danny
Sándor Tamás wrote:
| Sure I have. In fact if I use 'Grant', I don't have to 'flush'. But I've
| done it too. It didn't help.
|
| SanTa
|
| ----- Original Message -----
| From: "Danny Haworth" <[EMAIL PROTECTED]>
| To: <[EMAIL PROTECTED]>
| Sent: Tuesday, September 24, 2002 12:56 PM
| Subject: Re: Access denied in MyODBC
|
|
|
|>-----BEGIN PGP SIGNED MESSAGE-----
|>Hash: SHA1
|>
|>Have you issues a 'FLUSH PRIVILEGES' to reload the privilege tables and
|>pick up on the new grants?
|>
|>danny
|>
|>Sándor Tamás wrote:
|>| I gave privileges with NetUser@'%'. But I still can't connect.
|>| And through mysql command line I can connect, but with MyODBC, I can't.
|>|
|>| SanTa
|>|
|>| ----- Original Message -----
|>| From: "Bryan" <[EMAIL PROTECTED]>
|>| To: "'Sándor Tamás'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
|>| Sent: Tuesday, September 24, 2002 11:21 AM
|>| Subject: RE: Access denied in MyODBC
|>|
|>|
|>| Did you give netuser privileges for an i.p address (netuser@ip address
|>| or netuser@%(anywhere), if not then then Netuser probably only can
|>| connect as a localhost.
|>|
|>| -=Bryan=-
|>|
|>|
|>|
|>| -----Original Message-----
|>| From: Sándor Tamás [mailto:[EMAIL PROTECTED]]
|>| Sent: Tuesday, September 24, 2002 12:59 AM
|>| To: [EMAIL PROTECTED]
|>| Subject: Access denied in MyODBC
|>|
|>|
|>| Hi,
|>|
|>| I have a problem. I created a user called NetUser, and gave only usage
|>| privilege on all databases. I can connect through mysql command line,
|>| but I can't with ODBC. Is there anybody who know why it is? I need to
|>| know this to higher the security of my tables.
|>|
|>| Thanks,
|>| SanTa
|>|
|>|
|>|
|>|
|>|
|>| ---------------------------------------------------------------------
|>| Please check "http://www.mysql.com/Manual_chapter/manual_toc.html";
|
| before
|
|>| posting. To request this thread, e-mail
|
| [EMAIL PROTECTED]
|
|>|
|>| To unsubscribe, send a message to the address shown in the
|>| List-Unsubscribe header of this message. If you cannot see it,
|>| e-mail [EMAIL PROTECTED] instead.
|>|
|>|
|>
|>
|>
|>- --
|>
|>Danny Haworth
|>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
|>Ge2 System Administrator
|>Gas~Elec Safety Systems
|>Tel : 01895 422 997
|>Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED])
|>-----BEGIN PGP SIGNATURE-----
|>Version: GnuPG v1.0.7 (GNU/Linux)
|>Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
|>
|>iD8DBQE9kETfUKf+497XC3QRApHIAJ9iVnPPiydiqnkSPPEkAE3ggiwgzACfRbOY
|>ACADl+ztMq7Zbrvua5eE1UA=
|>=+I9q
|>-----END PGP SIGNATURE-----
|>
|>
|>---------------------------------------------------------------------
|>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
|>posting. To request this thread, e-mail [EMAIL PROTECTED]
|>
|>To unsubscribe, send a message to the address shown in the
|>List-Unsubscribe header of this message. If you cannot see it,
|>e-mail [EMAIL PROTECTED] instead.
|>
|>
|
|
|
| ---------------------------------------------------------------------
| Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
| posting. To request this thread, e-mail [EMAIL PROTECTED]
|
| To unsubscribe, send a message to the address shown in the
| List-Unsubscribe header of this message. If you cannot see it,
| e-mail [EMAIL PROTECTED] instead.
|
|
- --
Danny Haworth
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Ge2 System Administrator
Gas~Elec Safety Systems
Tel : 01895 422 997
Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED])
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE9kIwBUKf+497XC3QRApkpAJ9vJkTYspL1yddhRO6KE3njqONGggCggrKz
vqW5iDWmuxFXeIuqiirvPCo=
=cAYh
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
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
