| 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: 7373
Location: 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 |
|
