Fulltext results:
- Formatting Syntax @wiki
- post mirc mk-61 mmix modula2 modula3 mpasm mxml mysql nagios netrexx newlisp nginx nimrod nsis oberon2 ... f phix php-brief php pic16 pike pixelbender pli plsql postgresql postscript povray powerbuilder powershell proftpd progress prolog properties providex pureb... scilab scl sdlbasic smalltalk smarty spark sparql sql sshconfig standardml stonescript swift systemveri
- MySQL: Create User @info:mysql:user
- ====== MySQL: Create User ====== ==== Create User ==== <code sql> CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}... ==== * Usually, ''{user}'' == ''{db}'' <code sql> CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}... {user}'@'%'; </code> Simpler Alternative: <code sql> CREATE DATABASE IF NOT EXISTS `dbname` DEFAULT C
- Home Server Goals @blog:2010
- re. This includes PHP and JEE applications with MySQL as database. * **LAN Gateway**: I want to sercu... tches). {{tag>backup homeserver java mac osx mediaserver mysql opensolaris php ssh virtualbox webapp}}
- mysql @tag
- ====== mysql ====== ===== Pages ===== {{topic>mysql&nouser&tags}} ===== Bookmarks ===== {{rss>http://www.andunix.net/link/rss/all/mysql}}
- sql @tag
- ====== sql ====== ===== Pages ===== {{topic>sql&nouser&tags}} ===== Bookmarks ===== {{rss>http://www.andunix.net/link/rss/all/sql}}
- MySQL: Change Password @info:mysql:user
- ====== MySQL: Change Password ====== * 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... r you can alternatively use the following: <code sql> UPDATE mysql.user SET Password=PASSWORD('{passwd}') WHERE User='{user}'; FLUSH PRIVILEGES; </code> {
- Oracle: Resize Instance @info:oracle
- , change the [[spfile_and_pfiles|SPFile]]: <code sql> ALTER SYSTEM SET pga_aggregate_target = 2G SCOPE... (optionally) export the SPFile to a PFile: <code sql> CREATE PFILE FROM SPFILE; </code> Finally, reboot the instance to activate the change: <code sql> SHUTDOWN IMMEDIATE; STARTUP; </code> {{tag>admi
- Oracle: SPFile and PFiles @info:oracle
- File, just enter the following in SQLplus: <code sql> CREATE PFILE FROM SPFILE; </code> It will creat... to the PFile instead of ${PATH_TO_PFILE}. <code sql> SHUTDOWN IMMEDIATE; STARTUP NOMOUNT PFILE='${PAT... itweb.ora'', the the second line would be: <code sql> STARTUP NOMOUNT PFILE='/db/oracle/config/pfiles/... he init param in memory and in the SPFile. <code sql> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=8G S
- Oracle: SQLplus Scripting @info:oracle
- eader or other stuff, enter the following: <code sql> SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PA
- Oracle: List Accounts with Objects @info:oracle
- ts (like tables), you can query them with: <code sql> SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY ... ist all accounts, you can query them with: <code sql> SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME; </code> Or, if you only want the DBAs: <code sql> SELECT USERNAME FROM DBA_USERS ORDER BY USERNAME
- Oracle: Recovery Manager @info:oracle
- ll archive logs but keep the last 45 days: <code sql> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE ... rompting, e.g. via cron, after backup run: <code sql> DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE
- Travian Map Download Script @z:travian
- is is my script(s) which I use to downoad the map.sql from Travian and import it to the database. ====... n DUMP_DIR=/srv/glassfish/domains/domain1/docroot/sql # # executables MYSQL="/srv/mysql/bin/mysql --default-character-set=utf8 -u${DB_USER} -p${DB_PASS} ${DB_INST}" MYSQLDUMP="/s
- MySQL: Remove User @info:mysql:user
- ====== MySQL: Remove User ====== ==== Remove User ==== <code sql> DROP USER '{user}'@'%'; </code> ==== Remove Use... Database ==== * Usually, {user} == {db} <code sql> DROP USER '{user}'@'%'; DROP DATABASE '{db}'; </code> {{tag>admin database mysql sql}}
- MySQL @info:mysql
- ====== MySQL ====== {{indexmenu>.}}
- MySQL: View Permissions @info:mysql:permissions
- ====== MySQL: View Permissions ====== ==== View Permissions ==== <code sql> SHOW PRIVILEGES; SHOW GRANTS FOR '{user}'@'%'; </code> {{tag>admin database mysql sql}}