SQLSTATE [HY000] [1045]使用Mac Os和MAMP拒绝用户'root'@'localhost'(使用密码:NO)的访问 [英] SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) using Mac Os and MAMP

问题描述

我正在使用Mac OS，并由MAMP托管

当我输入 php artisan migration 或 sudo php artisan migration

时，出现

问题

首先我有一个连接被拒绝的问题，所以我在我的.env文件中添加了 DB_SOCKET =/Applications/MAMP/tmp/mysql/mysql.sock ，它已更改为ACCESS DENIED

我的.env

  APP_NAME = LaravelAPP_ENV =本地APP_KEY = base64:3dkG/ka7V81mIaIK34T/pOn10/J7n65q/O21K2slsWs =APP_DEBUG = trueAPP_URL = http://本地主机LOG_CHANNEL =堆栈LOG_LEVEL =调试DB_CONNECTION = mysqlDB_HOST = 127.0.0.1DB_PORT = 3306DB_DATABASE = laravel_dbDB_USERNAME =根DB_PASSWORD =DB_SOCKET =/应用程序/MAMP/tmp/mysql/mysql.sockBROADCAST_DRIVER =日志CACHE_DRIVER =文件QUEUE_CONNECTION =同步SESSION_DRIVER =文件SESSION_LIFETIME = 120MEMCACHED_HOST = 127.0.0.1REDIS_HOST = 127.0.0.1REDIS_PASSWORD =空REDIS_PORT = 6379MAIL_MAILER = smtpMAIL_HOST =邮件猪MAIL_PORT = 1025MAIL_USERNAME =空MAIL_PASSWORD =空MAIL_ENCRYPTION =空MAIL_FROM_ADDRESS =空MAIL_FROM_NAME =" $ {APP_NAME}"AWS_ACCESS_KEY_ID =AWS_SECRET_ACCESS_KEY =AWS_DEFAULT_REGION =我们东部-1AWS_BUCKET =PUSHER_APP_ID =PUSHER_APP_KEY =PUSHER_APP_SECRET =PUSHER_APP_CLUSTER = mt1MIX_PUSHER_APP_KEY ="$$ PUSHER_APP_KEY}"MIX_PUSHER_APP_CLUSTER =" $ {PUSHER_APP_CLUSTER}" 

