Databases
Resolving ‘ERROR 2006 (HY000): MySQL Server Has Gone Away’
Are you familiar with the ‘ERROR 2006 (HY000) at line XXX: MySQL server has gone away’ error message? If you…
Tag: MySQL
Databases
How To Find MySQL my.cnf File Location
As a database administrator, there are certain MySQL settings and configurations that need to be tweaked, enhanced, or adjusted to…
Databases
How to Check and Update max_connections Value in MySQL
MySQL is an open-source relational database management system that is widely used for web applications. It allows multiple users to…
Databases
How to Create, List or Drop Indexes on MySQL Table
Indexes are very useful to improve search queries on database tables. For example you are searching for particular record in…
JavaScript & Node.js
A Beginner’s Guide to Node.js and MySQL Integration
Node.js, a leading server-side programming language akin to PHP and Java, is widely used in web development. Paired with MySQL,…
JavaScript & Node.js
How to Connect Node.js with MySQL
Node.js is a popular server-side JavaScript platform used to build scalable and high-performance applications. MySQL is a popular open-source relational…
Databases
How to Temporarily Disable Foreign Key Checks in MySQL
You must have faced the foreign key constrains issues many times while working with MySQL database. Generally this issue occurred…
Web Servers
How to Install LAMP Quickly using tasksel on Ubuntu and LinuxMint
Tasksel is a command line utility for Debian based systems for installing a group of packages used for specific tasks.…
Databases
How to Install and Configure phpMyAdmin on Ubuntu 18.04 & 16.04 LTS
phpMyAdmin is the graphical web-based database management tool for MySQL. phpMyAdmin is easy to use and provides most of the…
Databases
How To Enable Logs in MySQL Server
The log file plays an important role during the troubleshooting of any application. It’s also useful to find about details…