Working with database in MySQL server trough phpMyAdmin is the graphical way and easier than command line interface for beginners. To create database inside phpMyAdmin just simply follow this step by step MySQL guide.
The phpMyAdmin is a free open source web software intended to manage and administrate MySQL Server. You can do all needed task such as create, delete, or modifying the existing database with a simple graphical interface. The other functions are working with tables, fields, rows and executing all SQL standard queries which can perform by command line.
Here we try to show you, How to create, delete or modify MySQL database with phpMyAdmin trough interface of a web browser. To perform the task you need to run the web server on local web server. For online website try to create database inside phpMyAdmin through website Cpanel.
How to Create Database Inside phpMyAdmin?
First open phpMyAdmin with your internet web browser by typing localhost/phpmyadmin in address bar. I have installed on my local computer with WAMP Server and maybe your case would be an online website. For online website try to create database inside phpMyAdmin through website Cpanel.
2. Enter as root user, type root in Username and let the Password empty. In online you must enter the root password.
3. So you can see phpMyadmin page with all needed information about web server, database server and phpMyAdmin. To create a new database click Database tab on the main page.
4. In this page simply type the name of your new database and click Create button in order to create a new database.
The new database has been created successfully. The database need a user to manage and manipulate it. By default the root user has the full privilege for all database.
You can add a new user to database and assign the appropriate privilege for administration. To create new user go to the User tab and click Add User. Fill the required information and permission for new user.
Click the go button to create the new user. Now you can use the database and user for your website.
To delete a database with all tables, select the database you want to delete and click Drop button.
This will perform the complete deletion of a database, and be careful do not delete your real website database.
Related Search:
how to create database in phpmyadmin in wamp server.
how to create database in phpmyadmin.
phpmyadmin create database no privileges.
how to create table in phpmyadmin.
how to create database using phpmyadmin.
how to create database mysql.
localhost phpmyadmin create database.
how to create table in mysql phpmyadmin.