Articles

Can we use the same name for the DB and DB_USER in MySQL?

Yes, we can use the same name for the database and database user. It is a good and quite...
Error 1503: Error while restarting MySQL service on Windows server

You may need to restart MySQL services from Services on Windows server. While restarting service,...
Fix - Collection Max error, Cannot Connect to Server

Problem Statement Recently one of our customers was unable to connect to Collection Max and...
Fix :: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found

Error Message ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no...
How To Check Running Processes Of MSSQL and MySQL?

The MSSQL processes will give you the data of the load running on your database server. This is...
How do I connect to MySQL server from phpMyAdmin?

This article will guide you on how to connect to the MySQL server from phpMyAdmin. 1. You can...
How do I disable ONLY_FULL_GROUP_BY in MySQL?

MySQL's only_full_group_by is the new default mode that changed in version 5.7.5. This mode is...
How do I place my database on your server? Will my primary keys, stored procedures and constraints be preserved or destroyed?

All you have to do is to take a full backup of your database on your local machine and place a...
How to Allow Remote Connection to MySQL Server through Windows Command Prompt?

This article will guide you through enabling remote access to the MySQL server using the Windows...
How to Clone MySQL database using PhpMyAdmin?

Database clone is a process to create a separate copy of the database. You can also use it as...
How to Enable Relation View in phpMyAdmin?

The option Relation View is probably one of the best features available in phpMyadmin. Sometimes...
How to Stop and Start MySQL Service in Windows and Linux VPS?

This article will assist you to stop and start MySQL service from Windows VPS and VPS Hosting....
How to change phpMyAdmin password?

This tutorial aims to provide you with step-by-step instructions on how to reset your phpMyAdmin...
How to connect MySQL using PHP?

You can connect your MySQL with PHP using the below methods. Method 1 - PHP extension(mysqli)...
How to enable Remote Access for MariaDB in virtualmin?

For web hosts looking to make better use of their resources, moving the database server to a...
How to generate MySQL (backup) dump from the command line in Windows VPS?

This article will assist you in generating MySQL (backup) dump from the Command line in the...
How to resolve MySQL error 1064?

What is SQL Error 1064? SQL Error 1064 is a common issue encountered when working with SQL...
How to resolve “mcrypt extension is missing. Please check your PHP configuration” error in phpMyAdmin?

This article will guide you on resolving the “mcrypt extension is missing. Please check your PHP...
How to restore MySQL database using Command Prompt?

Step 1: Open a Command Prompt. Step 2: Go to the MySQL bin folder. cd "C:\Program...
How to turn on/off Mysql strict mode in the Windows server?

By default in the windows server, the strict mode will be enabled on MySQL. Please refer to the...
My website is working but unable to fetch the data from MySQL database

There are many reasons why you are unable to fetch the data from your MySQL database. Following...
What is the database connection string for my website?

It is recommended that you take the help of your web developer to define the database connection...