Magento Installation Problem – MySQL Access Denied

I was installing Magento on one of my commercial sites just to try it out and ran into this installation problem:

The error message explains itself: there is a database connection issue and it’s probably because either your username and / or password don’t match or your account doesn’t have the privilege for this execution.

My question was exactly about that, too. “Why does it try to access MySQL database using the ‘root’ account? ”

I’m using shared hosting service from HostGator for this site, and I don’t have the root access to any of my MySQL databases. For example, my username for a DB would look like “ebiz_magento”, not ‘root’. This is a common case when you don’t have a dedicated server.

Something must’ve been messed up during my installation process because I couldn’t simply believe that they would’ve set the root account as default DB access for the installation.

So where is the file that has this incorrect DB access configuration?

After spending over 30 minutes, I found this file that contains the database access information.

It’s an XML file, ‘local.xml’ under ‘/app/etc/’.

Change the username, password and dbname appropriately.

After a couple of days later, I figured out why I had this problem. I had installed the software locally on my Windows using the root account for MySQL before I did on my server. I uploaded the files from that directory where it was configured to use the root account in ‘local.xml’.

When I checked the files freshly upzipped from the installation file, I found it doesn’t have the file ‘local.xml’.

By AbdulHakim Maina, February 2, 2010 @ 3:52 pm

Thanks mate! You really saved me a lot of bother trying to db connection settings.

Source


Overall RatingNo Rating
ProfessionalismNo Rating
Top QualityNo Rating
Great BenefitsNo Rating

WordPress Category Order and Category Hierarchy

Category Hierarchy

I have a personal WordPress blog where there are some sub categories under top categories. Its theme is non widgetized, and the sidebar function to display categories is “wp_list_categories(show_count=1&hierarchical=0).”

By default, WordPress displays all categories at one level regardless their hierarchy. Fortunately, I found out a simple modification would fix the way to display categories in regard to hierarchy.

Change the value of the argument ‘hierarchical’ to ‘1′ from ‘0′.

Before:
wp_list_categories(hierarchical=0)

After
wp_list_categories(hierarchical=1)

Category Order

I also have another blog where I want to control over category display order. The default display of categories in WordPress is by their alphabetical order. You can re-order categories by installing WordPress Category Order Plug-in.

Upzip the downloaded file, upload it to the root plug-in directory, activate the plugin via WordPress admin interface, and then change category orders by clicking ‘Manage’ -> ‘Order Categories’.

Make sure you don’t use ‘orderby=count’ in the sidebar function ‘wp_list_categories()’.

By Linda Camurato, January 17, 2010 @ 3:44 pm

Thank you so much for this article. It worked and it was very easy to follow your instructions!

Source


Overall RatingNo Rating
ProfessionalismNo Rating
Top QualityNo Rating
Great BenefitsNo Rating

SEO Tools – Search Engine Optimization Resources & Tools

Helpful web resources and tools that you can use for search engine optimization.

– Forums
Forums can be very beneficial not only because you can find answers for web development questions but also because it may bring your site more traffic. Don’t forget to be helpful as well by posting relevant articles or leaving answers and comments.

Here are some great webmaster forums.

Digital Point Forums
Very popular forum. Questions are generally answered promptly. The main categories this site covers are search engines, marketing, business, design & development, product and tools and so on.

SitePoint Forums
This site provides many forums where webmasters can ask questions about website programming, website development & design, hosting, advertising and so on.

Webmaster World
This forum also covers a lot of website development related categories. Check the forum index on the left side menu to locate the area that you’re interested in.

Webmaster Talk
Categories that this forum covers: coding (HTML, CSS, PHP, ASP, JavaScript and more), website design and graphic, web administration(hosting, domain names, database, server, and more), search engine(Google, web directories, blogging, and more), Internet marketing and business(advertising, ecommerce, content, and more) and other webmaster related topics.

– SEO Resource Sites
SitePro News
This site focuses on website promotion, Search Engine Optimization, blogging, design and marketing.

Sitepoint
This site provides a variety of web design articles, tutorials and information through articles, blogs and forums.

– SEO Tools
Wordtracker: Wordtracker by wordtracker.com is a powerful keyword analysis tool used by a great number of webmasters. It offers hundreds of millions search queries with which you can build keyword lists for pay per click advertising and web page search engine optimization for your site.

Its annual subscription fee is $329 and monthly subscription $59 as of April, 2008. If you have one domain, maybe you can take advantage of free 7 day trial. If you have several domain, or you have enough budget, annual subscription will bring you valuable keyword solutions.

Keyword Suggestion Tool: This tool from tools.seobook.com is a free tool that suggests possible target keywords.

Keyword Density Tool: This tool provides the percentage of occurrence of the given keywords in the given web site pages. Use this tool to properly manage the density for the targeted keywords of your web pages.

Keyword Verification by Marketleap
http://www.marketleap.com/verify/
This tools shows if your web site is in the top three pages of a search engine result for a specific keyword. It’s really a cool tool that you can check how well your site is doing with major keywords. Test search engines are Google, MSN, Yahoo and Ask.com.

Link Popularity Check by Marketleap
http://www.marketleap.com/publinkpop/
You check check how many inbound links that your site has. You can also compare your site popularity with main competitor sites of yours.

Page Strength
http://www.seomoz.org/page-strength
This tool provides information about webpage visibility and potential strength to rank in search enginges.

Source


Overall RatingNo Rating
ProfessionalismNo Rating
Top QualityNo Rating
Great BenefitsNo Rating

SEO Tools – Search Engine Optimization Resources & Tools

Helpful web resources and tools that you can use for search engine optimization.

– Forums
Forums can be very beneficial not only because you can find answers for web development questions but also because it may bring your site more traffic. Don’t forget to be helpful as well by posting relevant articles or leaving answers and comments.

Here are some great webmaster forums.

Digital Point Forums
Very popular forum. Questions are generally answered promptly. The main categories this site covers are search engines, marketing, business, design & development, product and tools and so on.

SitePoint Forums
This site provides many forums where webmasters can ask questions about website programming, website development & design, hosting, advertising and so on.

Webmaster World
This forum also covers a lot of website development related categories. Check the forum index on the left side menu to locate the area that you’re interested in.

Webmaster Talk
Categories that this forum covers: coding (HTML, CSS, PHP, ASP, JavaScript and more), website design and graphic, web administration(hosting, domain names, database, server, and more), search engine(Google, web directories, blogging, and more), Internet marketing and business(advertising, ecommerce, content, and more) and other webmaster related topics.

– SEO Resource Sites
SitePro News
This site focuses on website promotion, Search Engine Optimization, blogging, design and marketing.

Sitepoint
This site provides a variety of web design articles, tutorials and information through articles, blogs and forums.

– SEO Tools
Wordtracker: Wordtracker by wordtracker.com is a powerful keyword analysis tool used by a great number of webmasters. It offers hundreds of millions search queries with which you can build keyword lists for pay per click advertising and web page search engine optimization for your site.

Its annual subscription fee is $329 and monthly subscription $59 as of April, 2008. If you have one domain, maybe you can take advantage of free 7 day trial. If you have several domain, or you have enough budget, annual subscription will bring you valuable keyword solutions.

Keyword Suggestion Tool: This tool from tools.seobook.com is a free tool that suggests possible target keywords.

Keyword Density Tool: This tool provides the percentage of occurrence of the given keywords in the given web site pages. Use this tool to properly manage the density for the targeted keywords of your web pages.

Keyword Verification by Marketleap
http://www.marketleap.com/verify/
This tools shows if your web site is in the top three pages of a search engine result for a specific keyword. It’s really a cool tool that you can check how well your site is doing with major keywords. Test search engines are Google, MSN, Yahoo and Ask.com.

Link Popularity Check by Marketleap
http://www.marketleap.com/publinkpop/
You check check how many inbound links that your site has. You can also compare your site popularity with main competitor sites of yours.

Page Strength
http://www.seomoz.org/page-strength
This tool provides information about webpage visibility and potential strength to rank in search enginges.

Source


Overall RatingNo Rating
ProfessionalismNo Rating
Top QualityNo Rating
Great BenefitsNo Rating

Importance of ALT Text for images

Is ALT Text Still Important in Search Engine Optimization?

ALT text for images have been considered as an important element in search engine optimization for years. But this has changed as major search engines such as Google, Yahoo and MSN don’t consider ALT text for images in determining relevancy any more.

According to some experts in SEO, web sites that use keyword dense ALT text for images might get lower rank in search result pages because those ALT texts are considered as SEO tricks by search engines. That is, using ALT text for search engine optimization can affect the rankings in the search engine result pages negatively.

Then what should search engine optimizers do about ALT text for images?

Use ALT text for its original purpose designed by the W3C (World Wide Web Consortium): give a good relevant description about an image. Though the major search engines don’t regard ALT text important in determining relevancy of the content at the present time, their algorithm can always change to the opposite way. It’s always best to keep the basic rules.

Here are three main tips about how to use ALT text.

1. Use ALT text to describe the image. It is highly recommended by the W3C that ALT text should be used to describe images on web sites.

2. You can include keyword phrases in one or two instances of ALT text within one content page. Be careful not to put more than twice because major search engines might punish them by lowering the rankings in result pages.

3. Description of ALT text should be relevant to the image. This way, it is helpful for the people who read web pages for the visually impaired. The American Disabilities Act (ADA) has strict guidelines regarding what a web site needs to contain in order to be ADA compliant.

Source


Overall RatingNo Rating
ProfessionalismNo Rating
Top QualityNo Rating
Great BenefitsNo Rating

Importance of ALT Text for images

Is ALT Text Still Important in Search Engine Optimization?

ALT text for images have been considered as an important element in search engine optimization for years. But this has changed as major search engines such as Google, Yahoo and MSN don’t consider ALT text for images in determining relevancy any more.

According to some experts in SEO, web sites that use keyword dense ALT text for images might get lower rank in search result pages because those ALT texts are considered as SEO tricks by search engines. That is, using ALT text for search engine optimization can affect the rankings in the search engine result pages negatively.

Then what should search engine optimizers do about ALT text for images?

Use ALT text for its original purpose designed by the W3C (World Wide Web Consortium): give a good relevant description about an image. Though the major search engines don’t regard ALT text important in determining relevancy of the content at the present time, their algorithm can always change to the opposite way. It’s always best to keep the basic rules.

Here are three main tips about how to use ALT text.

1. Use ALT text to describe the image. It is highly recommended by the W3C that ALT text should be used to describe images on web sites.

2. You can include keyword phrases in one or two instances of ALT text within one content page. Be careful not to put more than twice because major search engines might punish them by lowering the rankings in result pages.

3. Description of ALT text should be relevant to the image. This way, it is helpful for the people who read web pages for the visually impaired. The American Disabilities Act (ADA) has strict guidelines regarding what a web site needs to contain in order to be ADA compliant.

Source


Overall RatingNo Rating
ProfessionalismNo Rating
Top QualityNo Rating
Great BenefitsNo Rating

Nofollow, rel=nofollow

Nofollow is a kind of HTML attributes that defines hyperlink relationship between the linking page and the linked page.

1. It can be used when you don’t want your links to influence the targeted site’s rankings by search engines. That is, the destination of that hyperlink won’t be given any additional weight or credit in search result rankings.

“From now on, when Google sees the attribute (rel=”nofollow”) on hyperlinks, those links won’t get any credit when we rank websites in our search results.”
Post on Google Blog on 2005-01-18

Not only Google but Yahoo! and MSN Search have agreed to this new hyperlink relationship attribute.

2. This also prevents link spammers from spamming blogs and web forums by posting links in comments and signatures.

WordPress seems to add this attribute by default to the links left in comments.

3. You can use this attribute on some of the links within your website to maximize link values to important content pages.

For example, let’s say that you have a site selling running sneakers. From the homepage, there are two links within the site. One is a link to About Us page and the other is a link to How To Choose Running Sneakers page. Each of these pages gets 50% of the rank value of the homepage in Google, but you don’t really care about how well the About Us page ranks in search engines. In this case, you can add the rel=nofollow attribute to the About Us link. This will give the full score of the homepage rank value to the second page which contains important content for your site.

Source


Overall RatingNo Rating
ProfessionalismNo Rating
Top QualityNo Rating
Great BenefitsNo Rating

Nofollow, rel=nofollow

Nofollow is a kind of HTML attributes that defines hyperlink relationship between the linking page and the linked page.

1. It can be used when you don’t want your links to influence the targeted site’s rankings by search engines. That is, the destination of that hyperlink won’t be given any additional weight or credit in search result rankings.

“From now on, when Google sees the attribute (rel=”nofollow”) on hyperlinks, those links won’t get any credit when we rank websites in our search results.”
Post on Google Blog on 2005-01-18

Not only Google but Yahoo! and MSN Search have agreed to this new hyperlink relationship attribute.

2. This also prevents link spammers from spamming blogs and web forums by posting links in comments and signatures.

WordPress seems to add this attribute by default to the links left in comments.

3. You can use this attribute on some of the links within your website to maximize link values to important content pages.

For example, let’s say that you have a site selling running sneakers. From the homepage, there are two links within the site. One is a link to About Us page and the other is a link to How To Choose Running Sneakers page. Each of these pages gets 50% of the rank value of the homepage in Google, but you don’t really care about how well the About Us page ranks in search engines. In this case, you can add the rel=nofollow attribute to the About Us link. This will give the full score of the homepage rank value to the second page which contains important content for your site.

Source


Overall RatingNo Rating
ProfessionalismNo Rating
Top QualityNo Rating
Great BenefitsNo Rating

How to choose the right hosting company – Web Hosting

There are several reasons that make it a difficult task to choose a right hosting company. First of all, there are simply so many of them. Apparently, it’s relatively easy to set up a hosting company. So there are many companies which have not been around long and might not be around in the next year or so.

Second, online reviews are not necessarily trustworthy. Often times, they are written by affiliates that have monetary interest for certain companies. Also, there are many companies that provide very cheap or even free hosting service. Website owners, especially new startups sometimes fall into these companies, which may lead long downtimes or slow customer supporting service.

Here is the essential guideline in choosing the right host company for your business.

Hosting Cost
The monthly hosting fee ranges from free to a few hundred dollars depending on what platform they offer such as shared hosting, dedicated hosting, reseller hosting, or virtual dedicated hosting. It’s fundamental what kind of platform you need for your business before you decide.

Usually it’s easy to upgrade a lower platform to a higher one. So it is a good idea to start with a smaller package. But try not to use a nameless cheap hosting service. This will cause you much more stress due to downtime or slow service.

Uptime
You might think 95% uptime is acceptable. But customers who visit during the 5% downtime would most likely never come back to your site. It’s not only losing a possible sale that time but also you may lose returning visitors and customers.

Look for a company that guarantees over 99.9% uptime. The fact that they guarantee it means that they understand how significant this matter is and they do their best to keep their commitment. It’s not really saving money if the hosting fee is half compared with competitors but uptime is less than 80%. It turns out a definite damage to your business.

Customer Service
Customer supporting is a very important factor, too. However, it’s a tricky issue. It’s not easy to see if they provide reliable customer service until you actually sign up with them. Try to read as much as user experience from their forums or other online webmaster forums. Check how fast and accurately they respond to customers’ or users’ questions.

Most website hosting companies offer a money-back guarantee or a trial period to experience their service and customer supporting.

Spec / Features / Packages
Website host packages offer various features and functions. Most website owners don’t need all of those additional bonus features. But there are certain things that you need to pay attention to before you decide a web host company.

Check if it offers plenty of bandwidth and its memory and CPU has recently been upgraded. It’s always good to have various email features such as auto-responder or forwarding. See if they provide an easy and reliable admin interface. The most popular one is CPanel. The common blogging tool is WordPress or b2evolution. See if these are provided in the service that you’re looking into.

Most hosting companies give you a dedicated IP address if you pay additional dollar or two.

Source


Overall RatingNo Rating
ProfessionalismNo Rating
Top QualityNo Rating
Great BenefitsNo Rating

How to choose the right hosting company – Web Hosting

There are several reasons that make it a difficult task to choose a right hosting company. First of all, there are simply so many of them. Apparently, it’s relatively easy to set up a hosting company. So there are many companies which have not been around long and might not be around in the next year or so.

Second, online reviews are not necessarily trustworthy. Often times, they are written by affiliates that have monetary interest for certain companies. Also, there are many companies that provide very cheap or even free hosting service. Website owners, especially new startups sometimes fall into these companies, which may lead long downtimes or slow customer supporting service.

Here is the essential guideline in choosing the right host company for your business.

Hosting Cost
The monthly hosting fee ranges from free to a few hundred dollars depending on what platform they offer such as shared hosting, dedicated hosting, reseller hosting, or virtual dedicated hosting. It’s fundamental what kind of platform you need for your business before you decide.

Usually it’s easy to upgrade a lower platform to a higher one. So it is a good idea to start with a smaller package. But try not to use a nameless cheap hosting service. This will cause you much more stress due to downtime or slow service.

Uptime
You might think 95% uptime is acceptable. But customers who visit during the 5% downtime would most likely never come back to your site. It’s not only losing a possible sale that time but also you may lose returning visitors and customers.

Look for a company that guarantees over 99.9% uptime. The fact that they guarantee it means that they understand how significant this matter is and they do their best to keep their commitment. It’s not really saving money if the hosting fee is half compared with competitors but uptime is less than 80%. It turns out a definite damage to your business.

Customer Service
Customer supporting is a very important factor, too. However, it’s a tricky issue. It’s not easy to see if they provide reliable customer service until you actually sign up with them. Try to read as much as user experience from their forums or other online webmaster forums. Check how fast and accurately they respond to customers’ or users’ questions.

Most website hosting companies offer a money-back guarantee or a trial period to experience their service and customer supporting.

Spec / Features / Packages
Website host packages offer various features and functions. Most website owners don’t need all of those additional bonus features. But there are certain things that you need to pay attention to before you decide a web host company.

Check if it offers plenty of bandwidth and its memory and CPU has recently been upgraded. It’s always good to have various email features such as auto-responder or forwarding. See if they provide an easy and reliable admin interface. The most popular one is CPanel. The common blogging tool is WordPress or b2evolution. See if these are provided in the service that you’re looking into.

Most hosting companies give you a dedicated IP address if you pay additional dollar or two.

Source


Overall RatingNo Rating
ProfessionalismNo Rating
Top QualityNo Rating
Great BenefitsNo Rating