MySQL在Linux上的问题

afoskoo 2004-12-07 10:27:51

Redhat 9
MySQL-Server 4.17 - max

mysql -u root
在linux上可以登录,并正常使用mysql(root是有密码的)

但在phpMyAdmin上就提示以下错误.
#2002 - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (13)
不知是什么原因
****已经 ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock****

...全文

86 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

shimch 2004-12-09

打赏
举报

我试试

sdpong 2004-12-07

打赏
举报

啊啊，呵呵，用mywql4.17要装php5.0的用最新的php_mysql.so，然后还要进行以下的操作才可...
1,shell> mysqld
shell> mysqld --default-character-set=latin1
shell> mysqld --default-character-set=latin1 \
--default-collation=latin1_swedish_ci
(或在安装时shell> ./configure --with-charset=latin1

Or:

shell> ./configure --with-charset=latin1 \
--with-collation=latin1_german1_ci

)
2
如果没有以上的指定在创建数据库时用如下指定字符集

CREATE DATABASE db_name
[[DEFAULT] CHARACTER SET charset_name]
[[DEFAULT] COLLATE collation_name]

ALTER DATABASE db_name
[[DEFAULT] CHARACTER SET charset_name]
[[DEFAULT] COLLATE collation_name]

Example:

CREATE DATABASE db_name
DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

3，操作以前的数据库如出现Client does not support authentication protocol requested
进行以下操作(用mysql -h -u -p登陆)
SET PASSWORD FOR '用户名'@'主机' = OLD_PASSWORD('newpwd');
UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = '主机' AND User = '用户';
FLUSH PRIVILEGES;

afoskoo 2004-12-07