garfy97 Posted February 1, 2021 Share Posted February 1, 2021 Hi, i am having an error to connect with database, but the error notification does not give any message just blank. I already checked my XAMPP port everything is default. Thanks in advance Link to comment Share on other sites More sharing options...
CMooNDK Posted February 2, 2021 Share Posted February 2, 2021 I have the same problem, i am using: XAMPP Control Panel v3.2.4 xampp-windows-x64-8.0.0-3-VS16-installer.exe it runs with som wordpress setup's trying to install prestashop_1.7.7.1.zip have tried restarting the apache and sql service create a new user in phpmyadmin (can't set a password on root, then my wordpress setup will not work) CREATE USER 'shop'@'127.0.0.1' IDENTIFIED VIA mysql_native_password USING '***';GRANT ALL PRIVILEGES ON *.* TO 'shop'@'127.0.0.1' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;GRANT ALL PRIVILEGES ON `shop`.* TO 'shop'@'127.0.0.1'; nothing in the sql log "mysql_error.log InnoDB: using atomic writes. 2021-02-02 1:33:08 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-02-02 1:33:08 0 [Note] InnoDB: Uses event mutexes 2021-02-02 1:33:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-02-02 1:33:08 0 [Note] InnoDB: Number of pools: 1 2021-02-02 1:33:08 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-02-02 1:33:08 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-02-02 1:33:08 0 [Note] InnoDB: Completed initialization of buffer pool 2021-02-02 1:33:08 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=6182452 2021-02-02 1:33:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-02-02 1:33:08 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-02-02 1:33:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-02-02 1:33:08 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-02-02 1:33:08 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-02-02 1:33:08 0 [Note] InnoDB: Waiting for purge to start 2021-02-02 1:33:08 0 [Note] InnoDB: 10.4.17 started; log sequence number 6182461; transaction id 4046 2021-02-02 1:33:08 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool 2021-02-02 1:33:08 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-02-02 1:33:08 0 [Note] Server socket created on IP: '::'. Link to comment Share on other sites More sharing options...
nikoz Posted February 2, 2021 Share Posted February 2, 2021 Name of your database is "Prestashop" ? Server address : localhost Link to comment Share on other sites More sharing options...
CMooNDK Posted February 2, 2021 Share Posted February 2, 2021 14 minutes ago, nikoz said: Name of your database is "Prestashop" ? Server address : localhost yes it's a test setup. se Picture Link to comment Share on other sites More sharing options...
garfy97 Posted February 3, 2021 Author Share Posted February 3, 2021 Solved thanks Link to comment Share on other sites More sharing options...
CMooNDK Posted February 3, 2021 Share Posted February 3, 2021 5 hours ago, garfy97 said: Solved thanks What was the solution? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now