SQL-Config|dbconf

Access denied for user 'Username'@'localhost' (using password: YES)

If you get the following error...

Can't connect to database
Access denied for user 'Username'@'localhost' (using password: YES)
check config in 'config.py' first

...you will have to check the permissions for the User Username of your MySQL Database.

config = {
    ## Database connection settings
    "dbTyp"             : "MySQLdb", # "sqlite"
    "dbHost"            : 'localhost', # Evtl. muß hier die Domain rein
    "dbDatabaseName"    : 'DatabaseName',
    "dbUserName"        : 'UserName',
    "dbPassword"        : 'Password',
    # der Tabellen-Prefix darf keine Leer-/Sonderzeichen erhalten.
    "dbTablePrefix"     : 'lucid_',
    "dbdatetime_format" : '%Y-%m-%d %H:%M:%S', # SQL-Datetime-String-Format
    #...
}

The best way to realize that is to create one database and one user which has access to only this database:


If you have your own server you can follow the instructions below:

user@system:mysql -uroot -p
Password:PASSWORD of your MySQL-Server

Create Database

mysql>create database DATABASENAME;
mysql>OK...

Create User (only Full-Access to the just created Database

mysql>grant all privileges on DATABASENAME.* to USERNAME identified by 'PASSWORD';
mysql>OK...

Else you are given only one database with DATABASENAME, USERNAME and PASSWORD by your provider please use this information in your config.py


Additional Information: