doq70020 2015-05-15 19:08
浏览 29

用户'grondon'@'localhost'拒绝访问(使用密码:否)

I've tried many ways, and search and read a lot through stack overflow, but I can't solve this problem. I'm trying to INSERT a form (user's email) into my table of a databank in Mysql. I've other pages and it works, but specifically for this one, it does not work at all.

This is my HTML code with the form:

 <div class="col-sm-4">

   <form action="//domain.com/subscribe.php" method="post" id="postcontent"> 

     <input type="email" name="email" class="form-control" placeholder="Tape your e-mail..." required />
     <button type="submit" class="btn-danger btn-subscribe-danger"  >Subscribe!</button>

   </form>
 </div>

Now this is the subscribe.php, that receives the POST.

<?php
// Inclui o arquivo que faz a conexão ao MySQL
include("http://domain.com/conection.php");

if($_POST) {

//incluindo as variáveis do formulário postado
$email_post = ($_POST['email']);

// Manipulamos as variáveis para evitar problemas com aspas e outros caracteres protegidos do MySQL
$email = mysql_escape_string($email_post);

// Montamos a consulta SQL
$query = "INSERT INTO 'mailinglist' ('id','email') VALUES (NULL, '".$email."')";

// Executa a query
$inserir = mysql_query($query);

if ($inserir) {

// Enter the email where you want to receive notification
$emailTo = 'myname@domain.com';

// DON'T EDIT BELOW CODE
$subscriber_email = ($_POST['email']);

// Send email code
$subject = 'Hi!';
$message = "There's someone you need to contact!

Email: " . $subscriber_email;
$headers = "From: ".$subscriber_email." <" . $subscriber_email . ">" . "
" . "Reply E-mail: " . $subscriber_email;

    if(mail($emailTo, $subject, $message, $headers)){
            header('Location: //domain.com/thanks.html');
            exit();
            }

} else {
echo "Error to send your request, please send an e-mail to: para myemail@domain.com";
// Exibe dados sobre o erro:
echo "Dados sobre o erro:" . mysql_error();
}

And finally, the conection.php

<?php

$n = -1;
/*
$n++;
$MySQL[$n]['dominios']  = array('127.0.0.1', 'localhost'); // Possíveis dominios
$MySQL[$n]['servidor']  = '127.0.0.1'; // Servidor MySQL
$MySQL[$n]['usuario']   = 'root'; // Usuário MySQL
$MySQL[$n]['senha']     = ''; // Senha MySQL
$MySQL[$n]['banco']     = 'meu_banco'; // Banco de dados
$MySQL[$n]['persis']    = false; // Conexão persistente?
*/

$n++;
$MySQL[$n]['dominios']  = array('hijumbo.com');
$MySQL[$n]['servidor']  = 'localhost'; // Servidor MySQL
$MySQL[$n]['usuario']   = 'user'; // Usuário MySQL
$MySQL[$n]['senha']     = 'password'; // Senha MySQL
$MySQL[$n]['banco']     = 'databank'; // Banco de dados
$MySQL[$n]['persis']    = false; // Conexão persistente?


foreach ($MySQL as $key=>$servidor) {
    if (!isset($_SERVER['HTTP_HOST'])) {
        $usar = $key;
        break;
    } else {
        $encontrado = false;
        foreach ($servidor['dominios'] as $dominio) {
            if (strpos($_SERVER['HTTP_HOST'], $dominio) !== false) {
              $usar = $key;
              $encontrado = true;
              break;
            }
        }
        if ($encontrado)
            break;
    }
}


$MySQL['conexao'] = ($MySQL[$usar]['persis']) ? 'mysql_pconnect' : 'mysql_connect';


$MySQL['link'] = $MySQL['conexao']($MySQL[$usar]['servidor'], $MySQL[$usar]['usuario'], $MySQL[$usar]['senha']) or die("Não foi possível se conectar ao servidor MySQL no endereço [".$MySQL[$usar]['servidor']."]");


mysql_select_db($MySQL[$usar]['banco'], $MySQL['link']) or die("Não foi possível conectar-se ao banco de dados [".$MySQL[$usar]['banco']."] no servidor [".$MySQL[$usar]['servidor']."]");
?>

Does anyone knows why I'm receiving the Access denied for user 'grondon'@'localhost' (using password: NO) ? Thanks

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 微信小程序协议怎么写
    • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
    • ¥20 怎么用dlib库的算法识别小麦病虫害
    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题,求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看