Data Science/DB+SQL
[MYSQL] root 원격 접속 허용
1) local 에서 mysql 실행. etc/mysql/mysql -u root 2) Grant privileges. As root user execute with this substituting 'password' with your current root password : RENAME USER 'root'@'localhost' TO 'root'@'%'; ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; SELECT User, Host, plugin, authenti..
2021. 6. 17. 11:56
최근댓글