shellkore/setMysqlPriviliges.md

## setMysqlPriviliges.md

      
    Raw
  

              setMysqlPriviliges.md
            
          
    mysql> USE mysql;
mysql> CREATE USER 'YOUR_SYSTEM_USER'@'localhost' IDENTIFIED BY '';
mysql> GRANT ALL PRIVILEGES ON . TO 'YOUR_SYSTEM_USER'@'localhost';
mysql> UPDATE user SET plugin='unix_socket' WHERE User='YOUR_SYSTEM_USER';
mysql> FLUSH PRIVILEGES;
mysql> exit;

unix_socket or auth_socket depending on your root privileges