logo
Apache Lounge
Webmasters

 


About

Forum Index Downloads Search Register Log in  RSS Apache Lounge
 


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

Apache Lounge is not sponsored.

Your donations will help to keep this site alive and well, and continuing building binaries.



php 7.2.9 cannot connect to mysql8 ??

 
Post new topic   Reply to topic    Apache Forum Index -> Other Software



View previous topic :: View next topic  
Author Message
spser



Joined: 29 Aug 2016
Posts: 45

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: 6478
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: 887
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: 45

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

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


Post new topic   Reply to topic    Apache Forum Index -> Other Software
Page 1 of 1