How to modify Blog title of the Word Press

The blog details are mentioned in the database of the word press.

Use the following query to find out the blog name from the database.
mysql> select * from wp_options where option_name="blogname"\G;

It will look like:
*************************** 1. row ***************************
option_id: 2
blog_id: 0
option_name: blogname
option_can_override: Y
option_type: 1
option_value: Jami is a Poet
option_width: 20
option_height: 8
option_description: Blog title
option_admin_level: 1
autoload: yes

You can modify the blog name (or title) to "Jami is an Artist" by:
update wp_options set option_value='Jami is an Artist' where option_name="blogname"

Thats all needed.

Wordpress admin login issue -due to siteurl

During the wordpress installation, customers set the Site URL as http://www.domainName/wordpress. But in the configuration file (or wordpress folder) it will be "WordPress". Due to this customer can't login wordpress admin using http://www.domaName/WordPress/wp-login.php.

Fix: In that case you need to modify the wordpress database table entry.

Use the word press database and the following update:
select * from wp_options where option_name="siteurl"\G;
update wp_options set option_value="http://www.domainName/WordPress" where option_name="siteurl";


Note: Replace the domainName by corresponding domain name. The wordpress prefix wp_ will change a
ccording to the situation.