Keep Server Online
If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.
or
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.
| |
|
 Topic: php 7.2.9 cannot connect to mysql8 ?? |
|
| Author |
|
spser
Joined: 29 Aug 2016
Posts: 97
|
 Posted: Fri 17 Aug '18 3:15 Post subject: php 7.2.9 cannot connect to mysql8 ?? |
 |
|
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: 7402
Location: EU, Germany, Next to Hamburg
|
| Posted: Sun 19 Aug '18 15:43 Post subject: |
|
|
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: 1266
Location: Amsterdam, NL, EU
|
|
| Back to top |
|
spser
Joined: 29 Aug 2016
Posts: 97
|
| Posted: Fri 31 Aug '18 3:39 Post subject: 7.3.0 beta3 test ok. |
|
|
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
|
| Posted: Mon 03 Sep '18 3:17 Post subject: |
|
|
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 |
|
|
|
|
|
|
