![]() ![]() Shows your Database was Created Completing Manual WordPress Installation I am sure you are relieved at this point. Overall, you don't really have to touch much here to move on in the process. Generally you will be fine but worth doing. Test Connection button: Click this and it will tell you if you are good. Default Schema: I would say just leave blank for now because we will cover that shortly below.Password: I would go ahead for good measure and click on “Store in Vault”.Username: If you have chosen it to be “root”… it will be sitting there for you.Hostname: Will be auto populated by default (write that down!!!!).You have the option to change that though. Connection Method: It defaults to “Standard (TCP/IP).Just give that ol' plus sign a click and up pops a window over your screen as shown below. S tep 2: You will want to select the “+” sign next to “MySQL Connections” at the top left hand side (main screen). Now, my screenshot here is showing you a couple “tiles' but that is only because I've created a few. You will come to the “home” screen where you should see something similar to this. Step 1: Assuming you have Workbench ready to roll…. I recommend choosing a complex and strong password if you choose to leave your username the same. Your default username will always be “root”. ![]() I won't be going over on how to install it but the prompts are fairly straight forward to get things set up. If your dedicated or virtual private server does not already have MySQL Workbench installed, head on over to get it downloaded: Go HERE. How to Get Started with MySQL Workbench For WordPress Database That site was built on Bootstrap and was NOT currently using WordPress as it's “engine”. The goal I was accomplishing was to set up a WordPress blog within an existing site. This is where MySQL Workbench comes into play. There is no easy control panel to quickly eliminate several steps to create a database for your new WordPress website. On this current project, they were using what I refer to as a raw server. Typically that entails a pretty control panel to make your life easier. Now, most hosting companies allow you to create an individual database manually and off to the races you are. Recently I came across the need to do it manually. Ideally this post is for someone that is fairly new but has some experience with setting up WordPress. Most people experience an easy way to use cPanel, Fantastico, or Simple Scripts which provide a push button approach of installing and doing the heavy lifting for you such as your Wordpress files on your domain and creating the database. Setting up a MySQL database while installing WordPress on their host has came a long ways compared to even 5 years ago. ![]()
0 Comments
Leave a Reply. |