WampServer

Hi,

I'm running wamserver 3.1.4 64 bit on my win10 laptop.

My local MySQL is 5.7.23 using 3308 port. This is the port I had to configure on Heidi to be able to reach its databases.

I disabled MySQL at WAMP Tools in order to use MariaDB. Then I tried to enable MySQL again and I'm not able to connect WAMP with MySQL again.

Any tip? O: )

Hi again,

I've check my mysql.log and got this error:
2022-03-15T05:25:54.983873Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2022-03-15T05:30:53.849238Z 0 [Warning] wampmysqld64: Forcing close of thread 2 user: 'root'

I found a place where suggests to check my.ini to remove 'NO_AUTO_CREATE_USER' from its sql-mode. But this is the value I've found:
sql-mode=""

Thanks in advance,
Juan Vicente

Hi,

That are Warning !! In no way can these warnings prevent the MySQL connection.

What's the point of me bothering to write the help that's right in front of you if you don't read it and go looking for some stupid suggestions.

Right-Click -> Help -> MariaDB - MySQL

Left-Click -> MySQL -> MySQL settings -> Explanations of sql_mode

> Then I tried to enable MySQL again and I'm not able to connect WAMP with MySQL again.
It doesn't mean anything!
If the Wampmanager icon is green, it means that MySQL is working.
What exactly do you mean by "not able to connect WAMP"?

------------------------------------------------------------------------------------------------------------
Wampserver 3.3.0 32 bit - Apache 2.4.54.2 - PHP 8.2.4…7.4.33 - MySQL 5.7.40 - MariaDB 10.5.13/10.6.5
Wampserver 3.3.0 64 bit - Apache 2.4.54.2 - PHP 8.2.4…7.4.33 - MySQL 5.7.40/8.0.31 - MariaDB 10.5.17/10.10.2
PhPMyadmin 5.2.1 - MysqlDumper 1.24.5 on W10 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

ok, sorry