logo
Apache Lounge
Webmasters

 

About Forum Index Downloads Search Register Log in RSS X


Keep Server Online

If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.

or

Bitcoin

A donation makes a contribution towards the costs, the time and effort that's going in this site and building.

Thank You! Steffen

Your donations will help to keep this site alive and well, and continuing building binaries. Apache Lounge is not sponsored.
Post new topic   Forum Index -> Other Software View previous topic :: View next topic
Reply to topic   Topic: php 7.2.9 cannot connect to mysql8 ??
Author
spser



Joined: 29 Aug 2016
Posts: 97

PostPosted: Fri 17 Aug '18 3:15    Post subject: php 7.2.9 cannot connect to mysql8 ?? Reply with quote

http://www.atuser.com/2.png
PHP 7.2.9 cannot connect to mysql8.0.12?


http://www.atuser.com/1.png
PHP 7.2.7 success


// mysql.exe Ver 8.0.12 for Win64 on x86_64 (MySQL Community Server - GPL)

How can I find out the cause? Thank you
Back to top
James Blond
Moderator


Joined: 19 Jan 2006
Posts: 7288
Location: Germany, Next to Hamburg

PostPosted: Sun 19 Aug '18 15:43    Post subject: Reply with quote

Since 7.2.7 can, but 7.2.9 can connect I think it is an issue with PHP

I know that you have to install MySQL 8 with a lagacy option for PHP able to connect, but if one version can, but the other can't connect, you may open a bug report on php.net
Back to top
Jan-E



Joined: 09 Mar 2012
Posts: 1248
Location: Amsterdam, NL, EU

PostPosted: Thu 23 Aug '18 7:51    Post subject: Reply with quote

Known bug. https://bugs.php.net/bug.php?id=76660 and https://bugs.php.net/bug.php?id=76651
Back to top
spser



Joined: 29 Aug 2016
Posts: 97

PostPosted: Fri 31 Aug '18 3:39    Post subject: 7.3.0 beta3 test ok. Reply with quote

7.3.0beta3
mysqli Object
(
[affected_rows] => 0
[client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 401a40ebd5e281cf22215acdc170723a1519aaa9 $
[client_version] => 50012
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)

[field_count] => 0
[host_info] => 127.0.0.1 via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 8.0.12
[server_version] => 80012
[stat] => Uptime: 2276 Threads: 2 Questions: 35 Slow queries: 0 Opens: 130 Flush tables: 2 Open tables: 106 Queries per second avg: 0.015
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 28
[warning_count] => 0
)
Back to top
spser



Joined: 29 Aug 2016
Posts: 97

PostPosted: Mon 03 Sep '18 3:17    Post subject: Reply with quote

Sorry, 7.3.0 beta 3 connection mysql 8 has been tested in detail.
Need to change the configuration file, my.ini :

Default_authentication_plugin=mysql_native_password

Can you connect successfully.. Maybe this can help you.
Back to top


Reply to topic   Topic: php 7.2.9 cannot connect to mysql8 ?? View previous topic :: View next topic
Post new topic   Forum Index -> Other Software