[Python-au] Re: python-au Digest, Vol 9, Issue 1

peter renshaw goonmail at netspace.net.au
Thu Mar 25 00:25:31 CET 2004


python-au-request at python.net wrote:

>Send python-au mailing list submissions to
>	python-au at starship.python.net
>
>To subscribe or unsubscribe via the World Wide Web, visit
>	http://starship.python.net/mailman/listinfo/python-au
>or, via email, send a message with subject or body 'help' to
>	python-au-request at starship.python.net
>
>You can reach the person managing the list at
>	python-au-owner at starship.python.net
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of python-au digest..."
>
>
>Today's Topics:
>
>   1. MySQLdb user login issue (Duane Hennessy)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Wed, 24 Mar 2004 20:06:52 +1000
>From: Duane Hennessy <duaneh at connexus.net.au>
>Subject: [Python-au] MySQLdb user login issue
>To: db-sig at python.org, Python Group <python-au at python.net>
>Message-ID: <40615DBC.9010800 at connexus.net.au>
>Content-Type: text/plain; charset="iso-8859-1"
>
>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
>
>  
>
Hi Duane,
    not exactly a *python problem* (probably get a better response on 
MySql Windows forum)  but here's 2 cents worth....

>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!
>
>  
>
looks like a privileges/grant problem. Have you read the manual on 
*default privileges* and *securing initial
MySql  account* ?

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Privilege_system
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Default_privileges

>Has anyone experienced this issue and do they know how to fix it? I 
>don't want to keep using the root userid.
>
>Thanks,
>  
>
Regs PR




More information about the python-au mailing list