Failed to connect to MySQL

Question

I have two computers connected on the lan and i want to simulate a client server type of configuration .So suppose i have pc1 acting as the server and pc2 as the client.I created a database on the pc1 and kept the registration form on the pc2 .so whenever i execute the registration script i get the following error.

Failed to connect to MySQL: Host '192.168.2.6' is not allowed to connect to this MySQL server

This is the registration code where i have replaced database host with the ip address of pc1(server) which is running xampp .

<?php

define('DB_HOST', '192.168.2.7');//192.168.2.7 is the ip address of my server.
define('DB_NAME', 'hello');
define('DB_USER','root');
define('DB_PASSWORD','');

$con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error());
$db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " . mysql_error());

Do have i have to make any changes in mysql config file in xampp or if i have to make changes to the database host name.

Checkout this thread http://stackoverflow.com/questions/13731514/host-is-not-allowed-to-connect-to-this-mysql-server-when-making-a-local-connecti — sofl, Mar 06 '14 at 17:36

Krimson · Answer 1 · 2014-03-06T17:44:02.183

1

If the server is on your local computer, try using localhost as the ip address.

To grant access to computer with ip: 192.168.2.7:
GRANT ALL ON *.* TO root@'192.168.2.7'

To grant access to all computer no matter what their ip is:
GRANT ALL ON *.* TO root@'%'

edited Mar 06 '14 at 17:44

answered Mar 06 '14 at 17:38

Krimson

7,386
11
60
97

how do i do this is xammp on windows – user2218550 Mar 06 '14 at 17:43
You cant do it using xammp, since xammp is a webserver which installs mysql. Its not a mysql interface. To make it easier, try using mysqlWorkBench: http://dev.mysql.com/downloads/tools/workbench/ – Krimson Mar 06 '14 at 17:45

score 0 · Accepted Answer · answered Mar 06 '14 at 17:41

0

you need to provide access to all hosts through wildcard by using following query

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password';

Refere to Documentation for more info

answered Mar 06 '14 at 17:41

Muhammad Haseeb Khan

885
9
24

how do i do this is xammp on windows – user2218550 Mar 06 '14 at 17:42
in phpmyadmin in `SQl` Tab PASTE the query and run – Muhammad Haseeb Khan Mar 06 '14 at 17:44
i got the following error Failed to connect to MySQL: Access denied for user 'root'@'192.168.2.6' (using password: NO) – user2218550 Mar 06 '14 at 17:48
Try to login via the mysql command line and type the command there. To open this, look here: http://stackoverflow.com/questions/698914/how-can-i-access-the-mysql-command-line-with-xampp-for-windows – sofl Mar 06 '14 at 17:49
try this query on localhost not remotely. then you can use this query remotely – Muhammad Haseeb Khan Mar 06 '14 at 17:50
i did it on the server itself (localhost) still the same error – user2218550 Mar 06 '14 at 17:54
please check in `phpmyadmin` privliges that what rights you have for current user – Muhammad Haseeb Khan Mar 06 '14 at 18:04
please try by creating a new user follow the instructions https://www.digitalocean.com/community/articles/how-to-create-a-new-user-and-grant-permissions-in-mysql and then try to access with new user – Muhammad Haseeb Khan Mar 06 '14 at 18:09

Failed to connect to MySQL

2 Answers2