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
> -> IDENTIFIED BY 'password' WITH GRANT OPTION;
> 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
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)