安装mysql 出现:Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
来源:互联网 发布:007支票打印软件 编辑:程序博客网 时间:2024/04/30 14:49
本来初始化配置是这样的:
scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
出现了
[root@localhost mysql-5.6.14]# service mysql restart
ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid).
在日志中出现了如下错误:
Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
后来采用了下面的语句就可以了:
scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --ldata=/var/lib/mysql
1 0
- 安装mysql 出现:Fatal error: 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
- 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.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
- Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- [MySQL]Fatalerror: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- MySQL启动失败[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mysql启动(Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist)
- MySQL故障 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- windows下Mysql解决Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- 大数阶乘
- 《白帽子讲web安全》笔记之认证与授权那些事
- Binary Tree Zigzag Level Order Traversal
- ajax异步上传文件
- 工厂模式
- 安装mysql 出现:Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- beorjy244217beorjybeorjy
- 世界杯最野蛮大战,巴西付出惨重代价步入四强
- 按位与、或、异或等运算方法
- POJ 1179 Polygon 区间DP
- [leetcode] Insertion Sort List(python)
- Smali基本语法
- ubuntu12.04配置静态ip
- static C语言