Ver el código de «Crear BasedeDatos del sitio Moodle»

{{Pendiente de traducir}}
{{Template:Instalación}}
Moodle supports [[MySQL]], [[PostgreSQL]] and MS SQL 2005 and Oracle databases.  Other databases may also work with Moodle. 

If your Moodle installer, does not create or add to an existing MySQL database, these instructions may help you.  

==MySQL==
===phpMyAdmin===
If you have access to phpMyAdmin you can use this to create database which the Moodle Installer will then populate with its tables.   See the [https://docs.moodle.org/19/en/Windows_installation_using_XAMPP#Create_the_MySQL_database create the MySQL database] section in the XAMPP installation page.   

===MySQL client===
This process uses a command line prompt using a MySQL Client program as follows (commands which you type-in are shown in bold):

- Start the MySQL Client program:
 #'''mysql -u root -p'''
 Enter password:
 Welcome to the MySQL monitor.  Commands end with ; or \g.
 Your MySQL connection id is 2 to server version: 5.0.22-log
 
 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
 mysql>

- The prompt changes to "mysql>" to indicate that you are now working in the MySQL Client program. When working in MySQL, all commands which you type-in must end in a semi-colon. (If you hit the Enter key without the final semi-colon, you'll get the line continuation symbol '->'; this is your second chance to type the semi-colon and hit Enter.) 

- Begin by checking for any existing databases called "moodle" - if there are any you should change the name in all the commands which follow:
 mysql> '''SHOW DATABASES;'''
 +-------------------------+
 | Database                |
 +-------------------------+
 | information_schema      |
 | mysql                   |
 | test                    |
 +-------------------------+
 3 rows in set (0.03 sec)

- Create a database to store the Moodle tables. We'll call this "moodle", as there are none with that name already in the above list, but change it if you need to.
 mysql> '''CREATE DATABASE moodle;'''
 Query OK, 1 row affected (0.00 sec)

- Change the default character set and collation of the "moodle" database to UTF8. Leave this out if you are installing Moodle 1.5 or earlier):
 mysql> '''ALTER DATABASE moodle DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;'''
 Query OK, 1 row affected (0.00 sec)

- Create a username and password to access the database "moodle" and grant database access permissions. We'll call the user "moodleuser" and set the password as "yourpassword". It's a good idea to change these for your installation however most people keep the username as "moodleuser". Remember the username and password you have set, as you'll need it in the configuration screens later. This is a long command so has been split over several lines by pressing the Return key.
 mysql> '''GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,'''
     -> '''DROP,INDEX,ALTER ON moodle.*'''
     -> '''TO moodleuser@localhost IDENTIFIED BY 'yourpassword';'''
 Query OK, 0 rows affected (0.01 sec)

:'''Security Warnings''': Never leave the password as the one shown here. Make sure you have a strong password (a mixture of letters and numbers, upper and lower case). Avoid granting "ALL" permissions on the database.
: '''Note''': For MySQL 4.0.1 or earlier, you don't need the CREATE TEMPORARY TABLES permission. 

- Exit the MySQL Client program:
 mysql> '''QUIT'''
 Bye
 #

- On older versions of MySQL you may need to reload the grant tables using the mysqladmin program:
 #'''mysqladmin -u root -p reload'''
 Enter password:
 #


If you want to run all this at once without so many commands then you can also do something like this (just copy and  paste these lines into the mysql command line). Although do note that 'grant all' gives a lot of privilege to the moodleuser account :
 create database moodle default character set utf8;
 grant all privileges on moodle.* to 'moodleuser'@'localhost' identified by 'yourpassword';
 flush privileges;
 quit

==PostgreSQL==

And some example command lines for those who wish to use a PostgreSQL database:

   # su - postgres
   > psql -c "create user moodleuser createdb;" template1
   > psql -c "alter user moodleuser with encrypted password 'yourpassword';" template1
   > psql -c "create database moodle <font color="red">with encoding 'unicode'</font>;" -U moodleuser template1
   > psql -c "alter user moodleuser nocreatedb;" template1
   > su - root
   # /etc/init.d/postgresql reload


If the Postgres create user command above (>psql -c "create user moodleuser...") gives an error message you may want to try initdb as postgres, then restarting postgresql as root, then start steps again from the beginning:
 initdb -D data
 su
 # /etc/init.d/postgresql restart

If the Postgres create database command above (>psql -c "create database moodle...") gives an error message you may want to try:
 psql -c "create database moodle with template=template1 encoding = 'unicode' owner =  moodleuser <br>     location = '/var/mydata';"

If the create database command asks you for a password, run the line containing 'encrypted password' first before proceeding.

==Using a SQLite database==
<table style=background-color:lightCyan border=1 cellpadding=5 cellspacing=0 ><tr><td>
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

Moodle 2.0 offers experimental support for SQLite3 database installations. In this case, no database setup is required. The database file will be created by the installation script. By default, the database file will be store in Moodle's data directory (see [[Installing_Moodle#Creating_the_data_directory |Creating the data directory]]). During install, the web server must have write access on the directory where the database file will be stored. After installation, the web server must have read-write access to the database file.

Continue with [[Installing_Moodle#Creating_the_data_directory |Creating the data directory]]

</td></tr></table>

==Using a hosted server==
If you are using a webhost, they will probably have a control panel web interface for you to create your database.

The '''[http://www.cpanel.com/ cPanel]''' system is one of the most popular of these. 
To create a database using cPanel:

# Click on the '''MySQL Databases''' icon.
# Type '''moodle''' in the New Database field and click '''Create Database'''.
# Type a ''username'' and ''password'' (not one you use elsewhere) in the respective fields and click '''Create  User'''.<br>Note that the ''username'' and ''database'' names may be prefixed by your cPanel account name and an underscore, and truncated to 16 characters. When entering this information into the Moodle installer - use the full names.
# Now use the '''Add Users to Databases''' button and give this new user account '''ALL''' rights to the new database.

Continue with [[Instalación#Crear_el_directorio_de_datos |Crear el directorio de datos]]

==Caution- be aware of Moodle version requirements==
See the [[http://download.moodle.org/ download page]] at Moodle.org  or [[PHP settings by Moodle version]] for supported database requirements for each version of Moodle.

For example Moodle 2.0 requires:
    * MySQL 5.0.25 or later (InnoDB storage engine highly recommended)
    * PostgreSQL 8.3 or later
    * Oracle 10.2 or later
    * MS SQL 2005 or later

==See also==
*[[Instalación]]
* Step-by-step instructions on  [https://docs.moodle.org/en/Step-by-step_Install_Guide_for_Ubuntu installation for Ubuntu(Debian)]
[[Category:BasedeDatos SQL]]
[[en:Create Moodle site database]]