[MySQL]Fatalerror: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
来源:互联网 发布:js toggle 控制隐藏 编辑:程序博客网 时间:2024/05/16 06:00
今天在centOS7上安装mysql5.6后, 无法通过mysql -u root登录, 并且提示
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/etc/my.cnf下的日志路径为/var/log/mysqld.log, 打开日志并查看发现提示:
Fatalerror: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist/etc/my.cnf下的数据目录为/var/lib/mysql,去到该目录下发现并没有相关的表文件, 子目录mysql还是空的。
我是这样安装mysql的:
# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm# rpm -ivh mysql-community-release-el7-5.noarch.rpm# yum install mysql-community-server结果安装完之后, 尝试重启服务service mysqld restart一直失败, 之后才发现这个错误提示。艰难查完资料后看到有说到默认安装的数据目录与my.cnf中默认的datadir不一致, 会导致这个问题。
安装mysql时默认指定数据目录为/opt/data, 因此我尝试将my.cnf的相关配置也修改为datadir=/opt/data。
保存退出, 重启mysql后, 可以正常登录, 并且在/opt/data/mysql下可以发现了基本的一些系统表。心情大好。
1 0
- [MySQL]Fatalerror: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- MySQL:Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解决办法
- windows下 Mysql 错误1067 Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- 安装mysql 出现:Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- Mysql linux 安装时遇到 Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 错误解决方案
- windows下 Mysql 错误1067 Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- MySql 错误1067,1045( Can't open and lock privilege tables: Table 'mysql.user' doesn't exist)
- mysql error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 问题的解决方法
- Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist
- Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 问题的解决方法
- MySQL error: Can’t open and lock privilege tables: table doesn’t exist
- Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- 《Java Concurency in Practice》
- 秒杀多线程-经典线程同步之关键段CS
- 顺序表的基本操作
- git的基本使用(二)---git基本指令和操作
- Eclipse配制maven注意事项
- [MySQL]Fatalerror: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- __declspec用法详解
- 《成神之路-基础篇》JVM——Java内存相关(已完结)
- 源码-Oracle数据库管理-第十二章-使用PL/SQL创建Oracle程序-Part 5(PL/SQL语言概览)
- android利用JNI调用C++自定义类
- 移动游戏战斗系统实现方式探讨
- 第九周 oj 一,统计各种字符个数
- Android 如何使控件对齐
- PHP SPL笔记