WAMPServer is primarily designed for use on a single machine i.e. a developer writing and testing code locally on that PC.
So to protect the beginner from his/her self the Apache & MySQL configuration by default is setup so no access can be made to the Apache or MySQL server form anywhere but the PC running Apache and MySQL.
When changing this configuration great care should be taken to only allow access that you intend and not global access. So be VERY CAREFUL with any help/tutorial that suggest adding
Allow from all or
Require all granted as they either dont really know what they are doing or the help is based on giving access to the site to the whole internet.
To allow access to phpMyAdmin you need to change the Alias configuration for phpMyAdmin, so edit
wamp\alias\phpmyadmin.conf and add an instruction to allow access from any ip address on your internal network like so :-
Alias /phpmyadmin "d:/wamp/apps/phpmyadmin4.1.14/"
Options Indexes FollowSymLinks MultiViews
--> Require ip 192.168.0
Deny from all
Allow from localhost ::1 127.0.0.1
--> Allow from 192.168.0
php_admin_value upload_max_filesize 128M
php_admin_value post_max_size 128M
php_admin_value max_execution_time 360
php_admin_value max_input_time 360
If you actually want to access MySQL via the mysql.exe processor and other tools like it from another IP address you have basically the same problem.
MySQL user account are made up of 2 parts, a UserId and a Host. The Host part tells MySQL where this userid is allowed to connect from. If you look using phpMyAdmin at the user accounts that are pre-created in MySQL you will see that the Host part of all the account is either
::1 all of which equate to
The PC running MySQL. Again for the security of the beginner no access allowed from outside the PC running MySQL.
So to use mysql.exe etc, I suggest you create a new MySQL User Account, lets say
MAKhan with a Host of
192.168.0 AND OF COURSE A PASSWORD. That account will them be allowed to login to MySQL from any ip on your local network. You will of course have to give rights to this new account so that it can access some or all of the databases on the MySQL server.