mysql - Rails bitnami，MYSQL无法启动

Question

所以我在 AWS 上设置了 bitnami ruby​​

然后我用它来设置 mysql 5.6 https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-14-04

当我使用“service mysql status”进行测试时，Mysql 没有启动

它一直给我这个“mysql 停止/等待”

所以我尝试了这个命令“sudo service mysql start”，它一直在运行但没有完成

当我运行“mysqladmin -p -u root version”时它确实返回了我

/opt/bitnami/mysql/bin/mysqladmin.bin  Ver 8.42 Distrib 5.6.35, for linux-glibc2.5 on x86_64
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version          5.6.35
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /opt/bitnami/mysql/tmp/mysql.sock
Uptime:                 14 min 59 sec

Threads: 1  Questions: 2  Slow queries: 0  Opens: 67  Flush tables: 1  Open tables: 60  Queries per second avg: 0.002

这对我来说似乎很正常，但是检查服务 mysql 状态仍然显示 mysql 停止/等待

我听说运行 mysqld 会给我解决问题的线索，但我在这里迷路了....

bitnami@ip-172-31-20-165:~/Projects/server-master$ mysqld
2017-03-08 16:08:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-03-08 16:08:24 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-03-08 16:08:24 0 [Note] /opt/bitnami/mysql/bin/mysqld.bin (mysqld 5.6.35) starting as process 26956 ...
2017-03-08 16:08:24 26956 [Warning] Can't create test file /opt/bitnami/mysql/data/ip-172-31-20-165.lower-test
2017-03-08 16:08:24 26956 [Warning] Can't create test file /opt/bitnami/mysql/data/ip-172-31-20-165.lower-test
2017-03-08 16:08:24 26956 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2017-03-08 16:08:24 26956 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)

2017-03-08 16:08:24 26956 [Note] Plugin 'FEDERATED' is disabled.
/opt/bitnami/mysql/bin/mysqld.bin: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
2017-03-08 16:08:24 26956 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-03-08 16:08:24 26956 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-03-08 16:08:24 26956 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-08 16:08:24 26956 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-08 16:08:24 26956 [Note] InnoDB: Memory barrier is not used
2017-03-08 16:08:24 26956 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-08 16:08:24 26956 [Note] InnoDB: Using Linux native AIO
2017-03-08 16:08:24 26956 [Note] InnoDB: Using CPU crc32 instructions
2017-03-08 16:08:24 26956 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-03-08 16:08:24 26956 [Note] InnoDB: Completed initialization of buffer pool
2017-03-08 16:08:24 26956 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
2017-03-08 16:08:24 26956 [ERROR] InnoDB: The system tablespace must be writable!
2017-03-08 16:08:24 26956 [ERROR] Plugin 'InnoDB' init function returned error.
2017-03-08 16:08:24 26956 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-03-08 16:08:25 26956 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-03-08 16:08:25 26956 [ERROR] Aborting

2017-03-08 16:08:25 26956 [Note] Binlog end
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'partition'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'ARCHIVE'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'BLACKHOLE'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_METRICS'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_CMP'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'INNODB_TRX'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'CSV'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'MEMORY'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'MyISAM'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'MRG_MYISAM'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'sha256_password'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'mysql_old_password'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'mysql_native_password'
2017-03-08 16:08:25 26956 [Note] Shutting down plugin 'binlog'
2017-03-08 16:08:25 26956 [Note] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete

当然，我测试了在 localhost:3000 上运行 rails，这当然给出了

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

在这件事上需要帮助。

2017 年 3 月 9 日更新

我在没有安装 mysql mumbo jumbo 的情况下重新做了所有的事情。仍然得到“无法通过套接字‘/tmp/mysql.sock’ (2) 连接到本地 MySQL 服务器”

下面我又运行了mysqld

