Articles
Connecting to MySQL from your own computer
By default, databases only accept connections from the server itself. That is deliberate: it...
Creating a database and a database userAn application needs two things: a database to store data in, and a user with permission to use...
How databases and database users are namedDatabase and user names are always prefixed with your cPanel account name and an underscore. You...
Importing a large databasephpMyAdmin has an upload size limit, and a large database import will fail part-way through...
Managing your MySQL databasesEverything to do with databases is in cPanel, in two places: MySQL Databases for creating and...
Repairing and optimising database tablesTwo different operations that are often confused. Repair Fixes a table reporting itself as...
Using phpMyAdmin without breaking anythingphpMyAdmin, in cPanel, gives you direct access to your data. That is useful and it is also the...
