29 questions in this topic
Expand a question to see the answer. The content is visible in HTML and can be indexed by search engines.
281. How to create a MySQL/MariaDB database?
For the topic "how to create a MySQL/MariaDB database", first check the settings in phpMyAdmin, the database user and connection parameters.
You create the MariaDB/MySQL database in cPanel, then create a database user and give him permissions to this specific database. The CMS application needs a database name, user, password and database host.
If the application runs on the same hosting, the database host is usually local. A connection error most often means wrong password, lack of permissions or wrong database name.
282. How to create a database user?
For the topic "how to create a database user", first check the setting in phpMyAdmin, database user and connection parameters.
You create the MariaDB/MySQL database in cPanel, then create a database user and give him permissions to this specific database. The CMS application needs a database name, user, password and database host.
If the application runs on the same hosting, the database host is usually local. A connection error most often means wrong password, lack of permissions or wrong database name.
283. How to grant permissions to the database?
For the topic "how to grant permissions to the database", first check the settings in phpMyAdmin, the database user and connection parameters.
You create the MariaDB/MySQL database in cPanel, then create a database user and give him permissions to this specific database. The CMS application needs a database name, user, password and database host.
If the application runs on the same hosting, the database host is usually local. A connection error most often means wrong password, lack of permissions or wrong database name.
284. How to connect applications to the database?
For the topic "how to connect applications to the database", first check the setting in phpMyAdmin, the database user and the connection parameters.
You create the MariaDB/MySQL database in cPanel, then create a database user and give him permissions to this specific database. The CMS application needs a database name, user, password and database host.
If the application runs on the same hosting, the database host is usually local. A connection error most often means wrong password, lack of permissions or wrong database name.
285. How to connect to the database from outside?
Remote database connections, if available, should be limited to specific IP addresses. Opening the database widely to the Internet increases the risk of attacks.
286. Do we allow remote connections to the databases?
Remote database connections, if available, should be limited to specific IP addresses. Opening the database widely to the Internet increases the risk of attacks.
287. How to make a copy of the MySQL/MariaDB database?
For the topic "how to make a copy of the MySQL/MariaDB database", first check the settings in phpMyAdmin, the database user and the connection parameters.
You can make a copy of the database via phpMyAdmin, cPanel backup tools or SSH, if the account has such access. Before updating the CMS, store or large import, make a copy of the files and database.
When importing, pay attention to file size, encoding, engine version and timeouts. For large databases, import via SSH may be better.
288. How to make a copy of the database via SSH?
For the topic "how to make a database copy via SSH", first check the settings in phpMyAdmin, the database user and the connection parameters.
You can make a copy of the database via phpMyAdmin, cPanel backup tools or SSH, if the account has such access. Before updating the CMS, store or large import, make a copy of the files and database.
When importing, pay attention to file size, encoding, engine version and timeouts. For large databases, import via SSH may be better.
289. How to restore a copy of the database?
For the topic "how to restore a database copy", first check the settings in phpMyAdmin, database user and connection parameters.
You can make a copy of the database via phpMyAdmin, cPanel backup tools or SSH, if the account has such access. Before updating the CMS, store or large import, make a copy of the files and database.
When importing, pay attention to file size, encoding, engine version and timeouts. For large databases, import via SSH may be better.
290. How to import a database via phpMyAdmin?
For the topic "how to import a database via phpMyAdmin", first check the settings in phpMyAdmin, the database user and connection parameters.
You can make a copy of the database via phpMyAdmin, cPanel backup tools or SSH, if the account has such access. Before updating the CMS, store or large import, make a copy of the files and database.
When importing, pay attention to file size, encoding, engine version and timeouts. For large databases, import via SSH may be better.
291. How to export database via phpMyAdmin?
For the topic "how to export database via phpMyAdmin", first check the settings in phpMyAdmin, database user and connection parameters.
You can make a copy of the database via phpMyAdmin, cPanel backup tools or SSH, if the account has such access. Before updating the CMS, store or large import, make a copy of the files and database.
When importing, pay attention to file size, encoding, engine version and timeouts. For large databases, import via SSH may be better.
292. What to do with a row error in phpMyAdmin?
For the topic "what to do with row errors in phpMyAdmin", first check the setting in phpMyAdmin, the database user and the connection parameters.
We diagnose problems in phpMyAdmin, damaged tables and slow queries based on the error message, logs, table structure and slow query log. A slow page may be due to missing indexes, large tables, or plugins generating too many queries.
In the report, provide the database name, operation, error message and time of the problem.
293. What to do when phpMyAdmin does not allow you to create another database?
For the topic "what to do when phpMyAdmin does not allow you to create another database", first check the settings in phpMyAdmin, database user and connection parameters.
We diagnose problems in phpMyAdmin, damaged tables and slow queries based on the error message, logs, table structure and slow query log. A slow page may be due to missing indexes, large tables, or plugins generating too many queries.
In the report, provide the database name, operation, error message and time of the problem.
294. How to repair a corrupt MySQL/MariaDB table?
For the topic "how to repair corrupt MySQL/MariaDB tables", first check the setting in phpMyAdmin, database user and connection parameters.
We diagnose problems in phpMyAdmin, damaged tables and slow queries based on the error message, logs, table structure and slow query log. A slow page may be due to missing indexes, large tables, or plugins generating too many queries.
In the report, provide the database name, operation, error message and time of the problem.
295. Where to find database slow_log?
For the topic "where to find database slow_log", first check the setting in phpMyAdmin, database user and connection parameters.
We diagnose problems in phpMyAdmin, damaged tables and slow queries based on the error message, logs, table structure and slow query log. A slow page may be due to missing indexes, large tables, or plugins generating too many queries.
In the report, provide the database name, operation, error message and time of the problem.
296. How to analyze slow queries?
For the topic "how to analyze slow queries", first check the setting in phpMyAdmin, database user and connection parameters.
We diagnose problems in phpMyAdmin, damaged tables and slow queries based on the error message, logs, table structure and slow query log. A slow page may be due to missing indexes, large tables, or plugins generating too many queries.
In the report, provide the database name, operation, error message and time of the problem.
297. What is worth knowing about mariaDB 11?
MariaDB 11 and MySQL 8 are modern database engines used by web applications, CMS and stores. In the description, it is worth specifying application compatibility, performance, indexes, backup and requirements of specific CMS.
298. What is worth knowing about mySQL 8?
MariaDB 11 and MySQL 8 are modern database engines used by web applications, CMS and stores. In the description, it is worth specifying application compatibility, performance, indexes, backup and requirements of specific CMS.
299. When is a website problem due to the database and not PHP?
The website problem results from the database when errors indicate connection to the database, queries are slow, tables are damaged or the application only works after disabling a specific plug-in/module. Check access data, user permissions and application logs.
If the error is intermittent, provide occurrence times and URLs so that PHP logs, database and LVE limits can be compared.
300. How to diagnose a database connection error?
The website problem results from the database when errors indicate connection to the database, queries are slow, tables are damaged or the application only works after disabling a specific plug-in/module. Check access data, user permissions and application logs.
If the error is intermittent, provide occurrence times and URLs so that PHP logs, database and LVE limits can be compared.
10188. How to log into the database via phpMyAdmin?
The client accesses phpMyAdmin from cPanel: Databases → phpMyAdmin. Access takes place after logging in to cPanel, without a separate password for phpMyAdmin. Databases and users should be created in cPanel in the MySQL/MariaDB Databases or Manage My Databases tool, and operations on existing databases should be performed in phpMyAdmin: import, export, SQL queries, table repair.
10253. How to connect to a MySQL database from outside?
Remote connection to MySQL requires a created database and user and adding the client's public IP in cPanel → Remote MySQL / Remote Database Access. The host is the name of the server or the specified database host, port usually 3306. For security reasons, we recommend limiting access to a specific IP or using an SSH tunnel, if available. With a variable IP, the client will have to update the entry.
10254. How to repair a corrupt table in MySQL?
You can try to repair a damaged MySQL table in cPanel → MySQL Databases via Repair Database or in phpMyAdmin by selecting the table and the Repair table option. Before repairing, you must export the database. If the table is InnoDB and the standard repair does not work, you may need to analyze MySQL logs and restore from a backup.
10264. How to back up or restore a MySQL database?
A copy of the MySQL database is made in cPanel → Backup/Backup Wizard as a partial MySQL backup or in phpMyAdmin via Export. Restore can be done via Backup Wizard, phpMyAdmin Import or mysql CLI, depending on the file size. Before restoring, you should make a current export, because the import may overwrite the data. Installatron applications can be restored from an Installatron backup, which restores the files and database together.
10267. How to restore a copy of MySQL database?
The MySQL database can be restored from cPanel Backup Wizard, phpMyAdmin Import, mySQL CLI or from the Installatron application backup. Before restoring, you must perform a current export of the current database. If the SQL file is large, importing via phpMyAdmin may timeout or upload limits - then it is better to import via SSH or contact support.
10284. How to solve the problem: MySQL super user?
On shared hosting, the client does not receive MySQL superuser/root privileges. Access is limited to databases and users created in cPanel, with selected permissions for specific databases. Global permissions, SUPER, FILE, PROCESS and database server administration are reserved for the administrator. If your application requires such permissions, you need to consider a VPS/dedicated database server.
10316. How to export a MySQL database?
MySQL database export is performed in phpMyAdmin: select database → Export → Quick or Custom → SQL → Go. Alternatively, you can download a partial copy of the database from cPanel → Backup Wizard. It is better to export large databases via SSH using the mysqldump command, if SSH is available. The export should be stored outside public_html and preferably downloaded locally.
10336. How to create a new MySQL database?
A new MySQL/MariaDB database is created in cPanel → MySQL Databases or Manage My Databases. After creating the database, create a database user, add it to the database and grant permissions. The database and username usually have a cPanel login prefix, e.g. login_databasename. These data are then entered in the application configuration.
10365. How to import a MySQL database?
The MySQL database is imported after creating an empty database and user in cPanel. In phpMyAdmin, select database → Import → .sql or .sql.gz file → Go. In the case of large databases, phpMyAdmin may exceed the upload or time limit, then you should use SSH: mysql -u USER -p DATABASE_NAME < file.sql or ask support for import. After import, you need to update the application's connection data.