Re: Access denied on use mysql;

2002-03-22 Thread alan4100

mysql

Brian,

Fine...lots of typing.:)



Re: Access denied on use mysql;

2002-03-22 Thread Brian Reichert

On Thu, Mar 21, 2002 at 08:13:16PM -0500, alan4100 wrote:
> mysql
> 
> Hi Colin,
> 
> I wish I can be able to live chat with you, but because of my hearing impaired...it 
>would not be possible..But what is the real problem?  A few days ago I got assistance 
> from others  on my Mysql problem. It has been fixed and everything works fine.

I _think_, when he said 'live chat', that he meant an IRC channel.
'Internet Relay Chat'.  Just lots of typing. :)

-- 
Brian 'you Bastard' Reichert<[EMAIL PROTECTED]>
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
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




Re: Access denied on use mysql;

2002-03-22 Thread Victoria Reznichenko

Kathy,
Thursday, March 21, 2002, 7:48:10 PM, you wrote:

KR> I just gave up, everything that I tried did not work. 

KR> I killed mysql and then
KR> started with safe_mysql --skip-grant-tables 
KR> then I was able to connect to mysql without an error. 
KR> But when I tried to 
KR> Grant all on mysql.* to root@localhost identified by "password";
KR> it gave me the message Unknown Command.

Kathy, if you start mysqld with "--skip-grant-tables" option you
should do "FLUSH PRIVILEGES" before using GRANT statement.




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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




Re: Access denied on use mysql;

2002-03-22 Thread Liyju Janardhan


--- Kathy Reyes <[EMAIL PROTECTED]> wrote:
> Now I have a different problem. When I type mysql it
> gives me the message
> Access denied for user: 'root@localhost' (Using
> password: NO)
> how do I get it to use the password. 
> When I type mysql -u root -p 
> I get in...
   ^
What do you mean? Can you see the mysql prompt.
If you acn then what's the problem.
type 'use mysql'
then type 'show tables'
then do select * from ..
so on



> 
> 
> - Original Message - 
> From: "alan4100" <[EMAIL PROTECTED]>
> To: "Kathy Reyes" <[EMAIL PROTECTED]>
> Sent: Thursday, March 21, 2002 2:55 PM
> Subject: Re: Access denied on use mysql;
> 
> 
> > Kathy
> > I see.
> > - Original Message - 
> > From: "Kathy Reyes" <[EMAIL PROTECTED]>
> > To: "alan4100" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> > Sent: Thursday, March 21, 2002 12:48 PM
> > Subject: Re: Access denied on use mysql;
> > 
> > 
> > > I just gave up, everything that I tried did not
> work. 
> > > 
> > > I killed mysql and then
> > > started with safe_mysql --skip-grant-tables 
> > > then I was able to connect to mysql without an
> error. 
> > > But when I tried to 
> > > Grant all on mysql.* to root@localhost
> identified by "password";
> > > it gave me the message Unknown Command.
> > > 
> > > - Original Message - 
> > > From: "alan4100" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Thursday, March 21, 2002 11:07 AM
> > > Subject: Re: Access denied on use mysql;
> > > 
> > > 
> > > > mysql
> > > > 
> > > > Hello Kathy,
> > > > 
> > > > How have you made out with access to mysql?
> > > > 
> > > > 
> > > 
> > > 
> > 
> > 
> > 
> 
> 
> 
>
-
> 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
> 

__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/

-
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




Re: Access denied on use mysql;

2002-03-21 Thread alan4100

mysql

Hi Colin,

I wish I can be able to live chat with you, but because of my hearing impaired...it 
would not be possible..But what is the real problem?  A few days ago I got assistance  
from others  on my Mysql problem. It has been fixed and everything works fine.

But I am still having reply problems to those who reply to me
at the mailing list. All emails I replied directly have been bounced back except a 
very few. But replies to all emails at the mailing list ([EMAIL PROTECTED]) are 
posted.  I am wondering what caused the problem.  

Too bad I am not able to live chat with you. I have Instant Message like AIM. My 
screen name is AlanNoneD. 





Re: Access denied on use mysql;

2002-03-21 Thread Colin Faber

alan, 

Given the large amount of postings you've made to this list, I suggest
that you may be bettered helped via live chat.

You can do so by using the mysqldeveloper.com Live Chat system:
http://www.mysqldeveloper.com/chat/

which connects you to the #mysql support channel on the EFnet IRC
network.


alan4100 wrote:
> 
> mysql
> 
> kathy,
> What would happen if you type in
> mysql -u root -p
> 
> then type in
> use mysql

-- 
Colin Faber
(303) 859-1491
fpsn.net, Inc.

-
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




Re: Access denied on use mysql;

2002-03-21 Thread alan4100

mysql

kathy,
What would happen if you type in 
mysql -u root -p

then type in 
use mysql



Re: Access denied on use mysql;

2002-03-21 Thread alan4100

mysql
Kathy..

Check version of mySQL for me.
Did you said after typing mysql -u root -p, you get in fine?
Then you type mysql? then access denied...

Is this in a sequence?



- Original Message - 
From: "Kathy Reyes" <[EMAIL PROTECTED]>
To: "alan4100" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 3:21 PM
Subject: Re: Access denied on use mysql;


