<

[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x

How to create and manage Databases with phpMyAdmin in cPanel

Published on
4,095 Points
1,095 Views
Last Modified:
Creating and Managing Databases with phpMyAdmin in cPanel.
While creating a database, a lot of users don't know that there are a few additional things that they need to organize as well. That includes the procedure of new database creation:
  • Creating a database user
  • Giving your database user rights to work with your database
Fortunately, cPanel added the MySQL Database Wizard that can help in creation of database by following the steps below.

How to create database in cPanel using the MySQL Database Wizard-
 
  • Login to your cPanel account provided by your cPanel hosting provider
  • Click the MySQL Database Wizard below the Databases
  • Enter a name for your database next to New Database and click on Next Step
  • Enter a username Next to Username.
  • Enter a password next to Password, reenter the Password and then click on Create User
  • On the next page, you can assign rights for the user to the database. Check the box next to All Privileges and then click on Next Step

You have created the database successfully!

You can handle various options for managing the databases by using phpMyAdmin in cPanel such as:
  • Structure:  It is the most efficient way to organize your schemas, tables, and columns.
  • SQL:  To run SQL query/queries on a database.
  • Search: To search words or values inside database tables.
  • Query: SQL defines a set of commands, such as SELECT, INSERT, UPDATE, DELETE, CREATE TABLE and etc.
  • Export: To exporting the database in different formats such as CSV, PDF, SQL, XML, Text etc.
  • Import: To importing the database in different formats such as OpenDocument Spreadsheet, CSV, SQL, ESRI Shape file, MediaWiki Table, XML.
  • Operations: There are various operations which you can execute on the whole database and on a separate table.
  • Triggers: A trigger is known as database object that is linked with a table, and it activates whenever a particular event (e.g. an insert, update or delete) happens for the table.

The basic functionality of the phpMyAdmin is to manage your databases.

Click on the Databases tab. Choose the database which you want to manage and click on the database name.Databases-in-phpMyAdmin.pngAfter clicking on the database name, you will see the list of database tables.

Database-Tables.png
Browse:
You can only browse the database tables with existing records. The Browse window opens with the records when you click on the table name.

Browse.pngBy simply clicking on the Pen symbol, you can edit the selected record.

Structure:
In the structure screen you will see the structure of database’s table. You will see the field name, their data types, collation, attributes etc. You can change the field’s structure as well as delete a field. Also, you can assign indexes i.e. Primary, Unique, Index, Fulltext.

Structure.png
Search:
You can create a search query for the selected table by using Search action. Either you can write the WHERE clause or use the "query by example" option. You must click on the Go button to perform search query.

Search.png
Insert:
You can insert the records in database table through the Insert action. To insert a new record you need to fill the appropriate values and click on the Go button.

Insert.png
Empty:
You can empty your database table using the Empty option. It will remove the records and keep the table blank.

Empty.png
Drop:
You can delete the table as well as delete stored records in it by using the Drop option.
Drop.png
See more videos of cPanel tutorials.
 
0
Comment
Author:Ajit Khodke
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
0 Comments

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Join & Write a Comment

This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Other articles by this author
Suggested Courses

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month