how to remote database mysql XAMPP from another computer?

Question

the script of connection =

<?
$server = "192.168.0.167";
$username = "root";
$password = "";
$database = "dbbook";
mysql_connect($server,$username,$password) or die("Koneksi gagal");
mysql_select_db($database) or die("Database tidak bisa dibuka");
?>

and i had add this script on my.cnf file after [mysqld] =

bind-address=192.168.0.167

but it didnt work with the following caption

mycomputer.mshome.net is not allowed to connect to this Mysql server

Please help me.How to remote database mysql XAMPP from another computer ?

can you ping 192.168.0.167 from the webservers ip? 192.168.* is a local network so im guessing you correctly opened the port(3306) in your router/firewall — Lawrence Cherone
– Lawrence Cherone, Commented Feb 20, 2012 at 7:18

drew010 · Accepted Answer · 2012-02-20 08:15:26Z

3

You will have to create a new user in MySQL that is allowed to connect from a remote host.

By default, root can only connect from localhost.

You could try running the following commands from the MySQL server (make sure to substitute 192.168.0.99 with the IP or hostname of the PC that will be connecting) In your case, try 'php'@'mycomputer.mshome.net' for the user:

CREATE USER 'php'@'192.168.0.99' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON dbbook.* TO 'php'@'192.168.0.99';

It is possible to specify a wildcard host ('php'@'%'), but then if anyone got your MySQL password they could connect to the DB. You could also wildcard your subnet ('php'@'192.168.0.%') which is a little safer.

edited Feb 20, 2012 at 8:15

answered Feb 20, 2012 at 7:27

drew010

70.3k11 gold badges144 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

N4ta nata Over a year ago

it didnt work. the following caption mycomputer.mshome.net is not allowed to connect to this Mysql server. I had create user with alnergisaver name, Please help :(

drew010 Over a year ago

Ok, try CREATE USER 'php'@'mycomputer.mshome.net' IDENTIFIED BY 'password';

N4ta nata Over a year ago

Does the user I created on the server computer?

drew010 Over a year ago

I don't understand your last question

N4ta nata Over a year ago

On computer server or computer client when i create user ?

|

Collectives™ on Stack Overflow

how to remote database mysql XAMPP from another computer?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related