Member Avatar for cpopham
cpopham 0 Junior Poster in Training

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

  • 1 Contributor
  • 0 Replies
  • 85 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.