You can do with the mysql command line program:
Suppose you have a user named freddywilson7, and that his current password is ‘blackberry’. You wish to change it to a more secure password like ’20#zLlDmFUDIR4Wzt$Ag*cef^mG8IZX5pg8xfzg&0#$ge’
You do the following:
$mysql -u root -h localhost -prootpass7 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2015 Server version: 5.5.30-1~dotdeb.0 (Debian) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SET PASSWORD FOR 'freddywilson7'@'localhost' = PASSWORD('mJ7msmwb0lk%*BAIKCA!hT!Xdr3K'); Query OK, 0 rows affected (0.00 sec)
I used this to manually set a stronger password for my WordPress databases, as i-mscp did not allow me to use special characters as part of the password.