Installing MySQL 5.7 On Ubuntu Using Generic Binaries

Installing MySQL 5.7 On Ubuntu Using Generic Binaries

1、安装依赖

apt-get install libaio1

2、获取软件包

wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz

3、创建mysql User 和 Group

groupadd mysql
useradd -r -g mysql -s /bin/false mysql

4、解压程序包

mkdir -pv  /data/apps/
tar -xf /root/mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz  -C /data/apps/

5、创建软链

cd /data/apps/
ln -sv mysql-5.7.9-linux-glibc2.5-x86_64 mysql

6、准备数据目录

mkdir /data/apps/mysql/{data,logs}

7、初始化数据目录

cd /data/apps/mysql
mkdir mysql-files
chown mysql:mysql mysql-files data logs
chmod 750 mysql-files

bin/mysqld --initialize --user=mysql --basedir=/data/apps/mysql --datadir=/data/apps/mysql/data 
  ......
2023-04-11T02:43:44.783949Z 1 [Note] A temporary password is generated for root@localhost: bR8oqd*Qwdd!

bin/mysql_ssl_rsa_setup --datadir=/data/apps/mysql/data

8、提供相关文件

# cp support-files/my-default.cnf  /etc/my.cnf
cat  > /etc/my.cnf <<EOF
[client]
port = 3306
socket = /data/apps/mysql/data/mysql.sock

[mysqld]
character_set_server=utf8mb4
skip_name_resolve=1
innodb_file_per_table=1
max_connections=20000
basedir = /data/apps/mysql/
datadir = /data/apps/mysql/data
port = 3306
socket = /data/apps/mysql/data/mysql.sock
log-error=/data/apps/mysql/logs/mysqld.log
pid-file=/data/apps/mysql/data/mysqld.pid
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
EOF

cp support-files/mysql.server /etc/init.d/mysqld

9、启动服务

/etc/init.d/mysqld start 

10、连接数据库报错解决

mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

ln -sv /usr/lib/x86_64-linux-gnu/libncurses.so.6.2 /usr/lib/x86_64-linux-gnu/libncurses.so.5

11、修改密码

mysql -uroot -p'bR8oqd*Qwdd!' -S /data/apps/mysql/data/mysql.sock 
alter user 'root'@'localhost' identified by 'root123';
flush privileges;

mysql -uroot -p'root123' -S /data/apps/mysql/data/mysql.sock  -e 'show databases;'
mysql: [Warning] Using a password on the command line interface can be insecure.
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+