This error happened to the mysql user and password not being correct on file. Change the setting in LocalSettings.php. You can verify whether the details you have are correct by logging into the mysql database mysql -u ''wikiuser'' -p ''wikipassword'' where of course you have to replace the user …
Read more →Mysql
Posts tagged with
Access denied for user ‘debian-sys-maint’@'localhost’
debian-sys-maint is a system MySQL user created to be able to start/stop the databases and to carry out maintenance operations. The above error message is therefore due to a mismatch between the mysql debian-sys-maint password in the mysql database and that in the configuration file /etc/debian.cnf. …
Read more →MySQL backup and restore
To backup a single database: mysqldump --user=root --password=password mydb > mydb.sql Yes it is no typo, there is no space between the -p and the password! You may like to add this to the my.cfg file in etc to avoid [mysqldump] events ignore-table=mysql.events If you didn’t use the …
Read more →