How to Set Up a Database for WordPress on My Website

Database Setup
1. Launch phpMyAdmin or a similar MySQL database tool.
2. Click 'Privileges' from the list of tasks. Scroll to the bottom of the list of databases displayed and click 'Add a New User.'

3. Enter a user name, which will also become the name of the database. Type '%' for the host, enter a password and retype the password. Click the radio button next to 'Create Database With the Same Name and Grant All Privileges.' Click 'Go' at the bottom-right of the screen.
4. Click the 'Databases' tab to display a list of databases. Scroll to the database you just created and click on it.
5. Click the 'Operations' tab and change the collation by selecting a different collation from the drop-down list box, for example: 'utf8_unicode_ci.' Click 'Go' after you've selected the new collation.
WordPress Setup
6. Open a command-prompt window and change to the directory of the WordPress installation. For example, type:cd /var/www/myblog
7. Create the WordPress configuration file by copying the sample configuration file in the directory. For example, type:cp wp-config-sample.php wp-config.php
8. Edit the WordPress configuration file in an HTML editor or in the Notepad. For example, type:nano wp-config.php
9. Scroll to the section of the file that begins with '** MySQL settings' and locate the three configuration statements for the name of the database, the database username and the database password.
10. Replace 'database_name_here' with the username/database name you entered when you created the database. Replace 'username_here' with the same name. Replace 'password_here' with the database password. Keep the single quotes surrounding each name in all three statements. Exit the editor and save the file.
11. Open a browser and navigate to the installation utility for the blog installation, for example: www.example.com/myblog/wp-admin/install.php. Verify that the installation program does not issue a database connection error and proceed with the WordPress installation.

How to Put CSS Code in a WordPress Widget

1. Log in to the WordPress dashboard from the 'wp-admin' directory of your website. Navigate to 'Appearance' and click the 'Widgets' link to load the 'Widgets' screen. You'll see your sidebars and a list of widgets on this page.
2. Click the name of a sidebar to expand it and display its widgets. Expand the widget's options by clicking on its down-pointing arrow.

3. Add HTML tags containing inline CSS code in an options field of the widget. Not all options fields can take HTML or CSS cod. To test this, input some HTML and click 'Save' to see if the HTML stays or gets deleted. You can always add HTML and CSS to the 'Text' widget that comes with every installation of WordPress. Click the blue 'Save' button in the widget's option box to save your changes.
4. Navigate to 'Appearance' and click the 'Editor' link if you couldn''t add CSS code directly in to the widget through its option fields. Locate the 'functions.php' file and click its link. Locate the 'register_sidebar' code and make the line containing 'before_widget' look like this:'before_widget' => '
',Change the 'after_widget' so that it closes the '
' tag you opened:'after_widget' => '
',
5. Load your blog in another tab or window of your Web browser. Right-click the browser screen and select to view the source code. Find the '
' tags surrounding the widget you want to change and take note of its ID attribute. The code will look similar to this:

6. Go back to the WordPress dashboard and navigate to the 'Edit Themes' screen again. Locate the 'style.css' file at the bottom of the screen and click its link. Add your CSS for the widget at the end of the file like this:#archives-3 {property: value;}Replace 'property: value;' with a CSS property-value pair such as 'color: red;'. Update the file when you finish editing.

How to Install a Friend Connect Widget on Your Wordpress Blog

How to Install a Friend Connect Widget on Your Wordpress Blog
1. Go to http://www.google.com/friendconnect/ and log in with your Google account. It can be the same one as your Gmail account. Register your site with this service: enter your web site's URL, the title, and the language it's written in.
2. Go to the 'Overview' section on the left column and edit the information there. Then click on the option right below it, where it says 'Gadgets'. Those are all the different Friend Connect boxes you can have on your sidebar. We are going to install the one for your Friends and community of readers.

