MySQL permissions

[liquidswords]

Hi, Im new 2 MySQL, my problem is that im trying 2 export data from Access 2 MySQL via a MyODBC link, the only problem is that it wont let me, it says 'Access denied for user(#1045)'. I have looked everywhere i can think of 2 set the permissions to MySQL but i cannot find them newhere, please could sum1 help me!!

 

[Guest_imported]

Check out

http://www.mysql.com

They have online documentation and chapter 6 covers permissions. 1. Must have user set up to allow access to DB. 2. Must grant correct permission for the user to make changes (can specify table by user). You didn't mention the platform you are working on. If in Linux, if you use WEBMIN the permissions are easier to manipulate.