• By Rasika Preethiraj
• In SQL
• Posted 12 Sep 2013

Create and Manage mysql database with phpmyadmin

phpMyAdmin is a popular web-based administration tool used to administrate MySQL servers and databases. This tutorial illustrates how to create a new database and a new user to access that database on a MySQL Server using phpMyAdmin.

Browse to your phpMyAdmin URL using your Internet Web Browser, and login using your root or dba user login as shown.
if you are using xampp installation, the url should be http://localhost/phpmyadmin

Browse to your phpMyAdmin URL using your Internet Web Browser, and login using your root or dba user login as shown.for xampp installation this will directly load since no password in use.
From the main menu choose Databases. In the create database field type in a name for your database. Leave the collation drop down box if you wish to use the default MySQL schema collation. Click Create.

Your database will now be visible on the right hand side under the list of available databases. To setup a new user login to access this database, click on Users in the main menu. Choose the Add User option under the list of available server users.
In the section titledLogin Information - type in a username, localhost and a password in the fields as shown. Optionally you can press the Generate button to create a random password for you.

for granting the permissions to your create user, execute below query with the required parameters, or simply this could be achieved from the privileges options displayed in users tab next to user name.

• 0
• 188