how to create a new user and grant permissions in mysql

How To Create a New User and Grant Permissions in MySQL

MySQL is one of the most popular and open-source relational database management systems around the world. It provides a lot of management options like creating and managing a user with specific permissions to databases and tables.

how to create a new user and grant permissions in mysql

When you hire a new developer to manage MySQL databases then you may need to grant specific permission to manage those databases such as deleting or modifying the information. In that case, it is essential for your to know how to grant specific privileges to the MySQL user account.
(more…)

How to Import an SQL File into MySQL database

How to Import an SQL File Into MySQL Database

MySQL is one of the most popular database management systems. It is most often used for web-based application and it is also one of the main components of the LAMP (Linux, Apache, MySQL and PHP) open-source web application stack. In this tutorial, we will show you how to import an SQL file into MySQL database on a Linux VPS. This will help you when you need to transfer your database from one server to another or to restore a database backup.

(more…)

How to Check MySQL Database Size

How to Check MySQL Database Size

MySQL is the most popular open-source database in the world, powering small blogs, high-volume websites, business applications and more. MySQL is used by some of the world’s most popular websites such as Facebook, Twitter, Youtube, Wikipedia ..etc. In this blog post, we will show you how to check the size of the MySQL databases and tables trough the MySQL shell. This post is written for MySQL but the exact same commands are also applicable for MariaDB.

(more…)