Error when trying to execute a Python program that uses MySQL

Question

I have a python program which makes use of MySQL database.
I am getting following error.
It would be very grateful if some one help me out a solution.

Traceback (most recent call last):
File "version2_1.py", line 105, in 
refine(wr,w)#function for replacement
File "version2_1.py", line 49, in refine
wrds=db_connect.database(word)
File "/home/anusha/db_connect.py", line 6, in database
db = MySQLdb.connect("localhost","root","localhost","anusha" )
File "/usr/lib/pymodules/python2.6/MySQLdb/_init_.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")

oops sorry, but I corrected that mistake and now I am getting the same error with this line db = MySQLdb.connect("localhost","root","anusha","anusha" ) — Anusha
– Anusha, Commented Apr 14, 2011 at 7:38

AJ. · Accepted Answer · 2011-04-09 17:49:57Z

2

You need to read about permissions and security within MySQL. Have a look at these links:

Overview: http://dev.mysql.com/doc/refman/5.1/en/privilege-system.html
Account administration: http://dev.mysql.com/doc/refman/5.1/en/account-management-sql.html

It could be that your user is not allowed to connect at all, or that it is only allowed certain types of queries. It could be that your remote host is not allowed to connect to the MySQL server. All of these considerations should be made when establishing grants for MySQL users.

answered Apr 9, 2011 at 17:49

AJ.

28.3k19 gold badges89 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Akhilraj N S · Accepted Answer · 2013-02-04 09:34:37Z

1

run this command in console

mysql> grant all privileges on *.* to 'user'@localhost identified by 'password' with grant option;

answered Feb 4, 2013 at 9:34

Akhilraj N S

9,5475 gold badges38 silver badges44 bronze badges

Comments

dave · Accepted Answer · 2011-04-09 17:40:21Z

0

Looks like you have an incorrect username/password for MySQL. Try creating a user in MySQL and use that to connect.

answered Apr 9, 2011 at 17:40

dave

12.9k10 gold badges45 silver badges60 bronze badges

Collectives™ on Stack Overflow

Error when trying to execute a Python program that uses MySQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related