‘MySQL’ Category

Take MySql database Backups remotely from command line

If you are a developer it is obvious that you take frequent backups of the project you develop.  If you are a web developer chances are that you always login to cpanel or some other dashboard provided by your hosting provider to take backups. Some tools provide scheduled backups on server.  This is fine if […]

Read More...

Mysql database administration tutorial – User management

Users in MySQL can be created in two ways. First way is by using CREATE or GRANT statements. Second one is to update or add to ‘user’, ‘grant’ tables of MySQL database (MySQL database is default databases that comes with installation and it holds important data realated to users, privilages and othe databases) Using CREATE […]

Read More...