CODEWITHSUNDEEP
pythonmysql
Jose Ramon
Jose Ramon

Reputation: 5444

Mysql OperationalError 1044, connect to mysql database

f_dbI am trying to connect to mysql database using a python script. My code to do so is the following: 

 `db = MySQLdb.connect(host="xxx.xx.xx.xx", # your host, usually localhost
                 port = xxxx,
                 user="chrathan", # your username
                 passwd="...", # your password
                 db="f_db") # name of the data base`

I ve open the database from mysql workbench. However, I am not able to open it from python I am getting the following error: 

_mysql_exceptions.OperationalError: (1044, "Access denied for user 'chrathan'@'%' to database 'f_db'"). Basically I am receiving `Traceback (most recent call last):
 File "D:\_WORKSPACE\mysql\fashion_db.py", line 7, in <module>
db = 'f_db') mysql_exceptions.OperationalError: (1044, "Access denied for user 'chrathan'@'%' to database 'f_db'")`

Upvotes: 0

Views: 10850

Answers (2)

user10773580
user10773580

Reputation: 11

maybe you should check db name whether is same, the same problem occour on me, finally i found mysqlclient db name is not same as i use in python

Upvotes: 1

Vahid Chakoshy
Vahid Chakoshy

Reputation: 1527

enter this command on mysql terminal

$> mysql
GRANT ALL PRIVILEGES ON f_db.* TO 'chrathan'@'%' identified by 'secret'

for add user to database in mysqlworkbench look at this page How to Create a MySQL Database with MySQL Workbench

Upvotes: 4

Related Questions