4,348
edits
MySQL: Difference between revisions
→Removing access from users
| Line 23: | Line 23: | ||
<source lang="mysql"> | <source lang="mysql"> | ||
mysql> revoke all privileges on dbcloud.* from 'dbacc'@'localhost'; | mysql> revoke all privileges on dbcloud.* from 'dbacc'@'localhost'; | ||
</source> | |||
== Suppress password on the CLI warning == | |||
When logging into the MySQL console with password you get a warning like this: | |||
<source lang="bash"> | |||
$ mysql -uusername -ppassword -Dmydb | |||
</source> | |||
<code>mysql: [Warning] Using a password on the command line interface can be insecure.</code> | |||
You can suppress this by using <span class="package">mysql_config_editor</span> utility. | |||
<source lang="bash"> | |||
$ mysql_config_editor set --login-path=local --host=localhost --user=username --password | |||
$ mysql --login-path=local -Dmydb -e "statement" | |||
</source> | </source> | ||