Rosamundwo.com

How to change the WordPress admin username

Tuesday, January 26th, 2010

How to change the default admin WordPress login name:

Login to your cpanel

Using your hosts MySQL administration tool (I.E. phpmyadmin), locate and select your WordPress database

selectdatabase

From your WordPress database, locate and select the wp_users table (Note: the wp prefix may differ) and then click the browse icon

wpuser

Next click edit

edit

Under the user_login column, change admin to your preferred WordPress administrative login name and then click go

[click to enlarge]

Now, you should be able to login with your new administrative WordPress login username

Posted in Wordpress | Comments

Display latest tweets in wordpress

Friday, October 30th, 2009

<div id="twitter">
<?php

// the function
/**
 * @desc Get latest tweet from a Twitter account
 * @param string The account's username
 * @return string The tweet
 */
function get_latest_tweet($username)
{
    $url = "http://search.twitter.com/search.atom?q=from:$username&rpp=1";
    $content = file_get_contents($url);
    $content = explode('<content type="html">', $content);
    $content = explode('</content>', $content[1]);
    return html_entity_decode($content[0]);
}

// now use it
$my_username = 'rosamundwo';
echo get_latest_tweet($my_username);
?>
<a href="http://twitter.com/rosamundwo"><br> <a href="http://www.twitter.com/rosamundwo/">Follow Me</a>
</div>

Demo

Posted in Twitter, Wordpress | Comments

[Solved] wordpress automatic update from version 2.7.1 to 2.8.4

Friday, October 2nd, 2009

After moving from Asmallorange to exabytes hosting, i cannot upgrade all my plugins and can’t upgrade my wordpress to the latest version 2.8.4

I have search through everywhere but couldn’t find the solution to this problem.

I have tried downloading core control and edit .htaccess but failed.

Finally i solved it !

1. Always backup your database and also your files / folder.
2. Delete your old wp-includes and wp-admin directories.
3. Upload the new wp-includes and wp-admin directories.
4. Upload and overwrite all the old files in the root, EXCEPT the wp-content folder and wp-config.php file. (I repeat DO NOT DELETE YOUR WP-CONTENT and WP-CONFIG.php file)
5. Visit your main WordPress admin page at /wp-admin, login and it leads you to an upgrade page, click upgrade and follow instruction.