問(wèn)題描述

感覺(jué)安裝nginx和php都比較簡(jiǎn)單一些，mysql比較麻煩呢

看官網(wǎng)介紹的也不是很詳細(xì)，比如沒(méi)有區(qū)分work、root用戶(hù)，安裝步驟走不下去，各個(gè)目錄的權(quán)限等。

很詳細(xì)的有張宴的blog，但是好久不更新了。

問(wèn)題解答

雖然MySQL可以用命令行安裝，但是會(huì)對(duì)一些細(xì)節(jié)和不可控性不了解,所以選擇源碼安裝最新版本需要用boost庫(kù)，所以要下載 mysql 和 boost, 下載鏈接如下: http://dev.mysql.com/downloads/mysql/選擇source code,下載最后兩個(gè)安裝包: mysql-5.7.14.tar.gz, mysql-boost-5.7.14.gz http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-boost-5.7.14.tar.gz http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.14.tar.gz1 安裝MySQL1.1 下載 wget http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-boost-5.7.14.tar.gz wget http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.14.tar.gz1.2 解壓 先解壓mysql-5.7.14.tar.gz, 然后再解壓mysql-boost-5.7.14.tar.gz 這樣能保證boost能解壓到mysql-5.7.14/boost目錄下 tar -xvf mysql-5.7.14.tar.gz tar -xvf mysql-boost-5.7.14.tar.gz1.3 安裝1.3.1 安裝MySQL必須庫(kù) apt-get update apt-get install bison openssl libncurses5-dev perl cmake1.3.2 編譯安裝 進(jìn)入目錄安裝 cd mysql-5.7.14 cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/opt/data/mysql/data -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_USER=mysql -DWITH_BOOST=boost make && make install 2.配置MySQL根據(jù)步驟1，MySQL安裝在/usr/local/mysql目錄下 cd /usr/local/mysql ls 可以查看mysql目錄2.1 創(chuàng)建MySQL用戶(hù) groupadd mysql useradd mysql -g mysql2.2 創(chuàng)建MySQL數(shù)據(jù)目錄,用來(lái)存儲(chǔ)MySQL數(shù)據(jù) mkdir -p /opt/data/mysql/data # 存放MySQL數(shù)據(jù)庫(kù)數(shù)據(jù) mkdir -p /opt/data/mysql/log # 存放MySQL日志，查看日常操作log和異常 mkdir -p /opt/data/mysql/bin-log # 存放MySQL bin log日志，用來(lái)同步數(shù)據(jù) chown -R mysql:mysql /opt/data/mysql # root用戶(hù)將mysql目錄歸mysql用戶(hù)所有2.3 配置MySQL cd /usr/local/mysql cp support-files/my-default.cnf /etc/my.cnf # 將my-default.cnf文件復(fù)制到/etc目錄下，并命名為my.cnf vim /etc/my.cnf # 打開(kāi)my.cnf, 添加如下配置:[mysqld]character_set_server=utf8server_id = 1port = 3306innodb_buffer_pool_size = 128Mbasedir = /usr/local/mysqldatadir = /opt/data/mysql/datasocket = /tmp/mysql.sockpid-file = /opt/data/mysql/mysql.pid log-bin = /opt/data/mysql/bin-log/mysql-bin sync-binlog = 1 general_log = 1 log-error = /opt/data/mysql/log/mysql_err.loggeneral_log_file = /opt/data/mysql/log/mysql.log[mysql]default-character-set=utf82.4 初始化MySQL cd /usr/local/mysql bin/mysqld --defaults-file=/etc/my.cnf --user=mysql --initialize 打開(kāi)/opt/data/mysql/log/mysql.log, 查找初始化密碼 2016-07-05T08:31:20.363565Z 1 [Note] A temporary password is generated for root@localhost: 9arAj*:r047g 登陸 bin/mysql -u root -p 9arAj*:r047g 不修改密碼不能操作 mysql> show databases; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.修改密碼 mysql> SET PASSWORD = PASSWORD(’123456’); mysql> ALTER USER ’root’@’localhost’ PASSWORD EXPIRE NEVER; mysql> flush privileges;2.5 配置MySQL執(zhí)行路勁 vim /root/.bashrc # 打開(kāi).bashrc文件，并記錄一下內(nèi)容 export PATH=$PATH:/usr/local/mysql/bin/ 保存，退出 source /root/.bashrc 執(zhí)行一下命令檢驗(yàn)是否準(zhǔn)確mysql -uroot -p123456回答2：

Mysql對(duì)linux支持很牛叉了，最少只需執(zhí)行3條命令即可安裝成功這里有個(gè)教程，CentOS 7中安裝Mysqlhttps://www.obneer.com/how-to...