Linked Questions

9
votes
9answers
30k 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
24k 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
309 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
1k 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
3k 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
1answer
3k 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
4answers
2k 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
2answers
553 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
345 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
121 views
1
vote
1answer
142 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
91 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: ...
0
votes
0answers
6 views

Couldn't connect to MySQL remotly without skip-grant-tables option [duplicate]

I trying to connect to MySQL remotely over a Win Server 2012 EC2 instance, to do so I'd: Enabled inbound traffic to MySQL port 3306 in the EC2 Security Group; Disabled Windows Firewall service. ...
0
votes
0answers
5 views

ERROR 1045 (28000): Access denied for user root [duplicate]

All of my non root users can still connect and all of my websites and applications work fine. I recently discovered that I was no longer able to login as root when trying to login to phpmyadmin. I've ...

15 30 50 per page