WampServer

how do i set mysql db username n passwrd

Please, check Setup Password guide here:

[guides.jlbn.net]

Have fun,

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

That does not work. Upon intalling Wamp 2.0b, there are three users named 'root'

root 127.0.0.1
root localhost
root production.mysql.com

since the guide at [guides.jlbn.net] shows 'root localhost', I used this one. That changes the password, but now I can't get back into phpMyAdmin to change the others. I get an error message

'Cannot access database for root using password where using password = NO' .

Something like that.

So, what do I do? Delete root 127.0.0.1 and root production.mysql.com? Why do I have a user named root at production.mysql.com?

Also, I want to delete all users named root and use an administrator name. Using 'root' is dangerous!

I've been through this before, years ago. I tried setting this up and had one hell of a time. I DO NOT want to go through this again. PLEASE explain how to do this the RIGHT WAY.

I've uninstalled Wamp and reinstalled it. I still could not get in. I had to use Regedit and remove all instances of mySQL to get back in. I'm now faced with all three of these users named root. What do I do?

simple . use config instead of cookie as it offers little protection.


can u sign into phpmyadmin? if so delete all the users except root loclalhost..


they are there as initial ones.


change the password to wat u want it to be for root localhost


now u wont be able to sign in


go in

wamp/apps/phpmyadmin and open config.inc.php


$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)




find this and fill ur password into the ' ' for password. make sure u have config in the auth type like above..


then save. now ul be able to sign in.. it will go in automatically..




ps use blowfish and cookie if u want to be supplied with a box to sign in . a lil bit more secure but only if u dont want peple on ur pc to go in

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

Actually, you only need to follow the guide until finish, then log into phmyadmin and set password for the other 2

Have fun,

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

Thanks. That did the trick.

I did not delete the users

Any %
Any localhost

Any localhost has no password, and is restricted to usage.

Any % has password = '--' and privilege is usage. I do not understand host = %. Should I delete this user?

% is a wildcard . its the same as any

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

Since they're wildcard, if you're not sure how to use them, you should delete them; just my 2 cents

Have fun,

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

Thanks, thanks, thanks! I've got it set up and my Homesite configured for server mappings. I'm on my way!

Now all I need is site content ideas. Anybody got any suggestions?

Anyways, I'm up and running. Thanks heaps for your prompt help!

Your Welcome
LOL u dont have an idea?! lol

Maybe Start with a page on oil prices.. take the value of oil or petrol daily off a site using php to get it, store it in data base and use php extentsions for drawing a graph with the info


i havent seen any yet that are daily

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