역시나 1060;번에도 누군가 1089;업해 .164;,163;1060; 나름 1228;,172;lj16; 폭탄1004;/196; 보여1256;서 해체 1473;1064;데 1096; 않.104;네요.
1060;번1032; ᅆ1;우lj16; 기1316; 설치.108; 패Ȗ12;1648;를 확1064;해 보면
# /usr/local/mysql/bin/mysql --version
/usr/local/mysql/bin/mysql 160;Ver 15.1 Distrib 10.1.41-MariaDB, for Linux (x86_64) using readline 5.1
위처/100; MariaDb 10.1.41 1060; 설치 .104;Ǻ12; 1080;다고 나오고
# yum list installed mariadb\*
Loaded plugins: fastestmirror, langpacks
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
Determining fastest mirrors
160;* base: mirror.kakao.com
160;* extras: mirror.kakao.com
160;* updates: mirror.kakao.com
Installed Packages
mariadb-libs.x86_64 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 1:5.5.56-2.el7 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160;@anaconda
위처/100; MariaDB가 5.5.561060; 설치 .108;,163;처/100; 나Ꮢ1;니다.
왠1648; 여기서 ǥ12;터 않맞lj16;,163; 같1008;데160;
기 설치.108; MariaDB를 확1064;해 봐도
# rpm -qa | grep maria*
mariadb-libs-5.5.56-2.el7.x86_64
marisa-0.2.4-4.el7.x86_64160;
위처/100; 나오lj16;,172; 1060; 버1204;1060; 맞lj16;,163; 처/100; 보1077;니다.
/196;그1064;1012; 해보면
# /usr/local/mysql/bin/mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor. 160;Commands end with ; or \g.
Your MariaDB connection id is 16
Server version: 10.1.41-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
위처/100; 현1116; 돌고 1080;lj16; 버1204;1008; MariaDB 10.1.411060; 맞고요
근데 문1228;lj16;......
# yum remove -y mariadb*
위 명/161;Ǻ12;를 통Ȣ16;여 1648;우면 해NJ17; 버1204;1064; mariadb-libs-5.5.56-2.el7.x86_64가 아래 내용처/100; 1648;워1665;니다.
# systemctl stop mysqld
# yum remove -y mariadb*
Loaded plugins: fastestmirror, langpacks
Resolving Dependencies
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.56-2.el7 will be erased
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
--> Running transaction check
---> Package postfix.x86_64 2:2.10.1-6.el7 will be erased
--> Finished Dependency Resolution
base/7/x86_64 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; | 3.6 kB 160;00:00:00
extras/7/x86_64 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; | 2.9 kB 160;00:00:00
updates/7/x86_64 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160;| 2.9 kB 160;00:00:00
updates/7/x86_64/primary_db 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; | 160;11 MB 160;00:00:02
Dependencies Resolved
=====================================================================================================================================
160;Package 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160;Arch 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; Version 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; Repository 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; Size
=====================================================================================================================================
Removing:
160;mariadb-libs 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; x86_64 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 1:5.5.56-2.el7 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160;@anaconda 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 4.4 M
Removing for dependencies:
160;postfix 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160;x86_64 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 2:2.10.1-6.el7 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160;@anaconda 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160;12 M
Transaction Summary
=====================================================================================================================================
Remove 160;1 Package (+1 Dependent package)
Installed size: 17 M
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
160; Erasing 160; 160;: 2:postfix-2.10.1-6.el7.x86_64 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 1/2
160; Erasing 160; 160;: 1:mariadb-libs-5.5.56-2.el7.x86_64 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160;2/2
ᅆ1;고: /etc/my.cnf(1060;)가 /etc/my.cnf.rpmsave(1004;)/196; 1200;1109;.104;었습니다
160; Verifying 160;: 1:mariadb-libs-5.5.56-2.el7.x86_64 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160;1/2
160; Verifying 160;: 2:postfix-2.10.1-6.el7.x86_64 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 160; 2/2
Removed:
160; mariadb-libs.x86_64 1:5.5.56-2.el7
Dependency Removed:
160; postfix.x86_64 2:2.10.1-6.el7
Complete!
근데 ǥ16;명 1648;ǽ12;lj16;데 서비스 시1089;후 DB에 1217;속해보면 않1648;워 1276;더라고요...12640;12640;
# systemctl start mysqld
# /usr/local/mysql/bin/mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor. 160;Commands end with ; or \g.
Your MariaDB connection id is 17
Server version: 10.1.41-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
1060;,172; 뭔1068;1064;1648;..........12640;12640;
아마도 1060;1204; 관리1088;가 Ǻ12;떻,172; 설치를 해서 1060;런 현상1060; 나오lj16;1648; 알1652; 못Ȣ16;1648;만
yum 설치도 아닌 rpm설치도 아닌..........
뭔가 특1060;한 0169;법1004;/196; 설치한,163;1060; 아닐까 dz10;1008;데
ᕬ1;시 해결 0169;법1008; 무Ꮗ1;1068;1648; ᅆ1;험해보신 ǥ16;1032; 1312;Ǻ16; ǥ12;ᓠ1;드립니다.
1060; 문1228;/196; 근 1달1704; DB 업그/112;1060;드 1204; 테스트1473;1064;데
해결1060; 않.104;고 1080;다가 1060;번에 설1221;파1068; 보고 역추1201; Ȣ16;다보니
왠1648; DB가 2개 설치 .104;Ǻ12; 1080;lj16;,163;1060; 아닌가 dz10;Ǻ12;서 마1648;ኔ1;1004;/196; 확1064;.108; 사항1077;니다.
물론 1076;시/196;
systemctl start mysqld 가 아닌
systemctl start mariadb.service /196; MariaDB 10.2 대 버1204;1004;/196; 업글1060; 성공.104;긴 한 상태1648;만
누군가1032; 실수/196; systemctl start mysqld 를 해 버리lj16; 순간 DB가 .160;개 돌,144;나 문1228;가 생길,163; 같아서
기1316;에 돌고1080;lj16; MariaDB 10.1.411012; 완1204;7176; 1648;우고 dz10;1008; 마1020;1077;니다.
참고/196; 해NJ17; 프/196;그ǖ16;1008; 국내 DRM 서버1032; DB여서 확 뒤1665;Ǻ12; 새/196; 클린 설치 Ȣ16;고 dz10;1648;만
사용1088;들1032; 1473;단시간1060; 길Ǻ12;서 참아야 .104;lj16; 상황1077;니다.160;
PM1064; 1200;lj16; 리눅스 엔1648;니Ǻ12;도 아니고, DBA도 아닌데 왜 1060;,152; 나오,172; 시Ȗ12;lj16;1648;..... 1805;1805;1805;
2. /usr/local¿¡ ±ò¸°°Ç Á÷Á¢ ÄÄÆÄÀÏÀ¸·Î ¼³Ä¡µÈ °ÍÀ¸·Î º¸ÀÔ´Ï´Ù. ÀÌ°Å´Â rmÀ¸·Î ¼ÕÀ¸·Î Áö¿ì¼Å¾ß ÇÕ´Ï´Ù.
systemctl status mysql, systemctl status mariadb Çϼż ³ª¿À´Â °ü·ÃµÈ bin, etc, lib µî Áö¿ì½Ê½Ã¿À.
3. yumÀ¸·Î »õ·Î ±î½Ã¸é µË´Ï´Ù.
yumµîÀ¸·Î´Â ¼³Ä¡ ÆÄÀÏÀÌ Ã£¾ÆÁöÁö°¡ ¾ÊÀ¸´Ï my.ini³ª my.cnfÆÄÀÏ È®ÀÎÇؼ ÀÏÀÏÀÌ Áö¿ö¾ß °Ú³×¿ä.
È®½ÅÀÌ ¾ø´Ùº¸´Ï µµÀü ¸øÇÏ°í ÀÖ¾ú´Âµ¥
Á¶¾ð ³Ê¹« °¨»çÇÕ´Ï´Ù.
/usr/localÀº ÀÌ·±½ÄÀ¸·Î ±ò¸°°Å¶ó ¼ÕÀ¸·Î Áö¿öµµ ¹®Á¦µÇÁö ¾Ê½À´Ï´Ù.
/usrÀº ¼ÕÀ¸·Î Áö¿ì½Ã¸é ¾ÈµË´Ï´Ù.
make install
ÀÌ ¾Æ´Ï¶ó rpm, deb°°Àº ÆÐÅ°Áö ¸Þ´ÏÁ®¿ëÀ¸·Î ºôµåÈÄ ±×°É ±ò¾Æ¾ß °ü¸®°¡ µÇ´Âµ¥, Àü °ü¸®ÀÚ°¡ ±×·±°Å »ý°¢ ¾È ÇѵíÇÕ´Ï´Ù
ÆÐÅ°Áö·Î ¸¸µé¸é ÆÐÅ°Áö °ü¸® °è¿·Î »èÁ¦ÇÏ¸é ´Ù ³¯¾Æ°©´Ï´Ù