mysql部署文檔
操作系統：centos Linux release 7.4.1708
內核版本：3.10.0
# 手動安裝
1> 將mysql-5.5.54-linux2.6-x86_64.tar.gz上傳至CentOS服務器/tmp目錄下
2> 解壓壓縮包至/usr/local/
[root@localhost?local]#?tar?-zxvf?/tmp/mysql-5.5.54-linux2.6-x86_64.tar.gz?-C?/usr/local/
3> 設置軟連接
[root@localhost?local]#?ln?-s?mysql-5.5.54-linux2.6-x86_64/?mysql
4> 新增用戶組和用戶
[root@localhost?local]#?groupadd?-r?mysql [root@localhost?local]#?useradd?-g?mysql?-r?-s?/sbin/nologin?mysql
5> 給/usr/local/mysql/*權限
[root@localhost?local]#?chown?-R?mysql.mysql?/usr/local/mysql/*
6> 設置數據存儲路徑，并賦予權限
[root@localhost?local]#?mkdir?–p?/data/mydata [root@localhost?local]#?chown?-R?mysql.mysql?/data/mydata
7> 初始化mysql
[root@localhost?local]#?cd?/usr/local/mysql [root@localhost?local]#?scripts/mysql_install_db?--datadir=/data/mydata?--user=mysql
8> 改回root權限
[root@localhost?local]#?chown?-R?root?/usr/local/mysql/*
9> 加入自動啟動
[root@localhost?local]#?cp?-a?mysql/support-files/mysql.server?/etc/rc.d/init.d/mysqld [root@localhost?local]#?chkconfig?--add?mysqld
10> 修改配置文件
[root@localhost?local]#?cp?-a?/usr/local/mysql/support-files/my-large.cnf?/etc/my.cnf [root@localhost?local]#?vi?/data/mydata
在[mysqld]字段下添加 datadir = /data/mydata
thread_concurrency = CPU物理核心數的2倍
保存，退出/etc/my.cnf
11> 啟動mysql服務
[root@localhost?local]#?/etc/rc.d/init.d/mysqld?start
12> 創建root用戶密碼
*先登錄mysql
[root@localhost?local]#?mysql?-uroot?-hlocalhost?-p Enter?password:
*承上，顯示Enter password:
(直接回車)
*設置密碼，假設密碼為：zz2014info
mysql>?SET?PASSWORD?FOR?'root'@'localhost'=PASSWORD('zz2014info');
*顯示如下，則表示創建密碼成功
Query?OK,?0?rows?affected?(0.14?sec)
13> 創建mysql實例
*創建mysql實例，例如logincenter
**************************************************************
****************mysql實例名是區分大小寫的*********************
********************開發這邊統一小寫**************************
********************忽略大小寫可配置**************************
**************************************************************
mysql>?CREATE?DATABASE?logincenter； Query?OK,?1?row?affected?(0.01?sec)
*查看實例是否創建成功
mysql>?SHOW?DATABASES;+--------------------+ |?Database?| +--------------------+ |?information_schema?| |?logincenter?| |?mysql?| |?performance_schema?| |?test?| +--------------------+
14> 將mysql命令加入環境變量
[root@localhost?local]#?echo?"PATH=$PATH:/usr/local/mysql/bin"?>?/etc/profile.d/mysql.sh[root@localhost?local]#?echo?"export?PATH"?>>?/etc/profile.d/mysql.sh[root@localhost?local]#?source?/etc/profile
15> 導入.sql語句腳本(以logincenter.sql為例)
[root@localhost?local]#?mysql?-uroot?-pzz2014info?logincenter?
