Tag: Database

Backup mysql databases into separate files This bach script makes separate backup files of all the databases in mysql and saves the result in the mysql_backup folder. #!/bin/bash -v USERNAME='yourusername'...
Script to backup MySql database #!/bin/bash # Shell script to backup MySql database # To backup Nysql databases file to /backup dir and later pick up by your # script. You can skip few databases from backup...
MySQL Not Listening On A Public IP By default, MySQL (on Debian) doesn’t listen on the public interface: #netstat -l tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 1768/mysqld In /etc/mysql/my.cnf, comment out the...
Resolving: ‘Client does not support authentication protocol requested by server’ If you get an error about client authentication version when connecting to MySQL then it may be because your server is using the new password format, while your mysql client...