PROBLEM CONNECTING to MYSQL SERVER !!

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

PROBLEM CONNECTING to MYSQL SERVER !!

Postby harshakrishnareddy » 26. February 2008 06:38

i'm using XAMPP 1.63...

i have a problem connecting to a MYSQL database on a remote system also running XAMPP...

It says... " You are not allowed to connect to the MYSQL sever on E10. "



<?PHP
$sql = mysql_pconnect('192.168.8.10','root','databasepwd');
mysql_select_db('kerb',$sql) or die(mysql__error());
?>



Can you suggest me a way to connect to the remote database..
harshakrishnareddy
 
Posts: 2
Joined: 26. February 2008 06:26

Postby sari42 » 26. February 2008 10:36

on that remote mysql server "E10" you have to grant your user access from '192.168.8.%'

p.s.
plz delete your cross post (click on [X])
sari42
 
Posts: 800
Joined: 27. November 2005 18:28

Postby harshakrishnareddy » 26. February 2008 20:42

how do i grant Remote user access permission ? ??
harshakrishnareddy
 
Posts: 2
Joined: 26. February 2008 06:26

Postby Wiedmann » 27. February 2008 00:02

how do i grant Remote user access permission ?

http://dev.mysql.com/doc/refman/5.0/en/ ... ccess.html
(you can do this also with phpMyAdmin)

BTW:
The best way is to ask the administrator from this MySQL server.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 2 guests