> Now I have a different problem. When I type mysql it gives me the message
> Access denied for user: 'root@localhost' (Using password: NO)
> how do I get it to use the password. 
> When I type mysql -u root -p 
> I get in...
> 
> 
> - Original Message - 
> From: "alan4100" <[EMAIL PROTECTED]>
> To: "Kathy Reyes" <[EMAIL PROTECTED]>
> Sent: Thursday, March 21, 2002 2:55 PM
> Subject: Re: Access denied on use mysql;
> 
> 
> > Kathy
> > I see.
> > - Original Message - 
> > From: "Kathy Reyes" <[EMAIL PROTECTED]>
> > To: "alan4100" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Thursday, March 21, 2002 12:48 PM
> > Subject: Re: Access denied on use mysql;
> > 
> > 
> > > I just gave up, everything that I tried did not work. 
> > > 
> > > I killed mysql and then
> > > started with safe_mysql --skip-grant-tables 
> > > then I was able to connect to mysql without an error. 
> > > But when I tried to 
> > > Grant all on mysql.* to root@localhost identified by "password";
> > > it gave me the message Unknown Command.
> > > 
> > > - Original Message - 
> > > From: "alan4100" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Thursday, March 21, 2002 11:07 AM
> > > Subject: Re: Access denied on use mysql;
> > > 
> > > 
> > > > mysql
> > > > 
> > > > Hello Kathy,
> > > > 
> > > > How have you made out with access to mysql?
> > > > 
> > > > 
> > > 
> > > 
> > 
> > 
> > 
> 
> 


-
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




Re: Access denied on use mysql;

2002-03-21 Thread Gerald Clark

Grant all on mysql.* to 'root'@'localhost' identified by "password";

What version MySQL are you running?
You need 3.23 for GRANT to work.



Kathy Reyes wrote:

>I just gave up, everything that I tried did not work. 
>
>I killed mysql and then
>started with safe_mysql --skip-grant-tables 
>then I was able to connect to mysql without an error. 
>But when I tried to 
>Grant all on mysql.* to root@localhost identified by "password";
>it gave me the message Unknown Command.
>
>- Original Message - 
>From: "alan4100" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Thursday, March 21, 2002 11:07 AM
>Subject: Re: Access denied on use mysql;
>
>
>>mysql
>>
>>Hello Kathy,
>>
>>How have you made out with access to mysql?
>>
>>
>
>
>
>-
>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
>
>



-
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




Re: Access denied on use mysql;

2002-03-21 Thread Kathy Reyes

Now I have a different problem. When I type mysql it gives me the message
Access denied for user: 'root@localhost' (Using password: NO)
how do I get it to use the password. 
When I type mysql -u root -p 
I get in...


- Original Message - 
From: "alan4100" <[EMAIL PROTECTED]>
To: "Kathy Reyes" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 2:55 PM
Subject: Re: Access denied on use mysql;


> Kathy
> I see.
> - Original Message - 
> From: "Kathy Reyes" <[EMAIL PROTECTED]>
> To: "alan4100" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, March 21, 2002 12:48 PM
> Subject: Re: Access denied on use mysql;
> 
> 
> > I just gave up, everything that I tried did not work. 
> > 
> > I killed mysql and then
> > started with safe_mysql --skip-grant-tables 
> > then I was able to connect to mysql without an error. 
> > But when I tried to 
> > Grant all on mysql.* to root@localhost identified by "password";
> > it gave me the message Unknown Command.
> > 
> > ----- Original Message - 
> > From: "alan4100" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, March 21, 2002 11:07 AM
> > Subject: Re: Access denied on use mysql;
> > 
> > 
> > > mysql
> > > 
> > > Hello Kathy,
> > > 
> > > How have you made out with access to mysql?
> > > 
> > > 
> > 
> > 
> 
> 
> 



-
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




Re: Access denied on use mysql;

2002-03-21 Thread alan4100

mysql

Kathy,

I see..



Re: Access denied on use mysql;

2002-03-21 Thread Kathy Reyes

I just gave up, everything that I tried did not work. 

I killed mysql and then
started with safe_mysql --skip-grant-tables 
then I was able to connect to mysql without an error. 
But when I tried to 
Grant all on mysql.* to root@localhost identified by "password";
it gave me the message Unknown Command.

- Original Message - 
From: "alan4100" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 11:07 AM
Subject: Re: Access denied on use mysql;


> mysql
> 
> Hello Kathy,
> 
> How have you made out with access to mysql?
> 
> 



-
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




Re: Access denied on use mysql;

2002-03-21 Thread alan4100

mysql

Hello Kathy,

How have you made out with access to mysql?




Re: Access denied on use mysql;

2002-03-20 Thread alan4100

mysql
Hi Doug,

I am not sure what you want to tell me.  But you may be right about shell
available for Windows.  I assume it is an add-on program. I have not used
this shell prompt either; it may be available on Windows XP.

But may I ask you one question?

Do you think I can find

mysql_install_db script

in mysql directory or subdirectories for windows XP?
I aint find it.

By the way, the c:> prompt does not show on the first page of the
troubleshooting at all.  The partial copy and paste will save our time. See
below.

4.2.11 Causes of Access denied Errors
If you encounter Access denied errors when you try to connect to the MySQL
server, the list below indicates some courses of action you can take to
correct the problem:

  a.. After installing MySQL, did you run the mysql_install_db script to set
up the initial grant table contents? If not, do so. See section 4.3.4
Setting Up the Initial MySQL Privileges. Test the initial privileges by
executing this command:
shell> mysql -u root test

  The server should let you connect without error. You should also make sure
you have a file `user.MYD' in the MySQL database directory. Ordinarily, this
is `PATH/var/mysql/user.MYD', where PATH is the pathname to the MySQL
installation root.
  b.. After a fresh installation, you should connect to the server and set
up your users and their access permissions:
shell> mysql -u root mysql

  The server should let you connect because the MySQL root user has no
password initially. That is also a security risk, so setting the root
password is something you should do while you're setting up your other MySQL
users. If you try to connect as root and get this error:
=
I would like to hear your reply. Then we discuss on it.

But my mysql now is working fine. It appears that a script is not needed for
installation. I always thought that script is for UNIX.

- Original Message -
From: "Doug Thompson" <[EMAIL PROTECTED]>
To: "alan4100" <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 8:36 PM
Subject: Re: Access denied on use mysql;


