Login Problem
Hi
I've got a problem here...
A DB was created, and grant privileges were given, but no password was specified, and somehow it reset the root password to nothing, and so I can't change the PW back because anonymous users can't change passwords...
Help me out
thanks
Mark Hensler posted this at 02:22 — 18th April 2002.
He has: 4,048 posts
Joined: Aug 2000
I don't see how that could have effected the root user. Anyway...
I think you'll neet root access to the server, and I believe the command you want is this:
mysqladmin -u root password
You can find more into in the man pages.
Mark Hensler
If there is no answer on Google, then there is no question.
mairving posted this at 02:44 — 18th April 2002.
They have: 2,256 posts
Joined: Feb 2001
Or if you are logged in as root on your Linux box, simply type in:
mysql
This assumes root user, localhost and it will prompt for a password if root has one.
Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states
nike_guy_man posted this at 00:33 — 19th April 2002.
They have: 840 posts
Joined: Sep 2000
I tried changing the root password, but it says that anonymous users cannot change passwords
I can login using mysql from the command line, but I can't get in through PHP
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.