mysql.hosts database

[Anon]

i logged into the sql server locally, opened up the mysql database, and typed

SELECT * FROM hosts;

just to get a feel for what's in there and how to edit it. however, this returns

ERROR 1146: Table 'mysql.hosts' doesn't exist

help?

[Anon]

first command should be:

use tablename;

then

select * from hosts;

[Anon]

Slight typo.

Should be "use <database name>"

so here either
use mysql

or

\u mysql

Cheers

[mithril]

Nope, that's not gonna get you any further along either🙂 The tablename is actaully "host", not "hosts". You can get a listing of available databases and tables with the following commands:

&nbsp;&nbsp;show datbases;
&nbsp;&nbsp;show tables;

-geoff

[Anon]

ok... so...

shell> mysql -u root
mysql> use mysql;
mysql> SELECT * FROM host;

returns this:
Empty set (0.00 sec)

how do i tell mysql to allow access from a specific IP address?