看板FreeBSD
标 题Re: ports中的MySQL 4发生啥事了?
发信站OpenFind 网路论坛 (Thu Jul 29 02:18:56 2004)
转信站ptt!ctu-reader!ctu-peer!Spring!news.nctu!newsfeed.media.kyoto-u.ac.jp!
※ 引述《[email protected] (Strategist)》之铭言:
> ==> 在 "法兰斯" <[email protected]> 的文章中提到:
> > mysqladmin -u root -p password "xxxxxx"
> > mysqladmin -u root password "xxxxxx"
> > 这两个意思不一样
> > mysqladmin -u root password "xxxxxx"
> > 设定密码
> > mysqladmin -u root -p password "xxxxxx"
> > 更改密码,而需输入原密码。初始安装者,原密码是 ""
> 这是指出现Enter password:时直接按enter,right?
> 我直接按enter出现下列error message
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> 是在connect时就挂了:~
> 看起来是不给root连
> 请前辈再给点指点吧
> Thanks in advance!
重设 MySQL root 密码:
/usr/local/etc/rc.d/mysql-server.sh stop
safe_mysqld --skip-grant-tables &
mysql -u root -p mysql
update user set password=password('newpassword') where user='root';
flush privileges;
\q
/usr/local/etc/rc.d/mysql-server.sh stop
/usr/local/etc/rc.d/mysql-server.sh start
--
好康讯息!
Openfind 提供免费拨接电话:40508888
帐号:openfind 密码:openfind
--
http://bbs.openfind.com.tw
※来源:192.83.*