Posted by:
CyberSpatium
(---.hsd1.or.comcast.net)
wamp comes setup to only allow access to phpmyadmin to localhost. this keeps anyone else from being able to access phpmyadmin steal/change/delete/etc your databases and data. if you need to allow access to the outside world you need to put some protection in place.
first, you will need to edit your root users permissions and add a password for the root user. mysql comes with the root user with no password, so for securiyht reasons you need to add a password. the phpmyadmin section in my manual covers this topic (link to my manual is in my sig). once you have setup the password for the root user, you need to follow the instructions in my manual that tell you how to edit the phpmyadmin config file to use the new password.
second, you will need to edit the alias setting for phpmyadmin to allow access to phpmyadmin from everyone. then you will also need to edit phpmyadmins config file to make phpmyadmin show a page where people have to login before they can access phpmyadmin.
to edit the alis setting open the phpmyadmin alias config file:
left click on the wamp tray icon -> alias directories -> [
localhost] -> edit alias
find:
<Directory "c:/wamp/phpmyadmin/">
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
</Directory>change to:
<Directory "c:/wamp/phpmyadmin/">
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Allow from all
</Directory>save the file. now open up phpmyadmin config file:
C:\wamp\phpmyadmin\config.inc.phpfind:
$cfg['blowfish_secret'] = '';change to:
$cfg['blowfish_secret'] = '_ENTER_SOME_RANDOM_UPPERCASE, LOWERCASE, AND NUMBERS_HERE_';i suggest you make the blowfish secret at least 20 characters.
now find:
$cfg['Servers'][$i]['auth_type'] = 'config';change to:
$cfg['Servers'][$i]['auth_type'] = 'cookie';now save the files and restart apache for the new settings to take effect. when you acces phpmymin now you will see a page where you now need to login to access phpmyadmin. your user name is root and your password is the password you set for the root user in the first step.
CyberSpatium----------------------WAMP English Forum Admin
I have WAMP5 working with (for development use only):Windows Vista Ultimate x64 (64 bit)
Kaspersky Internet Security Suite 7.0.x
Spyware Terminater 2.x
CounterSpy 2.5.x
Need help? Check out my [url=http://forum.wampserver.com/read.php? f=2&i=12300&t=12300][u][b]WAMP User Manual/Guide[/b][/u][/url] here!
[url=http://www.webdevnewbie.com][u][b]Web Development for Newbie's Blog[/b][/u] [/url] - Check out my new blog. It is for web developers, and especially tailored for the web development newbie. If you are not fluent in geek speak, then this incredible resource is just you. And even if you are a web development pro, this is a great resource to check out some of the latest web development tips, news, tutorials, codes and more.
[url=http://www.clarifyloans.com][b][u]Clarify Loans[/u][/b][/url]
Mortgage and Home Loan Advice
[url=http://www.laxgo.com][b][u]LaxGo Web Directory[/u][/b][/url]
Powerful human edited web directory of quality, spam-free sites organized via a comprehensive category structure.