http://www.linux-tips-and-tricks.de

Wer die SQL Beispiele von dieser Seite ausprobieren will benötigt ein mySQLServer. Das ist schnell gemacht und im folgenden sind die Schritte beschrieben, wie man mySQL auf Mint11 installiert und konfiguriert. Auf anderen Linux Distributionen wird es sich nur bei der Art, wie mySQL installiert wird, unterscheiden.

 

===> English <===

 

If you want to use the SQL example files from this website and execute them on your system you have to setup a mySQL database on your system. It's quite easy and the following steps describe how to setup and configure mySQL on Linux Mint11. On other Linux distributions the way to install mySQL will be the only different step.

 

===> Click here for English <===

 

2b) GRANT ALL PRIVILEGES ON *.* TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

 

===> English <===

 

1) Install

1a) mySQL server

      Menu -> Softwaremanager -> MySQL Server(Mysql database server binaries and system database setup)

1b) Install mysql-workbench and/or phpmyadmin is a too to access the mySQL server with a GUI either with gnome or with a web frontend

      Menu -> Softwaremanager -> gmysqlccoder or phpmyadmin

2) Open a command line and execute follwing steps and replace yourpassword and yourusername with your local values

2a) su -

2b) mysql -u root

2c) GRANT ALL PRIVILEGES ON *.* TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

2d) quit

 

Now you have a started mySQL server and can use the SQL sample files to createsample data and to execute SQL queries.