linux中mysql如何实现离线安装

这篇文章将为大家详细讲解有关linux中mysql如何实现离线安装，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。[root@hadoop-01 ~]# cd /usr/local[root@hadoop-01 local]# wget https://downloads.mariadb.com/archives/mysql-5.6/mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz[root@hadoop-01 local]# wget https://downloads.mariadb.com/archives/mysql-5.6/mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz.md5[root@hadoop-01 local]# vi mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz.md561affe944eff55fcf51b31e67f25dc10 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz[root@hadoop-01 local]# md5sum mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz61affe944eff55fcf51b31e67f25dc10 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz检查是否已安装[root@hadoop-01 local]# ps -ef|grep mysqld解压重命名[root@hadoop-01 local]# tar xzvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz[root@hadoop-01 local]# mv mysql-5.6.23-linux-glibc2.5-x86_64 mysql创建用户组[root@hadoop-01 local]# groupadd -g 101 dba[root@hadoop-01 local]# useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin[root@hadoop-01 local]# id mysqladminuid=514(mysqladmin) gid=101(dba) groups=101(dba),0(root)[root@hadoop-01 local]# passwd mysqladmin# copy 环境变量配置文件至mysqladmin用户的home目录中,为了以下步骤配置个人环境变量[root@hadoop-01 local]# cp /etc/skel/.* /usr/local/mysql创建配置文件 /etc/my.cnf(640)[root@hadoop-01 mysql]# vi /etc/my.cnf删除内容，并将以下内容复制进去[client]port = 3306socket = /usr/local/mysql/data/mysql.sock[mysqld]port = 3306socket = /usr/local/mysql/data/mysql.sockskip-external-lockingkey_buffer_size = 256Msort_buffer_size = 2Mread_buffer_size = 2Mread_rnd_buffer_size = 4Mquery_cache_size= 32Mmax_allowed_packet = 16Mmyisam_sort_buffer_size=128Mtmp_table_size=32Mtable_open_cache = 512thread_cache_size = 8wait_timeout = 86400interactive_timeout = 86400max_connections = 600# Try number of CPU’s*2 for thread_concurrencythread_concurrency = 32#isolation level and default enginedefault-storage-engine = INNODBtransaction-isolation = READ-COMMITTEDserver-id = 1basedir = /usr/local/mysqldatadir = /usr/local/mysql/datapid-file = /usr/local/mysql/data/hostname.pid#open performance schemalog-warningssysdate-is-nowbinlog_format = MIXEDlog_bin_trust_function_creators=1log-error = /usr/local/mysql/data/hostname.errlog-bin=/usr/local/mysql/arch/mysql-bin#other logs#general_log =1#general_log_file = /usr/local/m免费主机域名ysql/data/general_log.err#slow_query_log=1#slow_query_log_file=/usr/local/mysql/data/slow_log.err#for replication slave#log-slave-updates#sync_binlog = 1#for innodb optionsinnodb_data_home_dir = /usr/local/mysql/data/innodb_data_file_path = ibdata1:500M:autoextendinnodb_log_group_home_dir = /usr/local/mysql/archinnodb_log_f免费主机域名iles_in_group = 2innodb_log_file_size = 200M# rember changeinnodb_buffer_pool_size = 2048Minnodb_additional_mem_pool_size = 50Minnodb_log_buffer_size = 16Minnodb_lock_wait_timeout = 100#innodb_thread_concurrency = 0innodb_flush_log_at_trx_commit = 1innodb_locks_unsafe_for_binlog=1#innodb io features: add for mysql5.5.8performance_schemainnodb_read_io_threads=4innodb-write-io-threads=4innodb-io-capacity=200#purge threads change default(0) to 1 for purgeinnodb_purge_threads=1innodb_use_native_aio=on#case-sensitive file names and separate tablespaceinnodb_file_per_table = 1lower_case_table_names=1[mysqldump]quickmax_allowed_packet = 16M[mysql]no-auto-rehash[mysqlhotcopy]interactive-timeout[myisamchk]key_buffer_size = 256Msort_buffer_size = 256Mread_buffer = 2Mwrite_buffer = 2M 指定文件用户组、修改权限、尝试首次安装[root@hadoop-01 local]# chown mysqladmin:dba /etc/my.cnf[root@hadoop-01 local]# chmod 640 /etc/my.cnf[root@hadoop-01 etc]# ll my.cnf-rw-r—– 1 mysqladmin dba 2201 Aug 25 23:09 my.cnf [root@hadoop-01 local]# chown -R mysqladmin:dba /usr/local/mysql[root@hadoop-01 local]# chmod -R 755 /usr/local/mysql[root@hadoop-01 local]# su – mysqladmin[mysqladmin@hadoop-01 ~]# pwd/usr/local/mysql[mysqladmin@hadoop-01 ~]# mkdir arch[mysqladmin@hadoop-01 ~]# scripts/mysql_install_db ###importInstalling MySQL system tables…./bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory #缺少libaio.so 包[root@hadoop-01 local]# yum -y install libaio再次安装[mysqladmin@hadoop-01 ~]# scripts/mysql_install_db –user=mysqladmin –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data配置mysql服务自启动[root@sht-sgmhadoopnn-01 ~]# cd /usr/local/mysql#将服务文件拷贝到init.d下，并重命名为mysql[root@sht-sgmhadoopnn-01 mysql]# cp support-files/mysql.server /etc/rc.d/init.d/mysql#赋予可执行权限[root@sht-sgmhadoopnn-01 mysql]# chmod +x /etc/rc.d/init.d/mysql#删除服务[root@sht-sgmhadoopnn-01 mysql]# chkconfig –del mysql#添加服务[root@sht-sgmhadoopnn-01 mysql]# chkconfig –add mysql[root@sht-sgmhadoopnn-01 mysql]# chkconfig –level 345 mysql on[root@sht-sgmhadoopnn-01 mysql]# vi /etc/rc.local#!/bin/sh## This script will be executed *after* all the other init scripts.# You can put your own initialization stuff in here if you don’t# want to do the full Sys V style init stuff.touch /var/lock/subsys/localsu – mysqladmin -c “/etc/init.d/mysql start –federated””/etc/rc.local” 9L, 278C written查看进程[root@hadoop-01 mysql]# su – mysqladmin[mysqladmin@hadoop-01 ~]# pwd/usr/local/mysql[mysqladmin@hadoop-01 ~]# rm -rf my.cnf[mysqladmin@hadoop-01 ~]# bin/mysqld_safe &[mysqladmin@hadoop-01 ~]# ps -ef|grep mysqld[mysqladmin@hadoop-01 ~]# netstat -tulnp | grep mysql[root@hadoop-01 local]# service mysql status登录mysql[mysqladmin@hadoop-01 ~]# bin/mysqlmysql> show databases;+——————–+| Database |+——————–+| information_schema || mysql || performance_schema || test |+——————–+修改密码mysql> use mysql;mysql> update user set password=password(‘password’) where user=’root’;配置环境变量[mysqladmin@hadoop-01 ~]$ vi ./.bash_profile# insertexport MYSQL_HOME=/usr/local/mysqlexport PATH=${MYSQL_HOME}/bin:$PATH[mysqladmin@hadoop-01 ~]$ source ./.bash_profile [mysqladmin@hadoop-01 ~]$ vi ./.bash_profile实现window和其他工具远程连接linux服务器1、登陆mysql数据库 mysql -u root -p 查看user表mysql> use mysql;Database changedmysql> select host,user,password from user;+————–+——+——————————————-+| host | user | password |+————–+——+——————————————-+| localhost | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E || 192.168.1.1 | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |+————–+——+——————————————-+2 rows in set (0.00 sec)mysql> use mysql;Database changedQuery OK, 0 rows affected (0.00 sec)grant all on *.* to admin@’%’ identified by ‘123456’ with grant option;mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)关于“linux中mysql如何实现离线安装”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，使各位可以学到更多知识，如果觉得文章不错，请把它分享出去让更多的人看到。

相关推荐: MySQL数据库的性能分析

本篇内容主要讲解“MySQL数据库的性能分析”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“MySQL数据库的性能分析”吧!　　1. MySQL性能优化简介　　在Web应用程序体系架构中，数据持久层（通常是一个关系数…