Re: Major MySQL problem

[System Administrator a.k.a. The Root of the Problem]

Quickly what needs to be accomplished?

On Tue, Sep 25, 2001 at 09:00:08AM -0600, Virag, Thomas wrote:
> Hello,
> 
> The recently upgraded MySQL denies any access to my previously perfectly
> working database. I learned that in this version new Privilege/Grant tables
> have to be set up before database and table can be accessed. But I don't
> have access to these Grant Tables. 
> 
> I would like to know how to set up a database and user privileges correctly
> at NetKnow with this version of MySQL?  
> 
> Do I have access to user: "root"  or only to my default: "tvirag" ?
> 
> 
> When I try to access the Grant Tables get the I get the following message: 
> 
> doctor: {36} % mysql -u root mysql
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>  
> Didn't find any fields in table 'columns_priv'
> Didn't find any fields in table 'db'
> Didn't find any fields in table 'func'
> Didn't find any fields in table 'host'
> Didn't find any fields in table 'tables_priv'
> Didn't find any fields in table 'user'
>  
> 
> If I try to add my user id (tvirag) to the grant tables - it is denied:
> GRANT command is not available.
> 
> 
> If I connect as "tvirag" to the database "mercury" (as I used to) I get the
> following message:
> 
> mysql> connect mercury;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>  
> Didn't find any fields in table 'associator'
> Didn't find any fields in table 'audit'
> Didn't find any fields in table 'codes'
> Didn't find any fields in table 'contract'
> Didn't find any fields in table 'hits'
> Didn't find any fields in table 'journal'
> Didn't find any fields in table 'product'
> Didn't find any fields in table 'provider'
> Didn't find any fields in table 'request'
> Didn't find any fields in table 'session'
> Didn't find any fields in table 'users'
> Connection id:    299
> Current database: mercury
> 
> Tables are not accessible, I can't drop and re-create tables, I can't drop
> and re-create database. I can't drop and re-create my own default MySQL user
> id. What can I do?    
> 
> 
> Probably the best would be to delete my "mercury" database and delete and
> reset all my MySQL setting. Could you do this for me?
> 
> 
> Does NetKnow have some - site specific - instruction how to set up a
> database and MySQL user privileges? What are the assumptions and
> restrictions? What NetKnow will set up and what I'm supposed to set up?
> 
> 
> Thank you
> Thomas Virag
> Tel: 412-3659  

-- 
contact:
Dave Yadallee  NetLine 2000  The Edmonton Internet Service Company
[EMAIL PROTECTED]  http://www.nl2k.ab.ca
990-3244

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php