在centos上安裝數據庫,通常指的是安裝mysql數據庫,以下是詳細的安裝步驟:
通過yum源安裝mysql
- 配置yum源:
sudo wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm sudo rpm -ivh mysql80-community-release-el7-3.noarch.rpm
sudo yum install mysql-community-server
- 啟動并設置開機自啟:
sudo systemctl start mysqld sudo systemctl enable mysqld
- 設置root用戶密碼:
sudo mysql_secure_installation
手動編譯安裝MySQL
- 下載MySQL源碼包:
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.26.tar.gz tar -zxvf mysql-8.0.26.tar.gz cd mysql-8.0.26
- 安裝依賴包:
sudo yum install -y cmake gcc-c bison ncurses-devel
- 編譯并安裝MySQL:
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci make && sudo make install
- 初始化MySQL并設置開機自啟:
cd /usr/local/mysql sudo scripts/mysql_install_db --user=mysql sudo chown -R mysql:mysql /usr/local/mysql sudo systemctl start mysqld sudo systemctl enable mysqld
- 設置root用戶密碼:
sudo /usr/local/mysql/bin/mysql_secure_installation
請注意,具體的安裝步驟可能會因centos版本和MySQL版本的不同而有所差異。建議參考官方文檔或搜索相關教程以獲取最準確的信息。