Vimzaa Knowledgebase
  • Getting Started
  • Virtual Private Servers
    • What is Virtual Private Server
    • Getting Started With Linux
      • An Introduction to the Linux Terminal
      • Basic Linux Navigation and File Management
      • An Introduction to Linux Permissions
      • An Introduction to Linux I/O Redirection
      • Linux Permissions Basics and How to Use Umask on a VPS
    • Connect with SSH
      • How to Add SSH Keys to VPS
      • SSH Essentials: Working with SSH Servers, Clients, and Keys
    • How To Edit the Sudoers File on Ubuntu and CentOS
    • Introduction to Nginx and LEMP on Ubuntu
      • Initial Server Setup with Ubuntu
      • Installing LEMP Stack on Ubuntu 14.04
      • Installing LEMP Stack on Ubuntu 16.04
    • Anti-Spam Best Practices
  • cPanel Hosting
    • Cloudflare
    • cPanel - Advanced
      • How to add and manage cron jobs / scheduled tasks in cPanel
      • How to track DNS using cPanel
      • How to create custom ‘error pages’ in cPanel
      • How to flush your local machines DNS Cache
      • How to use the Google Public DNS for faster DNS lookups
      • How to check if your domain has ‘propagated’ following DNS changes
      • Install Wildcard SSL Certificates using LetsEncrypt with cPanel
      • Correct SPF Records
      • Check processes or users with high iowait (99.99%) from Cloudlinux Logs
      • How to tune MySQL on a cPanel server with MySQLTuner
      • Clear disk space on cPanel Server by removing backups, trash etc
      • Add monitoring script to server for monitoring top, iostat etc
      • Testing your site before ‘go-live’ by editing your hosts file
    • cPanel - Domains
      • How to use the Site Publisher in cPanel
      • Managing addon domains in cPanel
      • What is the difference between addon domains and ‘alias’ domains?
      • Managing subdomains in cPanel
      • Managing domain aliases in cPanel
      • Managing domain redirects using cPanel
      • How to use the Simple Zone Editor in cPanel for managing your DNS Records
      • How to use the Zone Editor within cPanel to manage your DNS records
      • How to redirect all domain ‘alias’ to the main domain using cPanel
      • How to enable Cloudflare on your cPanel account
      • How to check what nameservers a domain is using
      • How to create Custom Nameservers / Vanity Nameservers
      • How do I transfer a domain name to Vimzaa?
    • cPanel - Managing Databases
      • Managing a MySQL Database in cPanel with phpMyAdmin
      • Manage MySQL Database in cPanel
      • Simplified database creation with the cPanel MySQL Wizard
      • Managing MySQL databases remotely using ‘Remote MySQL’ in cPanel
    • cPanel - Managing Email Accounts
      • Managing email accounts with cPanel
      • How to create and manage email forwarders using cPanel
      • Managing email routing with cPanel
      • Change Your E-Mail Account Password
      • Improving mail deliverability (SPF & DKIM)
    • cPanel - Managing Files
    • cPanel - Metrics
    • cPanel - Software and Applications
    • cPanel - Security
    • SiteBuilder Pro
    • Enable or disable PHP modules
    • How can I migrate my cPanels to Vimzaa Website Hosting?
    • SSH Access to cPanel Servers
    • How do I add another domain to my Hosting Account?
    • How do I access WHM (Web Host Manager)?
  • Plesk Hosting
    • An Introduction to Plesk
    • Getting Started with Plesk
      • How to login to Plesk for the first time
      • The Plesk User Interface Explained
      • Understanding Subscriptions in Plesk
      • How to upload content with Plesk
      • How to manage mailboxes / mail accounts with Plesk
      • Managing Web ApplicationsManaging Web Applications
    • Plesk Tutorials
      • A basic getting started guide to creating your first site with Plesk
      • How to manage DNS and nameservers using Plesk
    • Plesk Funtionality - Explained
      • Managing your User Account in Plesk
      • Managing your Web Hosting with Plesk
  • Game Servers
    • Setup Teamspeak 3 Server on Linux
    • Installing SteamCMD for Steam Game Servers
  • SSL Certificates
  • Domains
    • Can I register or transfer my domain to Vimzaa
    • Can I buy a domain name together with a web hosting plan
    • Default nameservers for shared webhosting
Powered by GitBook
On this page
  • Overview
  • How to create database in cPanel using the MySQL Database Wizard-
  • Operations to Perform on the Database
  • Browse
  • Structure
  • Search
  • Insert
  • Empty
  • Drop
  1. cPanel Hosting
  2. cPanel - Managing Databases

Managing a MySQL Database in cPanel with phpMyAdmin

Overview

While creating a database, following are some additional things that they need to organize –

  • 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 Privilegesand 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: Helps to organize your schemas, tables, and columns.

  • SQL: Runs SQL query/queries on a database.

  • Search: Searches words or values inside database tables.

  • Query: SQL defines a set of commands, such as SELECT, INSERT, UPDATE, DELETE, CREATE TABLE and etc.

  • Export: Exports database in different formats such as CSV, PDF, SQL, XML, Text etc.

  • Import: Imports 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. Follw the steps below to create database

Step1:

Click on the Databases tab. Choose the database which you want to manage and click on the database name.

Step 2:

After clicking on the database name, you will see the list of database tables.

Operations to Perform on the Database

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.

By 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.

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.

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.

Empty

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

Drop

You can delete the table as well as delete stored records in it by using the Drop option

PreviouscPanel - Managing DatabasesNextManage MySQL Database in cPanel

Last updated 6 years ago

Databases-in-phpMyAdmin
Database-Tables
Browse
Structure
Search
Insert
Empty
Drop