大橙子网站建设,新征程启航
为企业提供网站建设、域名注册、服务器等服务
本文主要给大家简单讲讲二进制快速安装mysql5.6.35的步骤,相关专业术语大家可以上网查查或者找一些相关书籍补充一下,这里就不涉猎了,我们就直奔主题吧,希望二进制快速安装mysql5.6.35的步骤这篇文章可以给大家带来一些实际帮助。
创新互联是一家以成都网站建设公司、网页设计、品牌设计、软件运维、营销推广、小程序App开发等移动开发为一体互联网公司。已累计为地磅秤等众行业中小客户提供优质的互联网建站和软件开发服务。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
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
sudo cp support-files/mysql.server /etc/init.d/mysqld
sudo chkconfig --add mysqld sudo chkconfig mysqld on sudo chkconfig --list mysqld
sudo /etc/init.d/mysqld start ps –ef | grepmysql
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_installation NOTE: 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的步骤就先给大家讲到这里,对于其它相关问题大家想要了解的可以持续关注我们的行业资讯。我们的板块内容每天都会捕捉一些行业新闻及专业知识分享给大家的。
另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。