Databases
How to Check MySQL Database & Tables Size
MySQL is a Relational Database Management System, widely used as a database system for Linux systems. This article will help…
Tag: MySQL
Databases
How to Remove/PURGE BINARY LOGS in MySQL & MariaDB
Binary log files contains data about modification’s make by MySQL server. You can see there are multiple binary files will…
Databases
Error installing mysql2 Gem on Linux
Error: I have faced following issues during installation of MySQL gem on Linux systems. # gem install mysql2 -v '0.3.18'…
Security
15 Best Security Tips for LAMP Stack
Many new system administrators forgot to apply security when configuring a web hosting environment for production use with Apache, MySQL,…
Databases
How to Resolve “Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)” Error
If you’ve encountered the error message “Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)” while trying to connect…
Databases
Adding Users and Managing Permissions in MySQL
MySQL is a popular open-source relational database management system that is widely used for web development and data-driven applications. When…
Security
How to Disable root Login in phpMyAdmin
phpMyAdmin is a popular tool used to manage MySQL databases through a web interface. However, allowing root login through phpMyAdmin…
Databases
How to Upgrade MariaDB 5.5 to MariaDB 10.0 using YUM
MariaDB 10.0 Stable version has been released and available to install using yum package manager. Today we have upgrading TecAdmin.net…
Databases
How to Change the Default Data Directory in MySQL
In the world of database management, flexibility and organization are key. MySQL, as one of the most popular database management…
Databases
How to Extract Tables Backup from Full MySQL Dump File
Mysqldump is an utility provided by MySQL/MariaDB to backup databases and tables. Generally, we take a full dump of database…