MySql console closes after password entered
Posted by: Teegirl (---.range86-186.btcentralplus.com)
Date: May 19, 2012 01:22AM

I am new to PHP. I just installed Wamp server following a tutorial. I installed and set the root password. But when i try to verify if the the password works, the MySql console closes immediately I click enter. I have checked several forums but the solutions are not clear. Help pls asap!!! Also the wamp server icon did not change to green



Edited 1 time(s). Last edit at 05/19/2012 01:23AM by Teegirl.

Options: ReplyQuote
Re: MySql console closes after password entered
Posted by: TCP (---.dia.static.qwest.net)
Date: May 19, 2012 02:43AM

There are several reasons why the icon may not have turned green. The common one is that you are probably running a program which is already using port 80, such as Skype. Go through the forums, this has been addressed many times and you will probably find your answer there (about the icon color).

Options: ReplyQuote
Re: MySql console closes after password entered
Posted by: judith (---.dyn.optonline.net)
Date: May 20, 2012 03:20PM

I am having the same problem. Just hitting the enter key gives me a loud beep and the console closes. Need help!

Options: ReplyQuote
Re: MySql console closes after password entered
Posted by: stevenmartin99 (Moderator)
Date: May 20, 2012 05:38PM

Judith did u set a password?

What colour is the wamp icon?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: MySql console closes after password entered
Posted by: tdang13914 (---.washdc.fios.verizon.net)
Date: November 02, 2013 05:16AM

Dear Steven,
I am new to wamp server.
I have the same issue when click on mysql console it close immediately.
I can't use phpmyadmin because of error
"#1130 - Host 'localhost' is not allowed to connect to this MySQL server "
A year ago, I used version 2.2
I remember setting up the password but forget now.
After issue, I remove version 2.2 and install version 2.4 64 bit on win 7.
Even I delete everything inside the wamp folder, thing happens the same.
Redirect to port 81 with green icon but fail to open mysql in console ( close unexpectedly) and GUI ( access denied)

I don't know what to do now.
I have teamviewer installed in my system and you can help by connection to my system.
I will email or chat to you the ID and password.

Thank for your help.
my email thanhdang2 at gmail . com



Edited 1 time(s). Last edit at 11/02/2013 05:24AM by tdang13914.

Options: ReplyQuote
Re: MySql console closes after password entered
Posted by: tdang13914 (---.washdc.fios.verizon.net)
Date: November 02, 2013 05:18AM

Dear Steven,
I am new to wamp server.
I have the same issue when click on mysql console it close immediately.
I can't use phpmyadmin because of error
"#1130 - Host 'localhost' is not allowed to connect to this MySQL server "
A year ago, I used version 2.2
I remember setting up the password but forget now.
After issue, I remove version 2.2 and install version 2.4 64 bit on win 7.
Thing happens the same.
Redirect to port 81 with green icon but fail to open mysql in console ( close unexpectedly) and GUI ( error)

I have teamviewer installed in my system and you can help by connection to my system.
I will email or chat to you the ID and password.

Thank for your help.
my email thanhdang2 at gmail . com

Options: ReplyQuote
Re: MySql console closes after password entered
Posted by: RiggsFolly (---.as13285.net)
Date: November 02, 2013 09:12AM

If you installed a new version of WAMP after deleting the old files completely....

The MySQL Username = root
The deaful tpassword = nothing ( leave it blank )


This is documented on the MySQL Site !!!!



Edited 1 time(s). Last edit at 10/29/2019 04:58PM by RiggsFolly.

Options: ReplyQuote
Re: MySql console closes after password entered
Posted by: tdang13914 (---.washdc.fios.verizon.net)
Date: November 03, 2013 03:33AM

oh, it works now.
Thank you so much.
TD

Options: ReplyQuote
Re: MySql console closes after password entered
Posted by: sandeepkumar (157.45.60.---)
Date: October 29, 2019 04:33PM

In wampserver all my 3 services are running and shows green
But the mysql console window closes automatically when I enter the password
I would be helpful if given the appropriate steps to resolve this error and perform the neccessary correction

Options: ReplyQuote
Re: MySql console closes after password entered
Posted by: RiggsFolly (Moderator)
Date: October 29, 2019 04:53PM

Yes,

Unless you have added a password to the MySQL root account there is no password so just leave it blank and press enter.

Also please DONT tag onto a question onto a thread thats 7 years old !!! Instead start read this one or start a new one.
Although if you were to read the answers you may have got your solution !!!

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 3 time(s). Last edit at 10/29/2019 05:01PM by RiggsFolly.

Options: ReplyQuote


Sorry, only registered users may post in this forum.