musql shell launch
| User, date | Message |
|---|---|
|
Written by michail1982
4 months ago Category: Feature discussion 10 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
4 months ago 3950 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
4 months ago 3950 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
4 months ago 3950 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
4 months ago 3950 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
4 months ago 10 posts since Wed, 23 Jan 13 |
Problem fixed TNX for fast responce |
|
Please login to leave a reply, or register at first. |