install mysql 5.7 ubuntu

Installation of Mysql 5.7 Database Server On Ubuntu 17.10/18.04

MySql is an open source database server which is used to store data of any application and websites. It’s acquired by oracle. It’s widely used database server as of secure ,...
mysql myisam table

MyISAM Table Maintenance and Crash Recovery On Linux

MyISAM is a default Storage engine for Mysql server and InnoDB is also a storage engine. MyISAM supports three different storage format. Two of them, fixed and dynamic format, are chosen automatically...
error connection

Mysql Error “Too Many Connections” On Redhat/CentOs 7

It’s can be as when a client tries to connect MySQL server the request can be rejected and receive an error “too many connections “ to server has been reached. So...
connection issue mysql

Solve Mysql “Can’t connect to local MySQL server through socket “

Mysql is an open source relational database management system (RDMS ) based on sql query . It’s most widely used  relational database nowadays . It runs on 3306 port. Why do we need...
installation of mariadb

Installation of Mariadb(Mysql) Server In Redhat /CentOs 6/7

 Mariadb is a relational database server. It’s widely used Mysql server in the world. It is originaly made by developer of Mysql. It is a well known as mariadb server in...

ByPass Root Password Of Mysql Server On Redhat/CentOs 7

Here is an interesting thing I have found out that is if you have server access of database you want to login to Mysql server even you do not have root...
denied password yes

Mysql Error “Access denied for user ‘user’@’localhost’ (using password: YES) “

Error “Access denied for user 'user'@'localhost' (using password: YES) “  in Mysql Server. When you try to login Mysql server from remote host or locally . To solve this issue you...
table creation in mysql

Create User , Database , Tables in Mysql Server

In Mysql Server  , I’m going to show you how to create user , create database and tables. First of all check how many database is present there by command Show databases; Then Choose...
error: Content is protected !!