Re: Error 1045
But MySQL even doesn't ask me for a password but returns immediately this
error.
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Stephan Wölfel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 10:14 PM
Subject: Re: Error 1045
> You are not entering the right password.
> If you did NOT set a password for root, then leave the -p option off.
>
> Stephan Wölfel wrote:
>
> >When I start MySQL with "mysql -u root -p" I get again the error 1045
> >("Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)".
> >What am I doing wrong ?
> >
> >- Original Message -
> >From: "gerald_clark" <[EMAIL PROTECTED]>
> >To: "Stephan Wölfel" <[EMAIL PROTECTED]>
> >Cc: <[EMAIL PROTECTED]>
> >Sent: Monday, October 13, 2003 5:54 PM
> >Subject: Re: Error 1045
> >
> >
> >
> >
> >>Stephan Wölfel wrote:
> >>
> >>
> >>
> >>>Thanks for the advise.
> >>>However I have some additional questions:
> >>>ad 2) How can I check the grant privileges ?
> >>>ad 3) How can I "run this as the mysql root user" ?
> >>>
> >>>
> >>>
> >>mysql -u root -p
> >>enter the root password you set when you installed mysql
> >>use mysql
> >>enter the grant command.
> >>
> >>
> >>
> >>>- Original Message -
> >>>From: "gerald_clark" <[EMAIL PROTECTED]>
> >>>To: "Stephan Wölfel" <[EMAIL PROTECTED]>
> >>>Cc: <[EMAIL PROTECTED]>
> >>>Sent: Monday, October 13, 2003 4:47 PM
> >>>Subject: Re: Error 1045
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >>--
> >>MySQL General Mailing List
> >>For list archives: http://lists.mysql.com/mysql
> >>To unsubscribe:
> >>
> >>
> >http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> >>
> >>
> >___
> >M=FCde auf kleines Postfach? http://my-mail.ch/?redirect=3D9903
> >Weine aus der Toskana! http://my-mail.ch/?redirect=3D1179
> >
> >
> >
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
_
Schlappe =DCbertragungsgrenze? http://my-mail.ch/?redirect=3D9904
Weine aus der Toskana! http://my-mail.ch/?redirect=3D1179
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1045
When I start MySQL with "mysql -u root -p" I get again the error 1045
("Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)".
What am I doing wrong ?
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Stephan Wölfel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 5:54 PM
Subject: Re: Error 1045
>
>
> Stephan Wölfel wrote:
>
> >Thanks for the advise.
> >However I have some additional questions:
> >ad 2) How can I check the grant privileges ?
> >ad 3) How can I "run this as the mysql root user" ?
> >
> mysql -u root -p
> enter the root password you set when you installed mysql
> use mysql
> enter the grant command.
>
> >
> >- Original Message -
> >From: "gerald_clark" <[EMAIL PROTECTED]>
> >To: "Stephan Wölfel" <[EMAIL PROTECTED]>
> >Cc: <[EMAIL PROTECTED]>
> >Sent: Monday, October 13, 2003 4:47 PM
> >Subject: Re: Error 1045
> >
> >
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
___
M=FCde auf kleines Postfach? http://my-mail.ch/?redirect=3D9903
Weine aus der Toskana! http://my-mail.ch/?redirect=3D1179
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1045
Thanks for the advise.
However I have some additional questions:
ad 2) How can I check the grant privileges ?
ad 3) How can I "run this as the mysql root user" ?
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Stephan Wölfel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 4:47 PM
Subject: Re: Error 1045
> 1. The command is not properly formed.
> 2. You don't have grant privileges.
> 3. Run this as the mysql root user.
>
> Stephan Wölfel wrote:
>
> >When I try to execute "grant all on *.* to stw" where stw is my user
name, I get an error 1045 ("Access denied for user: '@127.0.0.1' (Using
password: NO).
> >Is there a way to check for user datas ? Or how to resolve this problem ?
> >
> >Stephan Wölfel
>
>___
> >Schreibsüchtige gesucht! http://my-mail.ch/?redirect=9902
> >Heute schon Danke gesagt? Mit swissflowers.ch Blumen schenken!
http://my-mail.ch/?redirect=9910
> >
> >
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
Schlappe =DCbertragungsgrenze? http://my-mail.ch/?redirect=3D9904
Ich ha Di g=E4rn! Sofort Blumen schenken mit swissflowers.ch!
http://my-mail.ch/?redirect=3D9911
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1045
Hi Jim,
thanks for the advise.
What you tell all works. But even after this I still get the same error 1045
when typing "grant all on *.* to stw". Why ?
Stephan
- Original Message -
From: "James Cradock" <[EMAIL PROTECTED]>
To: "Stephan Wölfel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 4:26 PM
Subject: Re: Error 1045
Stephan -
Connect to MySQL via a shell or command-line, change to the mysql
database with
use mysql;
...then query the user table:
select * from user
Also, to connect to the database server as a specific user, you'll need
to enter
mysql -u stw
or
mysql -u stw -p
...if you specified a password.
- Jim
On Monday, October 13, 2003, at 10:15 AM, Stephan Wölfel wrote:
> When I try to execute "grant all on *.* to stw" where stw is my user
> name, I get an error 1045 ("Access denied for user: '@127.0.0.1'
> (Using password: NO).
> Is there a way to check for user datas ? Or how to resolve this
> problem ?
>
-
James Cradock, [EMAIL PROTECTED]
me3 Technology Consultants, LLC
24 Preble Street
Portland, Maine, USA 04101
207-772-3217 (office)
207-838-8678 (mobile)
http://www.me3.com/
___
Schreibs=FCchtige gesucht! http://my-mail.ch/?redirect=3D9902
Ich vermiss Di! Jetzt Blumen schenken mit swissflowers.ch!
http://my-mail.ch/?redirect=3D9913
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error 1045
When I try to execute "grant all on *.* to stw" where stw is my user name, I get an
error 1045 ("Access denied for user: '@127.0.0.1' (Using password: NO).
Is there a way to check for user datas ? Or how to resolve this problem ?
Stephan Wölfel
___
Schreibsüchtige gesucht! http://my-mail.ch/?redirect=9902
Heute schon Danke gesagt? Mit swissflowers.ch Blumen schenken!
http://my-mail.ch/?redirect=9910
what means "shell" ?
In the third chapter of the MySQL manual I don't understand the mentioned "shell>". Where must I type in this and the following instructions or what does it mean ? Until now I have found and started the winmysqladmin.exe file. But how to continue ? Stephan ___ Schreibsüchtige gesucht! http://my-mail.ch/?redirect=9902 Heute schon Danke gesagt? Mit swissflowers.ch Blumen schenken! http://my-mail.ch/?redirect=9910
