Articles
Does Toshost support PostgreSQL?
Our standard cPanel shared and reseller plans are built around MySQL/MariaDB, which covers...
How big can my database be?
There is no fixed per-database size limit; your databases count toward your plan's total disk...
How do I connect my application to MySQL? (database host)
In almost all cases the database host is localhost because your site and MySQL run on the same...
How do I create a MySQL database and user?
Create a database and user from cPanel in a couple of minutes:Log in to cPanel from your client...
How do I delete a MySQL database?
Removing a database is permanent, so back it up first. From cPanel:Open phpMyAdmin, select the...
How do I enable Remote MySQL access?
By default MySQL only accepts connections from localhost. To connect from an outside server or...
How do I find my database name, username and host?
Your live database details are usually stored in your application's config file, and you can...
How do I fix "Error establishing a database connection"?
This means your site cannot reach its database. Work through these:Check credentials: confirm the...
How do I grant privileges to a database user?
A user must be attached to a database with the right privileges before your app can use it:Log in...
How do I import a large database?
phpMyAdmin has an upload size limit, so large .sql files often fail. Use one of these...
How do I import or export a MySQL database?
Both are done in phpMyAdmin from cPanel.Export:Open phpMyAdmin and select your database in the...
How do I manage my database with phpMyAdmin?
Use phpMyAdmin in cPanel to browse and edit your data:Log in to cPanel from your client area and...
How do I optimize or repair a MySQL database?
If your site is slow or a table looks corrupted, optimize or repair it in phpMyAdmin:Open...
How do I reset a database user's password?
Change a MySQL user's password from cPanel:Log in to cPanel from your client area and open MySQL...