Introduction To grant all privileges to a MySQL user use the GRANT command.In this post we will see through a simple case how to grant all privileges or only a part to a user.Let’s not waste any more time and let’s get to the point! How to grant privileges to a MySQL user To grant …
Introduction To create a user in MySQL there is a command called CREATE USER.So, if you’ve installed MySQL and now you don’t know how to create a new user, don’t worry, you’ve come to the right place!Don’t worry, this post will clear all your doubts! In fact, with this tutorial we will see how easy …
Introduction Do you need to start saving your data in a MySQL database but don’t know how to install it on your Ubuntu machine?Don’t worry, It’s very easy to install MySQL on Ubuntu if you know how to do it.With this post I will show you how to install MySQL on Ubuntu and how to …
Introduction The DROP DATABASE command is a basic command of the MySQL language and is used to delete an existing database. I imagine that you have created databases and then had to delete them.Maybe to start over or just to remove data you no longer needed.Well, with this tutorial we will discover how to delete …
Introduction The CREATE DATABASE command is used to create a new database in MySQL. If you’re starting to build your own data structure, the first thing you’ll need to do is create a database.Databases are the backbone of every application, in fact they contain all the data divided into tables. Always carefully execute commands that …
Introduction MySQL provides the DROP TABLE command to delete a table. If you have created several tables in a database and now you no longer need them, you will definitely want to delete them.Another possible scenario is that you just want to delete the data within a table without deleting the structure as well. This …
Introduction MySQL provides a command to create a new table; this command is called CREATE TABLE. If you are creating your own database you will definitely need to create multiple tables within it.Well, this post will show you the command syntax and several practical examples to best learn how to use it. Preliminary operations Since …