MySQL
How to Run SQL Text File on MySQL Command Prompt
Q. How do I run a SQL text file on MySQL prompt? How to source .sql file on MySQL command…
Category: MySQL
MySQL
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…
MySQL
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…
MariaDB
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…
MySQL
How to Install PHP 7, NGINX, MySQL on CentOS/RHEL 7.6 & 6.10
A few days back PHP version 7.2 has been released. Which has a number of changes and improvements over PHP…
Nginx
How to Install Nginx, PHP 7 & MySQL on Ubuntu 16.04, 14.04
The latest major release of PHP version 7.2 has been released with the number of speed optimizations and security. So…
MySQL
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…
Apache
How to Install PHP 7.2, Apache 2.4, MySQL 5.6 on CentOS/RHEL 7.5 & 6.9
The PHP team has released upgrade version 7.2. Which has a number of changes and improvements than over version 5.X.…
MariaDB
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…
MySQL
How to Install MySQL 5.7 on Ubuntu 16.04 LTS
MySQL is an open-source relational database management system. This tutorial will help you to install MySQL server on your Ubuntu…