Tag: mysql

Import and Export MySQL Database

Author: | Categories: Database, Wordpress One Comment
There are many ways you can Export and then Import MySQL on other server like phpMyAdmin and MySQL WorkBench. But most efficient way (though not much user friendly) is command line option. This is helpful when you don’t have other option to transfer database but you have SSH access to the server and you want […]

Accessing MySQL databases from remote computer

Author: | Categories: Database, Linux No Comments
To expose MySQL other than localhost uncomment following line in /etc/mysql/my.cnf and assign to your computers IP address and not loopback bind-address = xxx.xxx.xxx.xxx # replace xxx with IP Next for a remote user to connect with the correct privileges you need to have that user created in both the localhost and '%' as in. […]

SQL Joins

Author: | Categories: Database No Comments
Comprehensive image to show how SQL joins work