Help me setup mysql in nixos

Help
1

So i’m trying to setup mysql, I’m installed mysql in configuration.nix, and when i try to run this cmd:
mysql
i get an error :
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

please keep it simple so i can understand, ik i have to setup some socket for authetication and I just don’t know how :')

2

try sudo mysql -u root maybe?

1 Like
3

yes it worked, thank you so much. just another quick question, i can’t create table no insert data from laravel ORM , how can i fix that, error:

pluh@nixos > php artisan migrate
   Illuminate\Database\QueryException

  SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from information_schema.tables where table_schema = 'oneessr' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:813
    809▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    810▕                 );
    811▕             }
    812▕
  ➜ 813▕             throw new QueryException(
    814▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    815▕             );
    816▕         }
    817▕     }

      +38 vendor frames

  39  artisan:13
      Illuminate\Foundation\Application::handleCommand(Object(Symfony\Component\Console\Input\ArgvInput))
4

you should consider creating a separate user for your laravel application and assigning permissions based on that

are you familiar with managing users in mysql? if not then here is a random link focused on laravel from a quick search which should cover you

2 Likes
5

it’s working , I appreciate your help, thank you