Creating a Database for Joomla!/pt

From Joomla! Documentation

< Creating a Database for Joomla!

Cada instalação do Joomla! CMS requer uma base de dados. Esta irá armazenar os dados, tais como artigos, menus, categorias e utilizadores. Esta informação é necessária para criar e gerir o seu site da Web Joomla!. Independentemente dos requisitos da versão, para poder instalar o Joomla!, deverá ter uma base de dados ativa, um utilizador da base de dados, uma palavra-passe da base de dados e privilégios adequados para o utilizador da base de dados. Irá precisar de concluir estas tarefas antes de iniciar a instalação. Este artigo irá abordar o tipo mais comum da base de dados utilizada quando Installing Joomla!, uma base de dados MySQL. Embora o foco aqui seja a utilização do cPanel numa conta de hospedagem, outros tipos de interfaces de hospedagem devem ter etapas semelhantes.

Assistente da BD MySQL

For beginners, it is recommended the MySQL Database Wizard is used. The wizard will guide you step by step through the process. You may use these steps to guide you through your own hosting account panel if it differs, they are:

Create a Database  Create a User  Set User password  Set User Privileges.

First, activate the wizard by clicking the icon in you hosting account's cPanel.

CPanel-database-wizard-icon.png

Criação da Base de Dados

Next, you must choose a name for your database. In a shared hosting environment, your database name is usually proceeded by your hosting account's username, then an id your specify. For example, if your hosting account's username is B1234, your database name could look similar to this: B1234_joomla.

CPanel-create-MySQL-database.png

Criação do Utilizador da Base de Dados e Palavra-passe do Utilizador

Once you have created a database, you now need a 'database user' to access it. This step will create a user and the user's password at the same time. The username for a database will be similar in look to the database name. You can actually use the name of the database for the user, but for security, you should use a unique username with a strong password.

CPanel-create-MySQL-user.png

Set the User Privileges

The last task to creating a database for Joomla! is to give your database user privileges(permissions) to interact with your database. These privileges give your user the ability to create database tables, drop them(delete), alter, index and a variety of other interactive tasks.

CPanel-set-MySQL-user-privileges.png

  • If you are not using the database creation wizard. Privileges are usually included in the assignment of a database user to a database. This work flow is Create db  Create db User  Assign a db User to a db(including privileges).

Finishing Up

After you complete all the steps of the database wizard, you will see the summary of the final results.

CPanel-MySQL-database-wizard-finished.png

Write down the following information for use in your Joomla! installation.
  • Database name, example: D1234_joomla
  • Database user, example: D1234_juser
  • Database user's password
  • Note the location of the database. Usually, Localhost for a cPanel installation. Occasionally, a hosting account may have a database server completely separate from a user account's server for physical files. Instead of Localhost the database server may actually be a URL type of address, dbserver10.hosting.com.