How to install php_mysql_xdevapi on wamp.

Introduction

php_mysql_devapi extension provides access to the MySQL Document Store via the X DevAPI. The X DevAPI is a common API provided by multiple MySQL Connectors providing easy access to relational tables as well as collections of documents, which are represented in JSON, from a API with CRUD-style operations.

The X DevAPI uses the X Protocol, the new generation client-server protocol of the MySQL 8.0 server.

To install this extension, you need to have mysql 8 on your system.

Wamp

After installing mysql 8 follow these steps to install php_mysql_xdevapi.

  1. Go to this link https://pecl.php.net/package/mysql_xdevapi to download the .dll for the php_mysql_xdevapi .
  2. After downloading the extension paste in your php installation directory subfolder ext C:\wamp64\bin\php\php7.2.4\ext.
  3. Now you have to add this extension in the php.ini file near the dynamic extensions. extension=php_mysql_xdevapi.dll
  4. One important caveat is that in wamp default mysql 8 installation , XDevApi plugin is disable, you have to enable it by commenting the part which is disabling mysql_xdevapi.
           ;Disabling X Plugin
;mysqlx=0

Now you successfully have install the php_mysql_xdevapi on wamp, to see it working,

$session = mysql_xdevapi\getSession('mysqlx://<user>:<password>@host:33060?connect-timeout=5000&ssl-mode=disabled');

Post Author: timur_ul_hasan

Leave a Reply

Your email address will not be published. Required fields are marked *