JLBN – Remote MySQL through PHPMyAdmin on WAMP
For users’ own protections, WAMP by default is blocked from outside access; thus, if you wish to remote access your MySQL, you need to make some “little” changes in settings, and in this tutor guide for WAMP, we will show you what steps you need to do to achieve it 😉
Note: Even this guide is used for Wampserver, you can apply this method on other wamp package such as Xampp, EasyPHP, so on. Just make sure to select correct file(s) in proper location(s)
12 thoughts on “JLBN – Remote MySQL through PHPMyAdmin on WAMP”
The blog is absolutely fantastic. Lots of great information and inspiration, both of which we all need. Thanks.
Thanks, that’s help..now i can access the the phpAdmin but still, below it got this warning:
“Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user ‘.root’.”
But if i set a password, it will show error again..any idea?
To setup Password, follow this and make sure to go till the last step, not stopping in middle 😉
BN, do these link can be applied to xampp? (i mean the same step) since i’ve tried xampp and also faced the same problem on connecting to the MySQL server…
MS, yes of course however if you’ve already had a Database server and even if you’ve already uninstalled it but did not clean its registry, phpMyAdmin will detect and interact with the first server you had and you still get the error
i successfully installed WAMP 2.0 but Access Denied when i tried to go to phpAdmin. Error below appeared when i go to phpAdmin:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
#1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
But in php.ini under mysql connection, it says that ‘Note that this is generally a *bad* idea to store passwords in this file. *Any* user with PHP access can run ‘echo get_cfg_var(“mysql.default_password”) and reveal this password! And of course, any users with read access to this file will be able to reveal the password as well. Please advice. Thanks.
MS, we dont recommend to store password in config file either as posted in our Setup Password guide and in your case, you need to reset MySQL, setup password and setup database account so you can use in most sessions including remote access since you should avoid to use “root” on everything unless you have to 😉
Download resetmysql here
To setup Backup, follow this
To setup Password, follow this
To setup DB account, follow this
How can i Allow web access to my myql wamp server database, I set up wamp to use as a mysql server.
I dont have a domain setup on the wamp server, only for mysql.
I need to know how to set up direct web access to mysql database and what url format to use.
I followed instuctions under virtual host setup, but it fails to resolve host when trying to connect from the web.
I do not want to allow access from an anonymos public connection,only from one web site or IP address.
Mike Moore, it’s NOT recommend to have direct MySQL access since hackers, spammers and even some want-to-be hackers and spammers might get into your MySQL server and it’s very dangerous if your databases contain sensitive information 🙁
If you still insist, you still face another problem because you dont have a domain unless you have a static IP if you want to use your IP for setup
Anyway, you need to setup Access, DNS, and VH; Access for permission(s) to connect to your WAMP PC, DNS to tie domain(s) to your WAMP PC, and VH to host multiple domains/IP/websites and even you have only 1 domain/IP/website, you should use VH to set it up with the site you want to show up first on top and localhost on bottom while other domains/IP/websites in middle if having more than 1 domain/IP/website; if dont have real domain, just skip DNS guide
To setup Access, follow this
To setup VH, follow this
To setup DNS, follow this
Your post is great. There are some issues here but don’t have the time right now. I’m bookmarking this url and leave this comment to check again later and update my first comment (this one). By the way i found your blog post as i was searching for similar subjects in Bing
Very nice. A revision is blsacialy just an earlier version of a blog entry. I’m not sure how the revisions affect performance, but the search function sure does seem faster now. But it could just be my imagination and a bit of mental projection. Yeah, this site is a much quicker platform it’s not having to pull entries off a flat file on the web servers’ disk anymore. In addition, I’m running eAccelerator for PHP (caches PHP scripts in memory so it’s not hitting the disk over and over), MySQL query caching, front-end reverse proxy gzip compression, ModSecurity web firewall, and no back-end server tweaks to slow things down. All this greatly speeds things up, even over a DSL connection and keeps the site free of automated crapola. And on top of that, your browser hacks are probably helping too.