Difference between revisions of "Quick Notes"

From Secure Computing Wiki
Jump to: navigation, search
(MySQL Stuff)
(MySQL Stuff)
Line 34: Line 34:
 
* Forcibly change a user's password: '''SET PASSWORD FOR user=PASSWORD('password');'''
 
* Forcibly change a user's password: '''SET PASSWORD FOR user=PASSWORD('password');'''
 
* Add New Database User: '''GRANT ALL PRIVILEGES ON db.table to 'user'@'host' IDENTIFIED BY 'password';'''
 
* Add New Database User: '''GRANT ALL PRIVILEGES ON db.table to 'user'@'host' IDENTIFIED BY 'password';'''
 +
** You can use '''%''' to denote ANY host
 +
*** '''%''' purposely EXCLUDES localhost.  If you want a local host account you'll need to create two - one for local and one for others.
  
 
==== Links ====
 
==== Links ====
 
* [http://www.howtogeek.com/howto/programming/mysql-give-root-user-logon-permission-from-any-host/ http://www.howtogeek.com/howto/programming/mysql-give-root-user-logon-permission-from-any-host/]
 
* [http://www.howtogeek.com/howto/programming/mysql-give-root-user-logon-permission-from-any-host/ http://www.howtogeek.com/howto/programming/mysql-give-root-user-logon-permission-from-any-host/]

Revision as of 14:32, 18 July 2007

This page is to list all of those quick, often one-line, commands or hints that help during the course of system administration.

MediaWiki Notes

This section is for all the stuff you can do or need to do with Media Wiki that isn't found in an easy location.

Command Line Foo

iPhone Notes

Windows (Bleh) Notes

SpamAssassin

Postfix

http://www.freesoftwaremagazine.com/articles/secure_email_servers_from_scratch_with_freebsd_6_part_2

Postfix How-To

vMail.Admin

Link sudo to /usr/bin/sudo

# ln -s /usr/local/bin/sudo /usr/bin/sudo

Firefox

  • No Scroll Tabs: goto about:config, set browser.tabs.tabMinWidth=1
  • Close on Tab: goto about:config, set browser.tabs.closeButtons=1

MySQL Stuff

  • Forcibly change a user's password: SET PASSWORD FOR user=PASSWORD('password');
  • Add New Database User: GRANT ALL PRIVILEGES ON db.table to 'user'@'host' IDENTIFIED BY 'password';
    • You can use % to denote ANY host
      • % purposely EXCLUDES localhost. If you want a local host account you'll need to create two - one for local and one for others.

Links