•  Home
  •  Dashboard
  •  Company
    • About Us
    • Blog
    • Careers
    • Contact Us
    • Data Centers
    • Looking Glass
    • Network
    • Reseller
  •  Hosting Services
    • Backup
    • Content Delivery Network
    • Colocation Hosting
    • Dedicated Hosting
    • DDoS Mitigation
    • IP Transit
    • Private Cloud
    • Wavelength
  •  Solutions
    • Ecommerce
    • Finance
    • Gaming
    • Hosting
    • Management
    • Security
    • System Integrator
  •  Support
    • Community
    • Knowledge Base
    • Open A Ticket
  •  USA & Canada: 800-933-1517
  •  International: 626-549-2801
  •  Email: sales@psychz.net
  • Services
    • Dedicated Servers
    • Colocation
    • Private Cloud
    • DDos Protection
    • IP Transit
    • CDN
    • Backup
  • Solutions
    • Ecommerce
    • Security
    • Gaming
    • Hosting
    • Management
    • Finance
    • System Integrator
  • Dashboard

How to create a table in mysql using phpmyadmin?

  • Home
  • Client
  • Qa Forum
  • How to create a table in mysql using phpmyadmin?

Posted By: Jared | 1 Replies | Last Reply On: Feb 01, 2019 05:19:45

Is anyone able to provide steps on how to create a mysql table using phpmyadmin? 

Psychz - Steve

Votes: 0Posted On: Feb 01, 2019 05:19:45
 

Step 1.

Log into your cPanel account using the login details you have.

 

Step 2.

Once you have logged into your cPanel account, you will see multiple options on your dashboard.

Go to 'Databases' and click on 'MYSQL Databases'. 

 

Step 3.

Once you are inside the MYSQL Databases you will see an option to 'Create New Database' as shown below

Let us create a test database and name it 'test_dbase'. Click on 'Create Database' to create the database.

 

Step 4.

Now go back to the main menu of the cPanel and click on 'PHPMyAdmin' under 'Databases' as shown below

This will take you to page where you can see all the databases including the one we created named 'test_dbase'

 

Step 5.

Click on the database that we just created which would appear on the left-hand side of the screen.
For your reference, please see the arrow marked in the screenshot below

Once you do, you will see the option to create a table on the right hand side of the screen.

 

Step 6.

You can enter the name of the table that you want and the number of columns it will have.

Here, we have named the table as 'test_user' and allowed the number of columns to be '5'. Click on 'Go' button to create the table.

 

Step 7.

Alright, our table is now created. We need to enter the details that are going to go into the table.

Let the first column be User_Id which we will keep type as 'INT' because we want it to be purely a number. Here, I have defined the length of the number to be 4. You can choose as per your requirement. Lastly, you can allow the Index to be 'PRIMARY' since this is going to be a Unique key.

Please refer to the below screenshot for more details

Similarly, you can input the details in rest of the columns as shown above. Click on 'Save' button to confirm your entries.

 

Voila!!! You have successfully created a MySQL table using PHPMyAdmin.

Was this reply helpful?

Related topics

  • Ubuntu remove mysql
  • Installing MariaDB on Centos 7
  • Top SQL Databases
  • Installation of Lamp Stack on CentOS 7
  • IPv4 - Subnetting made easy
  • How to monitor MySQL using Nagios?
  • How to create website using cPanel?
  • Install MySQL Centos 7
  • Dedicated MySQL Server
  • Automatic Backup Of MySQL Database
  • Regex: regular expression cheat sheet
  • In Comparison: SQL VS NoSql
  • Best Open Source Monitoring Tools For Server
  • CDN and Load Balancer: Ultimate combination for efficient content delivery
  • Best Open-Source Software For Linux Users
Hosting Services
  • Dedicated Hosting
  • Colocation Hosting
  • Backup
  • IP Transit
  • DDoS Mitigation
Support
  • Portal Login
  • Knowledgebase
  • Community
Company
  • About Us
  • Contact Us
  • Network
  • Data Centers
  • Looking Glass
  • Affiliates
  • Reseller
  • Blog
Policies
  • Privacy Policy
  • Acceptable Usage Policy
  • Terms and Conditions
  • Service Level Agreement
Company
  • Psychz Networks,
    A Profuse Solutions Company
    611 Wilshire Blvd #300
    Los Angeles,California 90017
    USA
  • US/Canada: 800-933-1517
  • International: 626-549-2801
Subscribe to Our Mailing List
* indicates required
Copyright © 2023 Psychz Networks, A Profuse Solutions Inc Company