Join Ray Villalobos for an in-depth discussion in this video Creating a database with a custom control panel, part of Learning How to Manage a Hosted Web Site.
To create a database on most web hosts, you'll have to log into your control panel, create user as well as a database. 1and1 is a bit different than most web hosts and that the databases are not part of your server but are created in a separate web host. So, the login information is slightly different. So, let's take a look at how that's done. To log into your control panel just go to 1and1.com, look at the top of the screen for the Customer Login. I'll click on that, I'll type in my domain name and password and click Login. Once, you get into your control panel, you're going to want to go to MySQL Administration, and that's under Domains & Web Space and Web Space.
I'll click on that. Here's where your databases can be set up. Depending on the plan that you have, you're going to have a number of databases that you can use. So, the screen might look a little bit different for you. So, I'm going to hit New Database right here and I'm going to type in a name for my database. I'll just call it wordpress and I'll type in a password and I'll hit Set Up. Now, this is where 1and1 is a bit different than most other web hosts. Where in most cases your hostname would always be localhost when creating a database on a server, on 1and1, you actually connect to a separate computer or a separate server that hosts the database.
You can see the host name here is different than in most other plans. So, the host name here is db etcetera, etcetera and that's definitely different than localhost, which is what you put in in most of the other plans. Now, also notice that although we put a database name, a username is also assigned to us by 1and1. So, it adds username that probably starts with like dbo and then some sort of number after that. So, make sure you copy this information carefully because you're going to need it to access your database later on. You'll definitely need the database name, the host name, the user name and then the password.
I'm going to click to Go To Overview and you'll see that my username information is right here and the setup has been started. Whenever you create a database in 1and1, it also takes a little bit longer than in most other systems. So, you may have to wait a while before your database can be accessed. So, you can just keep on hitting refresh until you see that the status for this database is ready. If you do need to create tables or modify records, most web hosts provide an application called PHP MySQL. So, you can access that by clicking on this button right here.
Creating and managing databases is a complicated matter. So, if you want to find out more information, I suggest you check out MySQL Essential Training from the Online Training Library.
- Choosing server features
- Getting a domain name
- Using an FTP client
- Understanding link references
- Setting up webmail with forwards
- Protecting user information and directories
- Working with databases
- Creating shortcuts with subdomains