raineorshine/mysql-troubleshooting.md

## mysql-troubleshooting.md

      
    Raw
  

              mysql-troubleshooting.md
            
          
    Installing MySQL is the worst

Install

Use MariaDB.
MySQL community edition had permissons issued with mysqld.
brew update
brew install mariadb
Start

mysql.server start
Console

mysql
Check if MySQL is running

Default port is 3306.
lsof -i -n -P | grep mariadb
netstat -aln | grep 3306
Create new user with full access

CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'my_password';
GRANT ALL ON my_db.* TO 'new_user'@'localhost';
FLUSH PRIVILEGES;