musql shell launch

michail1982 posted 5 years ago in Feature discussion
Hi, i just update HeidiSQL & find feature to launch shell.
but i found some bug in there
in my local mysql db i have password digits,letters and "; symvols
when i try to launch shell it's does not started correctly..
Launching command line: Z:\usr\local\mysql-5.5.28-win32\bin\mysql.exe --host="" --port=3306 --user="myusername" --password="********"c"v2012"

i gues it's a password truble, because my password length is 19 symbols, but in log i see only 16..
PS: last sumbol before "c" is ;

HeidiSQL version
Mysql 5.5.28-win32
OS 7601.17803.x86fre.win7sp1_gdr.120330-1504
ansgar posted 5 years ago
The stars are only a cosmetic problem, just what HeidiSQL displays in its log. But on a command line, MySQL.exe has a similar problem with such a password, as it is surrounded by double quotes. If it contains double quotes, I don't know if there is a way to escape these.
ansgar posted 5 years ago
Ah, and do not rely on the number of stars! It does intentionally not match the length of your password, for security reasons.
ansgar posted 5 years ago
Please try out r4316 - works for me when using double quotes and semicolon within a 22 character password.
ansgar posted 5 years ago
The quoting stuff is more a Windows problem than a MySQL problem. You can surround parameters with double quotes, because the command shell is capable of removing these when passing to the program. Further, you need to escape double quotes with a backslash:
mysql.exe --host="localhost" --port=3306 --user="root" --password="your\"password"

This certainly does not only apply to the password parameter, although my fix in r4316 does it only for the password - I guess host names and user names never contain double quotes... do they? No :)
michail1982 posted 5 years ago
Problem fixed TNX for fast responce

Please login to leave a reply, or register at first.