mysql Can’t connect to local MySQL server through socket ‘/var/lib/mysql/
发布:smiling 来源: PHP粉丝网 添加日期:2014-10-14 14:11:51 浏览: 评论:0
今天在linux中安装了mysql但在连接时出现Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’提示,下面我总结了一些解决办法和用百度搜索的一些参数文档。
linux 环境下,所有数据库以及用户信息的存放位置可以在(vim /etc/my.cnf)查看[datadir=/usr/local/mysql_data ].
读取不到数据库信息(原因:移动datadir过程中权限也改变了[chown mysql:mysql -R datadir]) ,datadir是你的存放路径,代码如下:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
解决方法[查看是不是存在该文件,修改相应的路径 vim /etc/my.cnf,查看是不是权限不对.ls -l ].代码如下:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
解决方法[修改相应的路径 vim /etc/my.cnf],添加下面这段代码:
- port = 3306
- socket = /var/lib/mysql_data/mysql.sock
mysql 数据表使用中,错误提示:”martin” is marked as crashed and should be repaired
解决方法:
进入mysql的data目录,在命令行执行:myisamchk -c -r martin.MYI,mysql允许远程连接方法:在添加mysql用户的时候host选现修改成”%”就可以了,以后遇到的mysql问题会一并添加上来.
网络上其它方法:修改/etc/my.conf,代码如下:
- [mysqld]
- datadir=/usr/local/mysql/data
- socket=/var/lib/mysql/mysql.sock
- [mysql.server]
- user=mysql
- basedir=/usr/local/mysql
- If there is not currently a section called [client], add one at the bottom of the file and copy the socket= line under the [mysqld] section such as:
- --phpfensi.com
- [client]
- socket=/var/lib/mysql/mysql.sock
发现依旧如此,运行/etc/init.d/mysql start.
报错:Starting MySQLCouldn't find MySQL manager or server 是mysqld服务没启,运行如下代码:
/usr/local/mysql/bin/mysqld_safe
问题解决了.
官网的一点解决办法:
if you are new to installing mysql server you might probably face this error quite often if you type mysql in the shell prompt.代码如下:
- > mysql
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
To fix:First start the mysql daemon, then type mysql,代码如下:
- > /etc/init.d/mysqld start
- > mysql
Bingo! It worked for me!To update mysql root password,代码如下:
- mysql> USE mysql;
- mysql> UPDATE user SET Password=PASSWORD('new-password') WHERE user='root';
- mysql> FLUSH PRIVILEGES;
To add a new user to mysql.
1. First login as root then create a database ‘demo’
> mysql -u root -p,代码如下:
- Enter password:
- mysql> create database demo;
After that create a new user named ‘guest’ with password ‘guest’ with all previleges assigned to demo database;,代码如下:
- mysql> GRANT ALL PRIVILEGES ON mytest.* TO 'guest'@'localhost' IDENTIFIED BY 'guest' WITH GRANT OPTION;
Then exit mysql and connect through username guest;That should work!
Note:This could happen, if you run out of your disk space. Check your disk space.
Tags: Cant connect local MySQL server through
- 上一篇:mysql数据库导入导出代码
- 下一篇:mysql explain 用法详解
相关文章
- ·MySQL报错1042-Can t get hostname for your address(2014-10-10)
- ·MySQL报错1042-Can't get hostname for your address(2014-10-10)
- ·mysql恢复数据数据出现Variable sql_mode cant 解决方法(2014-10-10)
- ·MYSQL提示 max_open_files: 2048 max_connections: 800 table_cache: 619(2014-09-23)
- ·Mysql出现Can’t connect to MySQL server on ‘localhost’ (10061)问题(2014-09-23)
- ·Mysql "Too many connections"错误解决办法(2014-09-24)
- ·解决MySql Error:Host is blocked because of many connection errors问题(2014-09-24)
- ·Can t connect to mysql server on localhost (10061) 错误(2014-09-24)
- ·Warning:mysql_connect() [function.mysql-connect]: [2002] 由于目标机器.(2014-09-25)
- ·ERROR 1040: Too many connections问题解决办法(2014-09-28)
- ·Cant Connect MySQL Server(localhost:3306)问题(2014-09-28)
- ·MySql Lost connection to MySQL server during query问题(2014-09-28)
- ·mysql ERROR 1040: Too many connections(2014-10-02)
- ·MySQL连接too many connection错误并且启动时间特别长(2014-10-04)
- ·Mysql “Too many connections” 的解决方法(2014-10-04)
- ·启动MYSQL提示:Can’t connect to MySQL through socket ‘/tmp/mysql.sock(2014-10-08)
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)