Category: MySQL

0

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

MySQL stores given relation data 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...

0

How To Install MySQL On Ubuntu, Debian, Mint Kali

MySQL is free and opensource database server which is very popular in opensource community. MySQL is used by alot of applications and companies like Facebook, Google etc. In this tutorial we will learn how to install MySQL into deb or apt based distributions like Ubuntu, Debian, Mint and Kali. This guide can...

0

“ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock'” Error and Solution

MySQL service provides different connection methods. We generally prefer TCP/IP way where connection is established over Network Socket. There is alternative way named Socket which is connected over local system. During connection we may get error like Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ . In this tutorial we...

0

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...

0

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...

0

How To Create Database and Table In MySQL and MariaDB

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

0

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

Help

Connect Remote Database Server...

0

MySQL Drop Database

MySQL is very popular opensource database it is used by a lot of different type and size companies. In this post we will look how to drop or delete MySQL databases? Drop Database Dropping/Deleting/Removing a database in MySQL server is simple and fast solution which will delete data as well...

0

How To List MySQL Database Users?

MySQL database server have users to connect and use databases and tables. Users provides 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 how to list these users. Connect To Database We will...

Enjoy this blog? Please spread the word :)