Mysql Password Change.

by

mysqladmin -u root password NEWPASSWORD

mysqladmin -u root -p’oldpassword’ password newpass

mysqladmin -u root -p’abc’ password ’123456′

Use the following mysql command:

mysql -u root -p’123456′ db-name-here

OR

mysql -u root -p’123456′ -e ‘show databases;’

$ mysql -u root -p
Use mysql database (type command at mysql> prompt):

mysql> use mysql;
Change password for user ravindra, enter:

mysql> update user set password=PASSWORD(“NEWPASSWORD”) where User=’ravindra’;
Finally, reload the privileges:

mysql> flush privileges;
mysql> quit

HAProxy

by

HAProxy is a load balancer TCP/HTTP , commonly used to improve the performance of web sites and services by spreading requests across multiple servers.[1] It is written in C[2] and has a reputation for being fast, efficient (in terms of processor and memory usage) and stable.[3]

HAProxy is used by a number of high-profile websites including Stack Overflow,[4] Reddit, Tumblr, and Twitter[5][6] and is used in the OpsWorks product from Amazon Web Services.[7]

HAProxy is free and open-source software subject to the terms of the GNU General Public License (GPL) version 2.

HAProxy stands for High Availability Proxy, and is a great TCP/HTTP load balancer. It distributes a workload across a set of servers to maximize performance and optimize resource usage.

A front-end application that relies on a database backend can easily over-saturate it with too many concurrent running connections. HAProxy provides queuing and throttling of connections towards one or more MySQL Servers and prevents a single server to become overloaded with too many requests.

All clients connect to the HAProxy instance, and the proxy forwards the connection to one of the available MySQL Servers based on the load-balancing scheme used.