> Generally, yes.  I have used the procedures to troubleshoot win98 and
linux problems.  Certainly some of the items are
> particular to one OS or another, but that's usually pretty well
identified.  I have no practical experience with XP,
> so I cannot provide much help that's specific to that OS.
>
> For example, your problem is symptomatic of not having installed the mysql
database.  That's the first item on the
> troubleshooting page.  It's accomplished by running the  mysql_install_db
script.
>
> The "c:\>" prompt in windows is a shell prompt, btw.  In this context,
"shell" is a generic term referring to whatever
> command line prompt your system provides.
>
> Doug
>
> On Wed, 20 Mar 2002 11:16:48 -0500, alan4100 wrote:
>
> >Does it apply to windows xp?
> >
> >It applies only to unix because of shell prompt: shell>
> >
> >I am using windows XP.
> >
> >- Original Message -
> >From: "Doug Thompson" <[EMAIL PROTECTED]>
> >To: "alan4100" <[EMAIL PROTECTED]>; "Joel Rees" <[EMAIL PROTECTED]>
> >Cc: <[EMAIL PROTECTED]>
> >Sent: Wednesday, March 20, 2002 10:48 AM
> >Subject: Re: Access denied on use mysql;
> >
> >
> >> Odd, I think it does a very good job of helping troubleshoot:
> >>
> >> http://www.mysql.com/doc/A/c/Access_denied.html
> >>
> >>
> >> On Wed, 20 Mar 2002 09:30:48 -0500, alan4100 wrote:
> >>
> >> >And does not explain at all when mysql -u root -p does not work.
> >> >
> >>
> >>
> >>
> >
>
>
>

- Original Message -
From: "Doug Thompson" <[EMAIL PROTECTED]>
To: "alan4100" <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 8:36 PM
Subject: Re: Access denied on use mysql;


> Generally, yes.  I have used the procedures to troubleshoot win98 and
linux problems.  Certainly some of the items are
> particular to one OS or another, but that's usually pretty well
identified.  I have no practical experience with XP,
> so I cannot provide much help that's specific to that OS.
>
> For example, your problem is symptomatic of not having installed the mysql
database.  That's the first item on the
> troubleshooting page.  It's accomplished by running the  mysql_install_db
script.
>
> The "c:\>" prompt in windows is a shell prompt, btw.  In this context,
"shell" is a generic term referring to whatever
> command line prompt your system provides.
>
&

Re: Access denied on use mysql;

2002-03-20 Thread alan4100

Kathy,

This is 2nd copy because I forgot to cc to [EMAIL PROTECTED] myself.
Try to cc to [EMAIL PROTECTED] . There are others who want to read it.
But you said earlier about emails that did not do much of help. I was lucky.
Perhaps you have to wait for your turn.

First, I feel I am not ready to solve this problem for you because your
telneting into the linux machine from Windows 2000 machine.
I have never tried this.

I can tell you what I know as a complete beginner. I need to correct my
saying "NET CLOSE SERVER". When it should be NET STOP SERVER.  You need to
use WINMYSQLADMIN for adding users. There may be other ways, but I only know
this way.  But in your case about telneting, I am not sure what your doing
because I never tried it.  I am not clear about telneting, are your
accessing data remotely for editing,etc, from your local Mysql server. Or
vice versa. your transmitting data from your local machine to the remote
Mysql server.  I think your just accessing remote data.
Your reply may help.

I can only describe about my present settings on my pc with mysql. The
present settings right after the installation of Windows XP,  I did not go
anything beyond granting privileges to other users like you do.  But it is
ready to accept my typing input:  USE MYSQL before the database changed in
computer's reply. At that point, I assume I am granted access to this MYSQL
database. Did you type in  USE MYSQL command?

I dont know why you cannot.  I believe you should cc your emails to
[EMAIL PROTECTED] Others will help you. I think you have mentioned
emails, but got no help. Sometimes, patience pays off.
Good luck. And then enlightment follows.


- Original Message -
From: "Kathy Reyes" <[EMAIL PROTECTED]>
To: "alan4100" <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 10:54 AM
Subject: Re: Access denied on use mysql;


> I signed in as follows
>
> mysql -h localhost -u kreyes.
> mysql is installed on a linux machine and I am connecting remotely from a
> Windows 2000 machine. When I had access as root I was able to add users
and
> grants. I didnt give myself access to the 'msql' database because I didnt
> really need it. But up until yesterday I was able to go into mysql by
> telneting into the linux machine and then typing mysql but  now I keep
> getting an error. I'm not sure what you mean by NET CLOSE MYSQL. I am
kinda
> new to mysql. Please enlighten me
>
> - Original Message -
> From: "alan4100" <[EMAIL PROTECTED]>
> To: "Kathy Reyes" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 20, 2002 10:55 AM
> Subject: Re: Access denied on use mysql;
>
>
> > Kathy,
> >
> > Sounds like mine, but it is fixed. I still dont know what the fix was.
> May
> > I ask you how you signed in as Kreyes? Did you add username and password
> > yourself?
> >
> > Since you are denied access to mysql (default) database, it surely
sounded
> > like mine.   Before I may give you some help, may
> > I ask you again how you signed in as Kreyes. Did you use mysqladmin? How
> > long have you been using MySQL? Did you install recently?
> >
> > It sounds you may need to NET CLOSE MYSQL at DOS PROMPT.
> > And then NET START MYSQL again. I am afraid there are still related
> programs
> > running in the background. But five it a try.
> > Two times at most.  I did that several times over a few days period,
> before
> > it worked correctly.  And let me know.
> >
> >
> >
> > - Original Message -
> > From: "Kathy Reyes" <[EMAIL PROTECTED]>
> > To: "alan4100" <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Sent: Wednesday, March 20, 2002 10:11 AM
> > Subject: Re: Access denied on use mysql;
> >
> >
> > > I've tried everything thats in this email and nothing seems to work
for
> > me.
> > > I think my situation is a little different because I had access to my
> > > database originally but now I cant connect I can sign on as kreyes but
I
> > > cant sign on as root. I can even sign in as ODBC. I dont know what to
> do.
> > I
> > > have lost complete access to 'mysql'  datebase
> > > - Original Message -
> > > From: "alan4100" <[EMAIL PROTECTED]>
> > > To: "Joel Rees" <[EMAIL PROTECTED]>
> > > Cc: <[EMAIL PROTECTED]>
> > > Sent: Wednesday, March 20, 2002 9:30 AM
> > > Subject: Re: Access denied on use mysql;
> > >
> > >
> > > > Joel,
> > > >
> > > >
> > > > I have read the manual related to windows sever

