How to take the dump of Mysql table by select query
Sometimes we need to take the dump of selected data from Mysql table. We can use the following syntax to
Read More
TECHIES WORLD
For Techs.... Techniques.... Technologies....
Mysql
How to install PDO module for Php in Ubuntu
PDO - PHP Data Objects - is a database access layer providing a uniform method of access to multiple databases.
Read More
How to install LAMP in Ubuntu
LAMP stack is a popular open source web platform commonly used to run dynamic web sites and servers. It includes
Read More
How to disable Mysql password validation
The validate_password plugin serves to test passwords and improve security. The plugin exposes a set of system variables that enable
Read More
Could not set Mysql root password during installation
From Mysql version 5.7 onwards, we cannot log in as root to start with or cannot use 'mysqld_safe' to start
Read More
What is Mysql validate password plugin
The validate_password plugin serves to test passwords and improve security. The plugin exposes a set of system variables that enable
Read More
How to install phpMyAdmin in EC2 instance
phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL or MariaDB
Read More
How to disable strict mode in Mysql
MySQL’s, and MariaDB’s, strict mode controls how invalid or missing values in data changing queries are handled; this includes INSERT,
Read More
Mysql dump import error
Getting the following error while importing mysql database dump. ERROR 1115 (42000): Unknown character set: 'utf8mb4' As the message
Read More
How to reset MySql root user password
This article explains the detailed steps to reset the password for MySql root user. Step1: Stop MySQL service #/etc/init.d/mysql stop
Read More
Phpmyadmin asking for the login credentials while clicking the logout button
ISSUE: Phpmyadmin asking for the login credentials while clicking the logout button To resolve this problem, update the line
Read More