Solved

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

Posted on 2012-03-22
7
11,494 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
ID: 37752397
Open a command prompt first, then run the utility..
0
 

Author Comment

by:Ted Palmer
ID: 37752443
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
ID: 37752492
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:Ted Palmer
ID: 37753462
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 143

Expert Comment

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

Accepted Solution

by:
Ted Palmer earned 0 total points
ID: 37754365
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
ID: 37770431
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

839 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