How To

Grant and Revoke Permissions to Database Using phpMyAdmin

You can customize the database permission if the server allows this. For WordPress website, you can leave only the following permissions enabled:

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • ALTER (for updates)
  • CREATE TABLE
  • DROP TABLE
  • INDEX

Follow these steps:

  1. Login to phpMyAdmin and click on the Home icon to see all the databases.
  2. Click the Check Privileges link next to your WordPress database.
  1. Click the Edit Privileges link next to the database user.
  1. Change the privileges you want to have for your website and click the Go button to save the changes.

John Darrel

John Darrel
database permissionsdatabase provilegesmysql privileges
12 months

Change Database Prefix in WordPress

Because hackers often use bots to search for security flaws in your website, it is…

12 months

Customize WordPress Uploads Directory

The easiest way to change the default media uploads path is to use the WP…

12 months

WP Ghost and WP Rocket Cache

To hide all CSS and JS you need to follow the steps to Combine the…

12 months

Why is website security important?

https://youtu.be/6ylhojSi-_E In this video, we’ll explore why website security matters and what can happen if…

12 months

Is WordPress Website Easily Hacked?

The security of your WordPress site depends on multiple factors, such as the strength of…

12 months

Setting up Two-Factor Authentication (2FA) for WordPress Using Mobile Apps

When you enable two-factor authentication (2FA) for your WordPress website, it adds an extra layer…

12 months