今天在linux中安装了mysql但在连接时出现can’t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock’提示，下面我总结了一些解决办法和用百度搜索的一些参数文档。
linux 环境下。所有以及用户信息的存放位置可以在（vim /etc/my.cnf）查看[datadir=/usr/local/_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’
(2),解决方法[查看是不是存在该文件。修改相应的路径 vim /etc/my.cnf，查看是不是权限不对.ls -l ].
 代码如下 复制代码
error 2002 (hy000): can’t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock’
(111),解决方法[修改相应的路径 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:
[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.