Maris db error

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Maris db error

Postby dahdez90 » 06. November 2020 21:32

Hello Apache Friends Community:

I can't access through MariabDB in a react app, with Phalcon as backend.

I receive the following error in my response console
{
"code":1044,"
status":"error","
message":"SQLSTATE[HY000] [1044] Access denied for user 'clicksseeker'@'%' to database 'clicksseeker'"
}
O.S.: Windows 10 x64
Xampp version: 3.2.4
MariaDB version: 10.4.11-MariaDB

I just add the next line in my.ini:
default-storage-engine=INNODB

Then display this error:

2020-11-06 13:46:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-11-06 13:46:01 0 [Note] InnoDB: Uses event mutexes
2020-11-06 13:46:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-11-06 13:46:01 0 [Note] InnoDB: Number of pools: 1
2020-11-06 13:46:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-11-06 13:46:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-11-06 13:46:01 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-06 13:46:02 0 [Note] InnoDB: The log sequence number 450052909 in the system tablespace does not match the log sequence number 450053132 in the ib_logfiles!
2020-11-06 13:46:03 0 [Note] InnoDB: Resizing redo log from 2*50331648 to 2*5242880 bytes; LSN=450053141
2020-11-06 13:46:03 0 [Note] InnoDB: Starting to delete and rewrite log files.
2020-11-06 13:46:03 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2020-11-06 13:46:03 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2020-11-06 13:46:03 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2020-11-06 13:46:03 0 [Note] InnoDB: New log files created, LSN=450053141
2020-11-06 13:46:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-11-06 13:46:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-11-06 13:46:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-11-06 13:46:03 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-11-06 13:46:03 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-11-06 13:46:03 0 [Note] InnoDB: Waiting for purge to start
2020-11-06 13:46:03 0 [Note] InnoDB: 10.4.11 started; log sequence number 450053141; transaction id 1163
2020-11-06 13:46:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-11-06 13:46:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-11-06 13:46:03 0 [Note] Server socket created on IP: '::'.

Before add the line explained above the log error display the following:

2020-11-06 13:18:05 0 [ERROR] InnoDB: Operating system error number 32 in a file operation.
2020-11-06 13:18:05 0 [ERROR] InnoDB: The error means that another program is using InnoDB's files. This might be a backup or antivirus software or another instance of MySQL. Please close it to get rid of this error.

The port 3306 is used by mysqld.exe from xampp/mysql/bin directory

I hope your support to help me.

Thanks.
dahdez90
 
Posts: 1
Joined: 06. November 2020 20:54
XAMPP version: 3.2.4
Operating System: Windows 10 x64

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 122 guests