mysql5.6.35 二进制快速安装
mysql
说明:
mysql安装在/data/mysql-5.6.35目录下;
下载
cd /data/
wget
tar -zxf mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.6.35-linux-glibc2.5-x86_64 /data/mysql-5.6.35
新建mysql用户及设置权限
sudo useradd -s /sbin/nologin -M mysql
mkdir -pv /data/mysql-5.6.35/{var,log}
touch /data/mysql-5.6.35/log/error.log
sudo chown -R mysql:mysql /data/mysql-5.6.35/
添加环境变量:
vim ~/.bash_profile
export PATH=/data/mysql-5.6.35/bin:$PATH
刷新一下环境
source ~/.bash_profile
初始化数据库,修改默认路径
cd /data/mysql-5.6.35/
sudo ./scripts/mysql_install_db --basedir=/data/mysql-5.6.35/ --datadir=/data/mysql-5.6.35/data/ --user=mysql
#如果安装在/usr/local/mysql/目录下,则两个sed不许执行,因为默认是/usr/local/目录下;
sudo sed -i 's#/usr/local/mysql#/data/mysql-5.6.35#g' /data/mysql-5.6.35/bin/mysqld_safe
sudo sed -i 's#/usr/local/mysql#/data/mysql-5.6.35#g' /data/mysql-5.6.35/support-files/mysql.server
sudo ln -s /data/mysql-5.6.35/bin/mysql /usr/bin
修改配置文件
sudo rm –f /etc/my.cnf
sudo vim /data/mysql-5.6.35/my.cnf
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
server-id = 1
port = 3306
basedir = /data/mysql-5.6.35
datadir = /data/mysql-5.6.35/data
socket = /tmp/mysql.sock
binlog-ignore-db = mysql
log-bin = /data/mysql-5.6.35/log/mysql-bin
innodb_file_per_table = 1
open_files_limit = 65535
sql_mode =NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
skip-host-cache
skip-name-resolve
max_connections = 1024
wait_timeout = 31536000
interactive_timeout = 31536000
character-set-server =utf8mb4
collation-server = utf8mb4_general_ci
init_connect = 'SET NAMES utf8mb4'
lower_case_table_names = 1
log_error = /data/mysql-5.6.35/log/error.log
slow_query_log = 1
slow_query_log_file = /data/mysql-5.6.35/log/slow.log
[mysqld_safe]
err-log= /data/mysql-5.6.35/log/mysqld_safe_err.log
pid-file = /data/mysql-5.6.35/var/mysqld.pid
将服务脚本复制到/etc/init.d目录下,并添加到服务列表
sudo cp support-files/mysql.server /etc/init.d/mysqld
开机自启动
sudo chkconfig --add mysqld
sudo chkconfig mysqld on
sudo chkconfig --list mysqld
启动mysql
sudo /etc/init.d/mysqld start
ps –ef | grepmysql
设置mysql密码
sudo /data/mysql-5.6.35/bin/mysqladmin -u root password 'newpassword'
登录
mysql -uroot -p
配置安全策略:
- Removing privileges on testdatabase
...
... Success!
Reloading the privilege tables will ensure that all changes made so farwill take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
All done! If you've completed allof the above steps, your MySQLinstallation should now be secure.
Thanks for using MySQL!
Cleaning up...
[root@KVM mysql-5.6.35]#
本文转自898009427 51CTO博客,原文链接:http://blog.51cto.com/moerjinrong/1929355,如需转载请自行联系原作者