Error:2002:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
来源:互联网 发布:mac有安卓模拟器吗 编辑:程序博客网 时间:2024/05/30 12:29
lz在跑自己的php时突然又抛出这么个东西Error:2002:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock',
我先去看了一下/var/run/mysqld/,发现里面没有mysqld.sock,上网看了一下这个文件是自动生成的文件。
这时先看看mysql的错误日志,日志的可以在my.cnf里面找到,
日志显示说 default-character-set=utf8出错,这个是lz之前改的配置,因为之前的数据库会有中文乱码的情况,
然后网上建议说把 default-character-set=utf8改成character_set_server=utf8,
然后lz把my.cnf 里的default-character-set=utf8改成character_set_server=utf8,保存,然后mysql -uroot -p运行
完美解决问题!!!
1 0
- Error:2002:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
- MySQL ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- 51nod oj 1066 Bash游戏 1067 Bash游戏 V2【巴什博奕】
- 3333333333333
- JDBC处理器和BeanShell取样器的组合应用
- Python Web 9 —— flask中在js中如何解析render_template传递给html的数据
- iOS App上架流程
- Error:2002:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- android 应用自动升级安装并打开新版本应用
- java SSM 框架 多数据源 代码生成器
- 关于 iOS自定义转场动画
- String 转 java.sql.Timestamp 异常详解
- Linux学习目录
- 【BLE-CC2640】CC2640之按键
- Android的位深
- 点击控件 让ListView或者ScrollView 返回到顶部