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 ./, 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

Tutorial on how to connect python with MySQldb Date posted: 20/03/2019 Introduction: In this article helps you in connect python with MySQldb and insert queries in DB.  This example is explained based on Linux environment in Centos 7. Prerequisites: For centOS and RHEL based environment: 2. Pip installation is most… Continue Reading Tutorial on how to connect python with MySQldb

Date posted : 23/01/2019 Create a New User and Grant Permissions in MySQL MySQL MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. Step 1: A new user can be created within the MySQL shell, using the following statement: CREATE USER ‘pheonix’@’localhost’… Continue Reading Create a New User and Grant Permissions in MySQL

PHP Script for CRUD Application Date :06/12/2018 What is CRUD? CRUD refers to the four basic types of Database operations: Create, Read, Update, Delete. Most applications and projects perform  CRUD functionality. This is a important script for all PHP beginners. Once you learn about these CRUD operations, you can use them… Continue Reading PHP Script for CRUD Application

Edit the profile details using Angular2 Dated on: 25/10/2018 In this post we are going to see how to edit the profile details using angular 2. In previous post we have seen how to create the sign up form Step 1: Create the new component or new project as you… Continue Reading Edit the profile details using Angular2