Archive for MySQL

Aug
28

Bourne Shell Logging Routine

Posted by: celso | Comments (0)

Here’s another logging routine, this one is written in Bourne shell:

#!/bin/sh

log_message() {
    echo `date "+%m/%d/%y %H:%M:%S %Z"` "$1" | tee -a aaa.out
}

log_message "Hello there"
log_message "Goodbye"

Sample output:

08/28/07 23:16:13 EDT Hello there
08/28/07 23:16:13 EDT Goodbye

Categories : Linux, Mac OS X, MySQL, Notes
Comments (0)
Aug
23

Setting MySQL Password

Posted by: celso | Comments (1)

To set up root password the first time:

$ mysqladmin -u root password NeWPasSwORd

To change an existing root password:

$ mysqladmin -u root -p oldpassword newpass
Enter password:

To change a normal user password:

$ mysqladmin -u dbuser-p oldpassword newpass
Categories : MySQL, Notes
Comments (1)