/    Sign up×
Community /Pin to ProfileBookmark

mysql lock-out prob, suggestions?

Copy linkTweet thisAlerts:
Nov 01.2004

I realise this isn’t specifically a PHP problem but a) there’s no mysql forum here, b) I normally post on the php forum, and c) my project is to eventually connect to the DB via PHP, my language.

——–

Whenever I change a user’s password in the mysql monitor, via…

mysqladmin -u root -p password ‘newpass’

…it fails. It accepts the argument as expected, but any time after that I have to use the root password it fails to connect. whether I try the old password or the new one, it seems I’m locked out. why is the change password command setting it to something unbeknown to me? It’s driving me mad!

Cheers.

to post a comment
PHP

2 Comments(s) ↴

Copy linkTweet thisAlerts:
@this213Nov 03.2004 — mysqladmin -u root -p oldpassword password newpassword
Copy linkTweet thisAlerts:
@mityaauthorNov 03.2004 — Thanks man - my book deffo says "newpassword", and only says to replace newpassword, not the quotes as well. What a disaster.
×

Success!

Help @mitya spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.17,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...