3. The 'Members' gadget is the first one on the list. Click where it says 'Get this gadget' to access the HTML code you will paste on your site. Different boxes will show up--that's where you can choose the number of rows, columns, and the colors you want to include on the box. Once you are done, click on the third option, 'Generate code', and copy it (Ctrl C or cmd C)
4. Log in to your Wordpress blog and go to the 'Widgets' section on your administrator panel. Drag one of the 'Text' widgets to your sidebar. Open the widget and paste the code you copied from the Google Friend Connect Members gadget. Save and close the widget, and choose the location you want it to appear on your sidebar.
5. Go to your 'Settings' menu inside the Wordpress admin dashboard. There should be an option for 'Friend Connect.' Click on it. You'll need to enter your site ID in order for it to work. You can retrieve your site ID from your Google FriendConnect page. The ID is the last 20 digits on your URL. You can also find it within the code you posted on your widget, where it says:
(The numbers following 'div-' are your ID.) Save all changes.
6. Go to your blog and the widget should show on your sidebar. Now you can login to the widget and start inviting your friends to be part of your community!

How to Make a WordPress Blog a Widget on Facebook

1. Log in to your Facebook account using your user name and password.
2. Type 'RSS Feed' in the search box, and press the 'Enter' key.

3. Click on the 'Simply RSS' link.
4. Click on the 'Go To App' button at the top of the page.
5. Click the 'Allow' button to let the app access your basic information.
6. Click the 'Add new feed' button on the right.
7. Type the URL of your WordPress feed.
8. Enter the number of posts that you wish to display.
9. Check the 'Enable feed on profile' box.
10. Click the 'Add' button. Your WordPress blog's feed has now been added to your Facebook Profile. Each time you publish your blog, your Facebook profile will be updated with your most recent blog entry.

How to Transfer a Website to WordPress

1. Register for WordPress and make sure to create your blog. Log in to the site and click 'My Blog' and then 'Register a New Blog,' then choose your 'something.wordpress.com' address to begin. You can't use the import tools or add new posts until you've created your site. After your site is set up, all the WordPress functions are available to you.
2. Click 'Tools' on the left-hand side of the WordPress Dashboard; choose 'Import.' WordPress has built-in migration tools for a few platforms. You can use the Import tool to migrate all your content from Blogger, Blogroll, Israblog, LiveJournal, Movable Type (or TypePad), Posterous, Vox, Yahoo! 360 or another WordPress website through this control panel. If you use one of these platforms, this is the easiest way to move your site to WordPress, but not the only way.

3. Check the WordPress support forums for specific importing instructions or tips for moving your content from a database other than the ones listed in Step 2. It's likely that someone else on WordPress is coming from the same kind of setup that you have. If you are using a site based on Drupal, Joomla, Mambo or another open-source CMS, you'll find tutorials in the forums to help you transfer your site over. But since WordPress is a simplified CMS, you may find that the contents of a complex, open-source CMS won't migrate seamlessly.
4. Create a new blog structure on your WordPress site and manually migrate your content if Step 2 or Step 3 don't work for your website. This is also the easiest way to migrate your content from a basic site that didn't utilize CMS software. Define pages in WordPress that mimic the static content of your existing site. If you have a section on your site called 'About Us,' create a page on WordPress by the same name, then copy and paste the content from your site to WordPress. WordPress uses 'Pages' for static, unchanging content and 'Posts' for blog entries. Create new posts for each piece of content from your old site and copy and paste the data into each post. This process can be time consuming for large sites.

How to Embed Flash in WordPress Template

1. Open a Web browser and type your WordPress blog into the address bar. Press 'Enter.'
2. Log in to a WordPress account which has administrative access to that installation.

3. Click 'Administration.' Click 'Appearance.' Click 'Editor.'
4. Select the page that you wish to include the Flash embedded code on. If you're using a Flash ad, you may wish to change the header.php or footer.php file. For Flash widgets and small Flash ads, you can look at your sidebar.php file. Copy and paste the Flash embed code into the template file. Click 'Update File.'

How to Change the Password for WordPress Users

1. Hover the mouse over the WordPress Admin menu and click on 'Users.'
2. Click your WordPress username from the list. Scroll down to the 'New Password' section of the 'Edit User' screen.

3. Enter your desired new password into the two boxes marked 'New Password.' Choose one that creates a strong password on the strength meter below the boxes.
4. Click 'Update Profile' button at the bottom of the page when you have found a strong password.