• skip to content

andunix.net

User Tools

  • Log In

Site Tools

  • Recent Changes
  • Media Manager
  • Sitemap
You are here: andunix.net » tab
Trace: • download • ISO 3166-2:DE • Cleanup Packages • andunix.net • Travian Village Planner • setup • rmdir for OSX • Mercurial • online • Set a Mac's Hostname

tab
Please note, that this is an old archived version of this site. Check out the new version at andunix.net!

Search

You can find the results of your search below.

Contains
  • Exact match
  • Starts with
  • Ends with
  • Contains
@info
  • Any namespace
  • info:mysql (10)
  • info:oracle (4)
  • info:db (1)
  • info:prog (1)
  • info:virtualbox (1)
Any time
  • Any time
  • Past week
  • Past month
  • Past year
Sort by hits
  • Sort by hits
  • Sort by last modified

Matching pagenames:

  • MySQL: Backup
  • MySQL: Create Database
  • Database Administration
  • MySQL: Remove Database
  • andunix Infos

Fulltext results:

MySQL: Backup @info:mysql:database
7 Hits, Last modified: 13 years ago
====== MySQL: Backup ====== ===== Export a 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 individually ===== <code bash> # set or repl... es $USER and $PASS DATE_YMD=$(date "+%Y-%m-%d") DATABASES=$(mysql --batch -u${USER} -p${PASS} mysql --e
MySQL: Create Database @info:mysql:database
6 Hits, Last modified: 13 years ago
====== MySQL: Create Database ====== ==== Create Database ==== <code sql> CREATE DATABASE IF NOT EXISTS `{db}`; </code> ==== Create Database and Grant Rights to a User ==== <code sql> CRE
Firefox Extensions @info:prog:firefox
4 Hits, Last modified: 12 years ago
ing Cookies]] |Removes cookies after closing the tab or navigating to another site. | ===== Web Deve... [https://addons.mozilla.org/firefox/addon/private-tab/|Private Tab]] |Enables private tabs, so you can be logged in with two different accounts. | |[[https://addons.m
MySQL: Remove Database @info:mysql:database
4 Hits, Last modified: 13 years ago
====== MySQL: Remove Database ====== ==== Remove Database ==== <code sql> DROP DATABASE IF EXISTS `{db}`; </code> {{tag>admin database mysql sql}}
VBoxManage (The VirtualBox CLI) @info:virtualbox
4 Hits, Last modified: 12 years ago
] [--mouse ps2|usb|usbtablet [--keyboard ps2|us... [--mtype normal|writethrough|immutable|shareable| ... iocache on|off] [--bootable on|off] [--remove] ... [--type normal|writethrough|immutable|shareable|
MySQL: Create User @info:mysql:user
4 Hits, Last modified: 10 years ago
ED BY '{passwd}'; </code> ==== Create User and Database ==== * Usually, ''{user}'' == ''{db}'' <co... _PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON... /code> Simpler Alternative: <code sql> CREATE DATABASE IF NOT EXISTS `dbname` DEFAULT CHARACTER SET =... LL ON `dbname`.* TO 'dbuser'@'dbhost' IDENTIFIED BY 'dbpass'; </code> {{tag>admin database mysql sql}}
MySQL: Remove User @info:mysql:user
3 Hits, Last modified: 13 years ago
SER '{user}'@'%'; </code> ==== Remove User and Database ==== * Usually, {user} == {db} <code sql> DROP USER '{user}'@'%'; DROP DATABASE '{db}'; </code> {{tag>admin database mysql sql}}
Thunderbird Extendsions
2 Hits, Last modified: 13 years ago
.mozilla.org/thunderbird/addon/lightning-calendar-tabs/|Lightning Calendar Tabs]] * [[https://addons.mozilla.org/thunderbird/addon/mailredirect/|Mail Redi
Oracle @info:oracle
2 Hits, Last modified: 10 years ago
http://www.oracle.com/pls/db102/homepage|Oracle Database Online Documentation 10g Release 2 (10.2)]] ... http://www.oracle.com/pls/db112/homepage|Oracle Database Online Documentation 11g Release 2 (11.2)]] {
Oracle Errors @info:oracle
1 Hits, Last modified: 13 years ago
882_01/server.112/e10880/e0.htm#sthref197|11.2]] {{tag>database documentation error oracle reference}}
MySQL: Revoke Permissions @info:mysql:permissions
1 Hits, Last modified: 13 years ago
e sql> REVOKE ALL PRIVILEGES ON `{db}` . * FROM '{user}'@'%'; </code> {{tag>admin database mysql sql}}
MySQL: Grant Permissions @info:mysql:permissions
1 Hits, Last modified: 13 years ago
code sql> GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </code> {{tag>admin database mysql sql}}
MySQL: Change Password @info:mysql:user
1 Hits, Last modified: 12 years ago
D('{passwd}') WHERE User='{user}'; FLUSH PRIVILEGES; </code> {{tag>admin database mysql password sql}}
Database Administration @info:mysql:database
1 Hits, Last modified: 13 years ago
====== Database Administration ====== {{indexmenu>.}}
Oracle: List Accounts with Objects @info:oracle
1 Hits, Last modified: 13 years ago
= To list all accounts (users) the objects (like tables), you can query them with: <code sql> SELECT
Database @info:db
1 Hits, Last modified: 13 years ago
Oracle: Recovery Manager @info:oracle
1 Hits, Last modified: 13 years ago
MySQL: View Permissions @info:mysql:permissions
1 Hits, Last modified: 13 years ago

Page Tools

  • Show page
  • Old revisions
  • Backlinks
  • Back to top
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution 4.0 International
CC Attribution 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki