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

Enable Remote Access To PostgreSql 9.5Database Server On Redhat/CentOs 7

We have installed postgresql 9.5 Server on our machine. The procedure is same for all version of postgresql server. Check Out Installation Of Postgresql Database Server On Redhat Centos 7 By default, Postgresl server...
MongoDB installation

Installation Of MongoDB Database Server On Redhat/Cent0s 7

Installation Of MongoDB Database Server On Redhat/Cent0s 7 MongoDB is an open source cross-platform documented-oriented database program. It stores the data in JSON like documents with dynamic schemas. Other database stores the...
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...

Error “ Job For Postgresql.service failed ” On Redhat/CentOs 7

If you face this issue on your server means you need to check the status of your database server and logs to resolve this issue asap. Check out Installation of PostgreSql 9.5 Database...
root password mysql

Recover/Reset Root Password Of Mysql Server On Redhat/CentOs 7

Mysql is an Open source database server which is widely used in today’s technology as of its stability , scalability and secure. It uses port 3306. Check Out Solve Mysql Cant Connect To...
security of mysql server

Secure Mysql Server in Redhat/CentOs 6/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...

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...
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...
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: Content is protected !!