MYSQL服务启动不了

root@admin ~]# ls /www/server/data
admin.err admin.novalocal.err logBackup mysql mysql-bin.index test

日志是：
2018-04-13 10:57:26 3494 [Note] Plugin 'FEDERATED' is disabled.
/www/server/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
2018-04-13 10:57:26 3494 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2018-04-13 10:57:26 3494 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-04-13 10:57:26 3494 [Note] InnoDB: The InnoDB memory heap is disabled
2018-04-13 10:57:26 3494 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-04-13 10:57:26 3494 [Note] InnoDB: Memory barrier is not used
2018-04-13 10:57:26 3494 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-04-13 10:57:26 3494 [Note] InnoDB: Using Linux native AIO
2018-04-13 10:57:26 3494 [Note] InnoDB: Using CPU crc32 instructions
2018-04-13 10:57:26 3494 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2018-04-13 10:57:26 3494 [Note] InnoDB: Completed initialization of buffer pool
2018-04-13 10:57:26 2b16a0b835c0 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
2018-04-13 10:57:26 3494 [ERROR] InnoDB: os_file_get_status() failed on '/www/server/data/ibdata1'. Can't determine file permissions
2018-04-13 10:57:26 3494 [ERROR] InnoDB: The system tablespace must be writable!
2018-04-13 10:57:26 3494 [ERROR] Plugin 'InnoDB' init function returned error.
2018-04-13 10:57:26 3494 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
/www/server/mysql/bin/mysqld: File '/www/server/data/mysql-slow.log' not found (Errcode: 13 - Permission denied)
2018-04-13 10:57:26 3494 [ERROR] Could not open /www/server/data/mysql-slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
2018-04-13 10:57:26 3494 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-04-13 10:57:26 3494 [ERROR] Aborting

2018-04-13 10:57:26 3494 [Note] Binlog end
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'partition'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_METRICS'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_CMP'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'INNODB_TRX'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'ARCHIVE'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'BLACKHOLE'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'MEMORY'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'MRG_MYISAM'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'MyISAM'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'CSV'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'sha256_password'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'mysql_old_password'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'mysql_native_password'
2018-04-13 10:57:26 3494 [Note] Shutting down plugin 'binlog'
2018-04-13 10:57:26 3494 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

河妖 · 发表于 2018-4-13 11:26:12

私信我ssh信息看看私信完回复一下

ymjhaha · 发表于 2018-4-13 11:33:57

私信完成了

河妖 · 发表于 2018-4-13 12:07:42

可以了莫名其妙mysql不能使用/www/server/data作为存储目录
你再后台重置下root密码就能用了

█菠萝云买2送1活动！12G内存99元	cncsz专注海外服务器+站群	█ 蛮牛云-香港4H4G20M仅25元 █	A4招租，联系qq394030111	【UStat】免费易用的网站分析平台
高防服务器，无视一切流量攻击	【阿里云】宝塔一键部署，低至5折	香港站群金牌Gold 6138大促销	【阿里云】宝塔一键部署，低至5折	OV/EV SSL证书，可当日签发
✅出海专用服务器防封/安全	▶CPS云◀海外大带宽vps服务器	OV/EV SSL证书，可当日签发	恒爱云-香港弹性云8H8G10M 63元	【UStat】免费易用的网站分析平台