和我的database.php

 <?php使用Illuminate \ Support \ Str;返回 [/*| --------------------------------------------------------------------------|默认数据库连接名称| --------------------------------------------------------------------------||在这里，您可以指定您希望下面的哪个数据库连接|用作所有数据库工作的默认连接.当然|您可以使用数据库库一次使用许多连接.|*/'默认'=>env('DB_CONNECTION'，'mysql')，/*| --------------------------------------------------------------------------|数据库连接| --------------------------------------------------------------------------||这是您的应用程序的每个数据库连接设置.|当然，配置每个数据库平台的示例|下面显示了Laravel支持的示例，以简化开发过程.|||Laravel中的所有数据库工作都是通过PHP PDO工具完成的|因此，请确保您具有特定数据库的驱动程序|在开始开发之前，请先将选择安装在计算机上.|*/'connections'=>['sqlite'=>['驱动程序'=>'sqlite'，'url'=>env('DATABASE_URL')，'数据库'=>env('DB_DATABASE'，database_path('database.sqlite'))，'前缀'=>''，'foreign_key_constraints'=>env('DB_FOREIGN_KEYS'，true)，]，'mysql'=>['驱动程序'=>'mysql'，'url'=>env('DATABASE_URL')，'主机'=>env('DB_HOST'，'127.0.0.1')，'端口'=>env('DB_PORT'，'3306')，'数据库'=>env('DB_DATABASE'，'forge')，'用户名'=>env('DB_USERNAME'，'forge')，'password'=>env('DB_PASSWORD'，'')，'unix_socket'=>env('DB_SOCKET'，'')，'字符集'=>'utf8mb4'，'collat​​ion'=>'utf8mb4_unicode_ci'，'前缀'=>''，'prefix_indexes'=>真的，'strict'=>真的，'engine'=>空值，'options'=>extension_loaded('pdo_mysql')吗?array_filter([PDO :: MYSQL_ATTR_SSL_CA =>env('MYSQL_ATTR_SSL_CA')，]):[]，]，'pgsql'=>['驱动程序'=>'pgsql'，'url'=>env('DATABASE_URL')，'主机'=>env('DB_HOST'，'127.0.0.1')，'端口'=>env('DB_PORT'，'5432')，'数据库'=>env('DB_DATABASE'，'forge')，'用户名'=>env('DB_USERNAME'，'forge')，'password'=>env('DB_PASSWORD'，'')，'字符集'=>'utf8'，'前缀'=>''，'prefix_indexes'=>真的，'schema'=>'上市'，'sslmode'=>'更喜欢'，]，'sqlsrv'=>['驱动程序'=>'sqlsrv'，'url'=>env('DATABASE_URL')，'主机'=>env('DB_HOST'，'localhost')，'端口'=>env('DB_PORT'，'1433')，'数据库'=>env('DB_DATABASE'，'forge')，'用户名'=>env('DB_USERNAME'，'forge')，'password'=>env('DB_PASSWORD'，'')，'字符集'=>'utf8'，'前缀'=>''，'prefix_indexes'=>真的，]，]，/*| --------------------------------------------------------------------------|迁移存储库表| --------------------------------------------------------------------------||该表记录了已经为之运行的所有迁移|你的申请.利用这些信息，我们可以确定|磁盘上的迁移实际上尚未在数据库中运行.|*/'migrations'=>移民"，/*| --------------------------------------------------------------------------|Redis数据库| --------------------------------------------------------------------------||Redis是一个开源，快速且高级的键值存储，它还可以|提供比典型键值系统更丰富的命令主体|例如APC或Memcached.Laravel使您可以轻松地进行深入挖掘.|*/'redis'=>['客户'=>env('REDIS_CLIENT'，'phpredis')，'options'=>['cluster'=>env('REDIS_CLUSTER'，'redis')，'前缀'=>env('REDIS_PREFIX'，Str :: slug(env('APP_NAME'，'laravel')，'_').'_ database_')，]，'默认'=>['url'=>env('REDIS_URL')，'主机'=>env('REDIS_HOST'，'127.0.0.1')，'password'=>env('REDIS_PASSWORD'，null)，'端口'=>env('REDIS_PORT'，'6379')，'数据库'=>env('REDIS_DB'，'0')，]，'cache'=>['url'=>env('REDIS_URL')，'主机'=>env('REDIS_HOST'，'127.0.0.1')，'password'=>env('REDIS_PASSWORD'，null)，'端口'=>env('REDIS_PORT'，'6379')，'数据库'=>env('REDIS_CACHE_DB'，'1')，]，]，]; 

任何帮助将不胜感激，我是新来的，所以我真的很受困扰，互联网上什么都找不到，每个人都在使用ubuntu linux而不是mac os

编辑

我将密码"root"设置为并且问题从拒绝访问"更改为

SQLSTATE [HY000] [1049]未知数据库'laravel_db'(SQL:从information_schema.tables中选择*，其中table_schema = laravel_db，table_name =迁移，而table_type ='BASE TABLE')

这是我的phpmyadmin页面

解决方案

正如我提到的NanThiyagan，我只需要在 localhost/8888/phpmyadmin 中创建一个与.env中名称相同的数据库，或者database.php

您需要创建一个名称为laravel_db – NanThiyagan的数据库

I am using mac OS, and hosting by MAMP

problem is coming out when I am typing php artisan migrate or sudo php artisan migrate

first I had a problem CONNECTION REFUSED so I added DB_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock to my .env file and it changed to ACCESS DENIED

my .env

APP_NAME=Laravel
APP_ENV=local
APP_KEY=base64:3dkG/ka7V81mIaIK34T/pOn10/J7n65q/O21K2slsWs=
APP_DEBUG=true
APP_URL=http://localhost

LOG_CHANNEL=stack
LOG_LEVEL=debug

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel_db
DB_USERNAME=root
DB_PASSWORD=
DB_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock


BROADCAST_DRIVER=log
CACHE_DRIVER=file
QUEUE_CONNECTION=sync
SESSION_DRIVER=file
SESSION_LIFETIME=120

MEMCACHED_HOST=127.0.0.1

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_MAILER=smtp
MAIL_HOST=mailhog
MAIL_PORT=1025
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
MAIL_FROM_ADDRESS=null
MAIL_FROM_NAME="${APP_NAME}"

AWS_ACCESS_KEY_ID=
AWS_SECRET_ACCESS_KEY=
AWS_DEFAULT_REGION=us-east-1
AWS_BUCKET=

PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=
PUSHER_APP_CLUSTER=mt1

MIX_PUSHER_APP_KEY="${PUSHER_APP_KEY}"
MIX_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"

and my database.php

<?php

use Illuminate\Support\Str;

return [

    /*
    |--------------------------------------------------------------------------
    | Default Database Connection Name
    |--------------------------------------------------------------------------
    |
    | Here you may specify which of the database connections below you wish
    | to use as your default connection for all database work. Of course
    | you may use many connections at once using the Database library.
    |
    */

    'default' => env('DB_CONNECTION', 'mysql'),

    /*
    |--------------------------------------------------------------------------
    | Database Connections
    |--------------------------------------------------------------------------
    |
    | Here are each of the database connections setup for your application.
    | Of course, examples of configuring each database platform that is
    | supported by Laravel is shown below to make development simple.
    |
    |
    | All database work in Laravel is done through the PHP PDO facilities
    | so make sure you have the driver for your particular database of
    | choice installed on your machine before you begin development.
    |
    */

    'connections' => [

        'sqlite' => [
            'driver' => 'sqlite',
            'url' => env('DATABASE_URL'),
            'database' => env('DB_DATABASE', database_path('database.sqlite')),
            'prefix' => '',
            'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
        ],

        'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
            ]) : [],
        ],

        'pgsql' => [
            'driver' => 'pgsql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '5432'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
            'schema' => 'public',
            'sslmode' => 'prefer',
        ],

        'sqlsrv' => [
            'driver' => 'sqlsrv',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', 'localhost'),
            'port' => env('DB_PORT', '1433'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
        ],

    ],

    /*
    |--------------------------------------------------------------------------
    | Migration Repository Table
    |--------------------------------------------------------------------------
    |
    | This table keeps track of all the migrations that have already run for
    | your application. Using this information, we can determine which of
    | the migrations on disk haven't actually been run in the database.
    |
    */

    'migrations' => 'migrations',

    /*
    |--------------------------------------------------------------------------
    | Redis Databases
    |--------------------------------------------------------------------------
    |
    | Redis is an open source, fast, and advanced key-value store that also
    | provides a richer body of commands than a typical key-value system
    | such as APC or Memcached. Laravel makes it easy to dig right in.
    |
    */

    'redis' => [

        'client' => env('REDIS_CLIENT', 'phpredis'),

        'options' => [
            'cluster' => env('REDIS_CLUSTER', 'redis'),
            'prefix' => env('REDIS_PREFIX', Str::slug(env('APP_NAME', 'laravel'), '_').'_database_'),
        ],

        'default' => [
            'url' => env('REDIS_URL'),
            'host' => env('REDIS_HOST', '127.0.0.1'),
            'password' => env('REDIS_PASSWORD', null),
            'port' => env('REDIS_PORT', '6379'),
            'database' => env('REDIS_DB', '0'),
        ],

        'cache' => [
            'url' => env('REDIS_URL'),
            'host' => env('REDIS_HOST', '127.0.0.1'),
            'password' => env('REDIS_PASSWORD', null),
            'port' => env('REDIS_PORT', '6379'),
            'database' => env('REDIS_CACHE_DB', '1'),
        ],

    ],

];

Any help would be appreciated, I am new so I am really stuck, nothing found on the internet, everyone was using ubuntu linux not mac os

EDIT

I put the password "root" and the problem changed from access denied from

SQLSTATE[HY000] [1049] Unknown database 'laravel_db' (SQL: select * from information_schema.tables where table_schema = laravel_db and table_name = migrations and table_type = 'BASE TABLE')

Here is my phpmyadmin page

解决方案

as mentioned NanThiyagan I just had to create a database in localhost/8888/phpmyadmin with the same name as in the .env or database.php

u need to create a db with name laravel_db – NanThiyagan

这篇关于SQLSTATE [HY000] [1045]使用Mac Os和MAMP拒绝用户'root'@'localhost'(使用密码:NO)的访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！