Re: Access denied on use mysql;

2002-03-20 Thread Kathy Reyes

I've tried everything thats in this email and nothing seems to work for me.
I think my situation is a little different because I had access to my
database originally but now I cant connect I can sign on as kreyes but I
cant sign on as root. I can even sign in as ODBC. I dont know what to do. I
have lost complete access to 'mysql'  datebase

- Original Message -
From: "alan4100" <[EMAIL PROTECTED]>
To: "Liyju Janardhan" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 10:26 AM
Subject: Re: Access denied on use mysql;


> Hi Liyju,
>
> Before answering your note, I need to explain about the using the syntax
for
> mysql -u user -p.
>
> If I use the format above for mysql -u root -p,
>  I can press  after typing mysql -u root -p
> and wait for the password inquiry. I dont need to enter the password (I
dont
> have one, anyway) and then click 
> again to bypass the password inquiry. I  think it is the right way to do
> this if I am a root user. I am not sure if the root user can have a
> password. Does it? It does not sound possible. Perhaps someone has already
> mentioned it.
>
>  I had learned the hard way to skip that inquiry. I doubt it is mentioned
in
> the manual. Nevertheless, I have other problems with the installation,
> anyway.
>
> I think typing in mysql is the very same with mysql -u root -p.
> The grants are the very same. I hope it does. Does it?
>
> Your explanation about using the grant commmand for those who dont have
> password.
>
> > mysql>grant all on mysql.* to root@localhost
> > identified by '';
>
>
>
> Your correct! But I was not able to do that earlier because of something
> that went wrong with the installation.  And I had 7 traffic lights in
right
> corner without my knowing. After eliminating them and NET CLOSE  MYSQL and
> then NET START MYSQL. I had done that alone several times before to no
> avail.
> It seems the combination of elimination of 7 traffic lights and NET CLOSE
> MYSQL gave me a good fix. I still dont know what the real problem was. I
> thought all I could do was install.
>
> By now, I know how to use mysql -u root -p, but I could not see how it
could
> affect the installation in any way. I will be watching Mysql for several
> days.
>
> It looks like the second installation gave more problems.
> The NT server must have still running from the first installation.
> I thought I had deleted all my Mysql directores and subdirectories and
also
> the NT server; but it may had never deleted the NT server that was still
> running.
>
> I do really appreciate many people who tried to help me out.
>
>  - Original Message -
> From: "Liyju Janardhan" <[EMAIL PROTECTED]>
> To: "alan4100" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 20, 2002 12:30 AM
> Subject: Re: Access denied on use mysql;
>
>
> > Hi Alan,
> >   I am using mysql on linux, so I suggest you
> > to send cc to the list, let others help you.
> >
> > How do you get into mysql? Hope ur doing the
> > following.
> > $mysql -u root -p
> > Since you dont have the password you can use
> > $mysql   (remember $ means linux prompt)
> > If the above command is successful you get an mysql
> > prompt.
> > mysql>show grant for root@localhost;
> > since you don't have a password you set the grants
> > this way (I am not sure, try it)
> > mysql>grant all on mysql.* to root@localhost
> > identified by '';
> > Then run mysqladmin outside mysql prompt i.e.
> > Linux prompt>mysqladmin reload
> >
> > mysql>grant all on mysql.* to root@loaclhost
> > --- alan4100 <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > >
> > > These errors are produced after using GRANT
> > > commmand.
> > > Remember I have no password.
> > >
> > =
> > >
> > > mysql> grant all on test.* to user@localhost
> > > identified by "password";
> > > ERROR 1044: Access denied for user: '@localhost' to
> > > database 'test'
> > > mysql> $mysqladmin reload
> > > -> ;
> > > ERROR 1064: You have an error in your SQL syntax
> > > near '$mysqladmin reloa
> > > ne 1
> > > mysql> show databases;
> > > +-+
> > > | Database|
> > > +-+
> > > | Meet_a_Geek |
> > > | database05  |
> > > | db001   |
> > > | db002   |
> > > | mrbs|
> > &g

Re: Access denied on use mysql;

2002-03-20 Thread alan4100

Kathy,

Sounds like mine, but it is fixed. I still dont know what the fix was.  May
I ask you how you signed in as Kreyes? Did you add username and password
yourself?

Since you are denied access to mysql (default) database, it surely sounded
like mine.   Before I may give you some help, may
I ask you again how you signed in as Kreyes. Did you use mysqladmin? How
long have you been using MySQL? Did you install recently?

It sounds you may need to NET CLOSE MYSQL at DOS PROMPT.
And then NET START MYSQL again. I am afraid there are still related programs
running in the background. But five it a try.
Two times at most.  I did that several times over a few days period, before
it worked correctly.  And let me know.



- Original Message -
From: "Kathy Reyes" <[EMAIL PROTECTED]>
To: "alan4100" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 10:11 AM
Subject: Re: Access denied on use mysql;


