How can I view/modify data in my MySQL database?

There are two ways to view your MySQL database with Ultra Web Hosting:

Using phpMyAdmin

  1. Go to your Ultra Web Hosting control panel.
  2. Click on the "MySQL" tab.
  3. Click on the "phpMyAdmin" link.
  4. Enter your username and password.
  5. Click on the "Go" button.

Using the MySQL command line

  1. Log in to your Linux web server via Secure Shell.
  2. Open the MySQL client program on the server in the /usr/bin directory.
  3. Type in the following syntax to access your database:
$ mysql -h {hostname} -u username -p {databasename}
{hostname} is the hostname of your web server.
{username} is your MySQL username.
{password} is your MySQL password.
{databasename} is the name of the database you want to access.
 

Once you have accessed your database, you can use the MySQL command line to view the data. For example, to view the list of tables in the database, you would type the following command:

$ show tables;

To view the data in a specific table, you would type the following command:

$ select * from {tablename};

 

For more information on how to use the MySQL command line, please refer to the MySQL documentation: https://dev.mysql.com/doc/refman/8.0/en/mysql.html.

 

Which method you choose will depend on your preference and level of technical knowledge. If you are not familiar with the MySQL command line, then phpMyAdmin is a good option. It is a web-based interface that makes it easy to view and manage your MySQL databases.

If you still need help accessing your database please contact Ultra. Our support is standing by and waiting to help you.

 


 

 
  • 465 Users Found This Useful

Was this answer helpful?

Related Articles

Disable MySQL strict mode on cPanel server

here are the steps on how to disable MySQL strict mode on a cPanel server:   Log in to your...

Test MySQL Connection

The following is a great way to verify a MySQL / MariaDB database connection issue. Create a file...

When trying to connect to MariaDB or MySQL you receive error 2003 Cannot connect to MySQL on xxxxxx on port 3306 10060

The error 2003 "Cannot connect to MySQL on xxxxxx on port 3306 10060" means that the MySQL...

Increase PHP Memory

Fatal error: Allowed memory size of xxxxxxxxx bytes exhausted (tried to allocate xxxxxxxx bytes)....

Learn About MariaDB

MariaDB is a fork of MySQL, which was created by Michael "Monty" Widenius. MySQL was acquired by...