Tierra Hosting Guides
Empowering you with knowledge.
Welcome to Tierra Hosting's comprehensive guides page, where you can find step-by-step instructions and valuable insights to enhance your web hosting and domain management experience. Our dedicated team of experts has crafted detailed guides to help you navigate various aspects of web development, control panel functionalities, and more. Whether you need assistance setting up email addresses on mobile or email software, understanding different file types and their limitations, or learning essential PHP functions for web development, our guides have got you covered. Explore our collection of informative posts to expand your knowledge and make the most out of your hosting and domain services.
What is a MySQL database?
Posted: 2023-05-28 20:08:13
MySQL is one of the most popular and widely used Relational Database Management Systems (RDBMS).
Many web applications such as forums, content management systems, etc. use a database to store data (content). The majority of web applications that use databases require a MySQL database to operate.
For example, the popular web applications phpBB, Joomla, Drupal, osCommerce and WordPress store their data in MySQL databases.
It is almost guaranteed that if your web application (especially those written in PHP) requires the use of a database, then it will need exactly a MySQL database or will at least support MySQL.
To be sure, however, check the technical requirements of the web application. The data in a MySQL database is structured in tables which consist of columns and rows.
Whenever your script (application) needs to access specific data, it "asks" (makes query) the MySQL database for the content of a specific field (the intersection of a column and a row in a table).
To create a MySQL database in your hosting account, go to the Databases > MySQL Databases section and click on the Add MySQL tab, on the right side of your Control Panel.
Usually a separate database is created for each web application that you install. Thus, the web applications can be managed easier.
In the MySQL Databases section you can also see a list of all MySQL databases that you have.
Note that the database name and the username are the same. For example, if you have a database whose name is account database, then the username for the database will be account database and vice-versa.
On our servers a database can only have one user (that is created by default) and new users cannot be created. The default user of the database has all the privilege's.
When you set up a script to use one of your databases you need the database name and username (which are the same, as mentioned above), the password and the MySQL host/server. You can find the MySQL host under the table with your existing MySQL databases. It is usually localhost.
Recent Guides
- Understanding Image Formats: Choosing the Right Format for Your WebsitePosted: 2023-06-22 21:49:58
- How to Redirect/Forward a Website (URL redirection)Posted: 2023-06-19 23:06:04
- How to add a Catch-All Email addressPosted: 2023-06-10 14:44:30
- What is a MySQL database?Posted: 2023-05-28 20:08:13
- How to Set Up an Email Address on Mobile or Email SoftwarePosted: 2023-04-16 13:17:20
- Understanding File Types: What Can and Cannot be Done with Different File ExtensionsPosted: 2023-04-16 13:00:06
- 5 Essential PHP Functions for Web DevelopmentPosted: 2023-04-16 12:32:23
- Securing Your PHP Code: Best PracticesPosted: 2023-04-15 21:19:21
- Working with Dates and Times in PHPPosted: 2023-04-15 21:07:05
- Basic PHP Functions for Novice Users - Part 3Posted: 2023-04-15 21:02:12
- Basic PHP Functions for Novice Users - Part 2Posted: 2023-04-15 20:55:05
- Basic PHP Functions for Novice UsersPosted: 2023-04-15 20:41:15