Category: Miscellaneous

If you have never set a root password for MySQL server, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:
$ mysqladmin -u root password NEWPASSWORD
However, if you want to change (or update) a root password, then you need to use the following command:
$ mysqladmin -u root -p'oldpassword' password newpass
For example, If the old password is abc, you can set the new password to 123456, enter:

$ mysqladmin -u root -p'abc' password '123456'

Change MySQL password for other users

To change a normal user password you need to type (let us assume you would like to change password for user vivek) the following command:
$ mysqladmin -u vivek -p oldpassword password newpass

Changing MySQL root user password using MySQL sql command

This is another method. MySQL stores username and passwords in user table inside MySQL database. You can directly update password using the following method to update or change password for user vivek:

1) Login to mysql server, type the following command at shell prompt:
$ mysql -u root -p

2) Use mysql database (type command at mysql> prompt):

mysql> use mysql;

3) Change password for user vivek, enter:

mysql> update user set password=PASSWORD("NEWPASSWORD") where User='vivek';

4) Finally, reload the privileges:

mysql> flush privileges;
mysql> quit

The last method can be used with PHP, Python or Perl scripting mysql API.

Sign in your amazon account, hover your mouse to Hello “Your Name” and Look for “Manage Your Kindle”.

On the left hand column under “Your Kindle Account” click on “Manage your devices”. There, you will have to option to “Deregister” old devices.

MySQL SUBSTRING() returns a specified number of characters from a particular position of a given string.

Syntax

OR

UPDATE `lockers` SET `currpass` = SUBSTRING(`currpass`, 1, 8)

UPDATE `joo_categories` SET `title` = SUBSTRING(`title`, 1, CHAR_LENGTH(title) - 2) WHERE  `title` LIKE  '%∞%'

UPDATE messages SET message = CONCAT(message,'new text to add')where user_id =1;
OR
UPDATE `rqktr_content` SET `title` = SUBSTRING(`title`, 22) where `title` LIKE 'Watch Naruto Shippuden Episode ___'

UPDATE tb_messages 
SET message =CASE 
WHEN LENGTH(message)>0THEN 
                  CONCAT(message,',','New message content')  
ELSE'New message content' 
END
WHERE user_id =1

or

UPDATE `rqktr_content` 
SET `title` = CONCAT('Watch ', title) 
WHERE `title` LIKE 'Fairy Tail Episode ___'

ORRR

UPDATE `rqktr_content` 
SET `title` = CONCAT('Watch Naruto Shippuude', title) 
WHERE `title` LIKE 'n Episode ___'

Hope it helps 🙂
refs:http://www.w3resource.com/
http://stackoverflow.com/questions/9548097/does-mysql-offer-append-content-to-the-value-of-a-column