glibc方式安裝mysql

下載安裝包 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