I installed xampp in a server windows server 2012 and I am in the process of configuring, what I want is to connect to the server from my local machine, I did the ping test and I get to the server, in my local pc configure the config.inc file .php, it was like this originally:
|$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';
/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';|
And the line that says $cfg['Servers'][$i]['host'] = '127.0.0.1';
I change it for the ip of my server but it denies me the access it gives me the following error:
Error MySQL has said:
Documentación
#1130 - Host 'android-2afb7d8b283f83f7.domarzobispado.cl' is not allowed to connect to
this MariaDB server
mysqli_real_connect(): (HY000/1130): Host 'android-2afb7d8b283f83f7' is not allowed to
connect to this MariaDB server
La conexión para controluser, como está definida en su configuración, fracasó.
mysqli_real_connect(): (HY000/1130): Host 'android-2afb7d8b283f83f7' is not allowed to
connect to this MariaDB server
phpMyAdmin intentó conectarse con el servidor MySQL, y el servidor rechazó esta conexión.
Deberá revisar el host, nombre de usuario y contraseña en config.inc.php y asegurarse que
corresponden con la información provista por el administrador del servidor MySQL.