PHP connection problem with Mysql

Question

All the settings are right I don’t know why not connecting.. locally works, but when I step to the server gives this problem.

$hostnome = '192.185.176.204';
$usernome = 'tookc892';
$senha = '***'
$conexao = mysql_connect('$hostnome', '$usernome' , '$senha');

Answer 1

You are using simple quotes on your connection.

The variables inside the single quotes are not compiled by PHP, therefore, the server is literally trying to connect with the user '$usuario', to host '$hostnome' with the password '$senha' and not with the value contained in the variables, as you wish.

Remove simple quotes that should work:

<?php $conexao= mysql_connect( $hostnome, $usernome , $senha);

NOTE: The mysql_* functions are being discontinued by PHP, so prefer to work with something new and safer, like mysqli or PDO.

Answer 2

Your hostname has been blocked by Mysql for exceeding the standard of 10 attempts... Open your Mysql console and sign in with:

mysql> SET GLOBAL max_connect_errors=10000;

Reference: http://dev.mysql.com/doc/refman/5.0/en/blocked-host.html

Answer 3

The first error was explained by Matthew, there should be no single quotes in your mysql_connect. After many attempts of connection with error your host has been locked, you have to unlock it with the command: mysqladmin flush-hosts to be able to access again.

Works locally because the local mysql configuration should be different from the remote configuration.

I would also like to emphasize that you should abandon the mysql* commands replacing at least mysqli* at the risk of one day your website will stop working.

Answer 4

$hostnome = '192.185.176.204';
$usernome = 'tookc892';
$senha = '***';
$dbname = 'nome_banco';
$conexao = mysql_connect("$hostnome", "$usernome", "$senha");
$sel_banco = mysql_select_db("$dbname");

Forgot semicolon after variable $password; We still have to select the database... You must run $connected, then you could leave without setting it, so:

$hostnome = '192.185.176.204';
$usernome = 'tookc892';
$senha = '***';
$dbname = 'nome_banco';
mysql_connect("$hostnome, $usernome, $senha");
mysql_select_db("$dbname");

IN PDO:

<?php
//Arquivo de conexão com o Banco de Dados
try{
    $driver = 'mysql';
    $host = '192.185.176.204';
    $usuario = 'tookc892';
    $senha = '***';
    $dbname = 'nome_banco';

    $conn = new PDO("$driver:host=$host;dbname=$dbname", $usuario, $senha); 
} catch (PDOException $e){
    echo "Erro ao conectar no banco de dados $dbname <BR/>";
    echo $e->getMessage();
    die();
}

?>

Answer 5

An example of POO connection, I used to use it I think it’s working ...

class Db{

//Variáveis Privadas//

private $user       = 'root';
private $password   = 'senha';
private $database   = 'nomedobanco';
private $host       = 'localhost'; 

/**************************************
*              Conectar              *
*      Função de conexão protected   *
**************************************/
 protected function conect(){
   if( mysql_connect($this->host, $this->user, $this->password)){
       if(!mysql_select_db($this->database)){
            return ('Erro na seleção do banco');
       }else{
            return true;
       }
   }else{        
       return ('Não foi possível conectar ao banco de dados.');
   }
 }
}

I hope it helps ...