安装依赖环境 > sudo apt-get install -y cmake build-essential libreadline6-dev libncurses5-dev 获取mysql > cd
安装依赖环境
> sudo apt-get install -y cmake build-essential libreadline6-dev libncurses5-dev获取mysql
> cd /tmp && wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.6/mysql-5.6.37.tar.gz解压
> cd /tmp> tar -zxf mysql-5.6.37.tar.gz安装
> sudo groupadd mysql> sudo useradd -r -g mysql mysql> cd /tmp/mysql-5.6.37> sudo mkdir -p /etc/mysql/conf.d> sudo mkdir /run/mysqld> sudo mkdir -p /var/log/mysql> sudo mkdir -p /data/mysql> sudo mkdir -p /data/mysql-old-log> sudo chown -R mysql:mysql /var/log/mysql> sudo chown -R mysql:mysql /data/mysql> sudo chown -R mysql:mysql /data/mysql-old-log> sudo chown -R mysql:root /run/mysqld> cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DSYSCONFDIR=/etc/mysql -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/var/run/mysqld/mysqld.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=utf8,gbk -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_PARTITION_STORAGE_ENGINE=1> make -j6> sudo make install配置
> sudo chown -R mysql:mysql /usr/local/mysql> cd /usr/local/mysql> sudo touch /etc/mysql/conf.d/.keepme> sudo vim /etc/mysql/my.cnf> sudo scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql[my.cnf]
## The MySQL database server configuration file.## You can copy this to one of:# - "/etc/mysql/my.cnf" to set global options,# - "~/.my.cnf" to set user-specific options.## One can use all long options that the program supports.# Run program with --help to get a list of available options and with# --print-defaults to see which it would actually understand and use.## For explanations see# http://dev.mysql.com/doc/mysql/en/server-system-variables.html# This will be passed to all mysql clients# It has been reported that passwords should be enclosed with ticks/quotes# escpecially if they contain "#" chars...# Remember to edit /etc/mysql/debian.cnf when changing the socket location.[client]port=3306socket=/var/run/mysqld/mysqld.sock# Here is entries for some specific programs# The following values assume you have at least 32M ram# This was formally known as [safe_mysqld]. Both versions are currently parsed.[mysqld_safe]socket=/var/run/mysqld/mysqld.socknice=0[mysqld]## * Basic Settings#user=mysqlpid-file=/var/run/mysqld/mysqld.pidsocket=/var/run/mysqld/mysqld.sockport=3306basedir=/usr/local/mysqldatadir=/data/mysqltmpdir=/tmp#lc-messages-dir=/usr/share/mysqlskip-external-lockingmax_connections=1000event_scheduler=ONmax_allowed_packet=48M## Instead of skip-networking the default is now to listen only on# localhost which is more compatible and is not less secure.bind-address=0.0.0.0## * Fine Tuning#key_buffer=512Mmax_allowed_packet=64Mthread_stack=192Kthread_cache_size=24# This replaces the startup script and checks MyISAM tables if needed# the first time they are touchedmyisam-recover=BACKUP#max_connections = 100#table_cache = 64#thread_concurrency = 10## * Query Cache Configuration#query_cache_limit=16Mquery_cache_size=128M## * Logging and Replication## Both location gets rotated by the cronjob.# Be aware that this log type is a performance killer.# As of 5.1 you can enable the log at runtime!#general_log_file = /var/log/mysql/mysql.log#general_log = 1## Error log - should be very few entries.#log_error=/var/log/mysql/error.log## Here you can see queries with especially long duration#log_slow_queries = /var/log/mysql/mysql-slow.log#long_query_time = 2#log-queries-not-using-indexes## The following can be used as easy to replay backup logs or for replication.# note: if you are setting up a replication slave, see README.Debian about# other settings you may need to change.#server-id = 1#log_bin = /var/log/mysql/mysql-bin.logexpire_logs_days=10max_binlog_size=100M#binlog_do_db = include_database_name#binlog_ignore_db = include_database_name## * InnoDB## InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.# Read the manual for more InnoDB related options. There are many!## * Security Features## Read the manual, too, if you want chroot!# chroot = /var/lib/mysql/## For generating SSL certificates I recommend the OpenSSL GUI "tinyca".## ssl-ca=/etc/mysql/cacert.pem# ssl-cert=/etc/mysql/server-cert.pem# ssl-key=/etc/mysql/server-key.peminnodb_file_per_table=1innodb_open_files=2048innodb_log_group_home_dir=/data/mysqlinnodb_buffer_pool_instances=24innodb_buffer_pool_size=24Ginnodb_additional_mem_pool_size=64Minnodb_log_file_size=64Minnodb_lock_wait_timeout=50innodb_flush_log_at_trx_commit=0### small swap / IOinnodb_flush_method=O_DIRECTinnodb_write_io_threads=16innodb_read_io_threads=16innodb_thread_concurrency=16innodb_log_files_in_group=3innodb_max_dirty_pages_pct=90skip-name-resolveslow_query_loglong_query_time=0.1log-bin=mysql-binbinlog_format=mixedrelay-log=relay-binrelay-log-index=slave-relay-bin.index#auto-increment-increment=2#auto-increment-offset=1server-id=1log_slave_updates=1read_only=0[mysqldump]quickquote-namesmax_allowed_packet=48M[mysql]#no-auto-rehash # faster start of mysql but no tab completition[isamchk]key_buffer=16Mmax_allowed_packet=48M## * IMPORTANT: Additional settings that can override those from this file!# The files must end with '.cnf', otherwise they'll be ignored.#!includedir /etc/mysql/conf.d/创建软链接
> sudo ln -s /usr/local/mysql/bin/* /usr/bin启动mysql
> sudo bin/mysqld_safe --user=mysql --datadir=/data/mysql --pid-file=/var/run/mysqld/mysqld.pid &停止mysql
> sudo pkill -9 mysql完成安装后的一些操作
# 修改root密码> mysql -uroot> update user set password=passworD("password") where user='root';# 允许root(或者其他用户)远程登录（可选，个人开发环境可以开启）> grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;# 删除匿名用户> delete from mysql.user where user='';# 刷新权限表> flush privileges;