2022年3月27日 星期日

CentOS 安裝Mysql 4.0筆記

 Cent7 checkinstall 需要改參數安裝,先放置

https://lbbxsxlz.github.io/2020/10/13/checkinstall-centos/


ubuntu 20 套件更新不支援 也須從下拉起



echo '/* Linuxthreads */' >> /usr/include/pthread.h




套件

yum install make cmake gcc kernel-devel

 


checkinstall



yum -y install wget gcc* make cmake libtool* openssl* pcre* ncurses ncurses-devel curses-devel libxml* bzip2 bzip2-libs bzip2-devel curl-devel curl expat-devel expat gdbm gdbm-devel libjpeg* libpng* libtiff* freetype* freetype imap imap-devel krb5-devel libmcrypt* libmhash-devel mhash* flex icu libicu libicu-devel libc libcu-devel libc-client-devel zlib-devel zlib libtiff-devel libtiff gd* pcre-devel pcre gdbm* pam-devel patch libcurl libcurl-devel libvpx libvpx-devel libXpm libXpm-devel t1lib t1lib-devel gmp-devel openldap-devel readline-devel libedit-devel libtidy libtidy-devel libxslt libxslt-devel db4-devel ibc-client uw-imap-devel uw-imap uw-imap-static libc-client-2007f wget vim


yum install compat



安裝



目錄/var/lib/mysql


設定


# Preconfiguration setup

 groupadd mysql

 useradd -r -g mysql -s /bin/false mysql

# Beginning of source-build specific instructions

tar zxvf mysql-VERSION.tar.gz

cd mysql-VERSION

mkdir bld

cd bld

cmake ..

make

make install

# End of source-build specific instructions

# Postinstallation setup

 cd /usr/local/mysql

 mkdir mysql-files

 chown mysql:mysql mysql-files

 chmod 750 mysql-files

 bin/mysqld --initialize --user=mysql

 bin/mysql_ssl_rsa_setup

 bin/mysqld_safe --user=mysql &

# Next command is optional

 cp support-files/mysql.server /etc/init.d/mysql.server

2022年3月18日 星期五

Proxmox VM 移除

 Proxmox VM 移除

原因:NFS等空間清除,但VM沒有移除,故無法刪除

先確認空間已無占用,無法連結


方法一:將硬體設定檔內 相關的硬體移除(CD-ROM、Disk)

若這樣依然無法移除,檢查是否有快照

快照無法用此方式移除,故須SSH進入主機節點,移除設定檔


位置

XXX=VMID 

方法:rm -f /etc/pve/nodes/*/*/XXX.conf

EX:rm -f /etc/pve/nodes/*/*/1024.conf