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

[Nathan Eror]

It's a MySQL permission issue.  MySQL is very picky with user  
permissions.  You have to explicitly specify what host(s) a user is  
allowed to connect from.  Read section 5.5 in the user manual  
(http://www.mysql.com/documentation/mysql/bychapter/ 
manual_MySQL_Database_Administration.html#User_Account_Management).   
This issue caused some headaches for me as well.  Like, Rasjid said,  
I'd use the MySQL Control Center.  It's what helped me figure out this  
problem.

-Nathan

On Mar 24, 2004, at 5:20 AM, Rasjid Wilcox wrote:

> On Wednesday 24 March 2004 21:06, Duane Hennessy wrote:
>> Has anyone experienced this issue and do they know how to fix it? I
>> don't want to keep using the root userid.
>
> I've never used MySQL on Windows, only on Linux and there I'm  
> generally happy
> with the command line tools.  But on Windows I would suggest getting  
> the
> MySQL Control Center  
> (http://www.mysql.com/products/mysqlcc/index.html) and
> use it to add your new user.
>
> Cheers,
>
> Rasjid.
>
> -- 
> Rasjid Wilcox
> Canberra, Australia (UTC +11 hrs)
> http://www.openminddev.net
>
> _______________________________________________
> DB-SIG maillist  -  DB-SIG at python.org
> http://mail.python.org/mailman/listinfo/db-sig
>
>
-----
Nathan Eror - Celeritas
Mobile: 832.423.1973
Fax:    281.558.9551
http://www.celeritas-inc.com/