> I've tried everything thats in this email and nothing seems to work for
me.
> I think my situation is a little different because I had access to my
> database originally but now I cant connect I can sign on as kreyes but I
> cant sign on as root. I can even sign in as ODBC. I dont know what to do.
I
> have lost complete access to 'mysql'  datebase
> - Original Message -
> From: "alan4100" <[EMAIL PROTECTED]>
> To: "Joel Rees" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 20, 2002 9:30 AM
> Subject: Re: Access denied on use mysql;
>
>
> > Joel,
> >
> >
> > I have read the manual related to windows several times. But the problem
> > that I was not having is not mentioned in the manual.
> > I am not too sure if I am the one who needs root canal like someone
> earlier
> > claimed. Or the manual needs one.  I dont think the manual is helpful
for
> > beginners.  Of course, I can say that the manual is not  good. Of
course,
> > everyone can say it is free. The manual blends UNIX with Windows when
they
> > should be separate.
> > And does not explain at all when mysql -u root -p does not work.
> >
> > It seems to work for everyone for the first time. Not me!
> > Before getting into nitty and gritty details with you on my problem,
> please
> > dont bring up hardware limits. I have an excellent computer DELL 4100
> > Dimension with well over 256 megs ram..etc..etc.. on windows xp just
> > installed few days ago.
> > My processor is near  1 giga hertz!
> >
> > Who has 64 megs and 100 HRZ? Perhaps for those who work in the museum.
> >
> > Your information on  how to grant access to databases for specific users
> is
> > very good, but I was not able to put it to work. I could not done it as
a
> > root user. It just wont grant access to me  as a root user.I cannot
> type
> > mysql -u root -p  OR mysql -u root at all. It will display ACCESS
denied.
> > Same problems with first and second installation. The second
installation
> > was not necessary; you said you said waste of time. I am not going to
> > disagree on that, either. But the NT server from the first installation
> must
> > have still been running in the background  without my knowing.   I
cannot
> > explain how things went wrong with the first installation. But it seemed
> > that the first installation transmitted "disease" to the second.
> Everything
> > was impossible with both of these installations.
> >
> > Until then, I learned how to use WINMYSQLADMIN for adding my username
and
> > password. MYSQLADMIN did not do any good at that time. Still I was not
> > granted access until that traffic light icon thing popped up in the
right
> > corner. There were 7 of them there. I never saw them before! But I think
> it
> > was the turning point. After deleting one by one. To make story
short...I
> > learned how to stop and start server with that traffic light icon. When
I
> > stopped the server, I then started it with NET START MYSQL..
> >
> > Then I was able to type in my user name and password (not root user this

> > time), but think root user will be granted access. It appears that
> > WINMYSQLADMIN is finally put to work. I was granted access on my user
> > name/password.  Everything appears to be working fine.  I think removing
> > those 7 traffic lites and STOP Server and then START server somehow
fixed
> > everthing for me.
> > I have been granted access already without doing any configuration. I
did
> > not have that privilege in the beginning.
> >
> > The manual does not explain what I should do if mysql -u root -p does
not
> > work. 

Re: Access denied on use mysql;

2002-03-20 Thread Doug Thompson

Odd, I think it does a very good job of helping troubleshoot:

http://www.mysql.com/doc/A/c/Access_denied.html


On Wed, 20 Mar 2002 09:30:48 -0500, alan4100 wrote:

>And does not explain at all when mysql -u root -p does not work.
>




-
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




Re: Access denied on use mysql;

2002-03-20 Thread alan4100

Anis,

My problem has been solved without configurating my.cnf.
It looks like I dont need it at all because WINADMINSQL has created its own
my.ini file.

You may find my email to others about the fix. I still dont know what the
problem is. But it appears to be fixed ; fine and okay now. After closing
and starting SERVER several times, it at last accepts my mysql -u root or
mysql -u root -p with no ACCESS DENIED messages anymore.





- Original Message -
From: "Ahmed S K Anis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 10:00 AM
Subject: Re: Access denied on use mysql;


> Hi alan,
> quite a long one.but i figure u have problems with
> configuration ..rather than installation. on Win NT
> Kindly place my.cnf attached wiht his mail in C:\
> Start Mysql again..
>
> at   >mysql\bin type  "mysql"
> if that does not work  type  "mysql  -u root "
> and press enter
>
> please let me know.if that resulted in mysql>  promt.
>
>
> Cheers
> Anis
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> >>> alan4100 <[EMAIL PROTECTED]> 03/20/02 08:00PM >>>
> Joel,
>
>
> I have read the manual related to windows several times. But the
> problem
> that I was not having is not mentioned in the manual.
> I am not too sure if I am the one who needs root canal like someone
> earlier
> claimed. Or the manual needs one.  I dont think the manual is helpful
> for
> beginners.  Of course, I can say that the manual is not  good. Of
> course,
> everyone can say it is free. The manual blends UNIX with Windows when
> they
> should be separate.
> And does not explain at all when mysql -u root -p does not work.
>
> It seems to work for everyone for the first time. Not me!
> Before getting into nitty and gritty details with you on my problem,
> please
> dont bring up hardware limits. I have an excellent computer DELL 4100
> Dimension with well over 256 megs ram..etc..etc.. on windows xp just
> installed few days ago.
> My processor is near  1 giga hertz!
>
> Who has 64 megs and 100 HRZ? Perhaps for those who work in the museum.
>
> Your information on  how to grant access to databases for specific
> users is
> very good, but I was not able to put it to work. I could not done it as
> a
> root user. It just wont grant access to me  as a root user.I cannot
> type
> mysql -u root -p  OR mysql -u root at all. It will display ACCESS
> denied.
> Same problems with first and second installation. The second
> installation
> was not necessary; you said you said waste of time. I am not going to
> disagree on that, either. But the NT server from the first installation
> must
> have still been running in the background  without my knowing.   I
> cannot
> explain how things went wrong with the first installation. But it
> seemed
> that the first installation transmitted "disease" to the second.
> Everything
> was impossible with both of these installations.
>
> Until then, I learned how to use WINMYSQLADMIN for adding my username
> and
> password. MYSQLADMIN did not do any good at that time. Still I was not
> granted access until that traffic light icon thing popped up in the
> right
> corner. There were 7 of them there. I never saw them before! But I
> think it
> was the turning point. After deleting one by one. To make story
> short...I
> learned how to stop and start server with that traffic light icon. When
> I
> stopped the server, I then started it with NET START MYSQL..
>
> Then I was able to type in my user name and password (not root user
> this
> time), but think root user will be granted access. It appears that
> WINMYSQLADMIN is finally put to work. I was granted access on my user
> name/password.  Everything appears to be working fine.  I think
> removing
> those 7 traffic lites and STOP Server and then START server somehow
> fixed
> everthing for me.
> I have been granted access already without doing any configuration. I
> did
> not have that privilege in the beginning.
>
> The manual does not explain what I should do if mysql -u root -p does
> not
> work. And on how to use WINMYSQLADMIN on adding users. And also
> traffic
> lights. There is a program called MYSQLADMIN for DOS does not cover
> examples
> on how to using many different commands.
>
>  I am a very new mySQL newbie. I barely start. I feel very sorry for
> the new
> comers to mySQL. But hopefully, these new comers are able to locate
> newsgroups like this. I think the documentation does not need 300
> pages. And
> they should be separate with UNIX and WINDOWS.   And explain what we
> should
> do if

