Unable to find the mysql.host table!!!

Hi Mysql Gurus, We are facing a problem when we start mysql server. It is giving the error, unable to start mysql, Unable to locate the mysql.host table. Can anyone tell us how to resolve this error ? When we tried to reinstall the mysql package it started the mysql server with no errors

Re: Unable to find the mysql.host table!!!

chandrashekar, Tuesday, May 07, 2002, 12:22:43 PM, you wrote: cn We are facing a problem when we start mysql server. It cn is giving the error, unable to start mysql, Unable to locate cn the mysql.host table. Can anyone tell us how to resolve cn this error ? Did you installed grant tables

Re: Auto-normalization, and mysql.host table

the idea. If that will be better than a solution within your application, I don't know. [...] The docs are sparse on using the mysql.host table, See http://www.mysql.com/doc/P/r/Privileges.html, especially the following

Auto-normalization, and mysql.host table

will need access. We've got a half-dozen users each with mysql.user entries to allow them to have the appropriate permissions, and I'd like to allow these users to access from a specific list of IPs (also about half a dozen). The docs are sparse on using the mysql.host table, but it seems that I

Re: Deleted mysql.host Table!

of the tables? SH I'am running MySQL under Linux. SH Thank's for Comment's, Help ... SH Steffen Copy all YOUR databases files to another directory or use mysqldump to your databases when start mysql_install_db for restore mysql.host table

Deleted mysql.host Table!

Hallo, i'm new to mysql. I delete a mysal.host table. Does it means i can't access the rest of my tables in the database? If so, can i rebuild this table or is there another way, to access the rest of the tables? I'am running MySQL under Linux. Thank's for Comment's, Help ... Steffen

mysql.host table

I've been trying to understand how in the world the host table interacts with the db table to provide permissions. None of the documentation seems to help. I've been able to grant database/host specific access to certain users. Unfortunately, the exact same configuration (between user/db/host)

Re: mysql.host table

Did you read chapter 6 in the manual? Jeff Brewer wrote: I've been trying to understand how in the world the host table interacts with the db table to provide permissions. None of the documentation seems to help. I've been able to grant database/host specific access to certain users.

RE: mysql.host table

I've been over Chapter 6 quite a few times, however I don't see any actual example of using the host table in conjunction with the db table. One concrete example, I think, would be enough to get me on the right track, but there just doesn't seem to be any and I certainly can't make heads or

Re: mysql.host table

Then run some GRANT commands, and see what they do to the privilege tables. Chapter 6 goes into quite a bit of detail on this topic. Jeff Brewer wrote: I've been over Chapter 6 quite a few times, however I don't see any actual example of using the host table in conjunction with the db table.

RE: mysql.host table

I've already run quite a few GRANT commands. None of them have done anything to the mysql.host table. I'm pretty familiar with the db and user tables. Chapter 6 barely mentions that the host table exists. The statements it makes about its (the host table) interaction with the db table do

RE: mysql.host table

- From: Jeff Brewer [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 3:31 PM To: Gerald L. Clark Cc: MySQL Mail List Subject: RE: mysql.host table I've already run quite a few GRANT commands. None of them have done anything to the mysql.host table. I'm pretty familiar with the db