![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
a793408199
这个作者很懒,什么都没留下…
展开
-
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using pa
系统是linux,mysql在进入mysql工具时,有错误提示:# mysql -uroot -pEnter password:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)使用网上介绍的方法修改root用户的密码:# mysqladmin -uroot -p password '...2015-05-27 16:25:25 · 365 阅读 · 0 评论 -
linux导出数据库报错:Can't connect to local MySQL server through socket '/tmp/mysql.sock
在执行mysqldump命令时候报如下错误: [root@localhost ~]# mysqldump -uroot -p -d test> test.sql mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when try...2015-06-03 19:23:26 · 283 阅读 · 0 评论 -
mysql 无lock tables权限 报Access denied for user when using LOCK TABLES
普通用户备份mysql 数据库报错mysql 无lock tables权限 报Access denied for user 'dbuser'@'localhost' to database 'db' when using LOCK TABLES主要原因是该用户无lock tables 该权限,处理办法:1. 给该普通用户赋予lock tables 权限,建议是删除该用户,重新用mysql命令建...原创 2015-06-15 18:19:07 · 870 阅读 · 0 评论