WampServer

I have followed the guide for setting up the password but I still get this error when attempting to access phpmyadmin after setting up a password for 'host'.

Any ideas on how I can get this working?

Thanks

Andrew



Edited 1 time(s). Last edit at 04/20/2008 08:09PM by amcostello.

hi andrew. what have you done? did u set up a user called host with a password in mysql?


if so then open ur config.php file in c:/wamp/apps/phpmyadmin/ and change the user to host and fill in the password.. leave auth as config

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'host';
$cfg['Servers'][$i]['password'] = 'yourpassword';

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

For step-by-step password setup, check my guide here

[guides.jlbn.net]

Have fun,

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

When I do this, I get access to phpmyadmin, but now there is no password prompt. Is this ok?

yes as long as no one uses ur pc. if u want the prompt.... then change the auth type in the config file to cookie instead of config and in the blowfish box near the top type in a word diefferent to ur password

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

I have changed the phpmyadmin.conf file to "give access from outside" so that students in the course can modify their tables using phpmyadmin. If I do this, will there be a security issue by using the config option for the password on host?

When I try to set something for blowfish and then set the config to cookie, then I get the 1045 error.

Andrew

yes this could be a security issue... id use a .htaccess file to allow them to sign into phpmyadmin

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

Thank you very much for your help.

no problem. if u need help just ask

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

If you like to get the prompt for input user and password, follow my guide ;-)

Have fun,

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

yfastud

I have tried using your password guide many times but I still cannot get the password prompt to work. If I change the settings to 'cookie' and then use the same password I sent in phpmyadmin, I still get a 1045 error.

I have noticed that when I first go to user priviledges, there are 6 users listed:

Any % -- USAGE No Edit Privileges
Any localhost No USAGE No Edit Privileges
Any production.mysql.com No USAGE No Edit Privileges
root 127.0.0.1 No ALL PRIVILEGES Yes Edit Privileges
root localhost No ALL PRIVILEGES Yes Edit Privileges
root production.mysql.com No ALL PRIVILEGES Yes Edit Privileges

Should I delete all the others except for the root / localhost?

When I try to assign a password to each 'host', I am locked out of php when I try to get back to the privileges page!

I am following the guide, but clearly something is not working.

HELP

Andrew

First, if you don't know how to use it, delete all "Any"
Second, setup password for user "root" of "127.0.0.1" and "production.mysql.com" after user "root" of "localhost", and when setup password for root of locahost, you have to follow the guide from begin to end; then only setup password for other "root" users in phpmyadmin. If still stuck at any step, pm or email me ;-)

Have fun,

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



Edited 1 time(s). Last edit at 04/21/2008 01:19PM by yfastud.

I had the same problem. When trying to correct the error message at the bottom of MyPHPadmin, I had 3 host instances of "root" user (127.0.0.1, localhost, and production.mysql.com). However, I started at the top (127.0.0.1) and worked my way down. After I changed the password for localhost, I got locked out.

Following the above instructions, I went to c:\wamp\apps\myphpadmin2.11.5\config.inc.php on lines 71-73.

There I used the fillowing:
Line 71: $cfg['Servers'][$i]['auth_type'] = 'config';
Line 72: $cfg['Servers'][$i]['user'] = 'root';
Line 73: $cfg['Servers'][$i]['password'] = 'mypassword';

I then Reloaded Privileges. Clicked the Home icon. Closed the window. Reopened myphpadmin from WAMPServer and all was fine.

Thanks everyone, for the above help.

Doc

no problem . Your welcome

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

Thanks for the topic.
I had the same problems setting up and this thread got me up and going!