mysql

If you want to change default character set in Mysql then first you have to open my.cnf file with below command: vi /etc/my.cnf in this file you have to add below line: default-character-set=utf8 Under [mysqld] add below lines too: default-character-set=utf8 init_connect=’SET NAMES utf8′...

In mysql database 5.7 version strict mode is enabled but if you are getting issue or your application requirement is to disable strict mode then you can check this article. Mysql mainly helps to handle missing or invalid values in data change statements (INSERT or UPDATE). If mysql strict mode...

MySQL triggers is an object which is attached with particular table and execute when that event occur. These triggers only work when any of these Mysql statements run like INSERT, UPDATE, DELETE etc. NOTE: You can only use triggers if you have MySQL SUPERUSER privileges. So you have your own...

We are getting error “Error establishing a database connection” after up gradation to MySQL 5.6.5 or newer version; the reason is new hashing method. Mysql older version used a hashing method to store password but newer version does not support hash method. You have to delete your current user...

You will get mysqldump error as like below format: mysqldump -u root -p databasename> filename.sql Enter password: mysqldump: Error: ‘Can’t create/write to file ‘/var/tmp/#sql_a41_2.MAI’ (Errcode : 2)’ when trying to dump tablespaces mysqldump: Couldn’t execute ‘show fields from activated’...

You can follow below steps to restart mysql service: Login to Plesk. Here you will find “Tools and Settings” option, you have to click on them. Now under “Server Management” section you have to click on “Mysql server”. Finally, click on start.

If you’re using AWS to host your website or application, you may run into some errors from time to time. And one of the error is the AWS Error 2003 (HY000). Here, the MySQL client tries and fails to connect to the server in AWS cloud. If you’re stuck with the error, this article is for you...

You will have gone through the error called “500 server error” or “503 services unavailable”. What will your first step when you get MySQL errors? Of course! Your search will be on server logs and MySQL service logs. You might get an error if the error occurred because of the issues in memory...

When working with MySQL database (especially when restoring it), you may come across certain errors. And one of them is the MySQL Error 1127. When you try to import a backup file that’s created with mysqldump, you may get an error message that reads, “Error 1127: Access denied; you need (at...

You can follow below steps to resolve this error, this error occur while running query in phpmyadmin. First you need root access to resolve this error. With root access you can make changes in configuration file with below command: vi /etc/my.cnf You have to add below line in this file...

Login to SSH via root. Now you have to enter below command: mysql -u username –p You will see password prompt you have to enter password of your database. You have to enter below command to display all the databases and also you can see its size in MB. You can use this command to check single...

You can follow below steps to change Mysql root password: Login to WHM. Click on Mysql root password under “SQL services” tab. Now you have to enter new password of your Mysql database. You have to use STRONG and COMPLEX password for your database as everyone can access database. Do not use...

Mysql workbench is an Mysql client tool which helps to connect Mysql database. You can easily connect with mysql database from your computer with this mysql client. Here are the steps to use mysql client: Install mysql workbench and then open it. Click on “New Connection” and you will find...

Caching can significantly improve the performance of your website manifold. Your site visitors will experience faster loading speed and personalized content. But one caching mechanism in particular can greatly enhance the website performance which is Query Caching. If you’re using MySQL, then...

You can find the start/stop scripts in the /etc/init.d location in your server. You can run below command to start your Mysql: /etc/init.d/mysql start Similarly, you can run below command to stop mysql server: /etc/init.d/mysql stop In cpanel server your restart script location is...

If you’re running your website or application on a Linux server, then you should learn a thing or two about MySQL. Otherwise you’d constantly be bothered by errors like the “The Server Quit” error. When firing up your MySQL server, you’ll notice a error message flashing on the screen which...

Sometimes, you can see the performance of the website is slow down abruptly. You might be confused about the reason behind the slowdown of website performance. One hectic reason is slow MySQL queries which act as the main reason for website slowdown. It doesn’t stop with slowing down the...

Commonly Used MySQL Functions You Must Know MySQL is one of the most popular databases used all over the world for storing data. Developed by Oracle Corporation, the “My” part comes from the name of the daughter of Micheal Widenius, co-founder of MySQL, while SQL stands for Structured Query...

1. Create local directory in your project directory. 2. Move all files and folders except public directory in the local directory. 3. Move all files and folders from public directory to project directory and remove public directory. 4. Open index.php file and replace require...

You can run following SQL query in SSH or PhpMyAdmin : ALTER TABLE tablename ENGINE = InnoDB;