MySQL Forums
Forum List  »  Newbie

Access denied for user - new setup issue
Posted by: julesjohn
Date: August 08, 2004 10:44PM

I just setup an instance of MySQL on a Windows XP Pro machine. I am attempting to setup a few new PHP applications. My web server has been working fine and running PHP no problem. The MySQL windows service is running too.

I believe all my issues are related to security in relation to user/pwd issues. In the example below I am using the default user with no password out of box. But I have tried with no luck too using the user and password I modified in the my.ini file via the WinMySQLAdmin 1.4 GUI.

So being a newbie of course I am doing something wrong. Thanks for the help...

From CMD window:

mysql> create database mynewdatabase; GRANT ALL ON mynewdatabase.* TO mynewuser@localhost IDENTIFIED BY "mynewuserpassword";

Error 1044: Access denied for user: '@localhost' to database 'mynewdatabase'

Options: ReplyQuote

Written By
Access denied for user - new setup issue
August 08, 2004 10:44PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.