[NTLUG:Discuss] MySQL question

[Brian Silvers]

No, that information is correct.

Do a select on your host table as well.

> On Friday 26 July 2002 02:41 pm, you wrote:
>> Try this:
>> $ mysql -u root -p mysql
>> msyql> select User, Password, Host from user;
>
> Did all that and get the following:
> +--------+------------------+-----------------------+
> | user   | password         | host                  |
> +--------+------------------+-----------------------+
> | root   | 7705896139c3146a | localhost             |
> | root   |                  | localhost.localdomain |
> |        |                  | localhost             |
> |        |                  | localhost.localdomain |
> | neil   |                  |                       |
> | neil   | 7705896139c3146a | %                     |
> +--------+------------------+-----------------------+
>
> So, I have more than one root and more than one neil. Is there a way to
>  return the mysql database to default install state?
>
> TIA
> Bobby
>
> _______________________________________________
> http://www.ntlug.org/mailman/listinfo/discuss


Brian Silvers          bsilvers at x-net.com
X-Net Web Systems      http://www.x-net.com