HostOnNet Blog

Category Archives: Database

How to deactivate WordPress Plugins using PHPMyAdmin

We can deactivate a plugin through WP Admin Dashboard. What we can do if we can’t accessing the admin area ? Yes, The following situations may block you out from accessing the dashboard 1). Will show a blank page after

PostgreSQL – Quick Start Guide

After you install PostgreSQL on Ubuntu/Debian, it will create a user “postgres”, it have full privileges. It is like “root” user in MySQL. Connect to PostgreSQL To connect to PostgreSQL, run following command. This will change current user to linux

How to Check PostgreSQL is installed or not on Linux

PostgreSQL is a popular database management system that is used to handle the data of many websites and applications. If you were to run which psql and Postgres is not installed there appears to be no output. You just get

MySQL access from command line on Ubuntu

First connect to your Ubuntu server using ssh and run below command It will give you a password prompt as follow: Enter root password there and press enter key, then it will be connected successfully. It will show below output: To

Securing MySQL database on Cpanel Servers

After you setup Cpanel, you have to do few things to secure MySQL on Cpanel server. 1. Delete the test database This can be done with command mysqladmin drop test 2. Change MySQL root Password This can be done through

Cpanel phpMyAdmin shows “test” database

On Cpanel Server, test database shows on all users phpMyAdmin. This create problem as some new users create their tables on this “test” database and some other users delete these tables. To correct this problem, just delete this default database

MySQL Query Cache

The query cache stores the text of a SELECT query together with the corresponding result that was sent to the client. If an identical query is received later, the server retrieves the results from the query cache rather than parsing

MySQL Error: Can’t connect through socket /var/tmp/mysql.sock

On a Cpanel/WHM server running RHEL, after rebooting MySQL stoped working for all sites hosted on the server. I tried restarting MySQL, but it won’t solved the problem. Sites still shows the error message Warning: mysql_pconnect(): Can’t connect to local

Creating MySQL Database

You can create MySQL database with create database DATABASE_NAME command. root@host [~]# mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 937316 to server version: 4.0.25-standard Type ‘help;’ or ‘h’ for help.