python - Mysql OperationalError 1044, connect to mysql database

Question

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:\_WORKSPACEmysqlfashion_db.py", line 7, in <module>
db = 'f_db') mysql_exceptions.OperationalError: (1044, "Access denied for user 'chrathan'@'%' to database 'f_db'")` 

Answer 1

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