Re: Access denied on use mysql;

2002-03-20 Thread alan4100

Hi Liyju,

Before answering your note, I need to explain about the using the syntax for
mysql -u user -p.

If I use the format above for mysql -u root -p,
 I can press  after typing mysql -u root -p
and wait for the password inquiry. I dont need to enter the password (I dont
have one, anyway) and then click 
again to bypass the password inquiry. I  think it is the right way to do
this if I am a root user. I am not sure if the root user can have a
password. Does it? It does not sound possible. Perhaps someone has already
mentioned it.

 I had learned the hard way to skip that inquiry. I doubt it is mentioned in
the manual. Nevertheless, I have other problems with the installation,
anyway.

I think typing in mysql is the very same with mysql -u root -p.
The grants are the very same. I hope it does. Does it?

Your explanation about using the grant commmand for those who dont have
password.

> mysql>grant all on mysql.* to root@localhost
> identified by '';



Your correct! But I was not able to do that earlier because of something
that went wrong with the installation.  And I had 7 traffic lights in right
corner without my knowing. After eliminating them and NET CLOSE  MYSQL and
then NET START MYSQL. I had done that alone several times before to no
avail.
It seems the combination of elimination of 7 traffic lights and NET CLOSE
MYSQL gave me a good fix. I still dont know what the real problem was. I
thought all I could do was install.

By now, I know how to use mysql -u root -p, but I could not see how it could
affect the installation in any way. I will be watching Mysql for several
days.

It looks like the second installation gave more problems.
The NT server must have still running from the first installation.
I thought I had deleted all my Mysql directores and subdirectories and also
the NT server; but it may had never deleted the NT server that was still
running.

I do really appreciate many people who tried to help me out.

 - Original Message -
From: "Liyju Janardhan" <[EMAIL PROTECTED]>
To: "alan4100" <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 12:30 AM
Subject: Re: Access denied on use mysql;


> Hi Alan,
>   I am using mysql on linux, so I suggest you
> to send cc to the list, let others help you.
>
> How do you get into mysql? Hope ur doing the
> following.
> $mysql -u root -p
> Since you dont have the password you can use
> $mysql   (remember $ means linux prompt)
> If the above command is successful you get an mysql
> prompt.
> mysql>show grant for root@localhost;
> since you don't have a password you set the grants
> this way (I am not sure, try it)
> mysql>grant all on mysql.* to root@localhost
> identified by '';
> Then run mysqladmin outside mysql prompt i.e.
> Linux prompt>mysqladmin reload
>
> mysql>grant all on mysql.* to root@loaclhost
> --- alan4100 <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > These errors are produced after using GRANT
> > commmand.
> > Remember I have no password.
> >
> =
> >
> > mysql> grant all on test.* to user@localhost
> > identified by "password";
> > ERROR 1044: Access denied for user: '@localhost' to
> > database 'test'
> > mysql> $mysqladmin reload
> > -> ;
> > ERROR 1064: You have an error in your SQL syntax
> > near '$mysqladmin reloa
> > ne 1
> > mysql> show databases;
> > +-+
> > | Database|
> > +-+
> > | Meet_a_Geek |
> > | database05  |
> > | db001   |
> > | db002   |
> > | mrbs    |
> > | mysql       |
> > | sample_db   |
> > | shopcart|
> > | test|
> > +-+
> > 9 rows in set (0.00 sec)
> >
> > mysql>
> > - Original Message -
> > From: "Liyju Janardhan" <[EMAIL PROTECTED]>
> > To: "alan4100" <[EMAIL PROTECTED]>;
> > <[EMAIL PROTECTED]>
> > Sent: Tuesday, March 19, 2002 1:37 AM
> > Subject: Re: Access denied on use mysql;
> >
> >
> > >
> > > --- alan4100 <[EMAIL PROTECTED]> wrote:
> > > > The problem begins when I type in use mysql;
> > > > Please look at the very left edge with three
> > > > asterisks..*** where I marked. ACCESS denied
> > > > Hope it will be fixed with your help so I can
> > mind
> > > > my own chores.
> > > >
> > > > ==
> > > > C:\mysql\bin>net start mysql
> > > > The MySql service is starting.
> > > > The MySql se

Re: Access denied on use mysql;

2002-03-20 Thread Kathy Reyes

I've tried everything thats in this email and nothing seems to work for me.
I think my situation is a little different because I had access to my
database originally but now I cant connect I can sign on as kreyes but I
cant sign on as root. I can even sign in as ODBC. I dont know what to do. I
have lost complete access to 'mysql'  datebase
- Original Message -
From: "alan4100" <[EMAIL PROTECTED]>
To: "Joel Rees" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 9:30 AM
Subject: Re: Access denied on use mysql;


