On Fri, Sep 05, 2003 at 01:34:01PM -0400, Fortuno, Adam wrote:
> Jerry,
>
> Don't forget that MySQL authenticates an entity, which is based on the user
> name and host. For example, on my MySQL boxes root can only login from the
> localhost. If I attempt to login with root from another host, I am denied
> access.
>
True, by default it does, I ssh'ed into the mysql server and did it that
way. Actualy it apears that now it's not changeing the password. It's
now allowing clients to login but I'm not sure what would cuse it not to
allow root to change the password, I dubble and triple checked my entry
but still nothing happens. Once I login to root I do the following
mysql> use mysql
mysql> UPDATE user SET Password= ('xxxxx')
-> WHERE user='root';
Here is the response I get
Query OK, 0 rows affected (0.01 sec)
Rows matched: 4 Changed: 0 Warnings: 0
Not sure why nothing is changed? Anyideas. Might root not have the
privlage? if so, how might I be able to change the password?
--
Jerry M. Howell II
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
