SQLSTATE [HY000] [2005] Laravel中未知的MySQL服务器主机''(2) [英] SQLSTATE[HY000] [2005] Unknown MySQL server host ' ' (2) in Laravel

问题描述

我在laravel中进行简单登录，尝试执行身份验证时出现错误.这是一个相当奇怪的连接错误

Hi I am making a simple login in laravel and I get an error when I try to perform an authentication. It is a rather odd connection error

连接

'mysql' => array(
        'driver'    => 'mysql',
        'host'      => 'Marsur',
        'database'  => 'database',
        'username'  => 'root',
        'password'  => 'root',
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'options'   => array(
            PDO::ATTR_PERSISTENT => true,
        ),
    ),

控制器

public function doLogin(){
    $rules = array('correo' => 'required|email',
                    'password' => 'required');

    $validator = Validator::make(Input::all(), $rules);
    if($validator->fails()){
        return Redirect::to('usuario')
                ->withErrors($validator)// manda los errores al login
                ->withInput(Input::except('password')); //

    }else{
        $userData = array(
                    'Correo' => Input::get('correo'),
                    'Contrasena' => Input::get('password')
                    );

        if(Auth::attempt($userData)){
            echo 'bien';
        }else{
            return Redirect::to('login');
        }
    }
}

型号*

class Usuario extends Eloquent{
protected $table = 'Usuario';
protected $primaryKey = 'idUsuario';
protected $fillable = array('Nombre', 
                        'Apellido', 
                        'TipoUsuario', 
                        'Contrasena', 
                        'Correo', 
                        'Telefono');
}

我该如何解决?

推荐答案

Marsur几乎可以肯定不是有效的主机名.

Marsur is almost certainly not a valid hostname.

通常，主机名是IP地址或localhost.在某些情况下，您可以通过主机名来引用远程服务器，但是在这种情况下，它的名称看起来像一个网址.

Generally a hostname is an IP address, or localhost. On some occasions you may refer to a remote server by its hostname, but in such a case it will have a name that looks like a web address.

所以...解决这个问题.如果您的数据库与其余代码位于同一台物理计算机上，则需要localhost.

So... fix that. If your database is on the same physical machine as the rest of your code, then you need localhost.

这篇关于SQLSTATE [HY000] [2005] Laravel中未知的MySQL服务器主机''(2)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！