Very, very strange. But your idea is good. Try out using 'http'. It will activate authentication via so called HTTP Auth. If you now access to your phpMyAdmin your browser should pop up a small dialog window asking for a user name and password. Substantially the same like 'cookie' but another technologie.

Very, very strange. But your idea is good. Try out using 'http'. It will activate authentication via so called HTTP Auth. If you now access to your phpMyAdmin your browser should pop up a small dialog window asking for a user name and password. Substantially the same like 'cookie' but another technologie.

Many grettings from Berlin! Oswald

In a world of absurdity, we must
invent reason; we must create
beauty out of nothingness.

I'm absolutey!!! a NEWBIE in terms of wamp and lamp stuff!!
had the same password-problems as mentioned before. I solved this problem by not only adding a password but also changing the user 'root' to anything else. now it works brilliant!!

hope I could help
cheers
zappa

@ appachefriends:
thank you for that great stuff!!!!
tried to install WAMP' S before I knew about this <org> and always ended up with trouble!
BUT WITH YOUR HELP EVERYTHING WORKS FINE NOW!!!

I currently have no password in use, to get around the problem that I was having, but now I am locked out of PHPMYADMIN and I do not know why. (I have MySQL running as a services that launches on starup, so I know that it is running.)

MySQL starts with standard values for the user id and the password. The preset user id is "root", the password is "" (= no password). To access MySQL via PHP with the preset values, you'll have to use the following syntax: mysql_connect("localhost","root",""); If you want to set a password for MySQL access, please make use of mysqladmin. To set the passwort "secret" for the user "root", type the following: C:\wampp2\mysql\bin\mysqladmin - u root password secret

After changing the password you'll have to reconfigure PHPMyAdmin to use the new password, otherwise it won't be able to access the databases. To do that, open the file config.inc.php in \wampp2\phpmyadmin\ and edit the following lines:

To use the MySQL Daemon with "innodb" for better performance, please edit the "my" (or "my.cnf") in the /wampp2/mysql/bin directory respective for Service the C:\my.cnf for NT/2000. There, activate the "innodb_data_file_path=ibdata1:30M" statement. Attention, "innodb" is not recommanded for 95/98/ME/XP Home.

To use MySQL as Service for NT/2000/XP Professional, simply copy the "my" / "my.cnf" file to C:\my, respective to C:\my.cnf. Please note that this file has to be placed in C:\ (root), other locations are not permitted. Then execute the "mysql_installservice.bat" in the mysql Folder.

Hey!
Just curious but did you copy that *exactly*?
$cfg['Servers'][$i]['password'] = 'secret';
(?) Curious if maybe 'secret' is a password TYPE? Might just try this before I get a reply... but would be nice to figure it out!

Also I found a few nifty things out for those of you running Wampp with the use of .htaccess files: Windows by itself will *not* let you name a file without anything in front (a.htaccess will work but .htaccess gives 'you must supply a filename!') Found a trick to work that out! Just go to a command prompt, and type 'rename a.htaccess .htaccess' Works!
An issue I'm having with MySQL is that the 'install as service' batch file doesn't seem to work on Win2k for me. Not much of a problem since I can add myself or use a batch file, but I figured it would be worth a look-see!
Another problem: Where do I set the SERVER_ADMIN variable and stuff for the email link on the error pages?

If you want to contact me via e-mail: ariesiiiN0SP/\M@earthlink.net (anti-emailbot: remove n0sp/\m) I'd use the Mercury mail but I'm not sure if I trust my skill with these things yet:(

zappa wrote:hi david,with the first installation I had a little bit of trouble getting the things work right because I changed the password (dreamweaver needs one) and lost controll of what I had done.

so I just deleted the whole wampp-folder and reinstalled wampp, taking absolutely care of the steb-by-step instructions.I tested it without changing anything and it worked.

therafter I did that password-stuff.remember these lines in the instructions!

MySQL starts with standard values for the user id and the password. The preset user id is "root", the password is "" (= no password). To access MySQL via PHP with the preset values, you'll have to use the following syntax: mysql_connect("localhost","root",""); If you want to set a password for MySQL access, please make use of mysqladmin. To set the passwort "secret" for the user "root", type the following: C:\wampp2\mysql\bin\mysqladmin - u root password secret

After changing the password you'll have to reconfigure PHPMyAdmin to use the new password, otherwise it won't be able to access the databases. To do that, open the file config.inc.php in \wampp2\phpmyadmin\ and edit the following lines:

Hope this helps, and I think the mysqladmin -u root password **** is BROKEN. But the webconfig works perfectly now just to pray that outside users cant screw up the thing --- I'm still figuring out the security stuff

Please, don't panic!I have been using the right configuration without any trouble for some days: Declaring the password in the inc. file with cookie.I have now tried what you where speaking about, and now, I can sum myself as another one in disgrace. But let me ask you something:Have you considered restarting the server before arriving to any conclusion?I don't know what keeps on living in the system's memory, but I cannot return to my previous condition! That is not possible, just for erasing the password and then writing it again! I restarted the browser (any IE or NS) and the login won't accept my root password even after declaring it in the .inc file! I can enter as root without password (that is the default root user without password). But nothing else.I had some problems with the localhost password before. But worse , because the MySQL service couldn't start. It did start by manual.The service message said that the root@localhost password was incorrect, and then it crashed. Then, I installed it all again and solved the previous problem.So this password thing, carries a lot of history. But what confuses me more is that any change seems to not affect the actual configuration instantly.

Besides, MySQL and PHPmyAdmin:As a security for your system, did you consider installing a firewall like Zone Alarm?.With it, you can forget about your paranoia by dosifying it every time that the program asks you if you allow certain program to connect in/from Internet. You are asked to allow or not allow every connection and also tell the program to remember your answer. I think that in the paid version you can even have virus protection with it, and technical solutions. But the program works so well that you might never have any trouble with it.Hope it helpedalberto

Ok, I know this seems simple enough, and sometimes it's the simple things we over look, but have you guys tried setting your privacy setting lower, or adding your site to your "manage sites" list?

Yes I know, "i've allowed cookies" I was yelling the same thing at my screen for 15 minutes before it hit me lol. See I don't use MyAdmin, so I've never had this problem before. I saw your troubles so I started trying to figure it out, this is what I found out.

So now I went to my tool bar in IE and clicked Tools -> internet options... -> privacy -> and clicked the edit button on the bottom in web sites area.

once there I entered 127.0.0.1 and my domain name (www.your_sites_name.com) and clicked Allow after each. Poof! everything now works like a charm, I have cookies enabled in config.php.inc root as user and no password set. when I enter my username "root" and my password on login it now works perfectly.

Also as a bonus!!!!!!!!!! (can you tell I like this part? lol) you can now Logout of phpadmin! Now I might start using it. I hate not being able to logout. Anywho, I'll throw up some screen shots as soon as my passwrd is emailed to me to verify my email address. In the mean time I hope this helps