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)
That’s it.
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.
Joel G Mathew, known in tech circles by the pseudonym Droidzone, is an opensource and programming enthusiast.
He is a full stack developer, whose favorite languages are currently Python and Vue.js. He is also fluent in Javascript, Flutter/Dart, Perl, PHP, SQL, C and bash shell scripting. He loves Linux, and can often be found tinkering with linux kernel code, and source code for GNU applications. He used to be an active developer on XDA forums, and his tinkered ROMS used to be very popular in the early 2000s.
His favorite pastime is grappling with GNU compilers, discovering newer Linux secrets, writing scripts, hacking roms, and programs (nothing illegal), reading, blogging. and testing out the latest gadgets.
When away from the tech world, Dr Joel G. Mathew is a practising ENT Surgeon, busy with surgeries and clinical practise.