Install Symphony
A quick, easy guide to help you get Symphony up and running in just a few minutes.
Step 4. Create a Database
Creating a database for Symphony to use is a fairly simple step, but to proceed, you'll need to know your MySQL username and password. These may have been assigned by your hosting provider, or you may have created them using your server's control panel.
Depending on your host, you may have several different options for creating a MySQL database, including phpMyAdmin, the command line MySQL client, and other host-specific options. If you're unsure which options are available to you, or you aren't able to use one of the methods below, consult your hosting provider's documentation.
Using phpMyAdmin
- Log into your phpMyAdmin interface.
- You'll see a field on the home page labeled "Create new database." Enter a database name (note this for the next step), and from the "Collation" dropdown, select
utf8_unicode_ci
. - Click the "Create" button.
Using the Command Line MySQL Client
- SSH into your server
- Connect to the MySQL client:
Replacemysql -u username -p
username
with your MySQL username. You'll be prompted for your MySQL password. Enter it. - In the MySQL prompt (
mysql>
), type:
(Be sure to replaceCREATE DATABASE db_name CHARACTER SET utf8 COLLATE utf8_unicode_ci;
db_name
with a suitable database name, likesymphony
).You should see a message telling you that the query was executed. TypeEXIT
.