Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'MySQL Access Denied' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
MySQL Access Denied
Authored by: hrair on May 05, '01 12:46:26AM
I think I'm banging my head on my desk too much and skipping some medication is not helping either but here's my problem:

I did as the article said and deleted the row from the user table:

delete from user where host='localhost' and user='';
quit;


but now I can't connect or do anything else. It is running. I can see it in the ps list. Here's what I get:

shell> mysql -u root test
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)


Is there a way I can uninstall MySQL and try again except this time i'll skipp the delete step.
TIA,
-Hrair

[ Reply to This | # ]
MySQL Access Denied
Authored by: CodeOfficer on May 30, '01 01:22:59AM
What the hell, ... I'm having the same problem.

I wish macosxhints would try some of their suggestions out first before they get offered to the community. Perhaps removing some of the older "hints" that might be outdated would also be beneficial.

-CodeOfficer

[ Reply to This | # ]
MySQL Access Denied
Authored by: theolein on Jun 03, '01 07:47:56PM

try typing :
..... ./mysql -u root -p [enter]
you should get a prompt for your root password that you *should* have given mysql when you installed it in the first place



[ Reply to This | # ]
MySQL Access Denied
Authored by: Kintaro on Oct 18, '01 01:49:47AM

I used the command to set the root password when I installed, and now no SQL database on MySQL can be accessed by PHP. They all return that they can't find the database that I just created, with no other error message. Not only that, but I had to include the login and password for my root account in my PHP document, which is bad. I made the mysql user on my system, but it doesn't have permission to access this database. This is all getting rather annoying with permissions.... if anyone has any help to offer, please do.

Kintaro



[ Reply to This | # ]