On Mon, Mar 3, 2008 at 2:46 PM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
>
> mysql> select user,host,password from mysql.user;
> +------+----------------------+------------------+
> | user | host | password |
> +------+----------------------+------------------+
> | root | localhost | **************** |
> | root | dev.jss.com | |
> | | dev.jss.com | |
> | | localhost | |
> +------+----------------------+------------------+
> 4 rows in set (0.00 sec)
Okay, I wasn't aware that it's all on the same server. Try this:
USE mysql;
UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE
User='root' AND host='dev.jss.com' LIMIT 1;
FLUSH PRIVILEGES;
--
</Dan>
Daniel P. Brown
Senior Unix Geek
<? while(1) { $me = $mind--; sleep(86400); } ?>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
