linux下安装mysql尝试其他镜像_linux下安装mysql

mysql安装

1、mysql下载路径

https://pan.baidu.com/s/1MPuTenlhsX-bJrEsPD-wSw

mysql安装脚本

mysql_install-5.7.20.sh

#!/bin/bashif [ $# -ne 1]

then

echo"Usage: $0 port "exit1fi

( lsof-i:$1 &>/dev/null || which mysql$1 &>/dev/null ) && ( echo "error: the port $1 has been used" ; exit 11)

test $? -eq 11 && exit 1############################

base_dir=/usr/local/mysql$1data_dir=/mysql/mysql$1mysql_file='mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz'echo"install ing ........"############################

useradd mysql2>/dev/nullmkdir ${data_dir}-p 2>/dev/nullchown mysql:mysql ${base_dir} ${data_dir}-R

############################

#download mysql installpackageand install it

test-f $mysql_file || (echo "download mysql software package error!" ;exit 1)

test $? -eq 1 && exit 1echo"install mysql ......"tar-zxvf $mysql_file -C /usr/local

cd/usr/local && mv mysql-5.7.20-linux-glibc2.12-x86_64 mysql$1cd ${base_dir}

ln-s ${base_dir}/support-files/mysql.server /etc/init.d/mysql$1echo'export PATH=/usr/local/mysql3306/bin:$PATH' >> /etc/profile

source/etc/profile

chown mysql:mysql ${base_dir} ${data_dir}-R

printf"[client]\nport = $1\nsocket = ${data_dir}/mysqld.sock\ndefault-character-set=utf8\n\n[mysqld]\nport = $1\nsocket = ${data_dir}/mysqld.sock\nbasedir =${base_dir} \ndatadir = ${data_dir}\nback_log = 500\nskip-name-resolve\nskip-external-locking\nconcurrent_insert = 2\ndelay-key-write = ALL\nkey_buffer_size = 256M\nmax_allowed_packet = 128M\ntable_open_cache = 512\nsort_buffer_size = 2M\nnet_buffer_length = 8K\nread_buffer_size = 2M\nread_rnd_buffer_size = 512K\nmyisam_sort_buffer_size = 64M\nthread_stack = 512K\nlog-bin = mysql-bin\nbinlog_format = mixed\nrelay_log = relay-bin\nserver-id = $1\nbinlog_cache_size = 8M\nmax_binlog_size = 1024M\nmax_relay_log_size = 1024M\nexpire_logs_days = 3\nthread_cache_size = 8\nquery_cache_size = 32M\nmax_connections = 32000\nmax_user_connections=5000\ntmp_table_size = 256M\nlong_query_time = 1\nslow_query_log\ninnodb_file_per_table\ninnodb_buffer_pool_size = 1G\ninnodb_flush_log_at_trx_commit = 2\ninnodb_flush_method = O_DIRECT\ninnodb_file_format = barracuda\ninnodb_log_file_size = 256M\ninnodb_log_files_in_group = 3\ninnodb_fast_shutdown = 1\nexplicit_defaults_for_timestamp=off\nmax_user_connections=500\nsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES\nsql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES\ninnodb_io_capacity = 2000\ninnodb_io_capacity_max = 10000\ninnodb_open_files = 1000\nfederated\nevent_scheduler=1\ndefault-storage-engine=INNODB\ncharacter-set-server=utf8\ncollation-server=utf8_general_ci\n\n[mysqldump]\nquick\nmax_allowed_packet = 16M\n\n[mysql]\nno-auto-rehash\n\n[myisamchk]\nkey_buffer_size = 20M\nsort_buffer_size = 20M\nread_buffer = 2M\nwrite_buffer = 2M\n\n[mysqlhotcopy]\ninteractive-timeout" > /etc/my.cnf

#./scripts/mysql_install_db --defaults-file=${base_dir}/etc/my.cnf --basedir=${base_dir} --datadir=${data_dir} || exit 1${base_dir}/bin/mysqld --initialize --user=mysql --basedir=${base_dir} --datadir=${data_dir} || exit 1chown mysql:mysql ${base_dir} ${data_dir}-R/etc/init.d/mysql$1 start && echo "mysql has been install successfully!"############################

############################

chkconfig--add mysql$1chkconfig mysql$1 on

2、执行 sh mysql_install-5.7.13.sh ${MYSQL_PORT_NO} 脚本

sh mysql_install-5.7.13.sh 3306

Mysql安装时，会打印出root账户的临时密码，记下临时密码

3、登录mysql并修改临时密码,并给root用户在其他机器可以登录的权限，在安装完成后再取消该权限。命令如下：

mysql -uroot -p

ALTER USER'root'@'localhost' IDENTIFIED BY 'root';

use mysql

update user set Host= "%" where User = "root";

至此mysql安装完成