summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMarin Jankovski <marin@gitlab.com>2014-02-20 10:10:25 +0100
committerMarin Jankovski <marin@gitlab.com>2014-02-20 10:10:25 +0100
commitacdb808abc819180529855fa2f919587fa0dec58 (patch)
treee7b7b994488d39adad84a51eedcc09d4669ec1de
parentc1dddf8c7d947691729f6d64a8ea768b5c915855 (diff)
downloadgitlab-ce-acdb808abc819180529855fa2f919587fa0dec58.tar.gz
Update database documentation.
-rw-r--r--doc/install/database_mysql.md45
-rw-r--r--doc/install/databases.md48
-rw-r--r--doc/install/installation.md2
3 files changed, 48 insertions, 47 deletions
diff --git a/doc/install/database_mysql.md b/doc/install/database_mysql.md
new file mode 100644
index 00000000000..f0d0e830d4c
--- /dev/null
+++ b/doc/install/database_mysql.md
@@ -0,0 +1,45 @@
+## Note
+
+We do not recommend using MySQL due to various issues. For example, case [(in)sensitivity](https://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html) and [problems](http://bugs.mysql.com/bug.php?id=65830) that [suggested](http://bugs.mysql.com/bug.php?id=50909) [fixes](http://bugs.mysql.com/bug.php?id=65830) [have](http://bugs.mysql.com/bug.php?id=63164) .
+
+## MySQL
+
+ # Install the database packages
+ sudo apt-get install -y mysql-server mysql-client libmysqlclient-dev
+
+ # Pick a database root password (can be anything), type it and press enter
+ # Retype the database root password and press enter
+
+ # Secure your installation.
+ sudo mysql_secure_installation
+
+ # Login to MySQL
+ mysql -u root -p
+
+ # Type the database root password
+
+ # Create a user for GitLab
+ # do not type the 'mysql>', this is part of the prompt
+ # change $password in the command below to a real password you pick
+ mysql> CREATE USER 'git'@'localhost' IDENTIFIED BY '$password';
+
+ # Create the GitLab production database
+ mysql> CREATE DATABASE IF NOT EXISTS `gitlabhq_production` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`;
+
+ # Grant the GitLab user necessary permissions on the table.
+ mysql> GRANT SELECT, LOCK TABLES, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `gitlabhq_production`.* TO 'git'@'localhost';
+
+ # Quit the database session
+ mysql> \q
+
+ # Try connecting to the new database with the new user
+ sudo -u git -H mysql -u git -p -D gitlabhq_production
+
+ # Type the password you replaced $password with earlier
+
+ # You should now see a 'mysql>' prompt
+
+ # Quit the database session
+ mysql> \q
+
+ # You are done installing the database and can go back to the rest of the installation.
diff --git a/doc/install/databases.md b/doc/install/databases.md
index 481a698a8c8..b43f6b76b21 100644
--- a/doc/install/databases.md
+++ b/doc/install/databases.md
@@ -2,52 +2,8 @@
GitLab supports the following databases:
-* MySQL (preferred)
-* PostgreSQL
-
-
-## MySQL
-
- # Install the database packages
- sudo apt-get install -y mysql-server mysql-client libmysqlclient-dev
-
- # Pick a database root password (can be anything), type it and press enter
- # Retype the database root password and press enter
-
- # Secure your installation.
- sudo mysql_secure_installation
-
- # Login to MySQL
- mysql -u root -p
-
- # Type the database root password
-
- # Create a user for GitLab
- # do not type the 'mysql>', this is part of the prompt
- # change $password in the command below to a real password you pick
- mysql> CREATE USER 'git'@'localhost' IDENTIFIED BY '$password';
-
- # Create the GitLab production database
- mysql> CREATE DATABASE IF NOT EXISTS `gitlabhq_production` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`;
-
- # Grant the GitLab user necessary permissions on the table.
- mysql> GRANT SELECT, LOCK TABLES, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `gitlabhq_production`.* TO 'git'@'localhost';
-
- # Quit the database session
- mysql> \q
-
- # Try connecting to the new database with the new user
- sudo -u git -H mysql -u git -p -D gitlabhq_production
-
- # Type the password you replaced $password with earlier
-
- # You should now see a 'mysql>' prompt
-
- # Quit the database session
- mysql> \q
-
- # You are done installing the database and can go back to the rest of the installation.
-
+* PostgreSQL (preferred)
+* [MySQL](doc/install/database_mysql.md)
## PostgreSQL
diff --git a/doc/install/installation.md b/doc/install/installation.md
index dd391eeb4b3..3b009148957 100644
--- a/doc/install/installation.md
+++ b/doc/install/installation.md
@@ -144,7 +144,7 @@ GitLab Shell is an ssh access and repository management software developed speci
# 5. Database
-To setup the MySQL/PostgreSQL database and dependencies please see [doc/install/databases.md](./databases.md).
+To setup the PostgreSQL/MySQL database and dependencies please see [doc/install/databases.md](doc/install/databases.md).
# 6. GitLab