Re: Hostname change

[Paul McArdle]

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-----------------+
6 rows in set (0.01 sec)

mysql> select host, user from user;
+-----------------------+------+
| host | user |
+-----------------------+------+
| localhost | |
| localhost | root |
| localhost.localdomain | |
| localhost.localdomain | root |
+-----------------------+------+
4 rows in set (0.03 sec)

#carerfull now!
mysql> update user set host = 'whatever' where user = 'whatever'