How to locate Databases or phpMyAdmin at the DREAMHOST Control Panel

I shared with you the steps on how to locate databases or phpMyAdmin at the PLESK control panel and the steps on how to locate databases or phpMyAdmin at the H-SPHERE control panel.

Now, let me share with you the steps on how to locate MySQL Databases and/or phpMyAdmin at the DreamHost Control Panel.

Login to your Control Panel…

1. Enter your Control Panel username at the Email Address or Web ID field.

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

3. Click Log In button.

How to locate Databases or phpMyAdmin at the DreamHost Control Panel

You will be redirected to the DreamHost Control Panel.

Welcome

Welcome to your DreamHost Control Panel!

This is the control center of your DreamHost account. From here you can configure literally any aspect of your account in no time at all!

4. Look for Databases.

If you see Databases…

5. Click the text Databases with the icon.

How to locate Databases or phpMyAdmin at the DreamHost Control Panel

You will be redirected to another page.

MySQL Databases

MySQL Database Management

Be sure to review the MySQL documentation in our wiki!
To access a database from the command line, use:…

You will also see the text Add New Hostname with 3 columns under it, the Hostname column, Web Administration column, and Actions column.

6. Click the text phpMyAdmin under the Web Administration column of the corresponding Hostname that you would like to access.

How to locate Databases or phpMyAdmin at the DreamHost Control Panel

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

If you will be required to login…

7. Enter your database username at the Name field.

8. Enter your database password at the Password field.

9. 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…

10. Click Databases, then Database name.

That’s it!

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.

How to locate Databases or phpMyAdmin at the H-SPHERE Control Panel

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

Login to your Control Panel…

There are instances that H-SPHERE Control Panel looks like PLESK Control Panel.

Follow the instructions on how to locate databases and/or phpMyAdmin at the PLESK 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 H-SPHERE Control Panel

You are now at the Account page. I am assuming that you only have one domain.

4. Look for Databases and phpMyAdmin.

If you see phpMyAdmin under Databases…

5. Click the phpMyAdmin icon.

How to locate Databases or phpMyAdmin at the H-SPHERE Control Panel

You will be redirected to another page where you will see the User column and Login column.

6. Select user to configure database via phpMyAdmin.

7. Click the Built in phpMyAdmin control panel icon under the Login column of the corresponding User.

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 Built in phpMyAdmin control panel icon under the Login column of the corresponding User.

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.

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.

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.

Upgraded to WordPress 2.1 Ella

I finished upgrading the sites using WordPress from WordPress 2.0.7 to WordPress 2.1. Upgrading a WordPress site is not that complicated. What makes the site complicated when being upgraded? If some tags were deprecated, some features were removed or transferred, and if the Plugins, if you have any, aren’t compatible with WordPress 2.1 Ella.

There were no major problems with SofieHofmann.com Blog as it is a blog. I just have to check my blog entries for XHTML validation. I corrected a little bit at CSS file as my images are always centered but the text are always justified. All of a sudden, the centered text were adjusted to the left. They’re ok now.

With Sehdi.com, I had to redo the conditional tags because of the feature that a static page can be assigned to the front page. I did both the code for a static page as well as for the latest posts, so even if I switch from one to another, the pages won’t break and won’t be affected at all. No matter what, I can assign a static page or the latest blog posts anytime to the front page. I haven’t use this feature with other sites yet. One thing though, the quicktag <!--more--> doesn’t work but the quicktag <!--nextpage--> works. I still have to figure out the solution to the <!--more--> quicktag.

With Weggis.net, I needed to remove some conditional tags at the archives, having the articles after each topic. Sometimes they appear, sometimes not. Instead, I changed the number of articles at the individual archives. So if you check each topic archive, all the titles of the articles are there aside from the latest one on top of all the other ones.

With Pagtatap.org, there’s not a lot of problems, as it was just newly redesigned.

With Pandan.gov.ph News, it was just like Sofiehofmann.com Blog. I just fixed the CSS because of the floating images to the right, and XHTML for validation.

With Pandan.ph, I have more problems with one of the Plugins. I’m using a Paged Comments Plugin in this site and it was not working with PHP include <?php include (file.php); ?> unless you put the TEMPLATE PATH before file.php. I also have Paged Comments Plugin at Pagtatap.org but this problem didn’t occur there as I was not using too much page templates unlike with Pandan.ph. Anyway, I was able to fix everything.

