The newest versions of the Mysql server, such as the 8, presents the following message when users try to use the database password in the command line:
# mysql -u root -p"password" -e "show databases" mysql: [Warning] Using a password on the command line interface can be insecure.
In order to prevent this warning message, you just need to create a password profile, in this example we going to create one called “local”:
# mysql_config_editor set --login-path=local \ --host=localhost --port=3306 \ --socket=/var/lib/mysql/mysql.sock \ --user=root --password
Now, you can easily run queries without providing the password, just use the “local” profile:
# /usr/bin/mysql --login-path=local -h localhost -e "show databases"