mysql 외부접속 도전 일지 - user 생성 - 접속성공

https://cjh5414.github.io/mysql-create-user/

https://sleepyeyes.tistory.com/32

create user 'userid'@'localhost' identified by 'userpassword';

create user 'userid'@'%' identified by 'userpassword';

select host,user,plugin,authentication_string from mysql.user;

create schema dbname default character set utf8;

show databases;

grant all privileges on dbname.* to 'userid'@'%';

exit

mysql 리스타트

mysql -u userid -p

show databases;

그래도 접속이 안된다 윈도우10 방화벽 설정

https://walkingfox.tistory.com/66

그래도 안된다

http://gnujava.com/board/article_view.jsp?article_no=1636&menu_cd=29&board_no=16&table_cd=EPAR06&table_no=06

https://www.youtube.com/watch?v=p5afjjnM1zY&list=PLVsNizTWUw7HhYtI-4GGmlJ5yxNdwNI_X&index=14

접속 성공

https://www.youtube.com/watch?v=nzzspyD5aeY&t=1270s 둘러보기