Digi Educorp

Menu
Setting up XAMPP Environment

Creating a Database User with All Permissions

Table of contents

  • 1. Introduction to Web Development
Menu
  • 2. Deep Dive into Web Hosting
Menu
  • 3. Domain Management and DNS
Menu
  • 4. How Websites Works
Menu
  • 5. Introduction to WordPress
Menu
  • 6. XAMPP Server
Menu
  • 7. Setting up XAMPP Environment
Menu
  • 8. WordPress Setup
Menu
  • 9. WordPress Configuration
Menu
  • 10. Installing Themes and Plugins
Menu
  • 11. Building Your WordPress Site
Menu
  • 12. Backup and Security
Menu
  • 13. Linking domain with web hosting
Menu
  • 14. WordPress Migration
Menu

Access phpMyAdmin

  • Open your web browser and type http://localhost/phpmyadmin in the address bar
  • You'll see the phpMyAdmin dashboard.

Default username and password

By default, if you haven’t set up a separate user account, the username is “root” and the password field should be left blank.

Setup a separate user account

Select the Database

On the left sidebar of phpMyAdmin, click on the database for which you want to create a user. If you haven’t created a database yet, create one before proceeding.

Go to "Privileges"
  • After selecting the desired database, click on the "Privileges" tab located in the top menu bar
Add a New User
  • Click on "Add user Account", usually found near the top or bottom of the page
Fill in User Details
  • Enter the new user's username and password in the provided fields
  • Ensure the "Host" field is set to "localhost" (if the user is intended for local use only)
Grant All Privileges
  • Scroll down to the "Database for user account" section
  • Ensure the "Grant all privileges on database {database_name}" is checked.
  • Check the box next to "Check All" next to "Global privileges" or manually select the privileges you want to grant
  • Check the box next to "Check All" next to "Global privileges" or manually select the privileges you want to grant
Apply Changes
  • Finally, scroll to the bottom or top of the page and click on the "Go" or "Save" button to apply the changes