Re: Major MySQL problem

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

You should have acess to your own MYsql DB.

Attn Mysql users, is that a change from 3.23.41 to 3.23.42?


On Tue, Sep 25, 2001 at 09:32:08AM -0600, Virag, Thomas wrote:
> Probably the best would be to delete my "mercury" database and reset all my
> (tvirag) MySQL settings.  
> 
> Do I have to set up my own userid and privileges in MySQL or NetKnow does
> it?????? I have to know this....
> 
> 
> > -----Original Message-----
> > From:       System Administrator a.k.a. The Root of the Problem
> > [SMTP:[EMAIL PROTECTED]]
> > Sent:       Tuesday, September 25, 2001 9:21 AM
> > To: Virag, Thomas
> > Cc: [EMAIL PROTECTED]
> > Subject:    Re: Major MySQL 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

-- 
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