Bug #58297 Start menu shortcut for mysql client invalid
Submitted: 18 Nov 2010 18:27 Modified: 28 Dec 2010 19:05
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:5.5.7 OS:Windows
Assigned to: CPU Architecture:Any
Tags: qc

[18 Nov 2010 18:27] Peter Laursen
Description:
The .msi installer installs a shortcut to the client in start menu.  However path is invalid with 5.5.7

From context-menu .. properties of the start menu icon you get the path 

"C:\Program Files\MySQL\MySQL Server 5.5\bin\"

I believe it should be

"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql -uroot -p"

(5.0.90 and 5.1.52 are OK - but 5.5.7 is not - and I never noticed this with any other server version before - but I do not exclude the possibility that earlier 5.5.x had same problem)

How to repeat:
Try starting the client from the start menu shortcut.  It tries to invoke the installer, but fails (???? why does it invoke the installer BTW ????)

Suggested fix:
Fix path.
[18 Nov 2010 18:28] Peter Laursen
Forgot to mention that I am using 64 bit package.
[18 Nov 2010 19:16] Peter Laursen
My belief was wrong! 5.1 has the start folder definition set as "C:\Program Files\MySQL\MySQL Server 5.1\bin\" .. and it works fine. Not sure what the problem really is here. But definitely some packaging problem.

MSI displays 'the feature you are trying to use is on a network resource that is unavailable'.  If I click the 'Browse' button it becomes obvious that it is looking for the file "mysql-5.5.3-m3-winx64.msi".  

However from 'cmd.exe' I can start the client.
[19 Nov 2010 0:53] MySQL Verification Team
What exactly Windows version have you installed it?. On my side I got another bug on Vista Home Premium 64-bits, it was only shortcut for MySQL Instance Configuration Wizard and not mysql command line client. Thanks in advance.
[19 Nov 2010 8:42] Peter Laursen
Windows 7 Home Premium 64 bit.

The first 5.5 server on this machine was 5.5.3 installed back in April/May I think (this PC was bought at that time).  It has been upgraded with any 5.5 version released since.
[15 Dec 2010 12:26] MySQL Verification Team
I did again the install on fresh Vista Home Premium install and again got the same bug commented at [19 Nov 1:53] Miguel Solorzano. So please verify again to set as verified but the missed client shortcut not the wrong path. Thanks in advance.
[15 Dec 2010 12:32] Peter Laursen
I upgraded to 5.5.8 one hour ago and same thing still happens here: the start menu shortcut to the client launches the .msi installer and prompts (images will come).

Now this is not a fresh install.  It may have been introduced in an earlier 5.5x.
[15 Dec 2010 12:34] Peter Laursen
msi installer launches on click on shortcut

Attachment: msistart.jpg (image/jpeg, text), 42.26 KiB.

[15 Dec 2010 12:35] Peter Laursen
cancelling prompts this

Attachment: nosoruce.jpg (image/jpeg, text), 14.19 KiB.

[15 Dec 2010 20:55] Peter Laursen
It gets worse.

I tried to
1) uninstall MySQL 5.5,8
2) delete everything related to it
3) reinstall

then ..
1) I noticed there were *TWO* MySQL instances in Windows uninstall menu. I removed both
2) I did a fresh install of 5.5.8 and the shortcut to the client is not installed (I will open a new report about this(.
[15 Dec 2010 20:55] Peter Laursen
TWO MySQL 5.5 instances

Attachment: my55.jpg (image/jpeg, text), 12.27 KiB.

[15 Dec 2010 23:15] Vladislav Vaintroub
Peter, one of earlier betas was not uninstalled/upgraded correctly. I guess the only way to fix it is to uninstall both  5.5s and reinstall the correct one. What could probably work too, is to uninstall MySQL one and repairinstall the Oracle one. Off the top of my head I'd assume that the issue was changed product code.
[15 Dec 2010 23:17] Vladislav Vaintroub
s/product code/upgrade code
[16 Dec 2010 8:26] Peter Laursen
Well .. then it is explained.

But still Miguel has some weired issue with a fresh 5.5.7 and I have no shortcut with 5.5.8.

Anyway take this ahead as you want.
[16 Dec 2010 12:43] Peter Laursen
@Vlad .. I really do not understand what I should do with your latest comment reading: "s/product code/upgrade code". If it was for me please explain!
[26 Dec 2010 12:51] Valeriy Kravchuk
s/one string/the other/ is a command of ed editor in UNIX to replace one string with the other :)

As for this report, I think Vlad explained the reason, and as 5.5.8 has other (reported separately and verified) problem with missing shortcut, I think we should just close this report as 'Can't repeat', for example. Do you agree?
[26 Dec 2010 13:07] Peter Laursen
You may do as you want (close or make duplicate).  Whatever is most appropriate for your workflow.

The original problem I found seems to be that when upgrading from (I think) 5.5.3 to 5.5.4, the old version was not un-registered  - *OLD* and *NEW* version were registered in parallel. When activating the shortcut Windows would then try to install the *OLD* version (from a non-existing .msi installer file on my desktop)

After I uninstalled and removed 5.5.7 completely and did a fresh install of 5.5.8 I have a problem identical to what Miguel reported (shortcut does not exist).
[28 Dec 2010 19:05] MySQL Verification Team
I am closing since the missed shortcut has a bug reported and verified.
[8 Jan 2012 0:34] Niko Took
I'm creating my very first database with MySQL Workbench and I keep getting this response

What check_admin_commands/local
Operation failed: /usr/local/mysql/support-files/mysql.server start is invalid

What should I do??