Fulltext results:
- MySQL: Create User @info:mysql:user
- ====== MySQL: Create User ====== ==== Create User ==== <code sql> CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; </code> ==== Create User and Database ==== * Usually, ''{use
- base-exec-user @z:relax:api:base
- ====== base-exec-user ====== Executes a command as a given user. Command is executed using ssh if the user is not on localhost. ===== Usage ===== base-exec-user USER COMMAND * ''USER'': A key of an user defi
- MySQL: Remove User @info:mysql:user
- ====== MySQL: Remove User ====== ==== Remove User ==== <code sql> DROP USER '{user}'@'%'; </code> ==== Remove User and Database ==== * Usually, {user} == {db} <code sql> DROP
- base-exec-superuser @z:relax:api:base
- c-superuser ====== Executes a command as a given user. Command is executed using ssh if the user is not on localhost. Before executing the command, the privi... sudo''. ===== Usage ===== base-exec-superuser USER COMMAND * ''USER'': A key of an user definition in the repository. From this, the following properti
- MySQL: Change Password @info:mysql:user
- * Replace ''{passwd}'' with the password of the user. * Replace ''{user}'' with the name of the user. <code sql> GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY '{passwd}'; FLUSH PRIVILEGES; </code> Or
- MySQL: Backup @info:mysql:database
- ==== <code bash> # set or replace the variables $USER, $PASS and $DB mysqldump --add-drop-table -u${USER} -p${PASS} ${DB} </code> ===== Export all Databases... ==== <code bash> # 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
- base-ssh-login @z:relax:api:base
- t's used by other methods (especially [[base-exec-user]]) to remotely execute a command. ===== Usage ==... SERVICE [ COMMAND ] * ''SERVICE'': a key of an user or host definition in the repository. From this, ... ned, ''HOST_REF'' must be present. * ''REMOTE_USER'' (optional): The user execute the command remotely. If not present, same as local user will be taken.
- Travian Map Download Script @z:travian
- ==== config.inc ===== <code bash> # # database DB_USER="travian" # set this to your database user DB_PASS="travian" # set this to your database password DB_IN... sql/bin/mysql --default-character-set=utf8 -u${DB_USER} -p${DB_PASS} ${DB_INST}" MYSQLDUMP="/srv/mysql/bin/mysqldump -u${DB_USER} -p${DB_PASS} ${DB_INST}" WGET="/usr/bin/wget -nv
- Oracle: EXP @info:oracle
- ount ===== Enter the account name insteand of ''{user}''. <code bash> exp USERID=\'/ as sysdba\' FILE={user}.dmp FULL=N OWNER={user} </code> {{tag>admin exp oracle}}
- host-user-list @z:relax:api:host
- ====== host-user-list ====== Lists the users on a given host. ===== Usage ===== host-user-tab HOST * ''HOST'': a key of a host service d... e. ===== Example ===== <code bash> users=$(host-user-list "${host}" \ | egrep -v "${IGNORED_USERS}" )
- Project PDA @blog:2011
- ter the Star Trek Pads, it implements the GUI (or User Experience) facing the user. Can be a desktop app, web app or smartphone app. Whatever is next to the user. So far for now, stay tuned. {{tag>java program
- Project PDA @p:pda
- ter the Star Trek Pads, it implements the GUI (or User Experience) facing the user. Can be a desktop app, web app or smartphone app. Whatever is next to the user. ===== Sub-Projects ===== {{indexmenu>.#1}} ==
- root login with bash @info:script
- '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 wi
- host-user-tab @z:relax:api:host
- ====== host-user-tab ====== Lists the users on a given host as a colon separated table. ===== Usage ===== host-user-tab HOST * ''HOST'': a key of a host service d
- MySQL: Create Database @info:mysql:database
- code> ==== Create Database and Grant Rights to a User ==== <code sql> CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </code> {{tag>admin database mysql sql}}
