Difference between revisions of "User:Olenz"
Jump to navigation
Jump to search
(→MySQL) |
(→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 <pre>mysql -u root -p</pre> |
− | + | * Create a user <pre>CREATE USER <user> IDENTIFIED BY '<password>';</pre> | |
− | * Create a user | + | * Create a DB <pre>CREATE DATABASE <dbname>;</pre> |
− | + | * Grant full access on DB to user <pre>GRANT ALL ON <dbname>.* TO <user>;</pre> | |
− | * Create a DB | ||
− | |||
− | * Grant full access on DB to user | ||
− | |||
== Useful things == | == Useful things == |
Revision as of 09:53, 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
mysql -u root -p
- 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>;
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