How To Create A Database In Cpanel

The first thing you should do is create your database. Some hosting companies will create one for you at sign up, so you may want to check the registration confirmation and welcome info they sent you. If you don’t have one, then you can follow this example for setting up a MySQL database on BlueHost, which is powered by cPanel.

You’ll need to login to your control panel, which you usually do by either logging in through your hosting company’s site, or through your own site with an address like “manage.yourwebsite.com” or “yourwebsite.com:8448″. Refer to your registration email from your hosting company for that information.

Once you are logged in, on the home page of your admin control panel, click on the link for the MySQL database under the Database heading:You’re now at the place where you can create databases and users as well as assign users to databases. Now, in the world of computers, databases belong to users, which means before we can create a database, we need to create a user. To create a user, simply enter their username and password here:Once you’ve added the user, go back to the database management screen. Now you’re ready to create the database, which you can do by simply entering the name here:Now that you have a database and a user, you need to assign the user to the database, which you can do by selecting the username and the database name from the drop down menus. Be sure to leave the “all” option checked because you want the user to have full access privileges. Now click the “Add user to db” button here:Your database is now set-up! Be sure to write down the database name, username, and password as you will need them in Step 3. Please note that some hosting companies will tag characters on the front of your database name and username, for example you may have entered “wordpress” for your database name, but your hosting company made it “you_wordpress”.

Step 2 – Download
Now that we have all of the pieces in place, the next thing you’ll need to do is download WordPress. WordPress comes as one of 2 file formats: “.zip” and “.tar.gz”. If you don’t know what “.tar.gz” is, then I recommend downloading the zip file. The downloaded file should either unzip automagically, or you’ll need to do it manually. Unzipping the file manually should just be a matter of double-clicking on the file, which should open the application you have to unzip files. If you don’t have an unzipping application, then I recommend WinZip for a PC, and StuffIt Expander for Macs. Both are free to demo.

Unzipping the file should produce a single folder full of the application files. Open that folder and move on to the next step.

Step 3 – Edit the config file
In that folder there should be a file called “sample-wp-config.php”. Open that file with a text editor like Notepad or TextEdit. Do NOT use Microsoft Word because it doesn’t save files in a format that is compatible with the Web!

At the top of the config file there should be a place to enter your database name, username, and password; enter the names you wrote down from the end of Step 1. Save that file in the same folder, but change the file name by deleting the word sample, which should make the file named “wp-config.php”. Now you’re ready for Step 4.

Step 4 – Upload the application
Here’s where you are going to need the FTP program. Launch your FTP software and start a new connection. There should be a place for you to enter your server address, your FTP username, FTP password. This is not necessarily the same username and password as your database. Your hosting company should have sent you your FTP address, username and password as part of your sign-up, and you’ll need to contact them if you can’t find it.

After you enter your login data into your FTP program, there should be a button to connect or login, which should open your website’s root folder. Some hosting companies start you in a folder up a level or two from your website’s root folder. You may need to click on a folder or two to get to your website. Often times the first folder you need to click is the name of your site, such as “yoursite.com”. Then you need to click on a folder called something like “httpdocs”, “www”, “http”, “docs”, or “public”. This folder is what is known as your “root” folder and it’s the beginning of your website’s folder and file structure. If you want your blog address to be “yourwebsite.com”, then you’ll want to upload the contents of the WordPress folder on your computer into the root folder for your website. If you want your blog to be an address like “yourwebsite.com/blog”, then you need to create a new folder titled “blog”, or whatever you want the address to be, in the root folder of your website and upload the WordPress files there. * It’s important to note that you only want to upload the contents of the WordPress folder on your computer, not the main folder itself (you do want the folders within the main folder).

Step 5 – Run the installer
Now that everything is in place, open a web browser and type in the address for your blog (it should be something like yourwebsite.com or yourwebsite.com/blog). If your set up is correct, then you will see a screen telling you to run the installer. If you missed a step, then you’ll be told an error and it should prompt you with a possible solution.

Running the installer should lead you to a screen with a place to enter your blog’s name and your email address. WordPress will email a password to the address you enter here, so be sure you can access that account’s inbox. Plug the password from the confirmation email into the login screen and you’re in!

First tips
After your blog is up and running, you’ll need to poke around the admin to discover all of it’s possibilities. There are a few first things that people generally like to do, such as:

Change your blog name or add a tagline under the “Options” menu.
WordPress has links in your blogroll to start with, you can edit those or add new ones under “Links”.
WordPress also comes with a first post, which you can delete under the “Manage” menu.
You can write your first post by clicking on the “Write” menu.
When writing your first post, note the options on the right of the page. For example, you’ll want to make sure to assign categories to your post or it will remain uncategorized.
You can select a different layout or style under the “Presentation” menu. On the bottom of that page, you can click on a link for new WordPress themes, which links you to hundreds of pre-made styles with instructions for how to install them.

SEO Link Building

Are you looking for a SEO consultant that can help placing your website on top of major search engines? Well, as you seemingly have known, having a high rank website is important because it enables you to get many visitors more easily. Whether you have a business or a personal website, you can get many visitors easily if your website is listed on top of search engines.

In fact, to be able to have a high rank website, you need efforts. In this case, what you need to do is to hire a search engine optimization consultant. A SEO consultant is knowledgeable and skilled about search engine optimization. If you hire such consultant, you will be able to achieve your business goal easily and fast.

Amongst the many websites providing search engine optimization service, SeoLinkBuildings.net is a worth to consider website. Their website does not only provides SEO link building services but also three other services including blog post services, free guide services, and writer professional services. As when you need SEO articles for your websites, you can simply order from their company. Actually, ordering articles from their company will give you lots of advantages because their writing service is professionally managed. They have high quality writers that are capable in writing articles that can optimize your keywords. In this case, you can ask a writer to use keywords given by you or of writer’s choice. Because they have many writers, they can provide blog content articles. Whatever blog content you need, you can expect to receive suitable articles from their writers.

Further, if you are interested in monetizing your personal websites or blogs, you will not need to find other companies to be your partner. Their company is the right company to hire because they are not only able to make your website to be on top of search engines but also able to fill your websites and blogs with high quality ezine articles. As you know, articles for ezine should have high quality. They should be grammatically correct and have interesting yet useful topics. With the existence of their company, writing articles to be submitted to ezine should no longer a difficult thing to do. Then, if you want to make money by writing paid review articles, you had better hire their company to write for you.

These days, writing a paid review article has become an effective way to make money online. As long as you are able to write many articles, you can make lots of money. If you hire their company, you will have a better chance to make more money since their company is able to write lots of articles every day.

Then, whether you are a blogger or an advertiser, their company can always give the most suitable solution. You just need to contact their company in order to get further information about a service you are looking for or about their price. Therefore, anytime you need SEO link building service or writer professional service, you had better visit their website.

How Hard Does Link Building

Links

Links are other websites voting for you as the most popular for a specific keyword or topic. They also deal with internal linking, the links that take people from one page to another on your own website.

Without links there would be no way for the search engine spiders to crawl the internet and to index every page that’s been published. That’s why if your website has no links pointing to it, you won’t show up in the results for a while, if at all.

Let me give you an analogy that I came up with. The Internet is like the night sky and the websites are like the stars. Without links, the clear night sky is how this story would end and the websites would just sit there independently of one another with no way for the search engine spiders to get from one site to another.

Links create the Web and allow a pathway for easy crawling. I argue that without links, there would be no Internet and no search engines either. That’s why the focus of this website is on link building. Because it is and always will be a huge ranking factor for all search engines.

Content

Content has to do with On-Page SEO factors. Search engines love multimedia content that is super organized. Thankfully for us, WordPress does 99% of this organization for us. That is exactly the reason everyone says that Google loves WordPress, because of the way they set up your site for the crawlers (also related to a website’s internal linking).

Quick case in point.

I have spent many hours building links to one website that was not built on WordPress. After months, I could not get the site to stay on page one for most keywords. After moving the site over to WordPress and doing a little more link building, literally a few more days of work, the site moved to number one and number two overall for two keywords that get over 600,000 searches combined. For these particular keywords, I was never able to get the site past page three! I saw this major jump in every single keyword that I had been trying to rank for.

I used to think that On-Page SEO was a complete waste of time and the work did not justify the rewards. Boy, was I wrong.

Yes, link building does hold the majority of weight in these ranking factors but why swim upstream.

On-page organization of your content to make it easier for the search engines to crawl and index your site will only help you and propel you to the top of the SERPs. It actually says so right in Google’s Mission Statement, to organize the world’s information, so make it easy for them to do so.

Activity

Activity is the frequency in which your website is updated with new content. This also means user-generated content in the form of blog comments and the number of people who subscribe to your RSS feed. Google’s purchase of Feedburner a few years ago was a good indicator that your RSS subscriptions play a role in their ranking formula.

Frankly, I never ranked as well as when I’m publishing new posts on my blog every single day. This is clearly evident in the way that sites with an enormous number of indexed pages rank better than sites with only a few.

Activity and Content often overlap but just remember, if your site is alive with visitors and new content, it will be much easier for you to rank in Google, Yahoo and Bing compared to sites that don’t update often.

Furthermore, if your site has more content it can simply rank for more keywords because there is a better chance for those keywords to be found in the text itself.

Which Ranking Factor Should You Focus On?

Different weight is often allocated to different search engine ranking factors but you should focus on all three so if a change occurs in the algorithm, you will stay at the top of the SERPs.

If you were to press me for how much time or percentage of your efforts should be allocated to each one, I would have to say it’s a trick question. Like what came first the chicken or the egg? The content or the links? You need both. And these days Google is becoming so sophisticated, it would be ignorant of us to think that they cannot detect time on site or social sharing because they can and they use that “activity” information as a part of the ranking formula as well.

To put out more quality content you only have two options. You can either get typing or hire someone else to do it for you.

However, there are a bunch of products that can help you with the link building. If you are looking to buy SEO Software and link builidng tools, I suggest you take a look at our Resource Page first.

Just consider yourself warned… there are some super powerful SEO tools listed there. And NEVER expect one tool to get you the SEO results you want. It just wont happen! Not long term anyway.

Here I am not suggesting you use any or all of these methods. This is just a small sample of things people have done to boost their website’s search engine ranking.

Search Engine Optimization Basics

At this point in web development, virtually everyone I talk to about a project tells me they would like to “come up in Google”. In the industry, we refer to that as search engine optimization, or SEO for short. This post attempts to cover the basics for search engine optimization as a starter resource for others.

SEO Overview
It has been my experience that most people think about SEO as something one does after a website is up and running, like tuning a car. While SEO was born from trickery designed to exploit the algorithims search engines use to rank web pages, modern SEO practices need to be considered and implimented from the beginning of a site’s conception. SEO is more than just keywords, it’s a part of the site’s structure itself.

Search engines 101
In order to understand SEO, you must know a little something about how a search engine works. Essentially, there are 5 pieces to a search engine:

The web page crawler, also known as the spider
The index, which is the database
The algorithim
The search box
The search results pages
The spider is a type of robot that has the task of following links on the Web to download pages. Each page that is downloaded is processed and stored in the index. When a user makes an inquiry through the search box, the algorithim determines which pages to pull from the index and what order they are displayed on the results pages.

That’s the basic overview of how a search engine works. If you’re feeling geeky and want some in-depth knowledge, read The Anatomy of a Large-Scale Hypertextual Web Search Engine, which was the original research paper written by Sergey Brin and Lawrence Page for Google while they were still at Stanford. What matters to know about how engines work with respect to optimization is this:

Spiders find pages by following links, so you’ll want to make sure they can follow every link on your site.
The algorithim determines the order Web pages are displayed on the search results pages, so you want to make sure your pages take advantage of that algorithim.
Search engines rank Web pages, not websites.
Algorithims are tightly held secrets by the major search engines, and they are updated regularly. While there are people that focus on cracking the algorithims, most people will do just fine with the known best practices for maximizing your position in the engines. In fact, Google even provides some of them on their site as webmaster guidelines. The rest of what we know comes from experience and information sharing. When I first heard about SEO, I thought it was a scam for people that didn’t know better. Then I stumbled across Webmaster World. Webmaster World is the largets online forum in the world and it’s where all of the great optimizers share their knowledge with each other. If you want more than what this post offers, I recommend turning there next.

The lowdown
SEO tactics can be broken down into two areas: on page and off page factors. On page factors are what you do with your Web pages themselves. Off page factors are the factors outside of your Web pages that influence your ranking. Most people think it’s what you do on your Web pages that makes the most difference for rankings, but that’s not true. The biggest impact on your position on a results page comes from the links pointing to your page. Take for example a Google search on the word “failure“. The #1 result is the actual White House bio for George W. Bush. Now, I can promise you that the White House did nothing to optimize his bio for the word failure. What happened is that a bunch of bloggers organized to put links on their blogs using the word failure for the blue text and pointed the link to the President’s bio. It’s a phenomena called “Googlebombing”. Therefore, if you only do one thing when it comes to SEO, get links!

Content is King
After links, content is King. The only thing search engines process on a page to determine rankings is written content. In fact, Google employs artificial intelligence engineers and a grip of other really smart people to make computers that can “read” your page’s content. They can determine quite a bit about your page by the keywords that appear in the headlines, paragraphs, and more. I’ll cover more about how to write keyword friendly copy later. The most important thing you need to know about content is to have a lot of it. As I said earlier Google ranks web pages, not websites, therefore the more pages you have in Google, the more traffic you’ll pull.

And, the only thing SEs like more than content is fresh content. Google will visit your site a few times the first time the spider comes across it, if they don’t see new content, they won’t come back very often. If you do regularly produce new content, then Google *will* return often, and that equals good.

Proper document structure
Having loads of fresh content is great, but to get the most mileage out of it, you need proper document structure. Proper document structure refers to correctly coded web pages. This means having complete meta data and content that is wrapped in semantically correct tags. Google values the words that appear in headlines more than the ones in paragraph copy. And, in order for Google to know what your headline is you’ll need to do more than just make it a larger font and bold. Headlines need to be wrapped in <h1>, <h2>, and the other headline tags. Paragraphs need <p> tags. And so on.

I also highly recommend using <strong> and <em> tags in the middle of your paragraphs around keyword phrases.

Keyword density and proximity
While it’s true that search engines value keywords, gone are the days of using those keywords over and over on a single page. As I said before, Google employs artificial intelligence engineers and they have developed a thing called latent semantic indexing, which means they can read your pages to determine if you are keyword spamming. One of the things search engines look for is the number of times a keyword appears on a page divided by the total number of words on the page, which is known as keyword density. The optimal percentage is between 1.5% and 3%. I wouldn’t sweat keyword density too hard unless you are in a highly competitive keyword space.

Keyword proximity refers to the distance keywords appear to each other. Words that are next to each other are considered stronger than words that appear with other words between them. Proximity is less of an art and more of a concept to be aware of.

How To Be A Popular Web Developer

Just follow these simple steps and it will be you telling people you can’t take projects until sometime late next year.

Learn from the masters
It seems to me that there is a pattern among the web developing elite: develop with standards, maintain a website with a blog, promote a side project, write a book, and earn accolades for your work.

Developer Website Project Book
Dave Shea mezzoblue CSS Zen Garden The Zen of CSS Design
Shaun Inman Shaun Inman Mint and Designologue N/A
Jeffery Zeldman Zeldman ma.gnolia Designing with Standards
Molly Holzschlag Molly WaSP and W3C 30+ books, including The Zen of CSS Design
Eric Meyer meyerweb N/A Eric Meyer on CSS
Cameron Moll Cameron Moll N/A CSS Mastery
Dan Cederholm SimpleBits Cork’d Bullet Proof Web Design
Todd Domney Dominey Design, What do I know? SlideShowPro Professional CSS
Mike Rundle Business Logs 9rules N/A
The above is not an exhaustive list of the web developing elite, but it does help paint the picture of the success pattern. Be excellent at what you do, let the world know, help them for free, and sell an in-depth guide.

In addition to the master’s plan, here are a few more tips for building your name in the industry.

Submit your work to the CSS galleries
Promoting yourself includes gaining recognition for your work. Here’s a list of sites where you can submit your work:

Stylegala
CSS Beauty
CSS Vault
CSS Mania
Web Creme
Design Shack
CSS Drive
CSS Import
Unmatched Style
CSSElite
CSS Website
CSS Reboot
Styleboost
CSS Bloom
CSS Remix
Daily Slurp
screenfluent
css collection
light on dark
CSS Princess
W3C Sites
Best Web Gallery
Refresh
Darkeye
InspirationKing
CSS Allstar
Liquid Designs
screenspire
Participate in the larger conversation
Other moves I recommend to bolster your reputation in the community are:

Submit an entry to CSS Zen Garden
Submit an entry to Designologue
Subscribe to the RSS feeds of industry blogs and leave comments and trackbacks
Get a MySpace account and make friends
Submit your site to directories
Submit your blog and feed to directories
Build your web presence using the tips that will be coming from my web presence building series.