mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
来源:互联网 发布:sony 淘宝店推荐 编辑:程序博客网 时间:2024/05/21 11:12
一般MYSQL不能正常启动的时候,需要查看下日志文件:
tail /var/log/mysqld.log 显示所有日志
tail -n 20 /var/log/mysqld.log 显示最近的20条日志
根据日志情况,具体分析处理,一般是
mysql 数据库的权限问题:chmod 777 -r /var/lib/mysql;
注意数据库用户:chown -R mysql:mysql /var/lib/mysql
=================================================今天在安装MySQL后,启动时候没有启动成功,查看了下日志报错如下:
---------------------------------------------
[root@localhost local]# less /var/log/mysqld.log
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
mysql_install_db –usrer=mysql datadir=/var/lib/mysql
datadir是我的mysql存放文件目录
MySQL Daemon failed to start.
正在启动 mysqld: [失败]
mysql_install_db
[root@mysql mysqld]# /etc/init.d/mysqld restart
停止 mysqld: [确定]
正在启动 mysqld: [确定]
------------------------
dylan presents
阅读全文
0 0
- 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
- [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数据库报错:[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exi
- 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.user' 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 error: Can't open and lock privilege tables: Table 'mysql.host' 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.host' doesn't exist的解决方法
- Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist的解决方法
- 如何有效管理自己电脑里的文件?
- 周期串 UVa455
- CentOS下使用crontab命令来定时执行任务
- python爬虫学习--下载图片
- IOS 原生网络请求
- mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- arcgis api for javascript创建webscene
- int与byte互相转换,1个int存储4个byte
- 最近公共祖先
- Spring 定时器 定时执行任务
- 打造云上代码交付链_CodePipeline实践分享
- (转载)Android 客户端性能优化(魅族资深工程师毫无保留奉献)
- 第七篇文章:使用Vmware装虚拟机Ubuntu,网络模式采用桥接模式,不安全的连接的问题
- CSS文本超过省略