Accessing MySQL databases from remote computer
Allow remote MySQL connections by binding address, creating users with host %, and opening firewall port 3306.
Continue ReadingTag: mysql
Import and Export MySQL Database
Back up and restore MySQL databases with mysqldump and mysql client for migrations and disaster recovery.
Continue ReadingSQL Snippets
Reusable SQL patterns for paging, duplicates, pivots, and date ranges across SQL Server and MySQL.
Continue Reading