This is a permissions problem with mysql. It uses a couple of different things to authenticate a user. The user, the host and the password. Make sure you have root@(ipaddr) in the user table. That is not the same as root@localhost, or root@hostname. You can also have a user with a "%" as the host entry which will allow a user from any host to login. NOT RECOMMENDED FOR THE ROOT ACCOUNT. Regards, Drew -----Original Message----- From: Madziarczyk, Jonathan [mailto:than@cityofevanston.org] Sent: Monday, March 24, 2003 11:57 AM To: syslog-ng@lists.balabit.hu Subject: [syslog-ng]Syslog-ng and MySQL So I'm trying to log to a MySQL database with Syslog-ng. I followed the directions on "campin.net" and everything looks good. However when I try to look at the data, I get the message "[MySQL][ODBC 3.51 Driver] Access Denied for user: 'root@(IPAddr)' (Using password: YES). I'm using the odbc driver on a pc to look at the server. Is this a MySQL permissions problem or is there something else I should be looking at? If it is, what do I need to add to let this work? Thanks _______________________________________________ syslog-ng maillist - syslog-ng@lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng Frequently asked questions at http://www.campin.net/syslog-ng/faq.html