import MySQLdb
db = MySQLdb.connect(host = "localhost",user = "root",passwd = " ",db = "TESTDB" )
cursor = db.cursor()
sql = """CREATE TABLE CRAWLER (
FIRST_NAME CHAR(20) NOT NULL,
LAST_NAME CHAR(20),
AGE INT,
SEX CHAR(1),
INCOME FLOAT )"""
cursor.execute(sql)
db.close()

when i execute this code there is an error occure like
OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")

what can i do? pls clarify this....

import MySQLdb
db = MySQLdb.connect(host = "localhost",user = "root",passwd = " ",db = "TESTDB" )
cursor = db.cursor()
sql = """CREATE TABLE CRAWLER (
FIRST_NAME CHAR(20) NOT NULL,
LAST_NAME CHAR(20),
AGE INT,
SEX CHAR(1),
INCOME FLOAT )"""
cursor.execute(sql)
db.close()

when i execute this code there is an error occure like
OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")

what can i do? pls clarify this....

Code tags, please!

Are you sure that roots password is one space and not for example empty ""?

import MySQLdb
db = MySQLdb.connect(host = "localhost",user = "root",passwd = " ",db = "TESTDB" )
cursor = db.cursor()
sql = """CREATE TABLE CRAWLER (
         FIRST_NAME  CHAR(20) NOT NULL,
         LAST_NAME  CHAR(20),
         AGE INT,  
         SEX CHAR(1),
         INCOME FLOAT )"""
cursor.execute(sql)
db.close()

I solved that error thank u...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.