centos6.5安装mysql时,提示有依赖,强制安装后,mysql启动不起来,没有/etc/下没有my.cnf,拷贝了my-default.cnf
cp /usr/share/mysql/my-default.cnf /etc/my.cnf my.cnf里手工增加的配置如下: datadir = /var/lib/mysql
tmpdir = /tmp
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
innodb_use_sys_malloc =0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
可是启动service mysqld start,还是报下面的错,请各位帮忙看看。
160827 20:13:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-08-27 20:13:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-08-27 20:13:14 0 [Note] /usr/sbin/mysqld (mysqld 5.6.29) starting as process 4934 ...
2016-08-27 20:13:14 4934 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
2016-08-27 20:13:14 4934 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-08-27 20:13:14 4934 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-08-27 20:13:14 4934 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-27 20:13:14 4934 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-08-27 20:13:14 4934 [Note] InnoDB: Memory barrier is not used
2016-08-27 20:13:14 4934 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-27 20:13:14 4934 [Note] InnoDB: Using Linux native AIO
2016-08-27 20:13:14 4934 [Note] InnoDB: Using CPU crc32 instructions
2016-08-27 20:13:14 4934 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-08-27 20:13:14 4934 [Note] InnoDB: Completed initialization of buffer pool
2016-08-27 20:13:14 4934 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2016-08-27 20:13:15 4934 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2016-08-27 20:13:15 4934 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2016-08-27 20:13:15 4934 [Warning] InnoDB: New log files created, LSN=1601036
2016-08-27 20:13:15 4934 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-27 20:13:15 4934 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-27 20:13:15 4934 [Note] InnoDB: Waiting for purge to start
2016-08-27 20:13:15 4934 [Note] InnoDB: 5.6.29 started; log sequence number 1601548
2016-08-27 20:13:15 4934 [Note] Server hostname (bind-address): '*'; port: 3306
2016-08-27 20:13:15 4934 [Note] IPv6 is not available.
2016-08-27 20:13:15 4934 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2016-08-27 20:13:15 4934 [Note] Server socket created on IP: '0.0.0.0'.
2016-08-27 20:13:15 4934 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
160827 20:13:15 mysqld_safe mysqld from pid file /var/lib/mysql/da1.com.cn.pid ended
|