看板FreeBSD
标 题Re: ports中的MySQL 4发生啥事了?
发信站交大资科_BBS (Wed Jul 28 14:48:35 2004)
转信站ptt!ctu-reader!ctu-peer!news.nctu!news.cis.nctu!cis_nctu
==> 在 [email protected] (Advanced Perl) 的文章中提到:
> ※ 引述《[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)'
> > 再尝试另一个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'
> > 请有经验的前辈帮一下忙吧...
> sockstat -4l
> 先确定mysql-server有跑起来,
应该有跑起来
mysql mysqld 162 5 tcp4 *:3306 *:*
root sendmail 104 4 tcp4 *:25 *:*
root sendmail 104 6 tcp4 *:587 *:*
root sshd 99 4 tcp4 *:22 *:*
root syslogd 88 5 udp4 *:514 *:*
root dhclient 70 4 udp4 *:68 *:*
> then,
> mysqladmin -u root -p password "xxxxxx"
> (不知道有没有记错,用ports安装的好像有预设 ""的密码)
> 预设密码按enter就ok
我下mysqladmin -u root -p password
出现Enter password:
一按enter，出现下列错误讯息
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
--
* Post by strategist from telnet.hinet.net
* Origin: ★ 交通大学资讯科学系 BBS ★ <bbs.cis.nctu.edu.tw: 140.113.23.3>