您好，我已经在centos 7上安装了xampp-linux-x64-7.1.1-0-installer.run。 有10台电脑在本地networking运行，所以我需要远程访问phpmyadmin，所以我configuration了/opt/lampp/etc/extra/httpd-xampp.conf
<Directory "/opt/lampp/phpmyadmin"> AllowOverride AuthConfig Limit Order allow,deny Allow from all Require all granted ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var </Directory> <Directory "/opt/lampp/phpsqliteadmin"> AllowOverride AuthConfig Limit Order allow,deny Allow from all Require all granted ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var </Directory>
现在我可以远程访问它，然后我configuration/opt/lampp/phpmyadmin/config.ini.php用rootlogin密码
/* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'atpl@localdb'; /* Server parameters */ $cfg['Servers'][$i]['host'] = '127.0.0.1'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; $cfg['Servers'][$i]['AllowNoPassword'] = false;
现在，当我创build一个user @ localhost，用户可以login成功，但与数据库的连接显示Error: SQLSTATE[HY000] [2002] No route to host 。
现在，当我创build相同的用户@％（％意味着任何主机）其给予
mysqli_real_connect(): (HY000/1045): Access denied for user 'excelptpvpm'@'localhost' (using password: YES)
在我的networking中，xampp安装在服务器（192.168.1.10）上，源代码位于远程位置。 我想要做的是使用服务器的数据库，让我No route to host 。
请帮助我。
#1045 - Access denied for user 'excelptpvpm'@'localhost' (using password: YES)