> Joel,
>
>
> I have read the manual related to windows several times. But the problem
> that I was not having is not mentioned in the manual.
> I am not too sure if I am the one who needs root canal like someone
earlier
> claimed. Or the manual needs one.  I dont think the manual is helpful for
> beginners.  Of course, I can say that the manual is not  good. Of course,
> everyone can say it is free. The manual blends UNIX with Windows when they
> should be separate.
> And does not explain at all when mysql -u root -p does not work.
>
> It seems to work for everyone for the first time. Not me!
> Before getting into nitty and gritty details with you on my problem,
please
> dont bring up hardware limits. I have an excellent computer DELL 4100
> Dimension with well over 256 megs ram..etc..etc.. on windows xp just
> installed few days ago.
> My processor is near  1 giga hertz!
>
> Who has 64 megs and 100 HRZ? Perhaps for those who work in the museum.
>
> Your information on  how to grant access to databases for specific users
is
> very good, but I was not able to put it to work. I could not done it as a
> root user. It just wont grant access to me  as a root user.I cannot
type
> mysql -u root -p  OR mysql -u root at all. It will display ACCESS denied.
> Same problems with first and second installation. The second installation
> was not necessary; you said you said waste of time. I am not going to
> disagree on that, either. But the NT server from the first installation
must
> have still been running in the background  without my knowing.   I cannot
> explain how things went wrong with the first installation. But it seemed
> that the first installation transmitted "disease" to the second.
Everything
> was impossible with both of these installations.
>
> Until then, I learned how to use WINMYSQLADMIN for adding my username and
> password. MYSQLADMIN did not do any good at that time. Still I was not
> granted access until that traffic light icon thing popped up in the right
> corner. There were 7 of them there. I never saw them before! But I think
it
> was the turning point. After deleting one by one. To make story short...I
> learned how to stop and start server with that traffic light icon. When I
> stopped the server, I then started it with NET START MYSQL..
>
> Then I was able to type in my user name and password (not root user this
> time), but think root user will be granted access. It appears that
> WINMYSQLADMIN is finally put to work. I was granted access on my user
> name/password.  Everything appears to be working fine.  I think removing
> those 7 traffic lites and STOP Server and then START server somehow fixed
> everthing for me.
> I have been granted access already without doing any configuration. I did
> not have that privilege in the beginning.
>
> The manual does not explain what I should do if mysql -u root -p does not
> work. And on how to use WINMYSQLADMIN on adding users. And also traffic
> lights. There is a program called MYSQLADMIN for DOS does not cover
examples
> on how to using many different commands.
>
>  I am a very new mySQL newbie. I barely start. I feel very sorry for the
new
> comers to mySQL. But hopefully, these new comers are able to locate
> newsgroups like this. I think the documentation does not need 300 pages.
And
> they should be separate with UNIX and WINDOWS.   And explain what we
should
> do if mysql -u root -p does not work in some pages.
>
> Right now, it is still not clear what went wrong in the very beginning.
>
> Anyway, thanks for instructing me to cc the list...Now I see how MYSQL
list
> mailing works.
>
> - Original Message -
> From: "Joel Rees" <[EMAIL PROTECTED]>
> To: "alan4100" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, March 19, 2002 11:47 PM
> Subject: Re: Access denied on use mysql;
>
>
> > alan4100:
> >
> > If you reply to this, please CC the list.
> >
> > Keep reading the manual while you try things. From your questions, I am
> > wondering if you are not reading the manual, or are just too impatient
and
> &

Re: Access denied on use mysql;

2002-03-20 Thread alan4100

Joel,


I have read the manual related to windows several times. But the problem
that I was not having is not mentioned in the manual.
I am not too sure if I am the one who needs root canal like someone earlier
claimed. Or the manual needs one.  I dont think the manual is helpful for
beginners.  Of course, I can say that the manual is not  good. Of course,
everyone can say it is free. The manual blends UNIX with Windows when they
should be separate.
And does not explain at all when mysql -u root -p does not work.

It seems to work for everyone for the first time. Not me!
Before getting into nitty and gritty details with you on my problem,  please
dont bring up hardware limits. I have an excellent computer DELL 4100
Dimension with well over 256 megs ram..etc..etc.. on windows xp just
installed few days ago.
My processor is near  1 giga hertz!

Who has 64 megs and 100 HRZ? Perhaps for those who work in the museum.

Your information on  how to grant access to databases for specific users is
very good, but I was not able to put it to work. I could not done it as a
root user. It just wont grant access to me  as a root user.I cannot type
mysql -u root -p  OR mysql -u root at all. It will display ACCESS denied.
Same problems with first and second installation. The second installation
was not necessary; you said you said waste of time. I am not going to
disagree on that, either. But the NT server from the first installation must
have still been running in the background  without my knowing.   I cannot
explain how things went wrong with the first installation. But it seemed
that the first installation transmitted "disease" to the second.  Everything
was impossible with both of these installations.

Until then, I learned how to use WINMYSQLADMIN for adding my username and
password. MYSQLADMIN did not do any good at that time. Still I was not
granted access until that traffic light icon thing popped up in the right
corner. There were 7 of them there. I never saw them before! But I think it
was the turning point. After deleting one by one. To make story short...I
learned how to stop and start server with that traffic light icon. When I
stopped the server, I then started it with NET START MYSQL..

Then I was able to type in my user name and password (not root user this
time), but think root user will be granted access. It appears that
WINMYSQLADMIN is finally put to work. I was granted access on my user
name/password.  Everything appears to be working fine.  I think removing
those 7 traffic lites and STOP Server and then START server somehow fixed
everthing for me.
I have been granted access already without doing any configuration. I did
not have that privilege in the beginning.

The manual does not explain what I should do if mysql -u root -p does not
work. And on how to use WINMYSQLADMIN on adding users. And also traffic
lights. There is a program called MYSQLADMIN for DOS does not cover examples
on how to using many different commands.

 I am a very new mySQL newbie. I barely start. I feel very sorry for the new
comers to mySQL. But hopefully, these new comers are able to locate
newsgroups like this. I think the documentation does not need 300 pages. And
they should be separate with UNIX and WINDOWS.   And explain what we should
do if mysql -u root -p does not work in some pages.

Right now, it is still not clear what went wrong in the very beginning.

Anyway, thanks for instructing me to cc the list...Now I see how MYSQL list
mailing works.

- Original Message -
From: "Joel Rees" <[EMAIL PROTECTED]>
To: "alan4100" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, March 19, 2002 11:47 PM
Subject: Re: Access denied on use mysql;


