https://old.andunix.net/ 2026-06-03T22:06:58+00:00 https://old.andunix.net/ https://old.andunix.net/_media/favicon.ico text/html 2016-01-25T11:49:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/create MySQL: Create User Create User CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; Create User and Database * Usually, {user} == {db} CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; GRANT USAGE ON * . * TO '{user}'@'%' IDENTIFIED BY '{passwd}' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; text/html 2013-02-04T22:17:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/remove MySQL: Remove User Remove User DROP USER '{user}'@'%'; Remove User and Database * Usually, {user} == {db} DROP USER '{user}'@'%'; DROP DATABASE '{db}'; admin database mysql sql text/html 2013-12-17T09:09:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/password MySQL: Change Password * Replace {passwd} with the password of the user. * Replace {user} with the name of the user. GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY '{passwd}'; FLUSH PRIVILEGES; Or you can alternatively use the following: UPDATE mysql.user SET Password=PASSWORD('{passwd}') WHERE User='{user}'; FLUSH PRIVILEGES; text/html 2013-02-04T22:17:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/database/backup MySQL: Backup Export a Database # set or replace the variables $USER, $PASS and $DB mysqldump --add-drop-table -u${USER} -p${PASS} ${DB} Export all Databases individually # 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') for db in ${DATABASES} do mysqldump --add-drop-table -u${USER} -p${PASS} ${DB} > ${DB}_${DATE_YMD}.sql & bzip2 ${DB}_${DATE_YMD}.sql & # sleep 10 # option… text/html 2013-03-01T20:40:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/oracle/exp Oracle: EXP Export all Objects from an Account Enter the account name insteand of {user}. exp USERID=\'/ as sysdba\' FILE={user}.dmp FULL=N OWNER={user} admin exp oracle text/html 2013-02-04T22:17:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/root_login_with_bash root login with bash On our systems, the root account is set to be a role, so you can't login as root, just su to root from an user which has the root role. Also, the root user has the bourne shell (/bin/sh), but working with /bin/bash is much easier. Using this command, you can directly log in as text/html 2013-02-04T22:17:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/database/create MySQL: Create Database Create Database CREATE DATABASE IF NOT EXISTS `{db}`; Create Database and Grant Rights to a User CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; admin database mysql sql text/html 2013-02-04T22:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/permissions/revoke MySQL: Revoke Permissions Revoke Permissions REVOKE ALL PRIVILEGES ON `{db}` . * FROM '{user}'@'%'; admin database mysql sql text/html 2013-02-04T22:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/permissions/grant MySQL: Grant Permissions Grant Permissions GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; admin database mysql sql text/html 2018-12-06T10:07:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/code/git Git Basics Init Repository Standard: git init [DIR] Bare: git init --bare [DIR] Log See commits between branches: git log master..develop Branches List Branches git branch Switch Branch git checkout BRANCH Delete Branch git branch -d BRANCH Delete Remote Branch text/html 2013-02-04T22:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/permissions/view MySQL: View Permissions View Permissions SHOW PRIVILEGES; SHOW GRANTS FOR '{user}'@'%'; admin database mysql sql text/html 2013-02-04T22:17:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/dyndns_updates_without_client DynDNS Updates without a Client My new hosting provide Strato offers DynDNS. I was searching for a DynDNS client for my OpenSolaris Home Server, but a small bash script does the job as good as any other client. #! /bin/bash . ${HOME}/.dyndns.cfg DOMAINS=$(cat ${HOME}/.dyndns.domains) echo "$(date '+%Y-%m-%d %H:%M') $(basename $0)" for domain in ${DOMAINS}; do echo -n " ${domain} - " curl --silent --show-error --insecure --user ${LOGIN} "${UPDATE_URL}?hostname=${domain}" d… text/html 2013-02-04T22:17:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/index User Administration user index text/html 2013-02-19T14:05:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/java/jps jps - Java Virtual Machine Process Status Tool The Java Virtual Machine has a jps tool wich is a bit like the ps command. jps lists all java Processes of a user. You can find the man page at <http://java.sun.com/j2se/1.5.0/docs/tooldocs/share/jps.html>. I'm using it with the parameters -l (long listing) and -m