下载安装包 MySQL-5.6.38-linux-glibc2.12-x86_64.tar.gz
创建mysql用户useradd -r mysql -s /sbin/nologin
解压文件tar -zxvf mysql-5.6.38-linux-glibc2.12-x86_64.tar.gz -C /opt/
改名mv /opt/mysql-5.6.38-linux-glibc2.12-x86_64/ /opt/mysql-5.6
创建数据目录mkdir /data
更改目录属组
创新互联专注于延庆网站建设服务及定制,我们拥有丰富的企业做网站经验。 热诚为您提供延庆营销型网站建设,延庆网站制作、延庆网页设计、延庆网站官网定制、微信平台小程序开发服务,打造延庆网络公司原创品牌,更为您提供延庆网站排名全网营销落地服务。
chown -R mysql.mysql /data
chown -R mysql.mysql /opt/mysql-5.6/
安装mysql
cd /opt/mysql-5.6/scripts/
./mysql_install_db --basedir=/opt/mysql-5.6/ --datadir=/data --user=mysql --pid-file=/opt/mysql-5.6/mysql.pid
安装mysql报错FATAL ERROR: please install the following Perl modules before executing
缺少autoconf 包yum-y install autoconf
error while loading shared libraries: libaio.so.1:
缺少libaio-devel包yum -y install libaio-devel
添加启动脚本cp /opt/mysql-5.6/support-files/mysql.server /etc/init.d/mysqld
修改配置文件
vi /etc/my.cnf
[mysqld]
basedir = /opt/mysql-5.6
datadir = /data
socket = /tmp/mysql.sock
pid-file =/opt/mysql-5.6/mysql.pid
log-bin=mysql-bin
binlog_format=mixed
character-set-server = utf8
max_connections = 3000
default_storage_engine = InnoDB
innodb_file_per_table = 1
innodb_open_files = 500
innodb_buffer_pool_size = 64M
innodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb_thread_concurrency = 0
innodb_purge_threads = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
innodb_log_file_size = 32M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
interactive_timeout = 28800
wait_timeout = 28800
lower_case_table_names=1
event_scheduler=1
skip-name-resolve=1
[mysqldump]
quick
max_allowed_packet = 32M
启动mysql
/etc/init.d/mysqld start
修改root密码
cd /opt/mysql-5.6
./bin/mysqladmin -u root password '123'
登录mysql
cd /opt/mysql-5.6
./bin/mysql -uroot -p'123'
删除空用户和空密码
delete from mysql.user where user='';
delete from mysql.db where user='';
报错
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
找到mysql.sock文件,然后做个软连接ln -s /opt/mysql-5.6/mysql.sock /tmp/mysql.sock