MysqlCategory

Introduction Updating secure and unsecure URLs directly in the Magento database can be necessary when you need to modify your website’s base URLs swiftly and efficiently. This method bypasses the Magento admin panel and allows you to edit the configuration stored in the database directly. It’s handy when you’re unable… Continue Reading How to update secure and unsecure URLs directly in the Magento database

Introduction: MySQL’s slow query log makes it easy to track SQL queries that take more than a specific time for execution. This allows you to find inefficient SQL queries that can be optimized to improve database performance. Prerequisite: Implementation: Step 1: SSH the server with the user having sudo privileges… Continue Reading How to enable the slow query log – Mysql in Linux

Prerequisites Credentials to access the Plesk panel SSH root access  Implementation Follow the below steps to install MySQL, Enable remote access to the local MySQL server, and Proxy rule setup in the Plesk panelI. MySQL installation Log into Plesk with the credentials Go to Tools & Settings > Database Servers… Continue Reading How to add Proxy pass rule to access PHPMyAdmin without port number in URL -Plesk

Sometimes, a WordPress user, with one of the following capabilities, such as administrator, editor, author, contributor, or subscriber, forgets its login credentials, especially the password. WordPress passwords can be easily changed via the “Lost Password” WordPress login form. However, if the WordPress account has no way of accessing his email… Continue Reading How to reset the WordPress password in Mysql

Step1: Stopping the MySQL service by using this command systemctl command: Step2: Now, we need to restart the MySQL service. Step3: We have able to connect to the MySQL server as root, without specifying a password. Step4: Now, reset the root password, but first flush the privileges to reload the… Continue Reading How to change My SQL password on Linux

To disable foreign key constraints when you want to truncate a table: Use FOREIGN_KEY_CHECKS and remember to enable it when you’re done:

If the mysqld server receives too many connection requests from the host that is interrupted in the middle, the following error occurs: The max_connect_errors system variable determines the number of successive interrupted connection requests that are allowed. Once there are max_connect_errors failed requests without a successful connection, mysqld assumes that something is… Continue Reading Host host_name is blocked

ERROR 1153 (08S01) at line 8606: Got a packet bigger than ‘max_allowed_packet’ bytes. Date: 22-05-2021 Introduction: When doing a very large MySQL import from a dump file you may get this error. You can follow the below steps to solve this error. Step 1: You can see the current configured… Continue Reading ERROR 1153 (08S01) at line 8606: Got a packet bigger than ‘max_allowed_packet’ bytes.

We got this Error when we upgraded Bugzilla. This is a normal database error as well. When we ran ./checksetup.pl, we got this error. After following the below steps we upgraded Bugzilla successfully. 1) First we need to check the database version.mysql –version2) If it is below 5.5 then we… Continue Reading The used table type doesn’t support FULLTEXT indexes

Date :28/03/2019 What is codeigniter? Codeigniter is a php framework to develop the application. Therefore, it provides the many libraries for connecting to the database. Codeigniter simple Add, Edit, Delete, View However, we create database and table. Firstly, database name is considered to be as ‘form’. similarly, creating a table… Continue Reading CODEIGNITER: SIMPLE ADD, EDIT, DELETE, VIEW