Database Archives - Cubic Techie - Fix Technical Issue

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

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

Installation of PostgreSql 9.5 Database Server On Redhat/CentOS 7

PostgreSql  Server is object relational database management server. It’s an open source that uses the SQL language combined with many features to store data and scale database workloads. It uses the Port...
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...
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...
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...
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...
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...
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...
error: Content is protected !!