Topic: User or password is invalid or you have no permittions to create datab

Hi,

I'm new to XAMP and FrontAccounting and am having some issues when trying to install.  I've looked at the other posts that referred to this same error message:

Cannot connect to database. User or password is invalid or you have no permittions to create database.

But neither has helped me get over this first hurdle.

I have installed XAMPP for Windows 5.6.28 on my 64bit Windows 8.1 laptop.

I have IIS running as well so I changed the httpd.conf to Listen 81.

Version information:
Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/5.6.28
10.1.19-MariaDB

I manually created a new user, setting the Host Name to localhost and selected this check box: Create database with same name and grant all privileges.

Accessing the install page (http://localhost:81/frontaccounting/install/index.php) shows everything as OK on the first page.  When I hit continue and enter the server host as: 127.0.0.1:81, put in my database user, password and database name (I'm 99% sure I've got these details correct) then hit continue, it takes a few minutes before the above error message is displayed.

I'd appreciate any advice on troubleshooting this.

Re: User or password is invalid or you have no permittions to create datab

Turn off strict mode on PHP 5.6+ as date and time fields will otherwise not recognize zero values.