Fulltext results:

MySQL: Backup @info:mysql:database

4 Hits, Last modified: 12 years ago

h> # set or replace the variables $USER and $PASS DATE_YMD=$(date "+%Y-%m-%d") DATABASES=$(mysql --batch -u${USER} -p${PASS} mysql --execute='show databases')... dd-drop-table -u${USER} -p${PASS} ${DB} > ${DB}_${DATE_YMD}.sql & bzip2 ${DB}_${DATE_YMD}.sql & # sleep 10 # optional done wait # for child processes

MySQL: Change Password @info:mysql:user

1 Hits, Last modified: 11 years ago

an alternatively use the following: <code sql> UPDATE mysql.user SET Password=PASSWORD('{passwd}') WHER

MySQL: Create User @info:mysql:user

1 Hits, Last modified: 9 years ago

PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE D