看板FreeBSD
标 题Re: ports中的MySQL 4发生啥事了?
发信站壹参玖肆 (Wed Jul 28 12:38:44 2004)
转信站ptt!ctu-reader!ctu-peer!news.nctu!news.csie.ncyu!news.ncyu!news.ccu!ne
※ 引述《[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有跑起来,
then,
mysqladmin -u root -p password "xxxxxx"
(不知道有没有记错,用ports安装的好像有预设 ""的密码)
预设密码按enter就ok
--
0000000: 4865 6c6c 6f2c 776f 726c 642e 4974 2069 Hello,world.It i
0000010: 7320 4343 5520 436f 6d6d 2773 2042 4253 s CCU Comm's BBS
0000020: 3a31 3339 342e 7477 6262 732e 6f72 672e :1394.twbbs.org.
0000030: 2f3f 1b3f 2140 2324 6664 6a6b 6c73 6432 /?.b?!@jk?1jk11;
[+] Host :
Adios ,[+] SA :
211.75.241.244