I cannot connect with my local mysql
Posted by: Juan.Vicente (---.36.15.37.dynamic.jazztel.es)
Date: March 15, 2022 09:35AM

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: )

Options: ReplyQuote
Re: I cannot connect with my local mysql
Posted by: Juan.Vicente (---.36.15.37.dynamic.jazztel.es)
Date: March 15, 2022 09:47AM

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

Options: ReplyQuote
Re: I cannot connect with my local mysql
Posted by: Otomatic (Moderator)
Date: March 15, 2022 10:49AM

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.2.9 32 bit - Apache 2.4.54 - PHP 8.1.8…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.9 64 bit - Apache 2.4.54 - PHP 8.1.8…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.15/10.7.3
PhPMyadmin 5.1.3 - MysqlDumper 1.24.5
on W10 and W7 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 »

Options: ReplyQuote
Re: I cannot connect with my local mysql
Posted by: Juan.Vicente (---.red-2-139-219.staticip.rima-tde.net)
Date: March 15, 2022 11:31AM

ok, sorry sad smiley

Options: ReplyQuote


Sorry, only registered users may post in this forum.