====== MySQL-Server ======



===== Automatisierte MySQL-Konfiguration für viele Benutzer =====

  * Web-Interface zum User einrichten
  * User wird als Benutzer eingerichtet
  * User hat somit eigenen Web-Space
  * User bekommt eigene Datenbank und Zugang zu PHPMyAdmin




==== Apache-Config ====

Will ich bei Arktur abkucken...





==== MySQL-Config ====

Optionen von ''mysql'' unter Debian:
<code>
-u, --user=name     User for login if not current user.
 --database=db_name, -D db_name
          The database to use. This is useful primarily in an option file.
--host=host_name, -h host_name
          Connect to the MySQL server on the given host.
--password[=password]                | password               | The password to    |            |
       |                                     |                        | use when           |            |
       |                                     |                        | connecting to the  |            |
       |                                     |                        | server   

</code>

==== User einrichten ====

==== Datenbank erzeugen ====

==== Script dazu ====
Python?



===== root-Passwort zurücksetzen =====

Die folgende Anleitung habe ich auf [[http://blog.dotkam.com/2007/04/10/mysql-reset-lost-root-password/|dieser Seite]] gefunden. Ich habe sie erheblich gekürzt und an meine Bedürfnisse angepasst.

==== Step 1: Stop MySQL daemon if it is currently running ====
  /etc/init.d/mysql stop
Mittlerweile sollte das mit 
  service mysql stop
gehen.

==== Step 2: Run MySQL safe daemon with skipping grant tables ====
  mysqld_safe --skip-grant-tables &

==== Step 3: Login to MySQL as root with no password ====
  mysql -u root mysql

==== Step 4: Run UPDATE query to reset the root password ====
In MySQL command line prompt issue the following two commands:
  UPDATE user SET password=PASSWORD("ualue=42") WHERE user="root";
  FLUSH PRIVILEGES;
“ualue=42” is a common password for “The Hitchhiker’s Guide to the Galaxy” people which reads “Ultimate Answer to Life, the Universe, and Everything=42“

==== Step 5: Stop MySQL safe daemon ====
Look at "Step 1".

==== Step 6: Start MySQL daemon ====
Depending on the operating system (Unix-like examples):
  /etc/init.d/mysql start
or:
  service mysql start

==== Step 7: Root password is reset and ready to use ====
Password is reset. Privileges are flushed. Start MySQL and login as root with the password set in step 4:
  mysql -u root -p mysql