macOS(intel) > HomeBrew install > mariadb 삭제 후 재설치

1. mariadb 정지

brew services stop mariadb

 

2. 삭제

brew uninstall mariadb

 

3. Configuration Files and Databases 삭제

rm -rf /usr/local/etc/my.cnf
rm -rf /usr/local/etc/my.cnf.d
rm -rf /usr/local/var/mysql

 

4. Logs and Cache 삭제

rm -rf /usr/local/var/log/mysql
rm -rf /usr/local/var/run/mysql

 

5. 남아있는 파일 확인 후 삭제

find /usr/local -name "*mariadb*"

 

6. Homebrew 청소

brew cleanup
brew doctor

 

 

다시 리부팅 후 재설치

brew install mariadb

 

root 계정추가

sudo mysql_secure_installation

 

입력 참고

Enter current password for root (enter for none): Enter

Switch to unix_socket authentication [Y/n] N

Change the root password? [Y/n] Y

New password: 암호입력

Re-enter new password: 암호 재입력

Remove anonymous users? [Y/n] Y

Disallow root login remotely? [Y/n] N

Remove test database and access to it? [Y/n] Y

Reload Privilege tables now? [Y/n] Y

 

끝