看板FreeBSD
标 题Re: ports中的MySQL 4发生啥事了?
发信站交大资科_BBS (Wed Jul 28 14:50:21 2004)
转信站ptt!ctu-reader!ctu-peer!news.nctu!news.cis.nctu!cis_nctu
==> 在 [email protected] (Deferno) 的文章中提到:
> ※ 引述《[email protected] (Strategist)》之铭言：
> > 今天突然被老板告知他想测一下MySQL
> > 我就装了台FreeBSD 4.10 Stable
> > 用CVSup update了source tree跟ports tree
> > 进/usr/ports/databases/mysql40-server/
> > 成功安装了MySQL
> > 可是再来问题来了，依照MySQL安装完时的提示要更改root password
> > 却被禁止连线!!??
> > 我依照说明下了这行command
> > /usr/local/bin/mysqladmin -u root password '1A2b3C'
> > 却出现下列错误讯息
> > /usr/local/bin/mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> 先用没密码登入吧
> 刚装好不是都预设没有密码吗@@?(Using password: NO)<==很明白了
我也是记得刚装好是没有password的
可是一下"mysqladmin -u root -p password"
却出现"Enter password:"
按enter，出现下列Error message :<
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> > 再尝试另一个command
> > /usr/local/bin/mysqladmin -u root -h FreeBSD.haha.net password '1A2b3C'
> > 也出现下列另一个错误讯息...
> > /usr/local/bin/mysqladmin: connect to server at 'FreeBSD.haha.net' failed
> > error: 'Host 'FreeBSD' is not allowed to connect to this MySQL server'
> > 请有经验的前辈帮一下忙吧...
--
* Post by strategist from telnet.hinet.net
* Origin: ★ 交通大学资讯科学系 BBS ★ <bbs.cis.nctu.edu.tw: 140.113.23.3>