mysql can't connect error about privilege----not root user
mysql -uuser -ppass db
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
when use root user,It is ok.Obviously, it is privilege problem.
Try to check the mysql.sock privelege. If it is ok, then check its father dir to check.
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/545828/viewspace-908166/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysqldump: Got error: 2002: Can't connect to local MySQL server through.....MySqlGoErrorServer
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- ERROR 2002(HY000):Can't connect to local MySQL socket '/tmp/mysql.sock'ErrorMySql
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- ERROR 2002 (HY000): Can't connect server socket /tmp/mysql.sockErrorServerMySql
- MySQL連線提示Can't connect to local MySQL server through socketMySqlServer
- Can't connect to local MySQL server through socket '/tmp/mysql.sock'MySqlServer
- ERROR 2003 (HY000)Can't connect to MySQL server on '192.168.8.247' (113)ErrorMySqlServer
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)ErrorMySqlServerlocalhost
- 異常:Can't connect to MySQL server (10060)MySqlServer
- 連線MySQL錯誤:Can't connect to MySQL server (10060)MySqlServer
- MySQL 2003 - Can’t connect to MySQL server on (10060)MySqlServer
- Mysql:ERROR 1045 (28000): Access denied for user 'root'@'localhost'MySqlErrorlocalhost
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- 解決Error (1133): Can’t find any matching row in the user tableError
- 解決Can 't connect to local MySQL server through socket '/tmp/mysql.sock '(2) "MySqlServer
- MYSQL解決error: 'Access denied for user 'root'@'localhost' (using password:MySqlErrorlocalhost
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock錯誤MySqlServer
- [jenkins]Can’t connect to window server – not enough permissionsJenkinsServer
- 解決Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'MySqlErrorlocalhost
- MySQL 5.5 原始碼安裝報錯"[ERROR] Can't start server"MySql原始碼ErrorServer
- MySQL 5.5 關閉資料庫報錯"Can't connect to local MySQL server through socket"MySql資料庫Server
- Can't connect to X11 window server usingServer
- MySQL問題記錄--Can't connect to MySQL server on localhost (10061)解決方法MySqlServerlocalhost
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- 【linux】Can't connect to MySQL server on 'XXX' (13)問題解決方式LinuxMySqlServer
- ERROR in Entry module not found Error Can't resolve 'babel' in ' UseErrorBabel
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- ERROR 2002 (HY000): Can't connect server socket /var/run/mysqld/mysqld.sockErrorServerMySql
- MySQL案例-不同尋常的[ERROR]Can't create a new thread (errno 11)MySqlErrorthread
- mysql [ERROR] InnoDB: ./ibdata1 can't be opened in read-write modeMySqlError
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- linux下連線mysql報錯ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysqLinuxMySqlErrorServer
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)解決方法MySqlServer
- ERROR 1045 (28000): Access denied for user 'root'@'localhost'Errorlocalhost