Anjanesh Lekshminarayanan anjanesh

## mariadb-brew-macos.md

      
        
          
            
              
              1 file
            
          
          
            
              
              8 forks
            
          
          
            
              
              23 comments
            
          
          
            
              
              38 stars
            
          
        
        
          
              
          
          
            
                nickcernis
                / mariadb-brew-macos.md
            
            
              Created
              July 13, 2020 15:13
            
              
                Install MariaDB with brew on macOS and fix the “access denied” issue
              
          
        
      
        
  
      
    Attempting mysql -u root fails with Access denied for user 'root'@'localhost immediately after doing brew install mariadb and starting mariadb with brew services start mariadb.
To fix it (with MariaDB still running):

sudo mysql then enter your Mac user password
ALTER USER 'root'@'localhost' IDENTIFIED BY 'newrootpassword'; replacing newrootpassword with the password you wish to use for the MariaDB root user.
Ctrl-C to exit mysql.

You should then be able to connect to MariaDB with mysql -u root -p, then entering the root password when prompted.