To change the password on a MySQL user account, we can use the ALTER USER command: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'super-strong-password'; Query OK, 0 rows affected (0.00 sec) ...

mysql --password=secret --user=username database_name < query.sql This approach has two drawbacks. First, it is not secure. Second, if you have many scripts with embedded passwords you will have to ...