Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
# mysql -u root -p ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Anyone know how to reset this password?
Forgot mysql ROOT password
Started by
Guest_Wanch_*
, Nov 17 2008 06:05 AM
20 replies to this topic
#1
Guest_Wanch_*
Posted 17 November 2008 - 06:05 AM
Guest_Wanch_*
Guest_Wanch_*
-
- Guests
It isn't on a machine that clients use but on a local machine I have for messing around with. The problem is I can't remember what the root user password is for MySQL.
Anyone know how to reset this password?
Anyone know how to reset this password?
Back to top|
|
|
#2
Guest_Jordan_*
Posted 19 November 2008 - 04:52 AM
Guest_Jordan_*
Guest_Jordan_*
-
- Guests
Ah, I've been there before. MySQL Manual has a great reference on how to do it for both Linux and Windows:
MySQL :: MySQL 5.0 Reference Manual :: B.1.4.1 How to Reset the Root Password
Let me know if you need any help.
MySQL :: MySQL 5.0 Reference Manual :: B.1.4.1 How to Reset the Root Password
Let me know if you need any help.
#3
Posted 26 November 2008 - 06:27 AM
TcM
-
- Members
-
- 11,147 posts
Writes binary right handed and hex left handed
That's bad mate. Did you solve it?
#4
Guest_SexYLinuX_*
Posted 26 November 2008 - 06:48 AM
Guest_SexYLinuX_*
Guest_SexYLinuX_*
-
- Guests
Don't you think that having the functionality of resetting the password can compromise security?
#5
Posted 26 November 2008 - 09:02 AM
Tor
-
- Members
-
- 486 posts
Programming Expert
I think it can but if someone can gain root access to your system your security is already gone anyway.
#6
Posted 28 November 2008 - 04:15 AM
TcM
-
- Members
-
- 11,147 posts
Writes binary right handed and hex left handed
True. Because that means that they already hacked you...
#7
Guest_SexYLinuX_*
Posted 28 November 2008 - 06:05 AM
Guest_SexYLinuX_*
Guest_SexYLinuX_*
-
- Guests
Hmm.. no I mean if the hack the database server, can't they hack the root account and gain root access on the database?
#8
Posted 29 November 2008 - 01:43 AM
TcM
-
- Members
-
- 11,147 posts
Writes binary right handed and hex left handed
I've got no idea if that is possible.
#9
Posted 29 November 2008 - 02:01 AM
HappyUser
-
- Members
-
- 40 posts
Learning Programmer
Unless you hack the root user I don't think you will be able to hack his databases....right?
#10
Guest_Jordan_*
Posted 29 November 2008 - 06:36 AM
Guest_Jordan_*
Guest_Jordan_*
-
- Guests
In MySQL you set where people are allowed from. Most users are set to only access MySQL via localhost. Unless you have setup bad security permissions and have allowed users to access MySQL from any IP then you could risk being hacked.
#11
Posted 30 November 2008 - 08:12 AM
TcM
-
- Members
-
- 11,147 posts
Writes binary right handed and hex left handed
So the only way to access it from localhost would mean that they have to hack your root, right?
