Page 1 of 1

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

Posted: Fri Apr 24, 2020 9:00 am
by vijayvithal
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.

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

Posted: Mon Apr 27, 2020 4:51 am
by rajitha
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 1845 times