Thursday, April 25, 2019
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...
database access

Grant Permission On Database In Mysql

If user does not have the access of database  You can not login to the Mysql server And Access the database. So we will have to give grant permission on database...
how to enable slow query in mysql

How To Enable Slow Query In MySQL

How To Enable Slow Query In MySQL If you want to enable slow query in MySQL it’s easy to setup. It can help you analyse the database server response time. By default, slow_query_log is off in...
find users on mysql

How To Check Users in Mysql Server

How To Check Users in MySQL Server If you are not aware of how many users are on your MySQL server. So you can check it via command in MySQL. The local...
security of mysql server

Secure Mysql Server in Redhat/CentOs 7 Version

Security of Mysql server is most important in production environment for a big companies and small enterprises.  You should not allow remote login on the Database server from outside the network. There...
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...
how to check slow query in mysql

How To Check Slow Queries In Mysql

How To Check Slow Queries In Mysql Sometimes we face issue in database response time one of cause may be as of slow queries are running in MySQL. There are many ways...
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...
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...
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 !!