我已经在 CentOS 7 中安装了 LAMP
当我将文件放在默认目录中时(在我的情况下为 var/www/html(当我访问我的页面时,我收到以下内容:
Erreur : PB de connexion au serveur mysql de la langue : fr Erreur : PB de connexion la base de donn es de la langue : fr 错误 SQL : 从参数中选择 * 拒绝用户"apache"@"localhost"的访问(使用密码:否(
以下是我的配置文件:
$action = "action";
@error_reporting (E_ALL);
@setlocale(LC_TIME, 'french');
$host = "localhost";
$user = "";
$password = "" ;
//---> La langue utilisée (fr, en, ar)
global $lang ;
$lang = isset($_REQUEST["lang"])? $_REQUEST["lang"] : "";
switch($lang)
{
case "ar" : $lang = "ar" ; break;
case "en" : $lang = "en" ; break;
case "fr" : $lang = "fr" ; break;
default : $lang = "fr" ; //---> La langue par défaut
} //Fin switch
global $lang_param;
$lang_param = array
(
//---> principal = TRUE
"fr" => array(
"host" => "localhost" ,
"db" => "database_fr" ,
"user" => "user1" ,
"password" => "" ,
"chemin" => "fr" ,
"description" => "Langue française" ,
"short" => "Français" ,
),
//---> principal = FALSE
"en" => array(
"host" => "localhost" ,
"db" => "database_en" ,
"user" => "user1" ,
"password" => "" ,
"chemin" => "en" ,
"description" => "Langue anglaise" ,
"short" => "Anglais" ,
) ,
"ar" => array(
"host" => "localhost" ,
"db" => "database_ar" ,
"user" => "user1" ,
"password" => "" ,
"chemin" => "ar" ,
"description" => "Langue arabe" ,
"short" => "Arabe" ,
)
); //Fin $lang_param
//---> Se connecter
$r = @mysql_pconnect($lang_param[$lang]["host"], $lang_param[$lang] ["user"], $lang_param[$lang]["password"]);
if ($r==0)
{
echo "Erreur : PB de connexion au serveur mysql de la langue : $lang<br>";
} //Fsi
$r = @mysql_select_db($lang_param[$lang]["db"]);
if ($r==0) {
echo "Erreur : PB de connexion à la base de données de la langue : $lang<br>";
} //Fsi
如何获得apache@localhost的访问权限?
$user
变量中应该定义一个帐户。
尝试根帐户
$user='root';
请注意,没有密码的root帐户会使您的Web服务器不安全,并尽快进行设置。
您应该创建一个用户:
CREATE USER 'user'@'localhost' IDENTIFIED BY 'mypass';
并授予您尝试连接的数据库的权限:
GRANT ALL PRIVILEGES
ON database.*
TO 'user'@'%';
之后,您必须在代码上$user和$password填充变量。