Place of all tech articles

techarticles

  • Home
  • About
  • Contact Info

Create database and user in phpMyAdmin

18th February, 2015 · techinf1
Create database and user in phpMyAdmin

phpMyAdmin is a great tool to manage MySQL and MariaDB database.  Every cPanel allows  phpMyAdmin interface to manage the hosting database. It is often required to create a database  first  and  then create  a user who have  full permission on  that database only. Here I show step by step how to create database and user in phpMyAdmin. For instacne I will create a database named abantecart  and a user named testuser with password testpassword

1) Login to phpMyAdmin and select Databases. Under the Create database,  give your database name abantecart and submit create button.

Create-Database-by-PHPMyAdmin

2) You will see your database at left navigation side. Select your database abantecart  from left  side and then click Privileges from right side

Add user in phpMyAdmin

3) Click Add user under new

add user in phpmyadmin

4) Put your username  and password

add user in phpmyadmin

 

At the middle you will see Grant all privileges on database “abantecart which means user “testuser” has full access on database “abantecart.

4) Submit go button  at bottom right corner. Your will see the following screen if user is created successfully.

AddUser-4-PHPMyAdmin

Most of the CMS like WordPress, Joomla, Drupal and e-commerce like Magento, Abantecart etc.  require  creating a database and a user who have sole permission of that database. By phpMyAdmin you can do it within five minutes.

 

 

Posted in Database, MySQL, phpMyAdmin |
« Install WordPress in Bangla
fixing mysql replication error automatically »

Leave a comment Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts

  • Ansible Exam (RHCE 8) full solution with explanation
  • Install Ansible on CentOS 8
  • Recover MySQL 5.7 root Password in Redhat/CentOS 7
  • SSH login without password in Linux
  • How to write automated FTP script in Linux

Categories

Pages

  • About
  • aStore
  • Contact Info
  • google pagerank checker
  • SEO Keyword Rank
  • SEO Page Audit
  • Tools
  • whois

Archives

  • March 2022
  • February 2022
  • August 2017
  • May 2017
  • November 2015
  • October 2015
  • August 2015
  • May 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014

Categories

  • Adsense (1)
  • Ansible (2)
  • Database (17)
    • MySQL (15)
    • Oracle (2)
  • FTP (1)
  • Google Map (2)
  • HTML5 (1)
  • Linux (8)
    • AWK (1)
  • PageSpeed (1)
  • PHP (3)
  • phpMyAdmin (1)
  • Social Networking (1)
  • Varnish (3)
  • Webpage Optimization (1)
  • Webserver (5)
    • Apache (4)
    • Nginx (1)
  • Website Migration (1)
  • WordPress (6)

WordPress

  • Log in
  • WordPress
© Techinfobest is the house of tech articles
  • Home