Mysql

๋กœ๊ทธ์ธ ๋ฐฉ์‹์˜ ๋ณ€๊ฒฝ

์š”์ฆ˜ mysql์—์„œ ๋กœ๊ทธ์ธ๋ฐฉ์‹์ด ๋ณ€๊ฒฝ๋˜์—ˆ๋‹ค๊ณ ํ•œ๋‹ค.

์˜ค๋žœ๋งŒ์— ์„ค์น˜ํ–‡๋‹ค๊ฐ€ ๋งจ๋ถ•์— ๋น ์ง.

์ •๋ฆฌํ•ด๋ณด๋ฉด ๋‘๊ฐ€์ง€ ๋ฐฉ์‹์ด ์žˆ๋‹ค.

  • unix_socket ์ธ์ฆ

  • mysql_native_password ์ธ์ฆ

unix_socket ์ธ์ฆ

์œ ๋‹‰์Šค ๊ณ„์—ด ์šด์˜์ฒด์ œ์˜ ์‚ฌ์šฉ์ž ๊ณ„์ •๊ณผ mysql์˜ ์‚ฌ์šฉ์ž ๊ณ„์ •์„ ์ผ์น˜์‹œํ‚ค๋Š” ์ธ์ฆ ๋ฐฉ์‹

ubuntu 20.04์—์„œ ์„ค์น˜

sudo apt update -y
sudo apt install mysql-server -y
systemctl status mysql
sudo mysql_secure_installation

> Press y|Y for Yes, any other key for No: n
> password
> Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
> Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
> Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
> Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
Success.

All done!

์ด์ œ ์ ‘์†ํ•ด๋ณด์ž.

sudo mysql
show databases;

๋กœ๊ทธ์ธ์ด ๋œ๋‹ค.

mysql_secure_installation์—์„œ ์„ค์ •ํ•œ ํŒจ์Šค์›Œ๋“œ๊ฐ€ ์•„๋‹ˆ๋ผ๋„ ๋กœ๊ทธ์ธ์ด ๋˜๋ฒ„๋ฆฐ๋‹ค.

์œ ๋‹‰์Šค ๊ณ„์—ด ์šด์˜์ฒด์ œ์˜ root ๊ณ„์ •(๋˜๋Š” root ๊ณ„์ •์˜ ๊ถŒํ•œ์„ ๊ฐ€์ง„ ๊ณ„์ •)์€ mysql์˜ root ๊ณ„์ •์„ ์†Œ์œ ํ•˜์—ฌ ๊ด€๋ฆฌํ•  ์ˆ˜ ์žˆ๋„๋ก ํ•œ ๊ฒƒ

์ด unix_socket ์ธ์ฆ์„ ์‚ฌ์šฉํ•˜๋ฉด ์œ ๋‹‰์Šค ๊ณ„์—ด ์šด์˜ ์ฒด์ œ์˜ ๋ฃจํŠธ ์‚ฌ์šฉ์ž๊ฐ€ ์†Œ์œ  ๋ฐ ์‹คํ–‰ํ•œ ํ”„๋กœ์„ธ์Šค์—์„œ mysql์˜ ์ฝ˜์†”์— ๋กœ๊ทธ์ธํ•˜๋Š” ๊ฒฝ์šฐ ์†Œ์ผ“ ์‹œ์Šคํ…œ ๋ณ€์ˆ˜์— ์ •์˜๋œ ๋กœ์ปฌ Unix ์†Œ์ผ“ ํŒŒ์ผ์„ ํ†ตํ•ด ์•”ํ˜ธ ์ž…๋ ฅ ์—†์ด ๋กœ๊ทธ์ธ ๊ฐ€๋Šฅ

mysql_native_password ์ธ์ฆ

mysql_native_password ์ธ์ฆ ๋ฐฉ์‹์€ ์ „ํ†ต์ ์œผ๋กœ ์“ฐ์ด๋˜ ๋ฐฉ์‹์œผ๋กœ ๋กœ๊ทธ์ธ ์‹œ ์•„๋ž˜์™€ ๊ฐ™์ด ๊ณ„์ •๋ช…๊ณผ ์•”ํ˜ธ๋ฅผ ์ž…๋ ฅํ•˜์—ฌ ๋กœ๊ทธ์ธํ•˜๋Š” ๋ฐฉ์‹์ž…๋‹ˆ๋‹ค.

mysql -u root -p

์œ ์ €๋ฅผ ์ƒ์„ฑํ•ด๋ณด์ž.

CREATE USER 'yourUserName'@'localhost' IDENTIFIED BY 'YourPass';
CREATE DATABASE dbname;
GRANT ALL ON dbname.* TO 'yourUserName'@'localhost';
flush privileges;

์ •๋ฆฌ

root ๋น„๋ฒˆ์„ ๋„ฃ์„ ํ•„์š”๋Š” ์—†๋Š”๋“ฏ ๋ณด์ด๊ณ  ์ถ”๊ฐ€ ์œ ์ €๋ฅผ ๋งŒ๋“ค์–ด์„œ mysql_native_password๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด ๋ ๊ฒƒ๊ฐ™๋‹ค.

์„œ๋ฒ„์— ์ ‘์†๋˜๋ฉด ์„œ๋ฒ„์—์„œ๋Š” sudo mysqlํ•˜๋ฉด root๋กœ ๋กœ๊ทธ์ธ์ด ๋œ๋‹ค.

๋‹จ์ ์œผ๋กœ๋Š” ์„œ๋ฒ„๊ฐ€ ๋šค๋ฆฌ๋ฉด ์ „๋ถ€ ๋šค๋ฆฌ๊ฒŸ๋Š”๋ฐ?

Last updated

Was this helpful?