Tips and tricks on developing web sites

Creating a WordPress Database

Start phpMyAdmin by typing localhost/phpmyadmin in your development server browser.

Set your collation to utfmb4_unicode_ci if it isn’t set to that already. Click on the Databases tab. Under Create database type in your prefix_domain. If you have a really long domain name use an abbreviated version that you will recognize. In this example, we are entering examp_example. Don’t add .com. Press Go and just like that you have an empty database.

Click on the House Icon under the phpMyAdmin title. A new series of tabs will appear. Click on User accounts, then New->Add user account. You will assign a top-level account here that will have full access to the database and be used by WordPress engine. You can be very cryptic in the name, or use something logical like examp_exampleadmin. Remember that the username needs to start with your account’s assigned prefix. Make sure that your password is cryptic! Use a combination of symbols, numbers and letters or use the Generate button. Make sure to record this password and username. Use the utfmb4_unicode_ci collation. Also change the Host name: to local and click the Global privileges option to Check all. Scroll down to the bottom and click on the Go button. You will now have assigned that user account as the full administrator of your database. You can verify that by clicking on your database to the left and looking at the Privileges tab. That’s all you need to do for setting up the database, WordPress will take it from here.