MySQL Red hat linux

Password less command line scripts with MySQL 5.6

Prabath ThalangamaComment(0)

I have a number of command line scripts that copy MySQL databases down from staging servers and store them locally. These scripts set the password on the command line using the -p option.

With MySQL 5.6, a new warning is displayed every time my scripts run:

Warning: Using a password on the command line interface can be insecure.

This is annoying!

The way to solve this is to use the new command line tool mysql_config_editor to set up a “login path” which the mysql command line client can then use.

$ mysql_config_editor set --login-path=restore --host=localhost --user=restore --password

You will then be asked to enter the password for the user that you’ve set, ‘restore’ in this case.

Now, you can log in to mysql on the command line using:

$ mysql --login-path=restore

and note that you didn’t need to enter a password!

In my case, I then changed my scripts so that the restore line looks like this:

cat ${FILENAME} | mysql --login-path=restore ${DBNAME}
Prabath Thalangama
Web : sysadmin.lkEmail : inbox [at] sysadmin.lkLinkedin : https://www.linkedin.com/in/prabathtFacebook : https://www.facebook.com/prabath.hinoize

Related Articles
Red hat linux Web Hosting

Install and configure FTP server on CentOS

Prabath Thalangama

Complete answer that solved my question for any others that are after a step by step walkthrough… Install vsftpd using “yum install vsftpd”. Create user with useradd [user_name]. Create user’s password with passwd [user_name]. (You’ll be prompted to specify the password). Create FTP directory in /var/ftp and then bind to the ‘home’ directory you wish […]
Red hat linux

Docker Cheat Sheet

Prabath Thalangama

Docker Terms This section defines some of the most useful Docker terms. Docker Image: A set of read-only files. These files are a part of an operating system that is required to run a Docker container. Dockerfile: A simple text file that contains all the commands a user could call in the command line to […]
Red hat linux

Sending SNMP Traps from Nagios

Prabath Thalangama

As well as receiving SNMP traps in Nagios, you can send SNMP traps from Nagios to a remote SNMP management station like HP OpenView (NNM) or the like. The easiest way to do this is to create a notification command that generates an SNMP trap. This way, you can use an SNMP management station as […]

Leave a Reply

Your email address will not be published. Required fields are marked *