Stephan -
First, change to the root user on the Linux computer:
su -
And hit RETURN. Enter the root password when prompted. Then type
mysql
And hit RETURN. You should get into mysql then. Type
use mysql;
And hit RETURN.
Then type
GRANT ALL on *.* to [EMAIL PROTECTED] IDENTIFIED BY 'yourpassword';
And RETURN. That's it. Type
exit
And RETURN to exit mysql. Then type
exit
And RETURN to exit the root user. Now, finally, type
mysql -u stw -p
And hit RETURN. Type the password you just entered when prompted. You
should gain access to MySQL. Let me know how it goes.
- Jim
> 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.
-----
James Cradock, [EMAIL PROTECTED]
Me3 Technology Consultants, LLC
24 Preble Street
Portland, Maine, USA 04101
http://www.me3.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
