Database

MySQL DB import/export through the command line

MySQL is an open source database management software that helps users store, organize, and retrieve data. It is a very powerful program with a lot of flexibility—this tutorial will provide the simplest introduction to MySQL. Moving MySQL database is a frequent necessity. Servers migration/ disk space runs out etc are the main reasons where we need to migrate mysql database. ... Read More »

MySQL Tutorial Install Access Create and Delete Database

MySQL is an open source database management software that helps users store, organize, and retrieve data. It is a very powerful program with a lot of flexibility—this tutorial will provide the simplest introduction to MySQL How to Install MySQL on Ubuntu and CentOS If you don’t have MySQL installed on your droplet, you can quickly download it. Ubuntu: sudo apt-get ... Read More »

Create a New User and Grant Permissions in MySQL

MySQL is an open source database management software that helps users store, organize, and later retrieve data. This tutorial will give a short overview of options to grant specific users nuanced permissions within the tables and databases. How to Create a New User in MySQL Let’s start by making a new user within the MySQL shell: CREATE USER 'newuser'@'localhost' IDENTIFIED ... Read More »