Bonjour J'utilise la derniere version de wampserver 3.2.7. j'ai testé à nouveau les dll avec le logiciel de vérification seulement je n'arrive pas à me connecté en BDD avec x dev api ni en php ni en JAVA (et non javascript)
L'extension php x dev api à bien été dézippé dans bin/php/php 8.0.13/ext de Wamp (php_mysql_xdevapi-8.0.27-8.0-ts-vs16-x64.zip). Dans phpinfo,je vois l'extension active , (y compris clique gauche, php et extension)
en message d'erreur , j'ai "Connection could not be established: [2002][HY000] Aucune connexion n’a pu être établie car l’ordinateur cible l’a expressément refusée"
Après avoir fait : <?php
try { $session = mysql_xdevapi\getSession('mysqlx://root@localhost/ssl-mode=disabled'); die(); } catch (Exception $e) { die("Connection could not be established: " . $e->getMessage()); } ?>
est-ce qu'il y a une manip particulière pour se connecter avec le protocole mysqlx ?
2022-01-16T14:39:09.690765Z 0 [System] [MY-013105] [Server] c:\wamp64\bin\mysql\mysql8.0.27\bin\mysqld.exe: Normal shutdown. 2022-01-16T14:39:09.691408Z 0 [Note] [MY-010067] [Server] Giving 1 client threads a chance to die gracefully 2022-01-16T14:39:09.692056Z 0 [Note] [MY-010117] [Server] Shutting down slave threads 2022-01-16T14:39:09.692540Z 0 [Note] [MY-010054] [Server] Event Scheduler: Killing the scheduler thread, thread id 5 2022-01-16T14:39:09.693222Z 0 [Note] [MY-010050] [Server] Event Scheduler: Waiting for the scheduler thread to reply 2022-01-16T14:39:09.694128Z 0 [Note] [MY-010048] [Server] Event Scheduler: Stopped 2022-01-16T14:39:09.694458Z 0 [Note] [MY-010118] [Server] Forcefully disconnecting 0 remaining clients 2022-01-16T14:39:09.694842Z 0 [Note] [MY-010043] [Server] Event Scheduler: Purging the queue. 0 events 2022-01-16T14:39:09.697808Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting. 2022-01-16T14:39:09.950116Z 0 [Note] [MY-010120] [Server] Binlog end 2022-01-16T14:39:09.950939Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner' 2022-01-16T14:39:09.951305Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram' 2022-01-16T14:39:09.951594Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE' 2022-01-16T14:39:09.952003Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE' 2022-01-16T14:39:09.952347Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable' 2022-01-16T14:39:09.952646Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-01-16T14:39:09.952999Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM' 2022-01-16T14:39:09.953306Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM' 2022-01-16T14:39:09.953602Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES' 2022-01-16T14:39:09.954014Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES' 2022-01-16T14:39:09.954351Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL' 2022-01-16T14:39:09.954672Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS' 2022-01-16T14:39:09.954989Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES' 2022-01-16T14:39:09.955317Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES' 2022-01-16T14:39:09.955631Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS' 2022-01-16T14:39:09.955993Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES' 2022-01-16T14:39:09.956305Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-01-16T14:39:09.956642Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-01-16T14:39:09.956984Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG' 2022-01-16T14:39:09.957339Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-01-16T14:39:09.957809Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED' 2022-01-16T14:39:09.958147Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-01-16T14:39:09.958501Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS' 2022-01-16T14:39:09.958820Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-01-16T14:39:09.959161Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-01-16T14:39:09.959506Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-01-16T14:39:09.959852Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-01-16T14:39:09.960179Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-01-16T14:39:09.960535Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-01-16T14:39:09.960875Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-01-16T14:39:09.961204Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM' 2022-01-16T14:39:09.961521Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET' 2022-01-16T14:39:09.961847Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP' 2022-01-16T14:39:09.962149Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX' 2022-01-16T14:39:09.962451Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB' 2022-01-16T14:39:09.962769Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown... 2022-01-16T14:39:10.135757Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed... 2022-01-16T14:39:10.319301Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 36640704 2022-01-16T14:39:10.321173Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1" 2022-01-16T14:39:10.321768Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY' 2022-01-16T14:39:10.322218Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV' 2022-01-16T14:39:10.322546Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin' 2022-01-16T14:39:10.322950Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner' 2022-01-16T14:39:10.323320Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password' 2022-01-16T14:39:10.323671Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password' 2022-01-16T14:39:10.323996Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password' 2022-01-16T14:39:10.324471Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog' 2022-01-16T14:39:10.327619Z 0 [System] [MY-010910] [Server] c:\wamp64\bin\mysql\mysql8.0.27\bin\mysqld.exe: Shutdown complete (mysqld 8.0.27) MySQL Community Server - GPL. 2022-01-16T14:39:11.541187Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2022-01-16T14:39:11.541198Z 0 [Note] [MY-010949] [Server] Basedir set to c:\wamp64\bin\mysql\mysql8.0.27\. 2022-01-16T14:39:11.541209Z 0 [System] [MY-010116] [Server] c:\wamp64\bin\mysql\mysql8.0.27\bin\mysqld.exe (mysqld 8.0.27) starting as process 2860 2022-01-16T14:39:11.557478Z 0 [Note] [MY-012366] [InnoDB] Using Windows native AIO 2022-01-16T14:39:11.559572Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2022-01-16T14:39:11.559934Z 0 [Note] [MY-010747] [Server] Plugin 'mysqlx' is disabled. 2022-01-16T14:39:11.562595Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-01-16T14:39:11.563006Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled 2022-01-16T14:39:11.564045Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2022-01-16T14:39:11.564316Z 1 [Note] [MY-012945] [InnoDB] _mm_lfence() and _mm_sfence() are used for memory barrier 2022-01-16T14:39:11.564703Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11 2022-01-16T14:39:11.566348Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1 2022-01-16T14:39:11.566700Z 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication. 2022-01-16T14:39:11.568097Z 1 [Note] [MY-012203] [InnoDB] Directories to scan '.\' 2022-01-16T14:39:11.568535Z 1 [Note] [MY-012204] [InnoDB] Scanning '.\' 2022-01-16T14:39:11.594117Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 156 files. 2022-01-16T14:39:11.595983Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 1.000000G, instances = 2, chunk size =128.000000M 2022-01-16T14:39:11.621741Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2022-01-16T14:39:11.631459Z 1 [Note] [MY-013532] [InnoDB] Using '.\#ib_16384_0.dblwr' for doublewrite 2022-01-16T14:39:11.632657Z 1 [Note] [MY-013532] [InnoDB] Using '.\#ib_16384_1.dblwr' for doublewrite 2022-01-16T14:39:11.678948Z 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2 2022-01-16T14:39:11.679256Z 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4 2022-01-16T14:39:11.679710Z 1 [Note] [MY-013532] [InnoDB] Using '.\#ib_16384_0.dblwr' for doublewrite 2022-01-16T14:39:11.680241Z 1 [Note] [MY-013532] [InnoDB] Using '.\#ib_16384_1.dblwr' for doublewrite 2022-01-16T14:39:11.681678Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 36640269, whereas checkpoint_lsn = 36640704 and start_lsn = 36640256 2022-01-16T14:39:11.685656Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2022-01-16T14:39:11.686730Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ... 2022-01-16T14:39:11.687379Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2022-01-16T14:39:11.688286Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace '.\undo_001'. 2022-01-16T14:39:11.691785Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace '.\undo_002'. 2022-01-16T14:39:11.695781Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2022-01-16T14:39:11.696152Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 55819 2022-01-16T14:39:11.804757Z 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete 2022-01-16T14:39:11.805142Z 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 109002 ms. 2022-01-16T14:39:11.805678Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2022-01-16T14:39:11.806357Z 1 [Note] [MY-012265] [InnoDB] Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-01-16T14:39:11.843252Z 1 [Note] [MY-012266] [InnoDB] File '.\ibtmp1' size is now 12 MB. 2022-01-16T14:39:11.853570Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'.\#innodb_temp\' 2022-01-16T14:39:11.912571Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active. 2022-01-16T14:39:11.914318Z 1 [Note] [MY-012976] [InnoDB] 8.0.27 started; log sequence number 36640714 2022-01-16T14:39:11.916399Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2022-01-16T14:39:11.925740Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'. 2022-01-16T14:39:12.041609Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files 2022-01-16T14:39:12.176012Z 1 [Note] [MY-012356] [InnoDB] Scanned 158 tablespaces. Validated 158. 2022-01-16T14:39:12.193144Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'. 2022-01-16T14:39:12.238303Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2022-01-16T14:39:12.239016Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end 2022-01-16T14:39:12.251651Z 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-01-16T14:39:12.252260Z 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-01-16T14:39:12.254536Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2022-01-16T14:39:12.254921Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2022-01-16T14:39:12.255547Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory. 2022-01-16T14:39:12.256259Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory. 2022-01-16T14:39:12.257302Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3306 2022-01-16T14:39:12.257832Z 0 [Note] [MY-010253] [Server] IPv6 is available. 2022-01-16T14:39:12.258188Z 0 [Note] [MY-010264] [Server] - '::' resolves to '::'; 2022-01-16T14:39:12.258494Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'. 2022-01-16T14:39:12.295151Z 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5 2022-01-16T14:39:12.301389Z 0 [System] [MY-010931] [Server] c:\wamp64\bin\mysql\mysql8.0.27\bin\mysqld.exe: ready for connections. Version: '8.0.27' socket: '' port: 3306 MySQL Community Server - GPL.
j'avais éffacé le log et celà est récent...dans le log j'ai 2022-01-16T14:39:11.559934Z 0 [Note] [MY-010747] [Server] Plugin 'mysqlx' is disabled. alors que le plugin est bien montré activé....