How to locate Databases or phpMyAdmin at the PLESK Control Panel

Let me share with you the steps on how to locate MySQL Databases and/or phpMyAdmin at the PLESK Control Panel.

Login to your Control Panel…

1. Enter your Control Panel username at the Login field.

2. Enter your Control Panel password at the Password field.

3. Click Login button.

How to locate Databases or phpMyAdmin at the PLESK Control Panel

4. Look for the domain name of the database you would like to locate.

5. Click the domain name of the database you would like to locate.

You will be redirected to another page where you will see the Databases icon.

5. Click the Databases icon.

How to locate Databases or phpMyAdmin at the PLESK Control Panel

You will be redirected to another page and you will see the Database name.

6. Click the Database name.

You will be redirected to another page and you will see the DB WebAdmin.

7. Click the DB WebAdmin icon.

And you will be redirected to the MySQL and phpMyAdmin page.

The page might be a pop-up window.

If you do not see the MySQL and phpMyadmin page, make sure that pop-up windows are not blocked.

8. Unblock the Pop-Up Windows.

9. Click the DB WebAdmin icon again.

And you will be redirected to the MySQL and phpMyAdmin page.

If you will be required to login…

10. Enter your database username at the Name field.

11. Enter your database password at the Password field.

12. Click Log in button.

And you will be redirected to the MySQL and phpMyAdmin page.

You are now at the MySQL and phpMyAdmin page.

Warning:

Do not do anything at the phpMyAdmin unless you know what you are doing.

Take note of all the icons especially the delete icon all the time.

One mistake and your database might be gone in just one click.

To see your database…

13. Click Databases, then Database name.

That’s it!

Remember to block the pop-up windows later if you want it that way once you are finished looking at your database at the phpMyAdmin.

Also, now that you know the link to the phpMyAdmin, please bookmark it.

Sometimes, you do not have to login at the Control Panel to access the phpMyAdmin.

You can go directly to the phpMyAdmin.

Just enter your database username and database password to access your database.

Database,MySQL,phpMyAdmin,Plesk

How to locate MySQL Databases or phpMyAdmin at the Control Panel

A lot of you have been blogging and writing for quite some time now but you have not saved any of your Databases.

You have no idea how to save your Databases because you have no idea where to locate your MySQL Databases.

I will try to give you some ideas on how to locate your MySQL Databases at the Control Panel.

I said I will try and wrote “ideas” because I do not know what Control Panel you are using.

I do not know if we have the same specifications even if we use the same Control Panel.

Nevertheless, whether the Control Panels are different from each other, you can still make use of the information to locate your MySQL Databases or phpMyAdmin.

I will not write yet on this blog entry the details on how to locate your MySQL Databases or phpMyadmin but in the next few days.

It will be a series then as I will write about it per Control Panel.

I have experiences using Dreamhost’s own Control Panel.

I have experiences using Yahoo’s own Control Panel.

I have experiences with Plesk Control Panel.

I have experiences with H-SPHERE Control Panel.

I used to have experiences with CPanel Control Panel but have not been using it for quite some time now.

If the Control Panel was not mentioned here, please write me your request using the comments section below.

I will try to write about the other Control Panels too if I can.

Database,MySQL,phpMyAdmin

WordPress won Overall Best Open Source CMS Award

After 4 years, WordPress finally won the Overall Best Open Source CMS Award in the 2009 Open Source CMS Awards. WordPress won the award for the first time and it earned itself a place in the Hall of Fame category for the 2010 CMS Open Source Awards.

Other than that, WordPress also placed second to Drupal in the Best Open Source PHP CMS Category. Joomla came third. Drupal and Joomla were consistent in this category and first time for WordPress to be in the top five.

Indeed, WordPress has proven that it deserves to be called as Content Management System not just a blogging platform.

I have tested many Content Management System (CMS) and it was only WordPress that I pursued to learn and use for my websites. I was more into web designing than blogging and I was looking for a software that was easy to tweak and understand.

I knew then that WordPress was a blogging platform and I already saw the potential of it becoming a CMS. I have experimented using it for my websites and not for blogs, and I was able to use it the way I wanted it.

Every time I meet people who are into making websites not just into blogging, I always recommend to them to use WordPress because it is so easy to customize and it is not at all complicated.

To the WordPress Team! Congratulations!

Read Matt’s post, WordPress Wins CMS Award, at the WordPress.org Blog.

CMS,WordPress

Upgraded to WordPress 2.8.6

I spent a few hours yesterday upgrading sites and blogs from WordPress 2.8.5 to WordPress 2.8.6. You are probably wondering why I spent a few hours upgrading when WordPress has an automatic upgrading feature which would take a few minutes only.

Well, most of my time was spent testing the sites in my local computer in case something is broken. I finished upgrading the following:

Sofie Hofmann dot com
Sofie Estolloso Hofmann Designs International
Pro Blog it | ProBlogging Venture Tips and Ideas, Reviews and Opinions
ISYU.INFO Around the World
Patria Diesel Power Plant Issue
Semirara Dumpsite Issue
Pandan Antique Philippines
Tugbong Festival
Weggis along Lake Lucerne Switzerland
PAGTATAP Foundation
Philippine Seafarers Assistance Programme
Leocadio Alonsagay Dioso Memorial Public Library

Among the 12 sites including the blogs that I upgraded, everything went fine except for the 3 sites where I again have a problem with WordPress Image Gallery. As usual, I just solved it by commenting the 4 particular lines at the post.php file which is under wp-includes folder. With that, the images will be called from the right path.

If you have a problem with WordPress Image Gallery and you need a solution, kindly read this blog entry, Solution to WordPress 2.7.1 Gallery Code Problem. I have been having this problem with WordPress Image Gallery since upgrading to WordPress 2.7.1 and until yesterday when I upgraded the sites to WordPress 2.8.6.

You can also read this blog entry, Upgraded to WordPress 2.8.3, Image Gallery Problem and Solution if you would like more information why I have this problem. It might give you an idea what not do.

WordPress 2.8.6 is a security release fixing two security problems that can be exploited by registered, logged in users who have posting privileges. In the case of the sites and blogs that I upgraded, there would have no problem but I opted to upgrade them anyway.

Download the new WordPress version from this url: http://wordpress.org/download/.

WordPress

How to authenticate your site with Yahoo!

If you followed the instructions on how to get indexed by Yahoo!, and checked if the site was listed, then you successfully submitted your site. But it does not stop there, you still need to authenticate your site with Yahoo to see what pages got indexed by Yahoo. If your site was not yet indexed by Yahoo!, you just wait, eventually Yahoo! will crawl and index your site.

Anyway, when I wrote the blog entry, How to Get Indexed by Yahoo!, last Tuesday, after submitting the site, you were supposed to be redirected to the page like the one in number 4.

But today, when I tested it, instead of that thank you page you will be redirected to another page, to the Authentication page right away. Yahoo! probably changed it so that you will not forget to authenticate the site. Perhaps, some really just submit the site and do not authenticate it.

Let me start again from the very beginning.

1. Login to your Yahoo! account.
URL: https://login.yahoo.com/

2. Then go to Site Explorer – My Sites page.
URL: https://siteexplorer.search.yahoo.com/mysites

How to authenticate your site with Yahoo!

3. Submit your site for free by typing the domain name at the one line form.

How to authenticate your site with Yahoo!

4. Then click “Add My Site” button.

5. Once you submitted the site, you will be redirected to the page like the one below:

How to authenticate your site with Yahoo!

It says:

To authenticate your site ownership, you can either add a META tag to your home page, or upload a verification file to your site, please follow the instructions below.

How would you like to authenticate your site?
– By uploading a verification file to my site.
– By adding a META tag to my home page.

6. Click the link to see the instructions and you will see the illustration below.

How to authenticate your site with Yahoo!

– If you click “By uploading a verification file to my site”. You will see the illustration below.

How to authenticate your site with Yahoo!

It says:

. Download (button) an authentication key (DO NOT change the file name or content):

If you have a problem with downloading the authentication key, please create a text file named y_key_ea2a9d1c73744911.html, and put the string 29f4d5e87a118513 into the file.

. Upload the verification file to your site.

Please upload the key file that you downloaded, or created yourself, at the root level of your site directory. The expected file path is
https://www.sehdi.com/y_key_ea2a9d1c73744911.html.

. When the file is uploaded, please click the button below to let us know that the authentication key is in place. We will authenticate your site within 24 hours.

Ready to Authenticate (button)

– If you click “By adding a META tag to my home page”. You will see the illustration below.

How to authenticate your site with Yahoo!

It says:

Copy the META tag listed below and paste it in your site’s home page:

<META name=”y_key” content=”29f4d5e87a118513″>

. The META tag must be within and near the beginning of the first <HEAD> section of the page, and before the first <BODY> section.

. When the META tag is added, please click the button below to let us know that the META tag is in place. We will authenticate your site within 24 hours.

Ready to Authenticate (button)

7. You have two choices either to upload a verification file via FTP or add a META tag to your home page.

– If you would like to upload a verification file, follow the instructions like at the one below. See number 6 for text.

How to authenticate your site with Yahoo!

Once you downloaded the file, open and check the content of the file.

Click the file and it will open in your browser.

Check the content of the file using “View Source” by clicking File menu, then look for “View Source”.

It should look like the one below:
<!DOCTYPE HTML PUBLIC “-//IETF//DTD HTML//EN”>
<HTML>
<!– 29f4d5e87a118513 –>
<HEAD>
<TITLE>
</TITLE>
</HEAD>
<BODY>
</BODY>
</HTML>

Do not change anything.

Open an FTP software and upload the file.

– If you would like to add a META tag to your home page, follow the instructions like at the one below. See number 6 for text.

How to authenticate your site with Yahoo!

Go to the header of your file and look for <head> and </head> before the </body>.

Put this key <META name=”y_key” content=”29f4d5e87a118513″> inside or in between the <head> and </head>.

It should look like the one below.

<head>
<META name=”y_key” content=”29f4d5e87a118513″>
</head>

If you are using XHTML instead of HTML, it is advisable to change the word META into small letters and put a closing tag before the greater than symbol. Put a space after the last quotation mark then forward slash.

It should look like the one below.

<head>
<meta name=”y_key” content=”29f4d5e87a118513″ />
</head>

8. Once you have done either of the two, go back to Yahoo! Site Explorer.

9. Click “Ready to Authenticate” button. The page will look like the one below while it is processing.

How to authenticate your site with Yahoo!

10. Once it is finished, you will be redirected to a page. You will see the illustration below.

How to authenticate your site with Yahoo!

It says:

Your site is pending authentication.

If you have added the META tag, please keep the tag <META name=\”y_key\” content=\”29f4d5e87a118513\” > in your site’s home page. We will revalidate your site ownership by checking this META tag regularly.

If you have uploaded the verification file, please keep the file y_key_ea2a9d1c73744911.html on your site root https://www.sehdi.com and do not change the content (29f4d5e87a118513).We will authenticate your site ownership by checking this file within 24 hours.

Download (button) an authentication key (DO NOT change the file name or content):

11. Give it a few hours. Yahoo! will authenticate your site ownership within 24 hours.

12. The next time you login at the Yahoo! Site Explorer, and you see the “green round with check symbol” under Status on the right side corresponding to the domain name, then your site has been authenticated.

13. Click the “green round with check symbol” and you will see the illustration below.

How to authenticate your site with Yahoo!

It says:

Your site has been authenticated.

If you have added the META tag, please keep the tag <META name=\”y_key\” content=\”29f4d5e87a118513\” > in your site’s home page. We will revalidate your site ownership by checking this META tag regularly.

If you have uploaded the verification file, please keep the file y_key_ea2a9d1c73744911.html on your site root https://www.sehdi.com and do not change the content (29f4d5e87a118513).We will authenticate your site ownership by checking this file within 24 hours.

Ready to Authenticate (button)

14. Click the domain name and you will see the illustration below.

How to authenticate your site with Yahoo!

It says:

Authentication Status: Verified

If you the see the illustrations like the ones in number 13 and 14, that’s it.

It is finished. Your site has been authenticated.

Well then, good luck!

Note:
The domain name sehdi.com should be the domain name that you submitted.
The text file and the meta key will be different. Yahoo! will automatically create those for you.

Search Engines,Yahoo

How to Get Indexed by Yahoo!

I already wrote about how to get indexed by Yahoo! on another blog. I just thought that since this site and its blog is about web design and web designing extends to search engine optimization, to getting a site or blog crawled and indexed by the search engines, I decided to write about how to get indexed by Yahoo! on this blog.

I also have written about how to get indexed by Google and how to get indexed by Bing at ProBlogit.com. I will write again regarding those two topics later on here at Sehdi.com after I finished writing about how to get indexed by Yahoo!.

So, how are we going to get Yahoo! indexed our blog or site?

Simple, by submitting the blog or site to Yahoo! search.

First of all, submitting a site or blog to Yahoo! requires registration. Make sure that you already have an account with Yahoo!

If you do not have an account with Yahoo!, sign up for a Yahoo! account first at
https://na.edit.yahoo.com/registration.

If you already have an account with Yahoo!, login to your account first so the submission will be easier than what I posted at ProBlogit.com on how to get indexed by Yahoo!.

I wrote there that you can submit a site to Yahoo! even if you are not logged in. But then you will still be redirected to sign in to Yahoo after you submitted a site for inclusion in Yahoo! search.

If you already have an account with Yahoo!, let us proceed:

1. Login to your Yahoo! account.
URL: https://login.yahoo.com/

2. Then go to Site Explorer – My Sites page.
URL: https://siteexplorer.search.yahoo.com/mysites

How to Get Indexed by Yahoo!

3. Submit your site for free.

Fill out the one line form provided near the button “Add My Site” situated on the right side.

How to Get Indexed by Yahoo!

4. Then click “Add My Site” button.

After you submitted the site, you will be redirected to the page shown below.

How to Get Indexed by Yahoo!

It says:

Thank you! Your URL has been added to our list of URLs to crawl. Please expect a delay of several weeks before your URL is crawled.

Note that in the effort to maximize the quality of search results that appear on Yahoo! and our other distribution partners, we do not add every submitted URL to our search index. Therefore we cannot make predictions or guarantees about whether your URL will appear as a search result.

That’s it. That is how simple it is to submit your site for inclusion in Yahoo! search.

To make sure that your site was really added, click “My Sites” at the sidebar on the left.

If the site is listed, then everything is fine.

If you do not see the site, fill out the one line form provided like in #3, then click “Add My Site” button.

That’s it.

Your site may need to be authenticated, so follow the instructions to authenticate your site.

On the other hand, my next topic on this blog will be on how to authenticate your site with Yahoo!.

If you cannot wait, then proceed and authenticate your site with Yahoo!.

Bear in mind though that Yahoo! will crawl and index your site whenever it wants. So there is no guarantee that your site or blog will be crawled and indexed or be included soon enough in Yahoo! search. But this is the process or method on how to get indexed by Yahoo! fast.

Before I end this, let me show you another way of submitting a site to Yahoo!.

1. Login to your Yahoo! account.
URL: https://login.yahoo.com/

2. Then go to Site Explorer – Submit.
URL: http://siteexplorer.search.yahoo.com/submit

How to Get Indexed by Yahoo!

3. You have two options:

Submit a Website or Webpage
Submit Site Feed

To submit a Website or Webpage, click the link and the page will be like the image below.

How to Get Indexed by Yahoo!

To submit a Site Feed, click the link and the page will be like the image below.

How to Get Indexed by Yahoo!

4. Submit your site for free.

Fill out the one line form provided near the button “Submit URL” or “Submit Feed” situated on the right side.

5. Then click “Submit URL” or “Submit Feed” button.

That’s it.

Fore more information on how to submit your site to Yahoo! search, read the details at the Yahoo! Search Submission.
URL: http://search.yahoo.com/info/submit.html

Search Engines,Yahoo

Sofie Estolloso & Company

You probably landed on this page because you searched for “Sofie Estolloso & Company”. I especially wrote this blog entry for your information. I know that you are trying to inquire and verify if I designed the website of a certain fund company.

I actually wrote about it already before. Please read my blog entry, I did not design the website of a certain fund company!, for further information. But during that time, I did not mention the domain name or the name of the company which was supposed to be involved in this so-called investment program money making business.

I thought that this issue was over about less than 3 years ago, months after it was launched and then got exposed when I responded to the several queries of those people who contacted me. Then the real company legally redeemed the domain name from the domain squatter. But it seems like some of the contents of this old website were posted in several internet forum sites.

Since the domain name is now being redirected to the real company, I am mentioning the company name now which has nothing to do with the investment program. The ABB company has nothing to do with the money making business it used to have on the abbfund.com domain. The old content of the website is gone and ABB took the domain legally from the former owner.

In my case, I would like to declare that I have nothing to do with that investment program too. I am not at all connected with that company if there was any. I do not know those people behind that investment program.

With that declaration, I would like to repeat, I did not design the website of the old abbfund.com when it was used for the ABB FUND INVESTMENT PROGRAM – PAY-IT 4 PROFIT SYSTEM scheme to make money.

Well, that’s all, and I hope that this information will clarify everything around this investment program money making business.

Note:
For my other readers, please note that I wrote this blog entry to clarify some things regarding a website of an investment program which I did not design. Thank you for your understanding.

General,Web Design

Google, Yahoo! and Bing updated SERPs regarding GeoCities pages

Google, Yahoo! and Bing search engines updated its search engine results pages (SERPs) regarding GeoCities homepages.

Yesterday, when I was surfing the top three search engines, my GeoCities homepages about Pandan, Antique such as geocities.com/gopandan, geocities.com/pandanantique, and geocities.com/pandan_antique still appeared at the SERPs.

Today, I again checked Google, Yahoo! and Bing search engines, and all them updated its search engines results pages. But Bing search engine is probably not done yet cleaning its SERP regarding GeoCities pages. There are still remaining GeoCities homepages in its SERP as of this writing such as geocities.com/pandanantique and my personal homepage geocities.com/sofiehofmann.

But I am sure that in just a few days or a few hours or maybe in just a few minutes, Bing will notice its SERP, and the GeoCities pages will be removed right away from the search engine results page (SERP) of Bing.

That is of course an assumption. We will see if Bing is fast enough to notice its own SERP. 🙂

Bing,Google,Yahoo

GeoCities has finally closed

GeoCities has finally closed on Monday, October 26, 2009. My five homepages with GeoCities could not be accessed anymore after ten long years of being hosted free at Yahoo! GeoCities. It was with GeoCities where I took my first interest in web design. GeoCities has been my training ground regarding coding in HTML until I finally moved on that there was more beyond HTML in web designing.

The five homepages were still accessible on Monday until the last few minutes of the day. I tried redirecting the homepages to the new websites but it was only functional until that Monday. When I checked the homepages today, I just got a message:

Sorry, the GeoCities web site you were trying to reach is no longer available.

GeoCities has closed, but there’s a lot more to explore on Yahoo!

Despite owning several domain names already related to those old homepages, I chose to maintain all my homepages with GeoCities. Those homepages ranked high at the search engine result pages. It would have been a pity to just ditch them. I have invested a lot of time on those homepages but GeoCities made a decision to close them down for me. 🙂

I did not transfer those homepages as I have recreated them using my own domain names a long time ago. The websites with my own domain names were not copies of the homepages but somehow some of the contents are related to the old homepages.

