J
J
JackShcherbakov2018-03-13 17:42:54
MySQL
JackShcherbakov, 2018-03-13 17:42:54

How to solve MySQL login problem?

Hello!
When I try to login to mysql I get this message:

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

Like, it’s not safe to use the command line to log in. I found a solution (with others a similar problem arises) - write this to the console:
mysql_config_editor set --login-path="backup" --host="localhost" --user="root" --password

Registered and fell out the following message:
'mysql_config_editor' is not recognized as an internal or external command,
operable program or batch file.

I ran the command from C:\OpenServer\modules\database\MySQL-5.7\bin
How to get rid of this error? I used to restart the computer and everything, but now it does not help at all.
Thanks in advance!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
F
Fixid, 2018-03-13
@JackShcherbakov

It is not secure to pass the password in plain text via the command line.
You just need to pass an empty -p parameter and enter the password interactively

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question