Difference between revisions of "User:Olenz"

From ICPWiki
Jump to: navigation, search
(MySQL)
(MySQL)
Line 27: Line 27:
 
* For applications, allow access only from localhost
 
* For applications, allow access only from localhost
 
* Log in <pre>mysql -u root -p</pre>
 
* 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>
+
CREATE USER <user> IDENTIFIED BY '<password>';
* 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>
+
 +
# create a db
 +
Create a DB <pre>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 ==

Revision as of 09:11, 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

  1. Get the public ssh key of the user.
  2. Append the public ssh key to /home/svn/.ssh/authorized_keys.
  3. 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 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