Difference between revisions of "User:Olenz"
Jump to navigation
Jump to search
(→MySQL) |
(→MySQL) |
||
Line 29: | Line 29: | ||
* Create a user <pre>CREATE USER <user> IDENTIFIED BY '<password>';</pre> | * Create a user <pre>CREATE USER <user> IDENTIFIED BY '<password>';</pre> | ||
* Create a DB <pre>CREATE DATABASE <dbname>;</pre> | * Create a DB <pre>CREATE DATABASE <dbname>;</pre> | ||
− | * Grant full access on DB to user <pre>GRANT ALL ON <dbname>.* TO <user>;</pre> | + | * Grant full access on DB to user <pre>GRANT ALL ON <dbname>.* TO <user>@<where>;</pre> for example <pre>GRANT ALL ON testwiki.* TO testwiki@localhost;</pre> |
== Useful things == | == Useful things == |
Revision as of 09:58, 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>@<where>;
for exampleGRANT ALL ON testwiki.* TO testwiki@localhost;
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