How to Change Default MySQL Data Directory in Linux
MySQL is a popular relational database management system (RDMS). It is widely used by web applications for storing data permanently. MySQL is available for all …
Databases
How to Check and Update “max_connections” Value in MySQL
In this tutorial, we will learn How to Check and Update “max_connections” Value in MySQL? Sometimes your server may experience issues of too many connections …
How to Run SQL Query from File on MySQL Command Prompt
In this tutorial, we will learn How to Run SQL Query from File on MySQL Command Prompt? If you are on MySQL command prompt and …
How to Install MySQL 8.0 on Ubuntu
MySQL is the popular relational database management system used for storing structured data in table formats. It is an open-source database server that uses SQL …
How to Allow Remote Connections to MySQL
The default MySQL server listens only on the localhost interface. Which means no one can connect MySQL from the remote system. This is a good …
How to Rename MySQL Database
While working with the databases, many times you may need to rename a database. For security purposes, MySQL had dropped the direct command to rename …
How to Change MySQL User Password
In this tutorial, we will see How to Change MySQL User Password? MySQL changed the SQL statement syntax for changing user passwords from 5.7.6 and …
