Home > database >  Centos 7 with RPM installation mysql5.7.23-1. El7. X86_64, root can only see two databases
Centos 7 with RPM installation mysql5.7.23-1. El7. X86_64, root can only see two databases

Time:09-19

Can only see the test and information_schema two databases,
Baidu's method: use the mysqld_safe - skip - grant - table and prompt command cannot find
Use the find/-name mysqld_safe, didn't find the file
Configuration file is
Datadir=/var/lib/mysql
Socket=/var/lib/mysql/mysql. The sock
-- - the links=0
Skip - grant - tables

# Disabling -- - the links is it to prevent assorted security risks
-- - the links=0
Sql_mode=STRICT_TRANS_TABLES NO_ZERO_IN_DATE, NO_ZERO_DATE ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION

The log - error=/var/log/mysqld. Log
Pid - file=/var/run/mysqld/mysqld. Pid
! Includedir/etc/my. CNF. D

Baidu a lot, make more and more disorderly, but not a method useful, to ask you a great god
  • Related