您好,登錄后才能下訂單哦!
3分鐘內(nèi)快速部署MySQL5.6.35數(shù)據(jù)庫實踐
1、下載軟件
wget -q http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
2、解壓移動
tar xf mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz mkdir -p /application mv mysql-5.6.35-linux-glibc2.5-x86_64 /application/mysql-5.6.35 useradd -s /sbin/nologin -M mysql chown -R mysql.mysql /application/mysql-5.6.35/ cd /application/mysql-5.6.35/
3、初始化數(shù)據(jù)庫
cp support-files/my-default.cnf /etc/my.cnf ./scripts/mysql_install_db --basedir=/application/mysql-5.6.35/ --datadir=/application/mysql-5.6.35/data/ --user=mysql sed -i 's#/usr/local/mysql#/application/mysql-5.6.35#g' /application/mysql-5.6.35//bin/mysqld_safe
4、啟動登錄
/application/mysql-5.6.35//bin/mysqld_safe & lsof -i :3306 PATH="/application/mysql-5.6.35/bin/:$PATH"
5、登錄測試
[root@oldboy mysql-5.6.35]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.35 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select version(); +-----------+ | version() | +-----------+ | 5.6.35 | +-----------+ 1 row in set (0.00 sec) mysql> create database oldboy; Query OK, 1 row affected (0.00 sec) mysql> create database oldgirl; Query OK, 1 row affected (0.00 sec) mysql> show databases like 'old%'; +-----------------+ | Database (old%) | +-----------------+ | oldboy | | oldgirl | +-----------------+ 2 rows in set (0.00 sec)
6、配置安全策略:
[root@oldboy mysql-5.6.35]# mysql_secure_installation
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。