二进制快速安装mysql5.6.35的步骤

本文主要给大家简单讲讲二进制快速安装mysql5.6.35的步骤，相关专业术语大家可以上网查查或者找一些相关书籍补充一下，这里就不涉猎了，我们就直奔主题吧，希望二进制快速安装mysql5.6.35的步骤这篇文章可以给大家带来一些实际帮助。

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 mysqlmkdir -pv  /data/mysql-5.6.35/{var,log}touch /data/mysql-5.6.35/log/error.logsudo chown -R mysql:mysql /data/mysql-5.6.35/

添加环境变量：

vim ~/.bash_profileexport 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_safesudo sed -i 's#/usr/local/mysql#/data/mysql-5.6.35#g' /data/mysql-5.6.35/support-files/mysql.serversudo ln -s /data/mysql-5.6.35/bin/mysql /usr/bin

修改配置文件

sudo rm -f /etc/my.cnfsudo vim /data/mysql-5.6.35/my.cnf[client]port       = 3306socket   = /tmp/mysql.sock[mysqld]server-id  = 1port      = 3306basedir = /data/mysql-5.6.35datadir  = /data/mysql-5.6.35/datasocket  = /tmp/mysql.sockbinlog-ignore-db  = mysqllog-bin  = /data/mysql-5.6.35/log/mysql-bininnodb_file_per_table = 1open_files_limit  = 65535sql_mode  =NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESskip-host-cacheskip-name-resolvemax_connections  = 1024wait_timeout  = 31536000interactive_timeout = 31536000character-set-server  =utf8mb4collation-server  = utf8mb4_general_ciinit_connect  = 'SET NAMES utf8mb4'lower_case_table_names = 1log_error  = /data/mysql-5.6.35/log/error.logslow_query_log = 1slow_query_log_file = /data/mysql-5.6.35/log/slow.log[mysqld_safe]err-log= /data/mysql-5.6.35/log/mysqld_safe_err.logpid-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 mysqldsudo chkconfig mysqld onsudo chkconfig --list mysqld

启动mysql

sudo  /etc/init.d/mysqld startps -ef | grepmysql

设置mysql密码

sudo /data/mysql-5.6.35/bin/mysqladmin -u root password 'newpassword'

登录

mysql  -uroot   -p

配置安全策略：

[root@KVM mysql-5.6.35]#sudo /data/mysql-5.6.35/bin/mysql_secure_installationNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL            SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!                  In order to log into MySQL to secure it, we'll need the currentpassword for the root user.  Ifyou've just installed MySQL, andyou haven't set the root password yet, the password will be blank,so you should just press enter here.            Enter current password for root (enter for none):OK, successfully used password, moving on...            Setting the root password ensures that nobody can log into the MySQLroot user without the proper authorisation.      You already have a root password set, so you can safely answer 'n'.      Change the root password? [Y/n] n       ... skipping.            By default, a MySQL installation has an anonymous user, allowing anyoneto log into MySQL without having to have a user account created forthem.  This is intended only fortesting, and to make the installationgo a bit smoother.  You shouldremove them before moving into aproduction environment.            Remove anonymous users? [Y/n] y       ... Success!            Normally, root should only be allowed to connect from 'localhost'.  Thisensures that someone cannot guess at the root password from the network.      Disallow root login remotely? [Y/n] n       ... Success!            By default, MySQL comes with a database named 'test' that anyone canaccess.  This is also intended only fortesting, and should be removedbefore moving into a production environment.      Remove test database and access to it? [Y/n] y        - Dropping test database...        ... Success!        - 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]#

二进制快速安装mysql5.6.35的步骤就先给大家讲到这里，对于其它相关问题大家想要了解的可以持续关注我们的行业资讯。我们的板块内容每天都会捕捉一些行业新闻及专业知识分享给大家的。