| View previous topic :: View next topic |
| Author |
Message |
Moriah
Advocate
Joined: 27 Mar 2004
Posts: 2365
Location: Kentucky
|
 Posted: Sun Jun 23, 2013 2:19 am Post subject: HELP - how do I change passwords in mysql? SOLVED |
 |
|
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! 
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. 
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. 
_________________
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 |
|
 |
TomWij
Retired Dev
Joined: 04 Jul 2012
Posts: 1553
|
| Posted: Sun Jun 23, 2013 7:30 pm Post subject: |
|
|
| SET PASSWORD FOR 'mailsql'@'localhost' = PASSWORD('the password I wanted'); |
|
| Back to top |
|
|
Moriah
Advocate
Joined: 27 Mar 2004
Posts: 2365
Location: Kentucky
|
| Posted: Sun Jun 23, 2013 7:34 pm Post subject: |
|
|
Thanks! That worked! 
_________________
The MyWord KJV Bible tool is at http://www.elilabs.com/~myword
Foghorn Leghorn is a Warner Bros. cartoon character. |
|
| Back to top |
|
|
|
|
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
|
|
Portage & Programming