It is really a pity that GeoCities has to close down its free web hosting.

I was just thinking though, what if Yahoo! converted GeoCities into a blogging service like Blogger and allow the owners to publish advertisements using YPN (Yahoo! Publisher Network) instead of Google AdSense?

I know for a fact that Yahoo! put ads on the homepages hosted free at GeoCities some time ago but it was not for the benefit of the owners of the homepages. GeoCities homepage owners used to monetize their pages too but things have changed along the way.

If Blogger and Google are benefiting from their own services, why not Yahoo! benefiting from GeoCities as a blogging platform and YPN for publishing ads.

Well, probably Yahoo! did not want to invest into such as Yahoo! itself is using WordPress for their blogs instead of creating their own blogging software. I really do not know the real financial situation of Yahoo! and it is too late for me to say these things as Yahoo! closed GeoCities already.

Anyway, I had a lot of fun with GeoCities while it lasted.

Thank you, Yahoo! GeoCities for the ten-year free web hosting services!

Yahoo

Upgraded to WordPress 2.8.5

The new WordPress 2.8.5 version was released on October 20, 2009 just to make your sites or blogs as secure as possible. There was really no urgency in upgrading to this new version but I thought of upgrading all the websites and blogs in preparation for WordPress 2.9 which will be released in either late November or early December.

As mentioned at the WordPress Blog, WordPress 2.8.5: Hardening Release, the headline changes in this release are:

  • A fix for the Trackback Denial-of-Service attack that is currently being seen.
  • Removal of areas within the code where php code in variables was evaluated.
  • Switched the file upload functionality to be whitelisted for all users including Admins.
  • Retiring of the two importers of Tag data from old plugins.

I finished upgrading all the blogs and sites listed below:

Sofie Estolloso Hofmann Designs International
Sofie Hofmann dot com
Weggis along Lake Lucerne Switzerland
Pandan Antique Philippines
Pro Blog it | ProBlogging Venture Tips and Ideas, Reviews and Opinions
ISYU.INFO Around the World
Patria Diesel Power Plant Issue
Semirara Dumpsite Issue
Tugbong Festival
PAGTATAP Foundation
Philippine Seafarers Assistance Programme
Leocadio Alonsagay Dioso Memorial Public Library

I normally would upgrade all the WordPress Plugins first before upgrading to the latest WordPress release, in this case, to WordPress 2.8.5. In one of my web hosts, I was not able to upgrade the WordPress Stats Plugin automatically because it cannot locate ‘downloads.wordpress.org’ so I just upgraded it manually. I was afraid that I might not be able to use the WordPress Automatic Upgrade but when I did, it went fine.

I also checked the wp-config-sample.php and wp-cron.php files which I was telling you about in this blog entry, WordPress 2.8 to WordPress 2.8.4 wp-config-sample and wp-cron files, no closing tags. Up to now, the two files have no closing tags yet.

I still had a problem with the WordPress Image Gallery Code which I mentioned when I upgraded to WordPress 2.7.1, and again, when I upgraded to WordPress 2.8 Baker (Gallery Code Problem), WordPress 2.8.3 (Image Gallery Problem and Solution), WordPress 2.8.4, and in this new release, WordPress 2.8.5.

I found the solution for the WordPress Gallery Code problem anyway, so I just commented all the four necessary lines at post.php file which can be found under the wp-includes folder. I do not like to do it over and over again, but I have no choice. I might have to reorganize the images or photos one of these days.

I use the WordPress Automatic Upgrade feature in upgrading all the blogs and websites. Everything went fine except for the two problems that I mentioned that I have been having since WordPress 2.7.1. I have no other major problems regarding upgrading from WordPress 2.8.4 to WordPress 2.8.5. Thanks goodness!

By the way, every time I upgrade, I test all the sites in my local computer. I have PHP, phpMyAdmin, and WordPress installed in my local computer. I make sure that everything is fine before I upgrade.

One more thing, and it is a very important reminder!

Backup your WordPress database and files first before you upgrade.

WordPress