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,如需转载请自行联系原作者