MariaDB – Page 2 – POFTUT

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

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

MySQL provides the ability to create and users from its shell. Security is an important part of the database servers. In this tutorial, we will examine how to create users and manage privileges in MySQL database server. We will specifically learn to restrict user access to a database, database server, grant different types of privileges, … Read more

How To Check and Determine MySQL Database Server Version?

MySQL or MariaDB is very popular opensource databases servers. While using these database servers we may need to know the version of the client or server. We can use features according to these version numbers. In this tutorial we will look how to list MySQL and MariaDB database server versions. mysql –version Command mysql is a … Read more

How To List MySQL Tables with “show tables” SQL Query?

How To List MySQL Tables with "show tables" SQL Query?

MySQL is a popular relational data that stores information in tables. While using tables we generally need to check and list existing tables. We can use different ways to list tables. In this tutorial, we will learn how to use show tables and Select table_name in order to list and print table names. Connect MySQL Interactive Shell … Read more

What Is MySQL Default Port Number?

MySQL is very popular database in the opensource community. While developing applications or connecting MySQL database we need to specify the MySQL port implicitly or explicitly. In this tutorial we will learn MySQL default port number and alternative port numbers. TCP 3306 The default port for the MySQL service is TCP 3306. This port can … Read more

How To Connect MySQL Database From Python Application and Execute SQL Query with Examples?

How To Connect MySQL Database From Python Application and Execute SQL Query with Examples?

MySQL is a very popular and open source database server. Python is an old but lately discovered language. In this tutorial, we will look at how to use this popular tech in our applications in order to run SQL queries. Install Python MySQL Connector In order to connect the MySQL database from Python application, we … Read more

Mysql Database Import Tutorial with Examples

Backup and Restore operations are important part of the database administration. mysqlimport command is used to load data in file into Mysql or Mariadb servers. Mysql import is generally used by providing SQLfile. Syntax Syntax of mysqlimport is like below. mysqlimport OPTIONS DBNAME FILE OPTION is used provide detailed configuration DBNAME is the name of the database we … Read more

How To Create a Database and Table In MySQL and MariaDB?

How To Create Database and Table In MySQL and MariaDB?

MySQL database is a very popular database server used by a lot of small and big companies. In this tutorial we will look at the basics of MySQL server like creating databases and tables, populating data into tables. MySQL installation can be done with the following tutorial for Linux operating systems. How to Install Mariadb/Mysql … Read more

Backup and Restore MySQL Databases With Mysqldump In Linux

One of the most important task of a database administrator is backing up and restoring databases. MySQL is a popular database server and provides tool named mysqldump for backup and restore operations. We will look different usage types of mysqldump in this tutorial. Syntax mysqldump [OPTIONS] database [tables] OR      mysqldump [OPTIONS] –databases [OPTIONS] DB1 [DB2 … Read more

How To Drop MySQL Database?

MySQL is a very popular opensource database it is used by a lot of different types and size companies. In this post, we will look at how to drop or delete MySQL databases? Login MySQL Database Dropping/Deleting/Removing a database in MySQL server is a simple and fast solution that will delete data as well as … Read more

How To List MySQL Database Users?

How To List MySQL Database Users?

MySQL database server has users to connect and use databases and tables. Users provide security for database operations. MySQL server comes with default users or in the operations, a lot of users are created. In this post, we will look at how to list these users. Connect To MySQL Database We will connect to the … Read more