[DB-SIG] Re: [Python-au] MySQLdb user login issue
can at optiver.com.au
Wed Mar 24 17:00:03 EST 2004
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:
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
> 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.
More information about the DB-SIG