Category: MySQL

How To Create New User and Set, Grant Permissions To User In MySQL and MariaDB?

MySQL provides ability to create and users from its shell. Security is important part of the database servers. In this

MySQL or MariaDB is very popular opensource databases servers. While using these database servers we may need to know the

MySQL stores given relation data in tables. While using tables we generally need to check and list existing tables. We

MySQL is free and opensource database server which is very popular in opensource community. MySQL is used by alot of

MySQL service provides different connection methods. We generally prefer TCP/IP way where connection is established over Network Socket. There is

MySQL is very popular database in the opensource community. While developing applications or connecting MySQL database we need to specify

MySQL is very popular and open source database server. Python is old but lately discovered language. In this tutorial we

Backup and Restore operations are important part of the database administration. mysqlimport command is used to load data in file

MySQL database is very popular database server used by a lot of small and big companies. In this tutorial we

One of the most important task of a database administrator is backing up and restoring databases. MySQL is a popular