Using MySql on Mandrake Linux 10.1

[cpopham]

Okay, I have been working with MySql for quite a while on Windows and can generally do what I need. I use Navicat to do a lot of the work because it is a lot faster than working it from a prompt.

Anyway, I got permission to set up a linux box and I chose to mandrake on it. I downloaded MySql 5.0 both Server and Client RPMs and they installed fine. I pulled up a prompt and was right in when I typed mysql at the prompt. So I know that mysql is up and running and I can get in from local host without a password.

At the MYSql prompt, I have tried:
GRANT ALL PRIVILEGES ON *.* TO MyUser@% IDENTIFIED BY 'myPass';

And I get a SQL error every time. Anyone have any ideas?

Thanks, Chester