Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
HELP - how do I change passwords in mysql? SOLVED
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Portage & Programming
View previous topic :: View next topic  
Author Message
Moriah
Veteran
Veteran


Joined: 27 Mar 2004
Posts: 1860
Location: Kentucky

PostPosted: Sun Jun 23, 2013 2:19 am    Post subject: HELP - how do I change passwords in mysql? SOLVED Reply with quote

I followed the directions at http://www.gentoo.org/doc/en/virt-mail-howto.xml for setting up mysql to use with postfix, and at one place, they say:
Code:

mysql> GRANT SELECT,INSERT,UPDATE,DELETE
  ->     ON mailsql.*
  ->     TO mailsql@localhost
  ->     IDENTIFIED BY '$password';

Now I am not a sql person, so I did just like it said. Later on, it became apparent to me that this made my password literally $password, which of course was not what I wanted at all! :evil:

There were no directions saying to change $password to the password I wanted; I guess it was obvious to the guy who wrote it, but then he knew sql. :x

So how can I change the password to something a bit less obvious? :?:

Pardon my database ignorance, but I do mostly real-time embedded stuff, and you don't see sql databases there very often. :oops:
_________________
The MyWord KJV Bible tool is at http://www.elilabs.com/~myword

Foghorn Leghorn is a Warner Bros. cartoon character.


Last edited by Moriah on Sun Jun 23, 2013 7:34 pm; edited 1 time in total
Back to top
View user's profile Send private message
TomWij
Developer
Developer


Joined: 04 Jul 2012
Posts: 1353

PostPosted: Sun Jun 23, 2013 7:30 pm    Post subject: Reply with quote

SET PASSWORD FOR 'mailsql'@'localhost' = PASSWORD('the password I wanted');
Back to top
View user's profile Send private message
Moriah
Veteran
Veteran


Joined: 27 Mar 2004
Posts: 1860
Location: Kentucky

PostPosted: Sun Jun 23, 2013 7:34 pm    Post subject: Reply with quote

Thanks! That worked! :D
_________________
The MyWord KJV Bible tool is at http://www.elilabs.com/~myword

Foghorn Leghorn is a Warner Bros. cartoon character.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Portage & Programming All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum