Place of all tech articles

techarticles

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

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.

 

 

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

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

Leave a Reply Cancel reply

Android App to challenge math ability
MathQuiz

Top Posts

  • Optimize MySQL tmp_table_size
  • Optimize MySQL table_open_cache
  • Sum Column in Linux
  • fixing mysql replication error automatically

Recent Posts

  • Recover MySQL 5.7 root Password in Redhat/CentOS 7
  • SSH login without password in Linux
  • How to write automated FTP script in Linux
  • Installing Nginx with PHP support
  • How to access HTML5 local storage

Follow US

Follow US

Categories

© Techinfobest is the house of tech articles
  • About
  • aStore
  • Contact Info
  • google pagerank checker
  • SEO Keyword Rank
  • SEO Page Audit
  • Tools
  • whois