# MySQL 單機安裝 [TOC] >說明： 本次只在bd00上安裝了mysql 除了以下操作，其它操作均是在創建的bigdata用戶操作 1.創建用戶 2.關閉防火墻 3.卸載老軟件 4.添加自啟懂 ### 關閉防火墻 ``` systemctl stop firewalld.service #停止firewall systemctl disable firewalld.service #禁止firewall開機啟動 firewall-cmd --state #查看默認防火墻狀態（關閉后顯示notrunning，開啟后顯示running） ``` ### 檢查是否安裝NySQL,如果安裝 卸載之 ``` rpm -qa |grep mysql yum remove mysql* ``` ### 檢查是否安裝MariaDB,如果安裝 卸載之(重要) ``` rpm -qa |grep mariadb yum remove mariadb* ``` ## 安裝 ### 添加用戶 ``` useradd bigdata ``` >如果添加過了就不用了 ### 切換用戶 ``` su - bigdata ``` ### 下載 ``` wget http://uni.mirrors.163.com/mysql/Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz ``` ### 解壓 ``` tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz ``` ### 修改文件夾名 ``` mv mysql-5.7.26-linux-glibc2.12-x86_64 mysql ``` ### 進入mysql目錄 ``` cd /home/bigdata/soft/mysql ``` ### 創建my.conf ``` vim /home/bigdata/soft/mysql/my.cnf ``` ``` [client] port=3306 socket=/home/bigdata/soft/mysql/mysql.sock [mysqld] basedir=/home/bigdata/soft/mysql datadir=/home/bigdata/soft/mysql/data socket=/home/bigdata/soft/mysql/mysql.sock user=bigdata pid-file=/home/bigdata/soft/mysql/data/mysql.pid #進程id [mysql] socket=/home/bigdata/soft/mysql/mysql.sock ``` ### 初始化 ``` ./bin/mysqld --defaults-file=/home/bigdata/soft/mysql/my.cnf \ --initialize \ --basedir=/home/bigdata/soft/mysql/ \ --datadir=/home/bigdata/soft/mysql/data/ \ --user=bigdata \ --socket=/home/bigdata/soft/mysql/mysql.sock ``` >實際效果如下，還有個密碼？ ``` [mysql@bd00 mysql]$ ./bin/mysqld --initialize --user=mysql \ > --basedir=/home/bigdata/soft/mysql/ \ > --datadir=/home/bigdata/soft/mysql/data/ 2019-05-24T14:50:38.189220Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2019-05-24T14:50:38.189310Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2019-05-24T14:50:38.189429Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-05-24T14:50:38.508430Z 0 [Warning] InnoDB: New log files created, LSN=45790 2019-05-24T14:50:38.666223Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2019-05-24T14:50:38.776967Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4b918103-7e33-11e9-b47e-000c29034af1. 2019-05-24T14:50:38.778797Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2019-05-24T14:50:38.779456Z 1 [Note] A temporary password is generated for root@localhost: L#-ZlQ397_6m [mysql@bd00 mysql]$ ``` ### 復制mysql.server ``` cp /home/bigdata/soft/mysql/support-files/mysql.server /home/bigdata/soft/mysql/mysql.server ``` ### 修改mysqld ``` cd /home/bigdata/soft/mysql vim mysql.server ``` ``` basedir=/home/bigdata/soft/mysql datadir=/home/bigdata/soft/mysql/data ``` ### 添加環境變量 ``` vi /home/bigdata/.bash_profile ``` ``` export MYSQL_HOME=/home/bigdata/soft/mysql export PATH="$PATH:$MYSQL_HOME/bin" ``` ``` source /home/bigdata/.bash_profile ``` ## 運維 ### 啟動 ``` /home/bigdata/soft/mysql/mysql.server start ``` ### 停止 ``` /home/bigdata/soft/mysql/mysql.server stop ``` ### 開機自啟動 >本次是配合hadoop生態圈使用，比如HIVE使用，所以沒有添加自啟動 只需要把 `su - mysql -c "/home/bigdata/soft/mysql/mysql.server start"` 放到 `/etc/rc.d/rc.local` 即可 ### 初次登陸 ``` mysql -h127.0.0.1 -uroot -p ``` >輸入密碼后即可登錄 ### 修改用戶密碼 ``` mysql> alter user 'root'@'localhost' identified by 'youpassword'; ``` 或者 ``` mysql> set password=password("youpassword"); ``` ### 允許遠程連接 %代表任何ip ``` mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; ``` 刷新權限 ``` mysql>flush privileges; ``` 然后遠程就能訪問了 ## 參考 [https://www.jb51.net/article/150079.htm](https://www.jb51.net/article/150079.htm) [https://www.cnblogs.com/chinesern/p/9309853.html](https://www.cnblogs.com/chinesern/p/9309853.html)