For all the other sites, I needed to change the deprecated template tags, wp_list_cats to wp_list_categories and get_archives to wp_get_archives. Actually, as of the moment, even if you didn’t change them, they will stay the same, won’t really affect the site.

Regarding the links being part of categories now, if you have get_link_list and opted to check show description, it’s not working now. That option was removed from the admin side, and so, I replaced get_link_list with wp_list_bookmarks.

I’ve written something about a Plugin. What about other WordPress Plugins?

I don’t use too many WordPress Plugins. So far, I have these Plugins but not in all the sites.

Akismet Plugin by Matt Mullenweg, WP-PostViews by GaMerZ, Post Updated by Kaf Oseo, Peter’s Custom Anti-Spam by Peter Keung, Sidebar Widgets by Automattic, Simple Recent Comments Widget by Mika Perälä, randomimage by Justin Watt, Filosofo Home-Page Control by Austin Matzko. No problem with all these WordPress Plugins.

SRG Clean Archives Plugin by Shawn Grimes. I have to fix the post_status='publish' to post_type='post' as I don’t want the pages to be part of the monthly archives.

Paged Comments Plugin by Keyvan Minoukadeh. I already mentioned about the Paged Comments Plugin and fixed the problem.

Counterize II Plugin by Steffen Forkmann. I deactivated this Plugin except at Sehdi.com and SofieHofmann.com Blog even before upgrading to WordPress 2.1. It’s in conflict with the Google Search that I’m using. I couldn’t fix it yet. I’m always getting a message above the page referring to the database. But if I just use the normal WordPress search, no problem at all.

WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1]
update wp_Counterize_Pages set count = count + 1 where pageID =

Everytime I activate the Plugin and test google site and web search, the message above appears and another one and another one. I haven’t asked the author of the Plugin yet about this, hoping that I will solve it myself. But since I’m not a MySQL guru, I still have to figure it out. As I see it, I think the solution is just simple and it’s just there but I haven’t really figured that out yet.

WordPress Database Backup Plugin by Scott Merrill. I never really used WordPress Database Backup as I backup my database from the phpMyAdmin itself. I just tested it and eventually deactivated again in the other sites. No matter how I changed the File Permission of wp-content, it’s just not working in other sites. It’s not creating index.php at the backup folder and so I couldn’t backup my database. So as not to put the security of wp-content in danger, I just deactivated the Plugin except at the 2 of all the 6 sites.

Well, that’s all for today. Other than what I have mentioned above, everything is ok. All the sites are fine and running without any problems. Thanks to WordPress Team! Thanks to WordPress Plugins authors!

WordPress Upgrades, WordPress Plugins, Site Updates

I upgraded Simply Sofie Blog and the News section of the Official Website of the Muncipality of Pandan, Antique, Philippines from WordPress 2.0.4 to WordPress 2.0.5. It was an easy upgrade though. I just made a backup of the MySQL database, deactivated the WordPress Plugins, and then deleted the folders and its files except the wp-content folder, and the .htaccess. Afterwards, I uploaded the unzipped WordPress 2.0.5, default is wordpress of course, but in my case, I normally rename it.

With regards to the wp-config file, I deleted that file too, and just uploaded the new one with the same database name, username and password. If you are going to delete that file, make sure you remember the database name, username and password. But I suggest, not to delete it, just like the .htaccess, so you don’t have to upload that file again. There is always a tendency that you might overwrite the file, so always remember to make a backup of your wp-config file before you upload the other files. Make a habit too of making a copy of your wp-content files.

I know WordPress 2.0.5 was released 55 days ago and upgrading from WordPress 2.0.4 to WordPress 2.0.5 would only take a few minutes, but I was not able to do it. Why did I upgrade them now? Well, I installed the Counterize II Plugin version 2.04, that’s why. It seems like it has a problem with WordPress 2.0.4 but I didn’t bother anymore to analyze it. I know that it works with WordPress 2.0.5, so I just upgraded Simply Sofie Blog and Pandan.gov.ph News. The timing was just right.

Few weeks ago, I also installed Peter’s Custom Anti-Spam Plugin version 2.6. I’m already using Akismet, but it seems like it’s not enough. I have been getting a lot of spams, hundreds of them, but eversince I installed Peter’s Custom Anti-Spam, I don’t get those spams anymore, unless the spammers really visit my site and fill out the form from the site.

I’m not just installing these plugins in one site but in almost all my sites. Take note, these plugins should be regularly checked as well if they have new versions or not. Another plugin, the WP-PostViews Plugin has a new version, so I uploaded WP-PostViews 1.02 to replace WP-PostViews 1.00.

This is actually what I don’t like about all these software programs and plugins, we always have to upgrade. Well, that’s part of the web designer’s life. Anyway, when there’s something new, we learn too.

Lastly, I updated the site of Swiss Big Game Fishing. I added at least seven pictures at the “Fangerfolge” pages. I also updated the media pages of Green Cross Switzerland. The press releases are both in German and French Languages.

WordPress 2.0.3 to WordPress 2.0.4

I just finished upgrading Sehdi.com Blog, Weggis.net and Pagtatap.org Updates from WordPress 2.0.3 to WordPress 2.0.4. The latest stable release of WordPress is now available, the WordPress 2.0.4. You can download it from WordPress.org.

If you need to install WordPress, just follow the installation instructions available at WordPress Codex section. If you’re just going to upgrade, then follow the upgrading instructions.

It’s very simple to upgrade, make sure to backup your files and your MySQL database first, then delete the old files except the wp-content folder, .htaccess, if you have any, and wp-config.php. Upload, via FTP, the files that you extracted in your computer.

Just don’t forget to deactivate all the WordPress Plugins before you upload the files. This is just to make sure that you won’t have a broken installation after upgrading. Some plugins may not work with WordPress 2.0.4.

Anyway, just to add, I also updated Weggis.net site and Simply Sofie Blog at SofieHofmann.com.

PHP, MySQL, HTML, External Hard Disk Drive

I’ve been too busy lately. Few days ago, I revised the PHP codes of my personal site Simply Sofie at SofieHofmann.com. It’s better now and easier to update. I also updated some data.

I didn’t really appreciate PHP before because of MySQL. I just hated the idea that I always have to back-up my database and if ever I forget to do it, and then something happened (i.e. lost database), then I will be left with nothing and have to do it all over again.

I am not a programmer just a simple hobby web designer but if I would like to be more effective, I need to know PHP. So I learned PHP through reading tutorials on the net.

One way or another, I have learn to love PHP and MySQL but I will never forget HTML. If you would like to start designing a website, I will always recommend to start with HTML. Until now, I write my codes using notepad. I still use HTML/XHTML combined with PHP and MySQL.

Since I have to download a lot all the time, considering that I also take a lot of pictures, I’m now running out of space in my hard disk drive. I still have a lot of pending hobby projects and I couldn’t really clean up my computer because I need to back up my data first.

Finally, my husband bought a 300 GB external hard disk drive today. He bought it for me. I was really so happy when I saw it. I can finally transfer my other data and erase some unnecessary files. What a relief!

MySQL and Few Site Updates

I was on vacation for a month and came back here in Switzerland 2 weeks ago. I felt exhausted just thinking about the work I left behind that I could not even do some updating to the sites.

Well, I finally updated the sites of Swiss Big Game Fishing and Green Cross Switzerland.

Last Saturday, the 27th of May, I added few photos at the Swiss Big Game Fishing and you can see those pictures at the “Fangerfolge” page. Literally, “Fang” as a noun means “Catch”, and “Erfolg” as a noun means “Success”.

Last night, I updated the site of Green Cross Switzerland, took the pop-ups, changed something on the pages that they updated when I was on vacation, and still working on some of the pages.

Regarding MySQL, I installed MySQL before in my computer and it was running ok, but few days ago I accidentally did something that I could not access my database afterwards. I could not fix it properly so I decided to uninstall it. I was able to re-install it last night.

I read these resources when I installed MySQL in my computer and thought that after what happened to me, I might as well write the links here for your reference. I have IIS (Internet Information Services) running in my computer and configure it so PHP (PHP: Hypertext Preprocessor) would work aside from ASP (Active Server Pages).

Advice on setting up and configuring MySQL and mysqlcc
SwoofWare » How to be a WordPress WIMP
MySQL 5.0 Reference Manual
TUTORIAL: How to install PHP and MySQL on IIS
Installing MySQL to run with IIS
Free Workshop: How to Install PHP 5, Apache 2, MySQL 4.1, SQLite, SQLite Manager and XSLT on Windows
How to Install Apache, PHP and MySQL on Linux
MySQL Tutorial – Uninstalling MySQL as a Service
Mysql: How do you uninstall MySQL completely?

Some other resources that are very useful are Apache, Linux and Microsoft Windows.

Thank you everyone for taking the time to write all these so we have something to read.