centos 安装mysql 5.6 无法启动 Table 'mysql.plugin' doesn't exist

131203 23:09:36 mysqld_safe Starting mysqld daemon with databases from /mnt/mysqldata
2013-12-03 23:09:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2013-12-03 23:09:36 2563 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
2013-12-03 23:09:36 2563 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2013-12-03 23:09:36 2563 [Note] InnoDB: The InnoDB memory heap is disabled
2013-12-03 23:09:36 2563 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-12-03 23:09:36 2563 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-12-03 23:09:36 2563 [Note] InnoDB: Using CPU crc32 instructions
2013-12-03 23:09:36 2563 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-12-03 23:09:36 2563 [Note] InnoDB: Completed initialization of buffer pool
2013-12-03 23:09:36 2563 [Note] InnoDB: Highest supported file format is Barracuda.
2013-12-03 23:09:36 2563 [Note] InnoDB: Log scan progressed past the checkpoint lsn 49463
2013-12-03 23:09:36 2563 [Note] InnoDB: Database was not shutdown normally!
2013-12-03 23:09:36 2563 [Note] InnoDB: Starting crash recovery.
2013-12-03 23:09:36 2563 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-12-03 23:09:36 2563 [Note] InnoDB: Restoring possible half-written data pages
2013-12-03 23:09:36 2563 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600607
2013-12-03 23:09:36 2563 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
2013-12-03 23:09:36 2563 [Note] InnoDB: 128 rollback segment(s) are active.
2013-12-03 23:09:36 2563 [Note] InnoDB: Waiting for purge to start
2013-12-03 23:09:36 2563 [Note] InnoDB: 5.6.14 started; log sequence number 1600607
2013-12-03 23:09:36 2563 [Note] Server hostname (bind-address): '*'; port: 3306
2013-12-03 23:09:36 2563 [Note] IPv6 is available.
2013-12-03 23:09:36 2563 [Note]   - '::' resolves to '::';
2013-12-03 23:09:36 2563 [Note] Server socket created on IP: '::'.

2013-12-03 23:09:36 2563 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

解决办法：

1. 创建初始文件：

./scripts/mysql_install_db  --user=mysql --ldata=/mnt/mysqldata

2. 删 除重复的配置文件 my.cnf

3. 看官方文档

http://dev.mysql.com/doc/refman/5.6/en/option-files.html

时间： 2024-10-15 19:33:45

centos 安装mysql 5.6 无法启动 Table 'mysql.plugin' doesn't exist的相关文章

CentOS安装MySQL(rpm方式)

    首先你需要下载MySQL安装包,下载地址如下:        http://ftp.ntu.edu.tw/pub/MySQL/Downloads/        这里我以MySQL5.6.26-1.el7版本为例,其中安装包里的x86_64表示是x86架构的64位CPU,其中必须下载的两个安装包为:        MySQL-server-5.6.26-1.el7.x86_64.rpm        MySQL-client-5.6.26-1.el7.x86_64.rpm        

mysql-Linux安装MySQL 使用普通用户启动问题

问题描述 Linux安装MySQL 使用普通用户启动问题 在Centos上安装下MySQL数据,新建了一个mysql用户,想让mysql用户来管理MySQL数据库. 启动MySQL后,发现有连个进程为什么我装的MySQL启动两个服务,还有mysqld_safe是root启动的, mysqld是mysql用户启动,有谁知道怎么回事![图片说明](http://img.ask.csdn.net/upload/201501/27/1422353422_520893.png) 解决方案 mysqld_s

CentOS安装Apache+PHP+MySQL指南

第一步,CentOS系统选择设置就不说了,全部在Linode后台操作就可以了. 一.登录VPS修改主机名 1.登录到服务器 使用终端工具登录到服务器,Linux.Mac系统可以使用终端工具进行SSH连接登录,Windows平台可以使用Putty进行登录. 以Putty为例,只需输入IP地址,选择SSH连接,点击OPEN即可,第一次登录可能会弹出安全警告,确认即可,在终端界面输入管理员账户名和密码即可. 2.修改主机名 默认的主机名是localhost,建议修改掉,不只是为了安全,也方便记忆和识别

CentOS 安装 PHP5.5+Redis+XDebug+Nginx+MySQL全纪录_php实例

启动ssh服务 service sshd start yum -y update 查看centos版本 centos 5 执行: 复制代码 代码如下: rpm -Uvh http://mirror.webtatic.com/yum/el5/latest.rpm centos 6 执行: 复制代码 代码如下: rpm -Uvh http://mirror.webtatic.com/yum/el6/latest.rpm yum安装php 复制代码 代码如下: yum install php55w 

MySQL无法启动：Table mysql.host doesn t exist

提示: Timeout error occurred trying to start MySQL Daemon. Starting MySQL:  [FAILED] 检查了MySQL的日志(cat /var/log/mysqld.log)发现提示一个错误([ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist),如图: 猜测可能是MySQL的默认数据库没正常安装,但卸载

centos 安装mysql数据库碰到的问题笔记

centos中安装mysql很简单如下命令即可 yum install mysql 装好了, 运行mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2).有文章说是权限问题,后来把权限搞成777也不行.说是没启动MYSQL.那就启动吧 [root@localhost mysql]# service mysql start mysql:

CentOS 安装配置 Mysql 数据库。

centos 安装 Mysql 数据库.   安装mysql 命令和mysql服务器.yum install mysql mysql-server     然后设置 mysql 编码     vi /etc/my.cnf 在[mysqld]下添加 default-character-set = utf8   在末尾添加 [mysql] default-character-set = utf8   #然后开始启动mysql   service mysqld start   #设置MySQL服务随系

centos系统编译安装nginx+php环境另加独立mysql教程

  前端(nginx+php)ip:192.168.10.8 后端(独立mysql)ip:192.168.10.5 软件版本:libiconv-1.14.tar.gz mysql-5.1.63.tar.gz php-5.2.17.tar.gz php-5.2.17-fpm-0.5.14.diff.gz php-5.2.17-max-input-vars.patch 1.先在后端安装mysql 在192.168.10.5上只安装mysql.方法可以去看centos编译安装nginx+php-fpm

redhat下安装mysql 5.6.20,解压zip包，查看已经安装过的mysql,卸载rpm安装包，安装mysql服务器端和客户端，修改mysql用户名,登陆mysql，启动关闭mysql

 1 将相关的mysql rpm包上传到redhat上 2  我的电脑是Redhat 6.*版本,所以这里使用上面一个 3  解压zip包 4  安装以下几个rpm MySQL-client-advanced-5.6.20-1.el6.x86_64.rpm MySQL-server-advanced-5.6.20-1.el6.x86_64.rpm 5  查看已经安装过的mysql rpm –aq | grep mysql 结果: mysql-libs-5.1.66-2.el6_3.x86_6