Search results

phpMyAdmin is a great way to manage MySQL or MariaDB from within a browser. The intuitive GUI that it has allows you to create, delete, and maintain databases with ease. You can even run queries without the need to open a terminal. In this guide, learn how to install phpMyAdmin on a CentOS...

In Linux OS, Cron holds the process of scheduling the jobs and tasks. To maintain a good environment in software, using the scheduling the time the users are presented to maintain and set. You can process tasks like repetitive using Cron. Here, we are listing the scheduled jobs in Cron: The...

Script restoregrants which is available in /usr/local/cpanel/bin/restoregrants location helps to restore database users from data which is available in /var/cpanel/databases/grants_* files. You can use below command: /usr/local/cpanel/bin/restoregrants [--cpuser=cpuser] [--db=mysql|pg]...

If you want to convert your database tables to MyISAM then you can follow below steps.But for that it is must to have root access of your database. You have to first dumped your SQL file via mysqldump and for that we have to replace "ENGINE=INNODB" with "ENGINE=MyISAM". You can check below...

Normally MySQL data will store in /var/lib/mysql, but still you want to check the the location of your database then you can follow below steps: You can use below command to find the location of data directory: mysql -e "show variables like 'datadir'" You can get the directory for MySQL with...

We have to find database name and user name from table name which only we have. Let’s see how to find the details of database and cpanel user. If you want to determine the user of particular table then first you have to find out database name. For this you have to run below command, but make...

You can connect your VPS server with Windows 10, for that you have to follow below steps: First click on “Start” button and search for “Remote Desktop” . You will find “Remote Desktop Connection”, you have to click on it. A window will appear in which you have to enter IP address and after that...

Whenever user access PostgreSQL databases then its privileges are set in cpanel account and if user doesn’t going to visit then phppgadmin will not work. Also you have to check cpanel password for space as its going to creating the issue in psql/phpPGadmin. There is solution to resolve this...

If you are getting below error then also you can follow below steps: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Login to WHM. Here click on “SQL Services” Now you will find “MySQL Root Password”, click on it and you can change MySQL root password here.

The open_files_limit setting can be set via system on CentOS 7 server, for that you have to edit my.cnf file. First you have to create file and you can check command for that: /etc/systemd/system/mariadb.service.d/limits.conf After that you have to add below lines of code in your my.cnf file...

Normally MySQL data will store in /var/lib/mysql, but still you want to check the the location of your database then you can follow below steps: You can use below command to find the location of data directory: mysql -e "show variables like 'datadir'" You can get the directory for MySQL with...

Let us point the solution straight away! You have an immediate solution to solve both software and security issues by checking the server logs. Few services like application run, services, kernel and webserver some kind of events will occur possibly. An administrator role is to keep an eye on...

Linux systems work so seamlessly because of services. These keep working on the background continuously and process the incoming requests from clients. There are a wide range of system services and network services. When there’s a group of services working together, they’re collectively called...

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

Have you ever used LVM? It is one of the most recommended tools for a system admin who works on a web server. Use the command for checking the filesystem size: df –h The below command is to check the presence of drives and it helps to increase the size of the filesystem: fdisk –l Perform...

What happens if the installation of CentOS is completed? It helps you to block people who are unauthorized to your website area and follows up the intrusions too! Many hackers and spammers look keen into the server for getting all your information within a fraction of a second. Let us learn to...

When working with MySQL servers, you may face errors from time to time. One of them is the MySQL Error 1040: Too Many Connections. So what does this error message means? And how to deal with it? The message basically means that the server has reached maximum number of alloted connections. So it...

When managing a website or a web app, it’s important to give the right permissions to the right users. Otherwise, there’s a high security cost to be paid. If you’ve built your website on Plesk Onyx 12, you should know how to set and change the permissions. It can be easily done from the control...