WampServer

i try to access the Mysql Console but when i click the command it generates a cmd prompt to enter a password. I do not recall entering one,
Also i click the command to access Localhost and my browser generates a window screen requiring a usename and pw although none was previously entered. I was able to access both these screens earlier in the morning then it would not work. my icon in the system tray is white with a red section at the beginning of the scale. also earlier it was 3/4 yellow then it assumed the 1/4 red section and will not allow me to access these two screens. Please help Thank you

WAMP is not started. Left click the wamp tray icon and choose Start All Services. If its still shows red/yellow indicator then it means there is an issue and wamp is not running properly.

When running the MySQL Console just press enter when it asks for password. By default no password is setup for MySQL.

I have since closed the iis admin and am now able to get the local host but still cannot get the mysql console. i press enter as you suggested but it does noting and the icon for wamps is now 3/4 yellow i clicked to refresh and it goes red 1/4 for a second or two then back to 3/4 yellow
Thank you for your assistance

IIS and Apache/Wamp are both web server and might conflict in some way, so you have to disable IIS in order for Wamp to work

Disable IIS in Vista:

Control Panel, Uninstall Programs, Turn Widows Features On or Off, uncheck Internet Information Services

Disable IIS in XP:

Control Panel, Add/Remove Programs, Add/Remove Windows Components, uncheck Internet Information Services (IIS)

Restart computer, then restart Wamp

Also, open file hosts in folder C:\WINDOWS\System32\drivers\etc and delete anything in there and have only this line and nothing else

127.0.0.1 localhost

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

i have followed your instructions to the letter and uninstalled iis i cleared out the ststem32/drivers/etc folder and there is one file in there "hosts1" and in that file there is only one line "127.0.0.1 localhost" i even went sop far as to uninstall wamps and reinstall a fresh copy after restarting my computer. It installed and everything works fine except wheni click "Mysql console" it brings up a command prompt with the words as follows. maybe i'm am not too sure how to input the line "127.0.0.1 localhost" into the ststem32/drivers/etc folder


Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.36-community-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

once again thank you in advance for all your help

this is mysql....

mysql>

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

sorry but i no idea what you are trying to tell me re: this is mysql....

mysql>
if there is more meaning to your comment could you please elaborate. thank you

when you get to

mysql>


this is the mysql console....

so you have acheived what you wanted?


look at your wamp icon.. what colour is it now? if its not white.. then you have something blocking wamp.

add me to msn if you want me to take a look

stevenmartin99@hotmail.com

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

Thank you for all the help, my problem has been solved and we are off to the races. thank you again

Hello,

I have the same problem and I followed your instruction but no result

I deleted every thing in filed named lmhosts.sam E:\WINDOWS\System32\drivers\etc
and type only 127.0.0.1 localhost

phpmyadmin load very slowly and when go to mysql consol and hit enter nothing happen

I reinstall wamp but the problem still exist

I modified config.inc.php which in E:\wamp\apps\phpMyAdmin-3.3.8.1-all-languages
and it look like this:
<?php

/*
* This is needed for ****ie based authentication to encrypt password in
* ****ie
*/
$cfg['blowfish_secret'] = 'mycookie'; /* YOU MUST FILL IN THIS FOR ****IE AUTH! */

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/*$cfg['Servers'][$i]['auth_type'] = 'config';*/
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

also i modified httpd.conf in E:\wamp\bin\apache\Apache2.2.17\conf
i changed Deny for all to Allow for all

I managed to go to [localhost] after changing the auth-type to cookie rather than config
and type root for user and left password empty after submitted it drive me to a blank page with url:[localhost]



I uninstalled wamp then install [pampserver.com] but the problem still.


Please help



Edited 2 time(s). Last edit at 01/02/2011 08:35PM by ballack.

hello,

I am waiting for help

when I go to [localhost] its ok
but to [localhost] very slow and go to a blank page when submitted with user root and no password

In mysql consol when say Enter password: I hit enter but nothing happen


what can i do to solve this ?

This is a user-to-user forum; be patient.

"...I deleted every thing in filed named lmhosts.sam E:\WINDOWS\System32\drivers\etc
and type only 127.0.0.1 localhost ..."

The instructions said to open the file HOSTS
not the file lmhosts.sam.

regards...

thanks for your concern

I dont have file named HOSTS in this directory E:\WINDOWS\System32\drivers\etc

I am using Win 7



Edited 1 time(s). Last edit at 01/02/2011 09:21PM by ballack.

I do not run Win7. But the hosts file should be in the same place.
Make sure your Win 7 does not hide system folders and files.

see here:
[helpdeskgeek.com]

If the file HOSTS is truly missing, then I might suggest that you copy the lmhosts.sam file to a file named HOSTS (no extension) in the same folder.

Of course the file HOSTS should have the changes described in the instructions.

regards...

I brought the host file from my xp and copy it in E:\WINDOWS\System32\drivers\etc
i removed every thing and typed only 127.0.0.1 localhost

I tried login to phpmyadmin with user root and no password but it go to blank page
and when hit enter in mysql consol nothing happen

??

Maybe now would be a good time to apply yfastud's recommendation
for MySQL password and phpMyAdmin, which I have inserted below.

To setup Password, follow this
[blog.jlbn.net]

To setup Remote phpMyAdmin, follow this
[blog.jlbn.net]

regards...