001
cripts/mysql_install_db –no-defaults –datadir=/mysql/my_cluster/mysqld_data/
FATAL ERROR: please install the following Perl modules before executing scripts/mysql_install_db:
Data::Dumper
yum install perl-Data-Dumper.x86_64
002
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect…
set global max_allowed_packet=100M
将此值设置大些
003
[root@localhost ~]# rpm -ivh mysql-community-server-5.7.21-1.el6.x86_64.rpm
warning: mysql-community-server-5.7.21-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
libsasl2.so.2()(64bit) is needed by mysql-community-server-5.7.21-1.el6.x86_64
rpm -ivh https://rpmfind.net/linux/Mandriva/devel/cooker/x86_64/media/main/release/lib64sasl2-2.1.25-4-mdv2012.0.x86_64.rpm
004
[root@iZm5e3vnh3gtu6fzpvc2ooZ ~]# systemctl restart mysql
Job for mysql.service failed because the control process exited with error code. See “systemctl status mysql.service” and “journalctl -xe” for details.
[root@iZm5e3vnh3gtu6fzpvc2ooZ ~]# more /var/lib/mysql/iZm5e3vnh3gtu6fzpvc2ooZ.err
2018-03-11 16:21:02 4452 [Note] Plugin ‘FEDERATED’ is disabled.
/usr/sbin/mysqld: Can’t find file: ‘./mysql/plugin.frm’ (errno: 13 – Permission denied)
2018-03-11 16:21:02 4452 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-03-11 16:21:02 4452 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-03-11 16:21:02 4452 [Note] InnoDB: The InnoDB memory heap is disabled
2018-03-11 16:21:02 4452 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-03-11 16:21:02 4452 [Note] InnoDB: Memory barrier is not used
2018-03-11 16:21:02 4452 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-03-11 16:21:02 4452 [Note] InnoDB: Using Linux native AIO
2018-03-11 16:21:02 4452 [Note] InnoDB: Using CPU crc32 instructions
2018-03-11 16:21:02 4452 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-03-11 16:21:02 4452 [Note] InnoDB: Completed initialization of buffer pool
2018-03-11 16:21:02 4452 [ERROR] InnoDB: ./ibdata1 can’t be opened in read-write mode
2018-03-11 16:21:02 4452 [ERROR] InnoDB: The system tablespace must be writable!
2018-03-11 16:21:02 4452 [ERROR] Plugin ‘InnoDB’ init function returned error.
2018-03-11 16:21:02 4452 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2018-03-11 16:21:02 4452 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-03-11 16:21:02 4452 [ERROR] Aborting
解决办法solution:
chown mysql.mysql -R /var/lib/mysql
……
阅读全文