Newbie help needed

Duncan <Duncan@poohead.com> wrote:
> I get a message saying that ERROR 1045 (2800): Access denied for user
> 'ODBC'@'localhost' (using password: YES)

Default after install is 'root' without password for most windows flavours
afaik.
--
Rik Wasmus

On Feb 23, 11:19 pm, "Duncan" <Dun...@poohead.com> wrote:
> Hi All,
>
> I'm learning SQL and the book that I'm reading suggested mySQL as a good DB
> to use, it also uses it in the examples.
>
> This is good because I want to learn a bit more about Databases.
>
> So I tried to install the Apple Mac version and although it seemed to
> install ok I can't start it or even find it. (I'm not a wizz at the BASH
> terminal window).
> So I though I'd use the Windows version (using Windows XP on the Mac) this
> also seemed to install ok but when I try to start it from the command line
> using: > mysql [username] [password]
> I get a screen full of stuff starting:-
> mysql Ver 14.12 Distrib5.0.27, for Win32 (ia32)
> Copyright (C) 2002 MySQL AB
> it them lists a load of what I assume are options and then goes back to the
> prompt it was before:
>
> If I type: >mysql [username] -p
> it asks me for the password and then brings up the message:
>
> I get a message saying that ERROR 1045 (2800): Access denied for user
> 'ODBC'@'localhost' (using password: YES)
>
> I am certain I'm using the correct password.
>
> I also tried using Toad for MySQL as a front end but this gave the same
> password error message
>
> If someone could help with getting either the Windows or the Mac (or both)
> working I'd be most grateful
>
> Duncan

FWIW, this is what i type to access mysql

mysql -u myusername -p
mypassword

I use windows but I guess the command line interface is similar.

On Feb 24, 1:32 am, "Duncan" <Dun...@poohead.com> wrote:
> "strawberry" <zac.ca...@gmail.com> wrote in message
>
> news:1172251105.223200.4840@m58g2000cwm.googlegrou ps.com...
>
> > On Feb 23, 11:19 pm, "Duncan" <Dun...@poohead.com> wrote:
> > > Hi All,
> [snip]
> > > Duncan
>
> > FWIW, this is what i type to access mysql
> > mysql -u myusername -p
> > mypassword
> > I use windows but I guess the command line interface is similar.
>
> F*** me that worked, I was missing out the -u
> So simple
> When you say you use windows do you go in via a graphical front end?
> I'm using windows.
> thanks a load
>
> Duncan

No - I meant Windows vs Mac. I just didn't read your post very
thoroughly.
Although I do also use phpmyadmin

Hi All,

I'm learning SQL and the book that I'm reading suggested mySQL as a good DB
to use, it also uses it in the examples.

This is good because I want to learn a bit more about Databases.

So I tried to install the Apple Mac version and although it seemed to
install ok I can't start it or even find it. (I'm not a wizz at the BASH
terminal window).
So I though I'd use the Windows version (using Windows XP on the Mac) this
also seemed to install ok but when I try to start it from the command line
using: > mysql [username] [password]
I get a screen full of stuff starting:-
mysql Ver 14.12 Distrib5.0.27, for Win32 (ia32)
Copyright (C) 2002 MySQL AB
it them lists a load of what I assume are options and then goes back to the
prompt it was before:

If I type: >mysql [username] -p
it asks me for the password and then brings up the message:

I get a message saying that ERROR 1045 (2800): Access denied for user
'ODBC'@'localhost' (using password: YES)

I am certain I'm using the correct password.

I also tried using Toad for MySQL as a front end but this gave the same
password error message

If someone could help with getting either the Windows or the Mac (or both)
working I'd be most grateful

Duncan

"Rik" <luiheidsgoeroe@hotmail.com> wrote:
> Duncan <Duncan@poohead.com> wrote:
> > I get a message saying that ERROR 1045 (2800): Access denied for user
> > 'ODBC'@'localhost' (using password: YES)

> Default after install is 'root' without password for most windows flavours
> afaik.
> --
> Rik Wasmus

No, I've just tried root and same thing with or without the password I
stipulated at install

thanks for replying though
Duncan

"strawberry" <zac.carey@gmail.com> wrote in message
news:1172251105.223200.4840@m58g2000cwm.googlegrou ps.com...
> On Feb 23, 11:19 pm, "Duncan" <Dun...@poohead.com> wrote:
> > Hi All,
[snip]
> > Duncan
>
> FWIW, this is what i type to access mysql
> mysql -u myusername -p
> mypassword

> I use windows but I guess the command line interface is similar.


F*** me that worked, I was missing out the -u
So simple
When you say you use windows do you go in via a graphical front end?
I'm using windows.
thanks a load

Duncan

"strawberry" <zac.carey@gmail.com> wrote in message
news:1172252282.946270.8610@q2g2000cwa.googlegroup s.com...
> On Feb 24, 1:32 am, "Duncan" <Dun...@poohead.com> wrote:
> >
> > Duncan
>
> No - I meant Windows vs Mac. I just didn't read your post very
> thoroughly.
> Although I do also use phpmyadmin


I'll give that a look

Thanks again
Duncan