|
|
|
Similar results: "PostgreSQL Notes"
- MySQL Notes
- Upgrade MySQL script Extract a single database from a dump file of all databases GRANT SELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,CREATE,DROP ON database.* TO user@'10.1.1.%' IDENTIFIED by 'password';
echo "Starting MySQL"
cd /usr/local/mysql; ./bin/safe_mysqld --user=mysql &
echo...
- PostgreSQL Notes
- Compile from source Client-only installation: Create user and database Create a certificate and install Values to change in ~postgres/postgresql.conf Set table owners:
Compile from source
./configure --with-perl --with-openssl
make -j6
su nobody -c "make check"
make install
/usr/sbin...
- Oracle Notes
- To view the current connections to Oracle:
sqlplus> select machine, osuser, count(*) "Connections" from v$session group by machine, osuser;
|
 |
