O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Password-less authentication using mysql_config_editor

Whenever you enter a password using a command-line client, you might have noticed the following warning:

shell> mysql -u dbadmin -p'$troNgP@$$w0rd'mysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 1345Server version: 8.0.3-rc-log MySQL Community Server (GPL)~mysql>

If you do not pass the password in the command line and enter when it prompts, you won't get that warning:

shell> mysql -u dbadmin -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 1334Server version: 8.0.3-rc-log MySQL Community Server (GPL)~mysql>

However, when ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required