Difference between revisions of "DbMySQL/En"

From TuxFamilyFAQ
Jump to navigationJump to search
m (phpmyadmin is now an HTTPS-only service)
 
(8 intermediate revisions by 5 users not shown)
Line 19: Line 19:
 
*Use the "Create" link in the MySql section to create the database.
 
*Use the "Create" link in the MySql section to create the database.
 
*Don't forget to provide a good description to avoid moderation issues.
 
*Don't forget to provide a good description to avoid moderation issues.
*Your database name will be : ProjectName_Databae
+
*Your database name will be : ProjectName_Database
 
   
 
   
 
== Creation tips ==  
 
== Creation tips ==  
Line 38: Line 38:
 
You can use phpmyadmin to do basics operations on your database.
 
You can use phpmyadmin to do basics operations on your database.
  
http://phpmyadmin.tuxfamily.org
+
https://phpmyadmin.tuxfamily.org
  
User name: Database_name
+
* User name: Database_name (of the form projectname_databasename e.g. myproject_forum)
Password : Database_password
+
* Password : Database_password
  
 
== How to manage my group's permissions on this object ==
 
== How to manage my group's permissions on this object ==
Line 56: Line 56:
 
= How to use it =
 
= How to use it =
  
*Once your database moderated, you can use your database with the following informations :
+
Once your database moderated, you can use your database with the following informations :
*Login : NameOfTheDatabase
+
*Login : NameOfTheDatabase (of the form projectname_databasename  e.g. myproject_forum)
 
*Password : PasswordOfTheDatabase
 
*Password : PasswordOfTheDatabase
 
*host : sql
 
*host : sql
Line 64: Line 64:
 
SQL host: sql
 
SQL host: sql
  
'''Note : Yes, the database server is sql. Yes there isn't any extension, Yes, it does work. No you can't connect to the mysql server from outside '''
+
'''Note: Yes, the database server is sql. Yes, there isn't any extension. Yes, it does work. No, you can't connect to the mysql server from the outside.'''
  
 
=SQL Dumps=
 
=SQL Dumps=
Line 70: Line 70:
 
We provide daily SQL dumps in your group directory. the name of the dump file is db_name.mysql.dump
 
We provide daily SQL dumps in your group directory. the name of the dump file is db_name.mysql.dump
  
You can also use http://phpmyadmin.tuxfamily.org to dump it or even do it by ssh ;)
+
You can also use https://phpmyadmin.tuxfamily.org to dump it or even do it by ssh ;)
  
 
= Tips and tricks =
 
= Tips and tricks =

Latest revision as of 18:46, 28 February 2016

MySQL Databases



Description

Mysql databases allows you to easily store datas and access them from php webpages.


Dependencies

Creation

  • Login on the panel
  • Select the project that will receive the new database
  • Use the "Create" link in the MySql section to create the database.
  • Don't forget to provide a good description to avoid moderation issues.
  • Your database name will be : ProjectName_Database

Creation tips

  • Don't forget to provide a description
  • Be careful, there are some restrictions on the database's name length (the panel will help you)

Moderation

This object is moderated. See :this page

How to configure it (panel)

You don't have any configuration options on a MySQL database. The only thing you can do on this part of the panel is to overwrite the database's password.

Configuration

You can use phpmyadmin to do basics operations on your database.

https://phpmyadmin.tuxfamily.org

  • User name: Database_name (of the form projectname_databasename e.g. myproject_forum)
  • Password : Database_password

How to manage my group's permissions on this object

You can use some ACL rules to set special permissions and allow members of your group to see/modify your database on the panel.

How to destroy it

  • login to thepanel
  • Go in your project section
  • select your database
  • Use the destroy button

How to use it

Once your database moderated, you can use your database with the following informations :

  • Login : NameOfTheDatabase (of the form projectname_databasename e.g. myproject_forum)
  • Password : PasswordOfTheDatabase
  • host : sql
  • port : 3306

SQL host: sql

Note: Yes, the database server is sql. Yes, there isn't any extension. Yes, it does work. No, you can't connect to the mysql server from the outside.

SQL Dumps

We provide daily SQL dumps in your group directory. the name of the dump file is db_name.mysql.dump

You can also use https://phpmyadmin.tuxfamily.org to dump it or even do it by ssh ;)

Tips and tricks

  • Yes, the database user is the same as the database name.
  • Yes the SQL server is sql ! We know it sounds weird but it does work !

Useful Links