PostgreSQL FATAL: terminating connection due to administrator command
What is PostgreSQL? PostgreSQL is a powerful, open source object-relational database system with over 30 years of active developm…
Showing posts with the label databaseShow all
Recent posts
Backup MySQL databases in Kubernetes
Backup MySQL databases in Kubernetes As we are adopting more and more Databases in kubernetes scheme of things, we need to be mor…
SECURING MYSQL / MARIADB WITH MYSQL_SECURE_INSTALLATION
SECURING MYSQL / MARIADB WITH MYSQL_SECURE_INSTALLATION We'll be performing basic security in a mariadb installation like, ro…
How to Take Backup & Restore in PostgreSQL Database
What is PostgreSQL? PostgreSQL is a powerful, open source object-relational database system with over 30 years of active developm…
Solved : Last_IO_Error: Got fatal error 1236 from master when reading data from binary log
Backing up the any Configuration item is something that you need to do utmost carefully. We do maridb replication. The replicatio…
How to install DBeaver 4.3.2 on Windows 10
Trabla : How to install DBeaver database tool 4.3.2 on Windows 10 DBeaver is a free multi-platform database tool for developers, …
MySQL/MariaDB DBERROR: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception
Error: WARNING: Connect failed: DBERROR: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying e…
Empty set error in MySQL while Importing DB?
Empty set error in MySQL while Importing DB? Error: MariaDB [(none)]> use exampledb Database changed MariaDB [exampledb]> s…
Fatal Error: Contact system adminstrator. Unable to connect to Database : OS Ticket
Fatal Error: Contact system administrator . Unable to connect to Database : OS Ticket Cause: You would get this error if your PH…
ORA-15042: ASM disk "1" is missing from group number "1" in KVM guest.txt
Error: ERROR: diskgroup DB_DATA was not mounted ORA-15032: not all alterations performed ORA-15040: diskgroup is incomplete ORA-1…
Fixing SELECT command denied to user 'user'@'x' for table proc
Open your hibernate.cfg file and append this below string to your connection string. Use Procedu…
Rename Database in MySQL
Today I am writing about how to rename MySQL Database. So If you want to rename a database in MySQL dont forget taking backup of …
Basic MySQL Administration
1. How to create a user and along with his privileges automatically ? GRANT ALL PRIVILEGES ON database.* To 'username'@&#…
SQL Training Podcasts and Videos
Great resources for SQL Training Podcasts and Videos http://sqlserverpedia.com/ Books http://www.informit.com/index.aspx