Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2012-03-22
7
Medium Priority
?
15,112 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

610 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