SQL Error during 'Fill default data into the database Error' phase.

Pre-requisites, Installation Instructions and Implemenation Assisstance
Post Reply
vijayvithal
Posts: 1
Joined: Fri Apr 24, 2020 8:47 am

SQL Error during 'Fill default data into the database Error' phase.

Post by vijayvithal » Fri Apr 24, 2020 9:00 am

Hi,
During the database creation phase I am seeing the following error:

Code: Select all

Access denied for user 'vijayvithal'@'localhost' to database 'orangehrm_mysql'

Database Creation	Done
Create Database Tables	Done
Fill default data into the database	Error
Create Database User	Aborted
Create Default User	Aborted
Write Configuration File	Aborted
This user has all PRIVELEGES

Code: Select all

GRANT ALL PRIVILEGES ON *.* TO ' vijayvithal'@'localhost';
FLUSH PRIVILEGES;
exit;
  
I am not seeing any error messages in the mysql error.log file

Any assistance in debugging and fixing the error is welcome.

rajitha
Posts: 32
Joined: Tue Feb 11, 2020 9:54 am

Re: SQL Error during 'Fill default data into the database Error' phase.

Post by rajitha » Mon Apr 27, 2020 4:51 am

Hi,
Did you use root or any other privileged user in the Privileged Database Username?
In your case, given Privileged Database User does not have permission to create `vijayvithal` user. If you don't want separate user creation for OrangeHRM application please tick Use the same Database User for OrangeHRM field.
Screenshot from 2020-04-27 10-01-23.png
Screenshot from 2020-04-27 10-01-23.png (109.18 KiB) Viewed 1844 times

Post Reply