Linked Questions

9
votes
9answers
29k views

How can I reset the password for MySQL? [duplicate]

I have an old MySQL installation for which I do not have the password. How can I reset the password? My first idea was to completely remove it and reinstall with a new password. I am using Windows ...
3
votes
5answers
23k views

Access denied for user 'root@localhost' (using password:NO) [duplicate]

I am attempting to install a network management package called cacti onto Ubuntu running under Windows Virtual PC. I attempted to install MySQL as it is one of cacti's dependencies. I can install and ...
2
votes
3answers
3k views

Adding a MySQL user when no MySQL users have admin rights? [duplicate]

I'm working on a MySQL installation that has a user already created ("admin"), but that user doesn't have a password, and doesn't have any permissions, so I can't create new users or even reset the ...
5
votes
4answers
267 views

reseting mysql root password [duplicate]

Is there a mysql command to reset the root password? I am trying mysql -p -u root but I've forgotten the password. Is there any way to reset the password?
0
votes
1answer
971 views

Lost MySQL password [duplicate]

I've tried reinstalling mysql and I've tried the steps outlined here, but none of the commands work without a password. I'm using Ubuntu, Apache 2.2, and Webmin 1.550. Thanks in advance!
0
votes
1answer
2k views

Cannot reset password to access MySQL from PHPMyAdmin in EasyPHP [duplicate]

I have had the EasyPHP WAMP running fine for the past month, but I just followed MySQL's advice to put a password on 'root' user and now when I try to access MySQL from PHPMyAdmin I get the message: ...
2
votes
4answers
1k views

reset forgotten mysql password [duplicate]

I followed this link (http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html) to reset my forgotten password in mysql server on windows machine. I'm getting the following error, ...
2
votes
1answer
1k views

MySQL: “UPDATE command denied to user ''@'localhost'” [duplicate]

For some reason when I installed MySQL on my machine (a Mac running OS X 10.9) the 'root' MySQL account got messed up and I don't have access to it, but I do have access to the standard MySQL account ...
2
votes
2answers
501 views

Reset mysql root password after phpmyadmin corrupted it [duplicate]

So I tried to change my mysql root password for the first time using a advanced pattern and it looks like phpmyadmin stripped the password on save. Now I can't login under root. I am using RHEL 5 ...
1
vote
3answers
302 views

Reset MySQL Password [duplicate]

Ok, so I changed my password through phpMyAdmin and it's completely locked out my access to the root mysql user. There are various articles about this online, but none of them seem to work. Here's ...
1
vote
2answers
116 views
1
vote
1answer
136 views

Completely reset mysql server authentication [duplicate]

I was trying to change the password for a user on a mysql server, and i appear to have locked myself out. I have access to the root user, but root doesn't have the privileges to access any databses, ...
-3
votes
2answers
88 views

MySQL error no. 1045 [duplicate]

I am working on a college project, I installed MySQL Server 5.4. When I create a new connection, it gives a error, MySQL error number 1045 Access denied for user 'root'@'localhost'(using password: ...
1
vote
1answer
77 views

Reset MySQL password doesn't work (can't connect without granted tables) on OSX [closed]

Let me start by saying that I've looked through tons of posts (both here and elsewere on the internet and the article on mysql.com about resetting the admin password) about resetting the mysql ...