±âÁ¸¿¡ ¼³Ä¡µÈ MySQL ÆÐÅ°Áö Á¦°Å ¹æ¹ý ¹®ÀÇ

   Á¶È¸ 2114   Ãßõ 0    

역시나 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  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

 * base: mirror.kakao.com

 * extras: mirror.kakao.com

 * updates: mirror.kakao.com

Installed Packages

mariadb-libs.x86_64                                             1:5.5.56-2.el7                                              @anaconda


위처/100; MariaDB가 5.5.561060; 설치 .108;,163;처/100; 나Ꮢ1;니다.

왠1648; 여기서 ǥ12;터 않맞lj16;,163; 같1008;데 

기 설치.108; MariaDB를 확1064;해 봐도

# rpm -qa | grep maria*

mariadb-libs-5.5.56-2.el7.x86_64

marisa-0.2.4-4.el7.x86_64 

위처/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.  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*

위 명/16112;를 통Ȣ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                                                                                                 | 3.6 kB  00:00:00

extras/7/x86_64                                                                                               | 2.9 kB  00:00:00

updates/7/x86_64                                                                                              | 2.9 kB  00:00:00

updates/7/x86_64/primary_db                                                                                   |  11 MB  00:00:02


Dependencies Resolved


=====================================================================================================================================

 Package                          Arch                       Version                             Repository                     Size

=====================================================================================================================================

Removing:

 mariadb-libs                     x86_64                     1:5.5.56-2.el7                      @anaconda                     4.4 M

Removing for dependencies:

 postfix                          x86_64                     2:2.10.1-6.el7                      @anaconda                      12 M


Transaction Summary

=====================================================================================================================================

Remove  1 Package (+1 Dependent package)


Installed size: 17 M

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Erasing    : 2:postfix-2.10.1-6.el7.x86_64                                                                                     1/2

  Erasing    : 1:mariadb-libs-5.5.56-2.el7.x86_64                                                                                2/2

1;고: /etc/my.cnf(1060;)가 /etc/my.cnf.rpmsave(1004;)/196; 1200;1109;.104;었습니다

  Verifying  : 1:mariadb-libs-5.5.56-2.el7.x86_64                                                                                1/2

  Verifying  : 2:postfix-2.10.1-6.el7.x86_64                                                                                     2/2


Removed:

  mariadb-libs.x86_64 1:5.5.56-2.el7


Dependency Removed:

  postfix.x86_64 2:2.10.1-6.el7


Complete!


근데 ǥ16;명 1648;ǽ12;lj16;데 서비스 시1089;후 DB에 1217;속해보면 않1648;워 1276;더라고요...ㅠㅠ

# systemctl start mysqld

# /usr/local/mysql/bin/mysql -uroot -p

Enter password:

Welcome to the MariaDB monitor.  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;..........ㅠㅠ

아마도 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;니다. 


PM1064; 1200;lj16; 리눅스 엔1648;니Ǻ12;도 아니고, DBA도 아닌데 왜 1060;,152; 나오,172; 시Ȗ12;lj16;1648;..... 1805;1805;1805;

- by inoree.com -
ªÀº±Û Àϼö·Ï ½ÅÁßÇÏ°Ô.
1. yum list installed | grep (mysql|mariadb) Çϼż­ ¾Æ¹«°Íµµ ¾È³ª¿Ã¶§±îÁö yum uninstallÀ¸·Î ´Ù Áö¿ì½Ê½Ã¿À.
2. /usr/local¿¡ ±ò¸°°Ç Á÷Á¢ ÄÄÆÄÀÏÀ¸·Î ¼³Ä¡µÈ °ÍÀ¸·Î º¸ÀÔ´Ï´Ù. ÀÌ°Å´Â rmÀ¸·Î ¼ÕÀ¸·Î Áö¿ì¼Å¾ß ÇÕ´Ï´Ù.
systemctl status mysql, systemctl status mariadb Çϼż­ ³ª¿À´Â °ü·ÃµÈ bin, etc, lib µî Áö¿ì½Ê½Ã¿À.
3. yumÀ¸·Î »õ·Î ±î½Ã¸é µË´Ï´Ù.
     
±èȲÁß 2021-10
¾Æ Á÷Á¢ ÆÄÀÏ Ã£¾Æ¼­ Áö¿ì´Â°ÍÀÌ ¹®Á¦ µÇÁø ¾Ê°ÚÁÒ?
yumµîÀ¸·Î´Â ¼³Ä¡ ÆÄÀÏÀÌ Ã£¾ÆÁöÁö°¡ ¾ÊÀ¸´Ï my.ini³ª my.cnfÆÄÀÏ È®ÀÎÇؼ­ ÀÏÀÏÀÌ Áö¿ö¾ß °Ú³×¿ä.

È®½ÅÀÌ ¾ø´Ùº¸´Ï µµÀü ¸øÇÏ°í ÀÖ¾ú´Âµ¥
Á¶¾ð ³Ê¹« °¨»çÇÕ´Ï´Ù.
          
Á¤È®ÇÏ°Ô´Â Á÷Á¢ ÄÄÆÄÀÏ/¼³Ä¡ Ä¿¸ÇµåÀÎ "sudo make install" ÇßÀ»¶§ ³ª¿ÔÀ» ÆÄÀÏÀ» ¼ÕÀ¸·Î Áö¿öÁÖ½Ã¸é µË´Ï´Ù. ´Ù¸¸ ±× ¸®½ºÆ®¸¦ ÀúÀåÇØ µÎÁø ¾ÊÁÒ...
/usr/localÀº ÀÌ·±½ÄÀ¸·Î ±ò¸°°Å¶ó ¼ÕÀ¸·Î Áö¿öµµ ¹®Á¦µÇÁö ¾Ê½À´Ï´Ù.
/usrÀº ¼ÕÀ¸·Î Áö¿ì½Ã¸é ¾ÈµË´Ï´Ù.
dateno1 2021-10
¿ø·¡ ¼Ò½º ÄÄÆÄÀÏÇصµ ±×°É ¹Ù·Î
make install
ÀÌ ¾Æ´Ï¶ó rpm, deb°°Àº ÆÐÅ°Áö ¸Þ´ÏÁ®¿ëÀ¸·Î ºôµåÈÄ ±×°É ±ò¾Æ¾ß °ü¸®°¡ µÇ´Âµ¥, Àü °ü¸®ÀÚ°¡ ±×·±°Å »ý°¢ ¾È ÇѵíÇÕ´Ï´Ù

ÆÐÅ°Áö·Î ¸¸µé¸é ÆÐÅ°Áö °ü¸® °è¿­·Î »èÁ¦ÇÏ¸é ´Ù ³¯¾Æ°©´Ï´Ù


QnA
Á¦¸ñPage 279/420
2021-08   1950   ¼­µ¿±¹
2020-09   3324   ¼ø¯
2021-08   3514   °ËÀººí·¢
2020-09   2805   ±èÁ¦¿¬
2021-08   3179   ¾ÈÇü°ï
2020-09   20194   ±èÀçÈÆ74
2021-08   4013   ¾î²Ù±â
2020-09   2122   ³ªÆÄÀÌ°­½ÂÈÆ
2021-08   2709   VSPress
2020-09   2506   Shinjb
2021-08   2303   VSPress
2020-09   2904   ±ÃÀÌ
2021-07   3171   ljssmh1
2020-09   3100   À嵿°Ç2014
2021-07   2683   Âî·Ï
2020-09   2409   GPGPU
2021-07   3302   Âî·Ï
2020-09   2673   Ȧ¸¯0o0
2021-07   1891   NaHS
2020-08   2985   Áø½ÅµÎ