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