diff --git a/databases/rubygem-mysql/Makefile b/databases/rubygem-mysql/Makefile
index 28d99ce0528f..d0a20eb92c53 100644
--- a/databases/rubygem-mysql/Makefile
+++ b/databases/rubygem-mysql/Makefile
@@ -1,16 +1,17 @@
 PORTNAME=	mysql
 PORTVERSION=	2.9.1
+PORTREVISION=	1
 CATEGORIES=	databases rubygems
 MASTER_SITES=	RG
 
 MAINTAINER=	ruby@FreeBSD.org
 COMMENT=	MySQL API module for Ruby
 WWW=		https://github.com/luislavena/mysql-gem
 
 LICENSE=	GPLv2 RUBY
 LICENSE_COMB=	dual
 
 USES=		gem mysql
 IGNORE_WITH_MYSQL=	80
 
 .include <bsd.port.mk>
diff --git a/databases/rubygem-mysql/files/patch-ext-mysql_api-mysql.c b/databases/rubygem-mysql/files/patch-ext-mysql_api-mysql.c
index b7f8cf385303..ce59e04255ac 100644
--- a/databases/rubygem-mysql/files/patch-ext-mysql_api-mysql.c
+++ b/databases/rubygem-mysql/files/patch-ext-mysql_api-mysql.c
@@ -1,70 +1,86 @@
---- ext/mysql_api/mysql.c.orig	2022-03-10 04:04:50 UTC
+--- ext/mysql_api/mysql.c.orig	2023-03-11 18:29:50 UTC
 +++ ext/mysql_api/mysql.c
 @@ -273,7 +273,10 @@ static VALUE real_connect(int argc, VALUE* argv, VALUE
      rb_thread_start_timer();
  #endif
  
 +#if MYSQL_VERSION_ID >= 100400
 +#else
      myp->handler.reconnect = 0;
 +#endif
      myp->connection = Qtrue;
      myp->query_with_result = Qtrue;
      rb_obj_call_init(obj, argc, argv);
 @@ -347,7 +350,10 @@ static VALUE real_connect2(int argc, VALUE* argv, VALU
  #ifdef HAVE_RB_THREAD_START_TIMER
      rb_thread_start_timer();
  #endif
 +#if MYSQL_VERSION_ID >= 100400
 +#else
      m->reconnect = 0;
 +#endif
      GetMysqlStruct(obj)->connection = Qtrue;
  
      return obj;
 @@ -875,12 +881,12 @@ static VALUE stmt_init(VALUE obj)
      MYSQL *m = GetHandler(obj);
      MYSQL_STMT *s;
      struct mysql_stmt* stmt;
 -    my_bool true = 1;
 +    my_bool mytrue = 1;
      VALUE st_obj;
  
      if ((s = mysql_stmt_init(m)) == NULL)
  	mysql_raise(m);
 -    if (mysql_stmt_attr_set(s, STMT_ATTR_UPDATE_MAX_LENGTH, &true))
 +    if (mysql_stmt_attr_set(s, STMT_ATTR_UPDATE_MAX_LENGTH, &mytrue))
  	rb_raise(rb_eArgError, "mysql_stmt_attr_set() failed");
      st_obj = Data_Make_Struct(cMysqlStmt, struct mysql_stmt, 0, free_mysqlstmt, stmt);
      memset(stmt, 0, sizeof(*stmt));
 @@ -917,13 +923,21 @@ static VALUE query_with_result_set(VALUE obj, VALUE fl
  /*	reconnect()	*/
  static VALUE reconnect(VALUE obj)
  {
 +#if MYSQL_VERSION_ID >= 100400
 +    return Qfalse;
 +#else
      return GetHandler(obj)->reconnect ? Qtrue : Qfalse;
 +#endif
  }
  
  /*	reconnect=(flag)	*/
  static VALUE reconnect_set(VALUE obj, VALUE flag)
  {
 +#if MYSQL_VERSION_ID >= 100400
 +    return Qfalse;
 +#else
      GetHandler(obj)->reconnect = (flag == Qnil || flag == Qfalse) ? 0 : 1;
 +#endif
      return flag;
  }
  
 @@ -1317,7 +1331,7 @@ static VALUE stmt_bind_result(int argc, VALUE *argv, V
  	}
  	else if (argv[i] == rb_cString)
  	    s->result.bind[i].buffer_type = MYSQL_TYPE_STRING;
 -	else if (argv[i] == rb_cNumeric || argv[i] == rb_cInteger || argv[i] == rb_cFixnum)
 +	else if (argv[i] == rb_cNumeric || argv[i] == rb_cInteger || argv[i] == rb_cInteger)
  	    s->result.bind[i].buffer_type = MYSQL_TYPE_LONGLONG;
  	else if (argv[i] == rb_cFloat)
  	    s->result.bind[i].buffer_type = MYSQL_TYPE_DOUBLE;
+@@ -1884,6 +1898,7 @@ static VALUE error_sqlstate(VALUE obj)
+ 
+ void Init_mysql_api(void)
+ {
++#if 0
+     int i;
+     int dots = 0;
+     const char *lib = mysql_get_client_info();
+@@ -1898,6 +1913,7 @@ void Init_mysql_api(void)
+             return;
+         }
+     }
++#endif
+ 
+     cMysql = rb_define_class("Mysql", rb_cObject);
+     cMysqlRes = rb_define_class_under(cMysql, "Result", rb_cObject);