Notice
Recent Posts
Recent Comments
Link
์ผ | ์ | ํ | ์ | ๋ชฉ | ๊ธ | ํ |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 |
Tags
- ๊น๋ฏธ๊ฒฝ
- ์๋ฐ
- Python
- K๋ฐฐํฐ๋ฆฌ๋ ๋ณผ๋ฃจ์
- html
- ๋ฐ์ดํฐ๋ฒ ์ด์ค
- ComputerScience
- ๊ฐ๋ฐ
- ๋ผํ๋ผ์ค์๋ง๋
- ์ฅํธ์์ค
- ์นํผ๋ธ๋ฆฌ์ฑ
- ์ปดํจํฐ๊ณผํ
- ์ฝ๋ฉ
- ํ์ด์ฌ
- K๋ฐฐํฐ๋ฆฌ
- ์นํ์ด์ง๋ง๋ค๊ธฐ
- ๊น๋ฏธ๊ฒฝ์๋งํ์์
- ๊นํ๋จ
- ์ฑ
- ์ค๋ผํด
- ๋ ์
- database
- ํ๋ก๊ทธ๋๋ฐ
- ์๋ฐ์คํฌ๋ฆฝํธ
- css
- JavaScript
- ์ํ
- ๋ง์ผ๋ด๊ฐ์ธ์์๋ค์์ฐ๋ค๋ฉด
- ๋ฐ์ํ
- Java
Archives
- Today
- Total
JiYoung Dev ๐ฅ
[Linux] Apache ์น์๋ฒ ์ค์น / mariadb ์ฐ๊ฒฐ (2023.08.14) ๋ณธ๋ฌธ
full stack/Linux
[Linux] Apache ์น์๋ฒ ์ค์น / mariadb ์ฐ๊ฒฐ (2023.08.14)
Shinjio 2023. 8. 14. 11:16์ค์น ์ฌ๋ถ ํ์ธ
rpm -qa httpd php mariadb-server
ํ๋ก๊ทธ๋จ ์ค์น
dnf -y install httpd php php-mysqlnd mariadb-server
๋ฒ์ ผํ์ธ
rpm -qa httpd php mariadb-server
rpm -qi httpd php mariadb-server
dnf info httpd php mariadb-server
์๋น์ค ๊ตฌ๋
systemctl restart/enable/status httpd
systemctl restart/enable/status mariadb
start ์ฌ์ฉ์ ์ด๋ฏธ active ์ํ๋ผ๋ฉด ์ค๋ฅ๋ ์ ์์ → restart
ํฌํธ ์ด๊ธฐ (http, https)
firewall-config
ํด๋ผ์ด์ธํธ์์ ์๋ฒ ์ฐ๊ฒฐ
๋๋ฉ์ธ ์ค์
- DNS ์๋ฒ → domain ์ฃผ์๋ก ํด๋ผ์ด์ธํธ๊ฐ ์ ์ํ ์ ์๋๋ก ๋์์ค
- hosts file → ์๋์ฐ์์ dns ์๋ฒ์ ์ญํ ์ ํจ
- C:\Windows\System32\drivers\etc
๊ด๋ฆฌ์ ํ์ด์ง๋ก ์ด๊ธฐ ํ ์ถ๊ฐ
ip์ฃผ์ ๋๋ฉ์ธ
Mariadb ์ฐ๊ฒฐ
mysql
#mysql ์คํ
mysql
CREATE database smhrdDB;
mysql> grant all privileges on smhrdDB.* to stduser@localhost identified by '0000';
mysql>use sahrdDB;
grant all privileges on smhrdDB.* TO stduser;
CREATE TABLE smhrdDB.stdInfo (
gwajung VARCHAR(50),
irum VARCHAR(20),
sexgb VARCHAR(6),
mobile VARCHAR(20),
major VARCHAR(30),
location VARCHAR(50),
cdate DATE DEFAULT CURDATE()
);
INSERT INTO stdInfo (gwajung, irum, sexgb, mobile, major, location) VALUES ( 'FUll Stack SW', 'OOO', 'man', 'xxx-xxxx-xxxx', 'No Majetr', 'GangJu North Imdong');
COMMIT;
mysql> exit
# DB์ ์
# mysql -u wpUser -p
passwd 0000
'full stack > Linux' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
[Linux] Telnet ์๊ฒฉ์ ์ (2023.08.14) (0) | 2023.08.14 |
---|---|
[Linux] cron (2023.08.11) (0) | 2023.08.11 |
[Linux] ์๋ฒ ๊ตฌ์ถ ๋ฐ ํ๋ก๊ทธ๋จ ์ค์น (2023.08.11) (0) | 2023.08.11 |
[Linux] ์ ๊ธฐ๋ณธ ๋ฌธ๋ฒ (2023.08.09) (0) | 2023.08.09 |
[Linux] ํธ์ง๊ธฐ & ๊ถํ์ค์ (2023.08.08) (0) | 2023.08.08 |