Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2012-03-22
8
Medium Priority
?
17,863 Views
Last Modified: 2018-03-14
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
8 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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
 

Expert Comment

by:Asha Rani
ID: 42499197
Reconfigure Mysql Instance Config Wizard which solved my problem
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
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…

595 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