安装Mysql中报的错
准备用Mycat玩会,于是准备安装Mysql数据库,结果报错了。
FATAL ERROR: please install the following Perl modules before executing ./scripts/mysql_install_db:
解决:
[root@node2 scripts]# yum -y install autoconf Loaded plugins: fastestmirror Determining fastest mirrors * elrepo: mirrors.tuna.tsinghua.edu.cn aliyun-docker-ce | 3.5 kB 00:00:00 base | 3.6 kB 00:00:00 elrepo | 2.9 kB 00:00:00 epel | 5.3 kB 00:00:00 extras | 2.9 kB 00:00:00 updates | 2.9 kB 00:00:00 (1/2): epel/x86_64/updateinfo | 1.0 MB 00:00:00 (2/2): epel/x86_64/primary_db | 6.9 MB 00:00:00 Resolving Dependencies --> Running transaction check ---> Package autoconf.noarch 0:2.69-11.el7 will be installed --> Processing Dependency: perl(Data::Dumper) for package: autoconf-2.69-11.el7.noarch --> Running transaction check ---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved =============================================================================================================================================================== Package Arch Version Repository Size =============================================================================================================================================================== Installing: autoconf noarch 2.69-11.el7 base 701 k Installing for dependencies: perl-Data-Dumper x86_64 2.145-3.el7 base 47 k Transaction Summary =============================================================================================================================================================== Install 1 Package (+1 Dependent package) Total download size: 748 k Installed size: 2.3 M Downloading packages: (1/2): perl-Data-Dumper-2.145-3.el7.x86_64.rpm | 47 kB 00:00:00 (2/2): autoconf-2.69-11.el7.noarch.rpm | 701 kB 00:00:00 --------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 6.7 MB/s | 748 kB 00:00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : perl-Data-Dumper-2.145-3.el7.x86_64 1/2 Installing : autoconf-2.69-11.el7.noarch 2/2 Verifying : perl-Data-Dumper-2.145-3.el7.x86_64 1/2 Verifying : autoconf-2.69-11.el7.noarch 2/2 Installed: autoconf.noarch 0:2.69-11.el7 Dependency Installed: perl-Data-Dumper.x86_64 0:2.145-3.el7 Complete! [root@node2 scripts]# ll
Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
[root@node2 mysql-5.6.33-linux-glibc2.5-x86_64]# yum install -y libaio libaio-devel Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * elrepo: mirrors.tuna.tsinghua.edu.cn Resolving Dependencies --> Running transaction check ---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed ---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved =============================================================================================================================================================== Package Arch Version Repository Size =============================================================================================================================================================== Installing: libaio x86_64 0.3.109-13.el7 base 24 k libaio-devel x86_64 0.3.109-13.el7 base 13 k Transaction Summary =============================================================================================================================================================== Install 2 Packages Total download size: 37 k Installed size: 46 k Downloading packages: (1/2): libaio-0.3.109-13.el7.x86_64.rpm | 24 kB 00:00:00 (2/2): libaio-devel-0.3.109-13.el7.x86_64.rpm | 13 kB 00:00:00 --------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 434 kB/s | 37 kB 00:00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : libaio-0.3.109-13.el7.x86_64 1/2 Installing : libaio-devel-0.3.109-13.el7.x86_64 2/2 Verifying : libaio-0.3.109-13.el7.x86_64 1/2 Verifying : libaio-devel-0.3.109-13.el7.x86_64 2/2 Installed: libaio.x86_64 0:0.3.109-13.el7 libaio-devel.x86_64 0:0.3.109-13.el7 Complete! [root@node2 mysql-5.6.33-linux-glibc2.5-x86_64]# ./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql Installing MySQL system tables...2020-01-10 15:19:28 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timest amp server option (see documentation for more details). 2020-01-10 15:19:28 0 [Note] ./bin/mysqld (mysqld 5.6.33) starting as process 32099 ... 2020-01-10 15:19:28 32099 [Note] InnoDB: Using atomics to ref count buffer pool pages 2020-01-10 15:19:28 32099 [Note] InnoDB: The InnoDB memory heap is disabled 2020-01-10 15:19:28 32099 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-01-10 15:19:28 32099 [Note] InnoDB: Memory barrier is not used