Categories

PHPMyAdmin (8)

Articles

How many simultaneous MySQL connections can a MySQL user open?

In the shared hosting environment a MySQL user can open up to 30 simultaneous connections to the...
How to assign a user to a MySQL database in cPanel?

Access your CPanel at https://www.yourdomain.com:2083 (replace yourdomain.com with your real...
How to create a MySQL database in cPanel?

Access CPanel -> Databases Select "MySQL Databases" Enter the name of the database in the...
How to create a MySQL user in cPanel?

Please note that creating a MySQL user in cPanel does not imply granting the user the right to...
How to delete a MySQL database in cPanel?

Access CPanel -> Databases sections Select "MySQL Databases" Go to Current Databases...
How to delete a MySQL user in cPanel?

Access CPanel Select "MySQL Databases" Press the "Delete" button corresponding to the MySQL...
How to revoke user privileges from a MySQL database in cPanel?

Access CPanel Access MySQL Databases -> Current Users Press the "Delete" button...
I cannot create views in MySQL / MariaDB

Regular database users cannot create views in MySQL / MariaDB. If you try to execute the CREATE...
Is MySQL / MariaDB access restricted to "localhost"?

To access the MySQL / MariaDB server from a remote location please contact our Tech Department....
Managing MySQL databases in cPanel

CPanel includes a very powerful tool for managing MySQL databases - "phpMyAdmin". For more...
What generates the error: "MySQL server has gone away"?

This error can occur in several situations: MySQL query takes too long and a time-out is...
What is SQL? What is MySQL?

SQL (Structured Query Language) is the language used by most relational database systems. MySQL...
What is the maximum execution time of a MySQL query?

To ensure service quality for all users, each MySQL query can run for up to 8 seconds (maximum)....
What is the maximum size of a MySQL database?

HostX does not limit the number of databases that can be created within an account. However, to...