svang Posted November 1, 2003 Share Posted November 1, 2003 I am new to PHP and MySQL. I install php and everything went ok but when i install mysql, the installation went well but i ca not use it. I am currently running on a windows machine. When I try to create a database, this is the error I receive \"ERROR 1044: Access denied for user: \'@localhost\' to database \'portal\'\". I don\'t know what this means but I did create a hosts file in my WINNT folder. This did not solve the problem. I try using mysql -u (username) -p (password), this also gives me the same error message. Please help, all suggestions are welcome. Quote Link to comment Share on other sites More sharing options...
shivabharat Posted November 1, 2003 Share Posted November 1, 2003 Its lookd like the user doenst have enough privelage try logung as mysql -u root and by default they dont have password unless you have set one. Once you have got in as a super user. mysql> use mysql mysql> select * froom user; You will see the table being displayed check if you have given teh user permission. Now you can also use a tool called SQLYOG found at www.sqlyog.com which is a GUI based tool and can help you a lot. Check it out... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.