bitnami@ip-172-31-26-217:~/Projects/finowledge_server-master$ mysqld
2017-03-09 15:43:28 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-03-09 15:43:28 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-03-09 15:43:28 0 [Note] /opt/bitnami/mysql/bin/mysqld.bin (mysqld 5.6.35) starting as process 10181 ...
2017-03-09 15:43:28 10181 [Warning] Can't create test file /opt/bitnami/mysql/data/ip-172-31-26-217.lower-test
2017-03-09 15:43:28 10181 [Warning] Can't create test file /opt/bitnami/mysql/data/ip-172-31-26-217.lower-test
2017-03-09 15:43:28 10181 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2017-03-09 15:43:28 10181 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)

2017-03-09 15:43:28 10181 [Note] Plugin 'FEDERATED' is disabled.
/opt/bitnami/mysql/bin/mysqld.bin: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
2017-03-09 15:43:28 10181 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-03-09 15:43:28 10181 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-03-09 15:43:28 10181 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-09 15:43:28 10181 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-09 15:43:28 10181 [Note] InnoDB: Memory barrier is not used
2017-03-09 15:43:28 10181 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-09 15:43:28 10181 [Note] InnoDB: Using Linux native AIO
2017-03-09 15:43:28 10181 [Note] InnoDB: Using CPU crc32 instructions
2017-03-09 15:43:28 10181 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-03-09 15:43:28 10181 [Note] InnoDB: Completed initialization of buffer pool
2017-03-09 15:43:28 10181 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
2017-03-09 15:43:28 10181 [ERROR] InnoDB: The system tablespace must be writable!
2017-03-09 15:43:28 10181 [ERROR] Plugin 'InnoDB' init function returned error.
2017-03-09 15:43:28 10181 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-03-09 15:43:28 10181 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-03-09 15:43:28 10181 [ERROR] Aborting

2017-03-09 15:43:28 10181 [Note] Binlog end
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'partition'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'ARCHIVE'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'BLACKHOLE'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_METRICS'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_CMP'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'INNODB_TRX'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'CSV'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'MEMORY'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'MyISAM'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'MRG_MYISAM'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'sha256_password'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'mysql_old_password'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'mysql_native_password'
2017-03-09 15:43:28 10181 [Note] Shutting down plugin 'binlog'
2017-03-09 15:43:28 10181 [Note] /opt/bitnami/mysql/bin/mysqld.bin: Shutdown complete

Answer 1

这里是 Bitnami 开发者。

您不应该遵循这些指南，因为它们会给您指明错误的方向。在 Bitnami Ruby 堆栈中，mysql 和 postgresql 是默认安装的。要停止、启动或查看服务的状态，您应该使用位于 /opt/bitnami/ 中的 ctlscript.sh。

bitnami@ip-172-31-45-25:/opt/bitnami$ sudo ./ctlscript.sh help
usage: ./ctlscript.sh help
       ./ctlscript.sh (start|stop|restart|status)
       ./ctlscript.sh (start|stop|restart|status) mysql
       ./ctlscript.sh (start|stop|restart|status) postgresql
       ./ctlscript.sh (start|stop|restart|status) memcached
       ./ctlscript.sh (start|stop|restart|status) php-fpm
       ./ctlscript.sh (start|stop|restart|status) apache
       ./ctlscript.sh (start|stop|restart|status) nginx
       ./ctlscript.sh (start|stop|restart|status) redis

help       - this screen
start      - start the service(s)
stop       - stop  the service(s)
restart    - restart or start the service(s)
status     - show the status of the service(s)

并且，如果您在 Bitnami Ruby 堆栈中执行此操作:

bitnami@ip-172-31-45-25:/opt/bitnami$ sudo ./ctlscript.sh status
Nginx already running
php-fpm already running
apache already running
redis already running
mysql already running
postgresql already running
Memcached already running

可以看到mysql运行正常

这里有我们的 mysql 指南，我强烈建议您阅读它们: https://docs.bitnami.com/aws/components/mysql/

另外，这里有 aws 中的常见问题解答: https://docs.bitnami.com/aws/faq/

最好的问候。