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]
