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... |
