MySQL is one of the most widely used systems for storing and managing data. It organizes information in a structured format, allowing websites and applications to operate efficiently and reliably.
Many popular web applications—such as WordPress, Joomla, Drupal, or osCommerce—depend on MySQL databases to store content, settings, and user data. If your website or app requires a database, especially PHP-based applications, it will most likely need MySQL.
A MySQL database organizes data into tables, which consist of columns and rows. When your website needs specific information, it sends a query to the database to retrieve it.
TrexHost fully supports MySQL databases, making it easy to create, manage, and use databases for your website or web application. With TrexHost, you get reliable database performance and full control through your hosting Control Panel.
Creating a MySQL Database in TrexHost Hosting Account
To create a MySQL database in your TrexHost account:
- Log in to your Control Panel and go to Databases > MySQL Databases.
- Click the Add MySQL tab on the right-hand side.
- Fill in the required fields to create your new database.
Typically, a separate database is created for each web application you install. This helps you manage applications individually and keeps data organized.
In the MySQL Databases section of your Control Panel, you can view a list of all databases associated with your account.
Database Username and Access
On TrexHost servers, the database name and username are the same. For example, if your database is named account_database, the username will also be account_database.
Each database has one default user, created automatically with full privileges. Additional users cannot be added, ensuring secure and controlled access to each database.
Using Your Database with a Web Application
When setting up a script or application to connect to your MySQL database, you will need the following information:
- Database Name
- Database Username (same as the database name)
- Password
- MySQL Host/Server
The MySQL host is typically listed in your database table—most often it is localhost.
With your MySQL database ready, your website or application can store and retrieve data quickly and securely. Start today with TrexHost hosting and enjoy full MySQL support for your website or web applications!