是RedHat Linux 6.1 cron是crond进程吗?如是,我已经将它关掉了,但还是不行,错误依旧。
再create 這個文件 /var/lib/mysql/mysql.sock
我执行了一次mysql_install_db后,就再也不行执行它了,不知为何?是否有方法可以使它再执行一次? 另外,当我更改了linux服务器的名字后,它提示我:Warning: MySQL Connection Failed: Unknown MySQL Server Host 'webserver ' (0) in config.php3 on line 2 Unable to connect to MySQL MySQL是如何识别服务器名的?
你在user表中加入让所有的机器和用户名都可以访问mysql试试。 就是这条纪录,你那儿是内网吧? insert into user values("%","%",password(''),"Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y"); 你的mysql启动了没有?
是内部网,我的MySQL已经启动,因我在本机可以执行mysql,并打开mysql数据库,作了: insert into user values("%","%",password(''),"Y","Y","Y","Y","Y","Y","Y","Y", "Y","Y","Y","Y","Y","Y"); 这个操作,从远程打开phpMyAdmin时还是有下面的错误:Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in lib.inc.php3 on line 119我不是很清楚这种错误是由什么产生的?
email me: [email protected]
cron是crond进程吗?如是,我已经将它关掉了,但还是不行,错误依旧。
另外,当我更改了linux服务器的名字后,它提示我:Warning: MySQL Connection Failed: Unknown MySQL Server Host 'webserver ' (0) in config.php3 on line 2
Unable to connect to MySQL MySQL是如何识别服务器名的?
你的phpMyAdmin是和mysql安装在同一台机器上的吗?
如果是的话,你看在linux上能不能ping 能localhost,如果不行的话在/etc/hosts下加入下面一行
127.0.0.1 localhost localhost.localdomain
并用#mysql mysql打开mysql库
select * from user;
查看有没有localhost这条记录,如果没有插入一条。如果不在同一台机器的话,就要在user表中加入别的机器名字和用户名,权限等
127.0.0.1 localhost localhost.localdomain
192.100.106.218 webserver.maindomain webserver
192.000.106.218 localhost.localdomain webservermysql数据表里也有 webserver 及 localhost 的记录。但我执行phpMyAdmin错误依旧。另:
我用的是HP LH3000 服务器装的RedHat 6.1,这服务器本身不带 Linux 的设备驱动程序,都是利用Linux 自己检测到的设备来安装的。
就是这条纪录,你那儿是内网吧?
insert into user values("%","%",password(''),"Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y","Y"); 你的mysql启动了没有?
insert into user values("%","%",password(''),"Y","Y","Y","Y","Y","Y","Y","Y",
"Y","Y","Y","Y","Y","Y"); 这个操作,从远程打开phpMyAdmin时还是有下面的错误:Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in lib.inc.php3 on line 119我不是很清楚这种错误是由什么产生的?
访问http://168.168.18.11:81/etechbase/advsearch.php将您的问题输入查询内容框,选择不同的精确程度,即可以找到你所需要的答案。效果还是可以的。
我的机器是 HP Server LH3000,它的管理工具占住了硬盘的前32MB的一个小分区,主要用于记录机器硬件的事件,如:电脑重启,硬件错误等,当我把这些事件清除后,我的 MySQL 不管用什么用户,只要是加了口令的,都无法连接MySQL了。
(检查一下mysql.user)