List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:June 7 1999 4:40pm
Subject:Re: Granting privileges
View as plain text  
Online Designs wrote:
> I'm not sure what I'm doing wrong...I've followed the directions from
> the manual, but it's still not working.  This is what I get when I try
> to grant privileges to a new user:
> mysql> GRANT ALL PRIVILEGES ON *.* TO wwstaiwan@localhost
> ERROR 1064: parse error near '*.* TO wwstaiwan@localhost
> IDENTIFIED BY 'password' WITH GRANT OPTION' at line 1
> Obviously, I had a different password in there for 'password', but what
> am I doing wrong?  I can open mysql using the username above, but if I
> put in the password with it, it throws errors:
> ccsonlinedesigns: {10} % mysql -u wwstaiwan -p
> Enter password: *******
> ERROR 1045: Access denied for user: 'wwstaiwan@localhost' (Using
> password: YES)
> Also, I don't seem to be able to successfully install mysql_install_db.
>  If I try to run it, I get the following error:
> ccsonlinedesigns: {8} % /usr/local/bin/mysql_install_db
> /usr/local/bin/mysql_install_db: Command not found.
> I know that that is the correct path for the file, but it does not seem
> to be working.
> Thank you,
> Carrie

What is the output of 

ls -l /usr/local/bin/mysql_install_db

Sasha Pachev (home) (work)
Granting privilegesOnline Designs7 Jun
  • Re: Granting privilegesSasha Pachev7 Jun
  • Re: Granting privilegesBlake Binkley7 Jun
  • Granting privilegesMichael Widenius7 Jun