Difference between revisions of "User:Olenz"
Jump to navigation
Jump to search
(→MySQL) |
|||
Line 26: | Line 26: | ||
* MySQL is running on elk | * MySQL is running on elk | ||
* For applications, allow access only from localhost | * For applications, allow access only from localhost | ||
− | * Log in < | + | * Log in via <code>mysql -u root -p</code> |
+ | * MySQL commands: | ||
# create a user | # create a user | ||
CREATE USER <user> IDENTIFIED BY '<password>'; | CREATE USER <user> IDENTIFIED BY '<password>'; | ||
# create a db | # create a db | ||
− | + | CREATE DATABASE <dbname>; | |
# Grant full access on DB to user | # Grant full access on DB to user | ||
Line 37: | Line 38: | ||
# Example: Grant full access to user testwiki from localhost | # Example: Grant full access to user testwiki from localhost | ||
GRANT ALL ON testwiki.* TO testwiki@localhost; | GRANT ALL ON testwiki.* TO testwiki@localhost; | ||
− | + | ||
# Revoke access | # Revoke access | ||
REVOKE ALL ON testwiki.* FROM testwiki; | REVOKE ALL ON testwiki.* FROM testwiki; |
Revision as of 10:13, 13 April 2011
Problems with the skin
- Page looks strange on IE 6
- Page width problem
- Left and right border of the footer
- Logo has black background
- Font size in header nav tabs is too large
Quick links
Administration stuff
Granting SVN access to external users
Description: http://svnbook.red-bean.com/en/1.1/ch06s03.html
- Get the public ssh key of the user.
- Append the public ssh key to /home/svn/.ssh/authorized_keys.
- Insert
command="svnserve -r /home/svn/repos -t --tunnel-user=<user>",no-port-forwarding,no-agent-forwarding,no-X11-forwarding,no-pty
before the key. Now the user can only execute the SVN command, and any other command will be ignored.
MySQL
- MySQL is running on elk
- For applications, allow access only from localhost
- Log in via
mysql -u root -p
- MySQL commands:
# create a user CREATE USER <user> IDENTIFIED BY '<password>'; # create a db CREATE DATABASE <dbname>; # Grant full access on DB to user GRANT ALL ON <dbname>.* TO <user>@<where> # Example: Grant full access to user testwiki from localhost GRANT ALL ON testwiki.* TO testwiki@localhost; # Revoke access REVOKE ALL ON testwiki.* FROM testwiki;
Useful things
Useful things for LaTeX
Inside
- PDFLaTeX
- can use PDF, JPG, PNG
- use filename without extension!
- use
epstopdf
to convert EPS
- graphicsdir
- empty lines are significant
- Difference between
\\
and an empty line - LaTeX 2.09 vs. LaTeX 2ε
\documentstyle
→\documentclass
\it
,\em
, ... →\textit
,\emph
(Differences at the end!)- If anything, use
\itshape
- In general: prefer commands over declarations
- Koma-script classes
- Packages xspace, todonotes, inputenc, fontenc, lmodern, german/babel
Outside
texdoc
kpsewhich
latexmk