I have a web server which needs to link to a MS SQL server (not my choice). In my case I use Plack which calls the database in four steps. The catch I often struggle with is that some other files with the same name may float around and which you may not be aware off. Run therefore a âfind / -name âŠ
Read more âDatabase
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 â