
September 13th, 2000, 04:36 PM
|
|
Junior Member
|
|
Join Date: Sep 2000
Location: Madagascar
Posts: 9
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Your problem is clearly not about MyOdbc but about configuring privileges in MySql. In this very site is a link that have helped us set up correct access : http://www.devshed.com/Server_Side/...Administration/ by By W.J. Gilmore, March 30, 1999.
It explains to you that you should get through three hierarchical steps to gain access to your MySql database : 1) set host privileges 2) set then user privileges 3) and finally set db privileges.
It's been quite a time since I haven't touched MySql, but the hint is trying to be most permissive until you gain access via MyOdbc, then fine tuning only after that.
Hope this helps.
Note : I have never found a clear documentation on MyOdbc troubleshooting. It seems as if the privileges aspect is deliberately neglected...
Ihari
|