Solved

MySQL Command Line Client flashes then disappears when tryning to open in Windows 7?

Posted on 2012-03-22
7
9,839 Views
Last Modified: 2012-06-21
When I try to open an instance of MySQL Command Line Client in Windows 7, a DOS compatibility command line like window flashes up on my desktop then disappears in less than a half a second. Too fast for me to read anything on or in the Window. It is for MySQL version 5.5.20. This happens from desktop shortcut and Start Menu All Programs.

Does anybody know of a cure for this?
0
Comment
Question by:Ted Palmer
  • 5
7 Comments
 
LVL 11

Expert Comment

by:maeltar
Comment Utility
Open a command prompt first, then run the utility..
0
 

Author Comment

by:Ted Palmer
Comment Utility
maeltar,

Thank you, but that didn't help. I opened a command prompt first, and kept it open -- no help. I opened a command prompt - closed it. Then I tried to open the MySQL command line and got the same result. It just flashes up - then disappears from my desktop very fast. Everthing else on the PC is behaving normal as best I can tell.

TedPalmer
0
 

Author Comment

by:Ted Palmer
Comment Utility
EE Experts:

I have TOAD for MySQL installed on that PC. I can open TOAD and connect to the running instance of MySQL server. There are only 4 schemas there because I haven't created a user database in the MySQL RDBMS instance yet. The performance schema is the only one with any tables in it. Only 3 of the tables have any data in them at all, and it is not very much. So I know that the MySQL instance is running as a service on that PC. At this point this is all I know.

TedPalmer
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:Ted Palmer
Comment Utility
EE Experts:

Another test is that I opened a DOS prompt window; navigated to "C:\Program Files\MySQL\MySQL Server 5.5\bin

Executed the command line "mysql -u root =p". Entered the root password when prompted.

I'm running the command line prompt that way. I can execute several varieties of the SHOW command and get good results. This would be OK except the DOS compatibility window will not expand width wise and the MySQL Command Line client will. This is an issue for me that I would rather not have to live with.

So I'm still stuck waiting for a comment that works.

Thank you very much in advance.

TedPalmer
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
is that "path" in the path environment variable?
0
 

Accepted Solution

by:
Ted Palmer earned 0 total points
Comment Utility
angelIII,

That didn't fix it, but that got me to looking closer at something else that I should have looked at more closely in the first place. The problem was this.

The full path to the executable didn't have to be in the PATH environment variable because the short cut created by the installation wizard specified the full path to the executable. The problem was that there was a command line parameter on the short cut "Target" execution line that specified the path to the "my.ini" file that the MySQL server uses to know where to find the data and log files and a whole bunch of other stuff. That path was to the wrong directory because I frequently change the specified place to put things. I have paid a high price for being obstinate about things like that before.

This is what the Wizard created in the Shortcut:
====================
"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe" "--defaults-file=C:\Program Files\MySQL\MySQL Server 5.5\my.ini" "-uroot" "-p"

This is what I changed it to to fix it:
====================
"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe" "--defaults-file=C:\ProgramData\MySQL\MySQL 5520 InnoDB Datafiles\my.ini" "-uroot" "-p"

Thank you,
Ted Palmer
0
 

Author Closing Comment

by:Ted Palmer
Comment Utility
No comment from an EE Expert provided a solution that fixed the problem exactly. I want those who are looking for a solution to read this question and answer in the future to get directly to the complete correct answer as soon as possible without spending time on an incorrect answer before reading my full description.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Creating and Managing Databases with phpMyAdmin in cPanel.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now