Search results

Mysqluserstore script helps to update users.db and users.db.cache file. You can check location of these files : /var/cpanel/databases/users.db /var/cpanel/databases/users.db.cache After that you will get below error: [mysqluserstore] Restarting MySQL due to my.cnf modifications. You have to...

If you want to change password of postgre user then you can follow below steps: Login to WHM. Go to SQL Services >> Configure PostgreSQL Now enter your desired password and click on “Change Password”

You can install ‘tablefunc' extension and for that you have to follow below steps: To install 'tablefunc' extension you have to install 'postgresql-contrib' package: yum install postgresql-contrib First you have to login into PostgreSQL with commands. psql -U postgres After login connect to...

You can follow below steps to install and configure PostgreSQL. First you have to run below command to install. /usr/local/cpanel/scripts/installpostgres Now login to WHM and go to WHM >> Home >> SQL Services >> Configure PostgreSQL After that you have to click on “Install Config”, if you do...

If you have installed latest version of PostgreSQL and getting issue then you can easily revert tots previous version to make it working. You can run below commands: service postgresql stop mv /var/lib/pgsql /var/lib/directory_file_name mv /var/lib/pgsql.old /var/lib/pgsql service postgresql...

If you want to install latest version of PostgreSQL then first you have to take backup of your database and then try to install or update database. To take backup it is must to have access of root user, you can follow below steps: Login via SSH You can run below command to take backup of your...

You can follow below steps: Log into WHM. Here you will find “Service Configuration” option, you have to click on it. Now click on “Service Manager” option. You will find “Monitor” column checkbox, you have to deselect it. This option will prevent automatic restart of PostgreSQL service.

With MySQL governor we can set the limits of LVE for MySQL users and its provided by CloudLinux. You can use below command to install MySQL governor package: yum install governor-mysql Now we have to select the MySQL version and version should be one of the below...

If you want to DROP MySQL users manually then you can check this article. Sometime we need to DROP users to resolve the issue then here is the solution: You can run below command to DROP user: mysql mysql -e "DROP user '$USER'@'$HOST';" In this command you have to replace $USER with your...

You can lock MySQL user from MySQL database and also unlock them. You can only modify MySQL user with root privileges and that’s why it is must to have root access. You can login to MySQL as a root use this command: # mysql Now you have to run below command to lock user: ALTER USER...

If you want to use MySQL database remotely then you have to create MySQL user too. You can follow below steps to create MySQL remote user: Login to cpanel. Here click on “Remote MySQL” under Databases. Now you have to enter your IP address to allow MySQL server. Click on “Add Host”. You can...

If you are using dynamic IP address to make connection with MySQL remotely, its little bit tricky to allow dynamic IP Address because it changes frequently. You can add wild card IP’s in Remote MySQL option. For Example: As we know whenever the IP address changes only its last 2 digits updates...

If you want to enable mysql error log then explicitly you have to enable option /etc/my.cnf file and after that you have to restart mysql service. You have to follow below steps: Login to server via SSH as root. Here check your /etc/my.cnf file and add below line in [mysqld] section...

If you are using MySQL 8 version then you must know that Event Scheduler is enabled by default. You have to modify etc/my.cnf file, you have to add below line under [mysqld] section. event_scheduler=off After that you have to restart mysql service to reflect the changes.

You can increase the max_allowed_packet in my.cnf file. You have to edit my.cnf file and add below line in my.cnf file. First you have to find [mysqldump] section in /etc/my.cnf file and then add below code : [mysqldump] max_allowed_packet=268435456 You can add value according to your choice.

Storage engines are software components which help DBMS to create, read, update and delete. We can also change storage engine for database. By default mysql 5.5 and later storage engine is InnoDB. We can change the default storage engines in my.cnf file. In this file we have to update...

If you want to change default character set in Mysql then first you have to open my.cnf file with below command: vi /etc/my.cnf in this file you have to add below line: default-character-set=utf8 Under [mysqld] add below lines too: default-character-set=utf8 init_connect=’SET NAMES utf8′...

In mysql database 5.7 version strict mode is enabled but if you are getting issue or your application requirement is to disable strict mode then you can check this article. Mysql mainly helps to handle missing or invalid values in data change statements (INSERT or UPDATE). If mysql strict mode...

You are getting this error while opening a file which means mysql file open permission has been exceeded. Open files limit can be managed by open_files_limit variable, we can run below query in phpmyadmin: SHOW VARIABLES LIKE 'open%' You will check the limit of open_files_limit variable with...

When you will get error in /var/log/messages that packets are being dropped due to limit being reached then you have to increase the limit of concurrent connections on server. We have set Concurrent connections limit on server due to security otherwise hackers can hack the server. If any...