mysqlCan’tconnecttolocalMySQLserverthroughsocket‘

今天在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是你的存放路径。

(2),解决方法[查看是不是存在该文件。修改相应的路径 vim /etc/my.cnf，查看是不是权限不对.ls -l ].

(111),解决方法[修改相应的路径 vim /etc/my.cnf]

添加下面这段:

mysql 数据表使用中,错误提示:”martin” is marked as crashed and should be repaired
解决方法:

进入mysql的data目录,在命令行执行:myisamchk -c -r martin.MYI

mysql允许远程连接方法:在添加mysql用户的时候host选现修改成”%”就可以了。
以后遇到的mysql问题会一并添加上来.

网络上其它 方法

问题终于解决：

方法： 修改/etc/my.conf:

发现依旧如此，运行/etc/init.d/mysql start

报错：Starting MySQLCouldn't find MySQL manager or server
是mysqld服务没启，运行

问题解决了

官网的一点解决办法

if you are new to installing mysql server you might probably face this error quite often if you type mysql in the shell prompt.

To fix:

First start the mysql daemon, then type mysql

Bingo! It worked for me!

To update mysql root password

To add a new user to mysql

1. First login as root then create a database ‘demo’

> mysql -u root -p

After that create a new user named ‘guest’ with password ‘guest’ with all previleges assigned to demo database;

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.