- CREATE DATABASE `answerhub` - Creates the AnswerHub database on your MySQL server.
- CHARACTER SET utf8- Sets UTF-8 as your character set.Note: The MySQL Database must be configured to allow the UTF8 character set and utf8_general_ci collation. If you want to support unicode emoji, you may need the UTF8MB4 character set. =
- COLLATE utf8_general_ci- Sets the collation format for your character set. Note: Collation is the set of rules that determines how a database interprets a given character set. In this case, you are setting the collation to be Case Insensitive (CI), this means that characters will share the same system value no matter what case they are presented in to the system.
- GRANT ALL ON `answerhub`.* TO `answerhub`@localhost IDENTIFIED BY 'answerhub' - Grants all user privileges to the answerhub user on the answerhub database created above. Note: If you want to create a different user to grant these privileges to, change the italicized answerhub text in the code block above to the preferred user name. The second answerhub.
- FLUSH PRIVILEGES- Flushes all previous permissions settings to ensure that those that were set by the code in this step take effect immediately.
Note: You can test these settings by connecting to the mysql server with the user account you created and running the use answerhub code in your console. You should get a Database changed response. The show tables code will give a Empty set result.
- teamhub.home- points to the location of the teamhub.home directory of your AnswerHub installation.
- database.engine- specifies the type of database that you’re using.
Note: In this example, the database type is MySQL.- database.name- is name of the database you created.
Note: In this example, the name of the database is answerhub. If you entered another name for your database, enter that name in this field.- database.user- is the user whose credentials will be used to access the database.
Note : Unless you are using an external database with an established set of users, you will want this user to be called root.- database.password- is the password for the database.
Note: For a local database, you will likely not have a password, depending on your settings.- database.url- is the server name that points to the database.
Note: For a local database, this will be localhost, but an external database will need the appropriate url here
Copyright © 2019 Devada