> alan4100:
>
> If you reply to this, please CC the list.
>
> Keep reading the manual while you try things. From your questions, I am
> wondering if you are not reading the manual, or are just too impatient and
> are trying things before you read the whole story.
>
> If your processor is faster than 100MHz and has more than 64M RAM, I
> recommend downloading the manual.pdf (Adobe Acrobat), so you can browse it
> off-line. You'll need Acrobat, of course, but Acrobat is useful for
reading
> many things, well worth the download time. You can find links to the
> documentation pages at mysql's main web page.
>
> To repeat what others have said, you need to understand how to set
> passwords, how to supply passwords when running the client, and how to
GRANT
> access to databases to specific users. Yes, "GRANT" is a MySQL command,
and
> you do need to understand it.
>
> It would be easier if you had someone handy to configure a database for
you.
> Then you wouldn't need to understand the GRANT command, just how to log in
> with a user name and password. Actually, your initial installation should
be
> without a root password, so you shou

Re: Access denied on use mysql;

2002-03-19 Thread Joel Rees

alan4100:

If you reply to this, please CC the list.

Keep reading the manual while you try things. From your questions, I am
wondering if you are not reading the manual, or are just too impatient and
are trying things before you read the whole story.

If your processor is faster than 100MHz and has more than 64M RAM, I
recommend downloading the manual.pdf (Adobe Acrobat), so you can browse it
off-line. You'll need Acrobat, of course, but Acrobat is useful for reading
many things, well worth the download time. You can find links to the
documentation pages at mysql's main web page.

To repeat what others have said, you need to understand how to set
passwords, how to supply passwords when running the client, and how to GRANT
access to databases to specific users. Yes, "GRANT" is a MySQL command, and
you do need to understand it.

It would be easier if you had someone handy to configure a database for you.
Then you wouldn't need to understand the GRANT command, just how to log in
with a user name and password. Actually, your initial installation should be
without a root password, so you should be okay.

Deleting the whole installation was a drastic step, and probably
unnecessary.

See below for a few comments:


> Your mentioning about mysql -h host -u user  prompts me to type
>
> mysql> select system_user(); ...the output is
>
> ++
> | system_user()  |
> ++
> | ODBC@localhost |
> ++
> 1 row in set (0.00 sec)
>
> I then tried mysql -h localhost -u ODBC

Okay, you logged on as your ODBC driver.

> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 19 to server version: 3.23.44-nt
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> use mysql
> ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

You didn't GRANT ODBC access to the database 'mysql', neither did you log on
as root.

BTW, do not grant access to the 'mysql' database to ODBC. Since that's the
configuration database, that would be a major security hole.

Find out the root password and login as root. In your fresh install, there
shouldn't be a password yet, but it would be a good idea to set one just as
soon as you know how.

You may have a my.cnf (root of your system drive, I did see a c:> didn't I?)
or my.ini (Windows directory) left over from the previous install. That may
have a default password set in it for root.

As was mentioned, you might have been able to access the 'test' database.

Anyway, read that fantastic manual. And follow up on list.

Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka




-
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




Re: Access denied on use mysql;

2002-03-18 Thread Liyju Janardhan


--- alan4100 <[EMAIL PROTECTED]> wrote:
> The problem begins when I type in use mysql;
> Please look at the very left edge with three
> asterisks..*** where I marked. ACCESS denied
> Hope it will be fixed with your help so I can mind
> my own chores.
> 
> ==
> C:\mysql\bin>net start mysql
> The MySql service is starting.
> The MySql service was started successfully.
> 
> 
> C:\mysql\bin>mysqladmin ping
> mysqld is alive
> 
> C:\mysql\bin>mysql
> Welcome to the MySQL monitor.  Commands end with ;
> or \g.
> Your MySQL connection id is 2 to server version:
> 3.23.44-nt
> 
> Type 'help;' or '\h' for help. Type '\c' to clear
> the buffer.
> 
> mysql> mysqld
> -> \q
> Bye
> 
> C:\mysql\bin>mysqld
> 
> C:\mysql\bin>mysql
> Welcome to the MySQL monitor.  Commands end with ;
> or \g.
> Your MySQL connection id is 3 to server version:
> 3.23.44-nt
> 
> Type 'help;' or '\h' for help. Type '\c' to clear
> the buffer.
> 
> mysql> show databases;
> +-+
> | Database|
> +-+
> | Meet_a_Geek |
> | database05  |
> | db001   |
> | db002   |
> | mrbs|
> | mysql   |
> | sample_db   |
> | shopcart|
> | test|
> +-+
> 9 rows in set (0.02 sec)
> 
> ***mysql> use mysql;
> ERROR 1044: Access denied for user: '@localhost' to
> database 'mysql'
> mysql> use mysql -root
> ERROR 1044: Access denied for user: '@localhost' to
> database 'mysql'

do the following:
mysql>grant all on test.* to user@localhost identified
by 'password';

$mysqladmin reload


> mysql> mysql
> -> /q
> -> \q
> Bye
> 
> C:\mysql\bin>mysql
> Welcome to the MySQL monitor.  Commands end with ;
> or \g.
> Your MySQL connection id is 4 to server version:
> 3.23.44-nt
> 
> Type 'help;' or '\h' for help. Type '\c' to clear
> the buffer.
> 
> mysql> use mysql;
> ERROR 1044: Access denied for user: '@localhost' to
> database 'mysql'
> mysql>
> 


__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/

-
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




Re: Access denied on use mysql;

2002-03-18 Thread Joel Rees

It looks like you need a root kit. No. A root canal. No, wait! That's not
right, either. ;)

alan4100 queried:

[snipped]

> C:\mysql\bin>mysql

[snipped]

> ***mysql> use mysql;
> ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

I know the manual takes a lot of reading, but it is worth it. Section 3
("Introduction to MySQL") shows you how to specify the host and user, and
you are not going to get administrator access logging on anonymously.
Section 4.3 has the nitty-gritty, if you need it.

c:>mysql -h host -u user

And there's a password option, too, which you may need.

Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka




-
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