How to use PHPMyAdmin to Create Database, User

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.

phpmyadmin

This interface allows you to perform the below operation on the MySQL database using a web page.

  • Database – Create and List Database
  • SQL – Run SQL Queries against the database
  • Status
  • User Accounts
  • Export
  • Import
  • Settings
  • Replication
  • Variables
  • Charset
  • Engine

1. Create Database using PHPMyAdmin

Now let’ see how to create a database in MySQL.

You can either use Database Tab or click on New Database link on the left-hand side navigation bar. Enter database name and collation and click Create button.

mysql create database

This should create the required database and you can see it in the list on the right-hand side of the navigation.

2. Create User using PHPMyAdmin

The default user is root. For the installation of specific cms, you need to create a user. Click on the User Accounts tab. The next window displays all the existing user information. Scroll down and click Add user account link as shown below.

mysql add new user

Enter User Name, Host Name, and Password as shown below. You can also select privilege to this user in the same window.

After entering all information, scroll down and click the Go button.

enter user information

This is the way you can use XAMPP MySQL Service and use PHPMyAdmin to work with MySQL to create required objects like a database, user or table, and other.

I hope you found this useful. Please share.

Share This: