Some people (like myself) will want to connect to their MySQL database from time to time. If you know the SQL command language, you can query and update your data (posts, pages, settings, etc.) directly. So this post is for the geeks out there.HeidiSQL
HeidiSQL is a free, open-source Windows client for MySQL. After installing it to your computer, you can connect to your database. Here’s a link to their website: http://www.heidisql.com/
DreamHost does provide a web interface (phpMyAdmin) to manage your database. I prefer using a Windows client.Getting Connection More >
From the full-edit screen (where you initially create your WordPress page), you do NOT have the ability to specify whether or not users can leave comments on the page. Instead you must use the Quick Edit option.Set the Comment Setting for a Single Page
To disable or enable visitors to leave comments on one of your WordPress pages (as opposed to posts), do the following:
- From your WordPress Dashboard, select Pages, then All Pages.
- Hover your mouse over the title of the selected page. This should cause the Edit | Quick Edit | Trash | View links to More >
Because of its power, flexibility, and price (free), WordPress is a very popular platform for quickly building attractive websites. As many as one in five new websites are built using WordPress. As a result, WordPress sites have also become a popular target for hackers.
A hacker who gets access to your server can modify your files and/or records in your database. (Your WordPress pages and posts are stored in a database.) By inserting malicious code, the hacker can either distribute malware through your site or redirect visitors to their site. In More >
Although building an information-rich website is a great goal, it isn’t the ultimate goal. You want to get visitors to your information-rich website. Many of your new visitors will find your site by using a search engine like Google, Bing, or Yahoo.
Getting ranked high by the search engines requires a fair amount of work. You need to optimize things like the title of your pages, the meta descriptions, the urls, etc. Fortunately for WordPress users, a number of plugins make this easy.WordPress Plugins for SEO
Two of the more popular WordPress plugins for More >
The Internet offers many free (as well as premium) WordPress themes. Many of them are excellent — offering useful functionality, appealing graphics, and more. However some carry dangerous or even nefarious code. These theme “developers” will usually hide the code by obfuscation. Sometimes they will hijack the work of other developers, insert their code, and then offer the modified theme for free.
So why would someone go to the effort of embedding their malicious code? Sometimes it is to promote a third-party website; sometimes it is to do something like infect More >
One thing that I initially found frustrating with WordPress was trying to figure out how to insert extra blank lines into my posts to space out content.
Simply pressing the Enter key multiple times between lines doesn’t work. Using the HTML code for a blank line <br /> doesn’t work either. Some online sources say to use <code><br /></code> but I found that my stylesheet ended up placing an obnoxious, shaded space at the far left.Blank Lines Solution
Searching online, I found that inserting <p> </p> works. Basically you are inserting a paragraph that More >
Here’s how this site looks with a custom icon.
To customize this, you simply need to upload a file named favicon.ico to the main folder of your theme as well as to the root of your website. I used FileZilla to accomplish this. If you are not artistic, a number of sites offer icons that you can download and use. This site site allows you to both create an icon or to search from thousands of icons.
To create a favicon.gif file from a favicon.ico file, I More >
If you have a web site that allows comments, unless you have some prevention method in place, you’ve undoubtedly encountered spam. Spam bots are automated software programs that search the Internet looking for web pages to leave comments with links back to their web sites. Their goal is to increase their page ranking and to get traffic.
WordPress offers the Akismet plugin (which installs automatically at DreamHost). You must register at akismet.com to get your API key. This can be free for personal sites. Small commercial sites start at $5 a month. Here’s a description of the plugin from More >
I’ve set up WordPress for a number of websites at DreamHost.com. They say that it is a “One-click Install.” Technically it takes a few clicks…but it is very fast and easy! You can have WordPress up and running within about 10 minutes.
After logging in at DreamHost, click on One-Click Installs in the upper-left of the DreamHost dashboard.
Then click on WordPress.
Next click Custom Installation.
Finally select your domain in the drop-down list and then click Install it for me now! Leave the default settings of Automatically Create Database and Deluxe Install checked.
Here’s a nice browser add-on to help you see the PageRank of websites that you visit. Here’s a screenshot from FireFox.
The following is the “official” description.
A toolbar that gives you automatically website rank, pages indexed and backlinks in various search engines. Find webpages share count at Twitter, Digg and Delicious using the SocioMeter. You can click on each of the buttons to get in-depth information about the website. You can even Bookmark the website at PickMeWeb.com. Also find websites offering similar content or services at SimilarSites.com. It is a tool for SEO and website More >