ERROR 2002 HY000 Cant connect to local MySQL server through socket var
-bash: mysql: command not found [root@localhost ~]# cd /home [root@localhost home]# mysql -uroot -pdonglei tlbbdb < DBInit_0_31_0180_table_mysql.sql -bash: mysql: command not found [root@localhost home]# mysql -uroot -pdonglei tlbbdb < DBInit_0_31_0180_data_mysql.sql -bash: mysql: command not found [root@localhost home]# mysql -uroot -pdonglei tlbbdb_stat < tlbbdb_stat.sql -bash: mysql: command ...
by foc - MySQL - 2009-03-26 08:58:42 阅读（5823） 回复（15）
已经赋远程链接用户的权限，结果一直出现： error 2003 (hy000): Can't connect to mysql server on '*.*.*.*' (113)的解决办法： 1.查看配置文件: skip-networking #注释掉 因为它是屏蔽掉一切TCP/IP连接 bind-address = 127.0.0.1 #它和上一个选项是异曲同工，要想远程连接，也得注释掉 2.如果以上工作都做过还是出现： error 2003 (hy000): Can't connect to mysql server on '*.*.*.*' (113)，那就得考虑防火墙的问题了，...
今天服务器遇到了一个很熟悉的问题 输入 #mysql -u root -p error 2002 (hy000):Can't connect to local mysql server 随即上网找寻答案 根据大家提供的方法我逐一尝试 方案1. 1.#ps -A|grep mysql 显示类似： 1829 ? 00:00:00 mysqld_safe 1876 ? 00:00:31 mysqld 2.#kill -9 1829 3.#kill -9 1876 4.#/etc/init.d/mysql restart 5.#mysql -u root -p 他的麻烦解决了,我的还没解决...
error 2002 (hy000): Can't connect to local mysql server through socket '/tmp/mysql.sock' (2) 每次都是这个问题。装了 N次 还是一样。 /tmp/mysql.sock 没有这个 mysql.sock 每次装都没有
如果建表时使用的字符集和mysql默认的字符集不一样,在查询操作时,尤其是有中文字符的情况下,经常会出现如下错误: error 1267 (hy000): Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'like' 解决办法是: 在执行mysql查询语句前,执行"set names gbk",gbk是建表是使用的字符集,请根据实际情况修改! 本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinau...
先把情况说明一下，大家帮帮忙 有一部DB server，称为旧DB，装有 mysql-client-standard-4.1.16-0.rhel3.i386.rpm mysql-devel-standard-4.1.16-0.rhel3.i386.rpm mysql-server-standard-4.1.16-0.rhel3.i386.rpm mysql-shared-standard-4.1.16-0.rhel3.i386.rpm 有另外一部DB server，成为新DB，装有 mysql-client-standard-5.0.22-0.rhel3.i386.rpm mysql-shared-standard-5.0.22-0.rhel3.i386.rpm mysql-devel-standard-5.0.2...
工作日志之-mysql slave Replication error Description： mysql> start slave; error 1201 (hy000): Could not initialize master info structure; more error messages can be found in the mysql error log [root@slave ~]# tail /var/log/mysqld.log 090105 11:53:52 [error] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000013' (relay_log_pos 235) 090105 11:53:52 [error] Could not find target log...
我登录mysql时 输入密码后 提示： error 2003 (hy000): Can't connect to mysql server on 'host' (10060) 找了半天没有解决办法，希望高手帮忙。 版本：5.1.30
今天要写一个函数.但没有办法建提示错误如下: mysql> CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) -> RETURN CONCAT('Hello, ',s,'!'); -> // error 1418 (hy000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) 解决方式:(编缉my.cnf,添加如下)...
电信机房的WEB访问网通机房的两台mysql mysql-5.0 mysql-5.1 1.版本都试过. 2.编译安装,二进制包也试过. 3.skip-name-resove 4.max_packets timeout之类的也试过. error 2013 (hy000): Lost connection to mysql server during query mysql> show processlist; error 2006 (hy000): mysql server has gone away No connection. Trying to reconnect... connection id: 197 Current database: *** NONE *** error 2013 (hy000)...
有人可帮我吗,搞了一天了 欢迎使用 phpMyAdmin 2.8.0.4 错误 mysql 返回： #2002 - 服务器没有响应 (or the local mysql server's socket is not correctly configured) Open new phpMyAdmin window
