[DB-SIG] Re: [Python-au] MySQLdb user login issue

Christopher Nilsson can at optiver.com.au
Wed Mar 24 17:00:03 EST 2004

Hi Duane,

This is a matter of MySQL permissions, not really python's or windows' 
fault. :)  You need to tell mysql where they're allowed to login from, 
in addition to the normal user id + password.  I won't go into it any 
further here, but you might want to have a look at:


~ Chris.

Duane Hennessy wrote:

> I'm using MySQLdb module to access MySQL 5.0 on Windows. I'm accessing 
> via the "root" user ID. I set the .INI file with
> user=duane
> passwd = hello
> but I cannot logon to MySQL with these properties instead I get a 
> message saying something along the lines of  "No permission for 
> ''@'localhost'" etc. So I can only logon as "root". I'm trying to 
> create a user through SQL and so far I am having little success with 
> that also. I'm following the manual that comes with MySQL. This is a 
> real pain!
> Has anyone experienced this issue and do they know how to fix it? I 
> don't want to keep using the root userid.
> Thanks,

More information about the DB-SIG mailing list