Setting the mysql DB for VEP
This page will help you setup mysql database properly for use with VEP. We will assume that you have mysql server installed and running on the machine.
Steps:
- login using the root credentials
- $ mysql -u root -p
Enter the root user password when prompted.
- $ mysql -u root -p
- create a VEP mysql user on mysql server
- mysql> CREATE USER 'username'@'localhost' IDENTIFIED BY 'mypass';
Replace 'localhost' with remote machine IP if the user will log on from a remote machine (i.e. the machine where VEP will run), if VEP runs on the same machine as mysql server, you can leave 'localhost' as is. Replace 'username' with the desired username.
- mysql> CREATE USER 'username'@'localhost' IDENTIFIED BY 'mypass';
- create a VEP database [make sure you use 'vepdb' as the name]
- mysql> CREATE DATABASE vepdb;
- grant access rights on the VEP database to this newly created user
- mysql> GRANT ALL ON vepdb.* TO 'username'@'localhost';
Replace 'username' and 'localhost' with the account name and the machine you used in the step before.
- mysql> GRANT ALL ON vepdb.* TO 'username'@'localhost';
- quit from mysql shell
- mysql> exit
This is all you need to setup VEP database on mysql server. Make sure you enter the user account details correctly in the VEP settings. Do not worry about the tables and DB schema, the software will initialize everything during its initial run.
