distal-attribute
distal-attribute
distal-attribute
distal-attribute

musql shell launch

User, date Message
Written by michail1982
2 years ago
Category: Feature discussion
13 posts since Wed, 23 Jan 13
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="127.0.0.1" --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 7.0.0.4315
Mysql 5.5.28-win32
OS 7601.17803.x86fre.win7sp1_gdr.120330-1504
Written by ansgar
2 years ago
4986 posts since Fri, 07 Apr 06
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.
Written by ansgar
2 years ago
4986 posts since Fri, 07 Apr 06
Ah, and do not rely on the number of stars! It does intentionally not match the length of your password, for security reasons.
Written by ansgar
2 years ago
4986 posts since Fri, 07 Apr 06
Please try out r4316 - works for me when using double quotes and semicolon within a 22 character password.
Written by ansgar
2 years ago
4986 posts since Fri, 07 Apr 06
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 :)
Written by michail1982
2 years ago
13 posts since Wed, 23 Jan 13
Problem fixed TNX for fast responce
 

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