Questions tagged [plugins]
23 questions
34
votes
1 answer
What is mysql_native_password?
I was trying to set password for root. When I run:
mysql> SELECT * from mysql.user where User="root";
It…
d a i s y
- 443
- 1
- 4
- 7
3
votes
2 answers
PostgreSQL How do I convert struct text to plain *char in C functions?
I'm using my internal C function which doesn't know about postgresql's text struct, how do I pass text argument when char * expected?
#include
#include
#include "postgres.h"
#include "fmgr.h"
#ifdef…
Moe
- 41
- 1
- 3
3
votes
1 answer
Can underscore be forced as a word splitter without a full-text parser plugin?
Is there any way in MySQL to force underscore to become a word splitter character (like space or dash) without having to use a fulltext parser plugin?
If not, does such a plugin already exist or do I have to learn to make my own?
ck_
- 271
- 3
- 10
3
votes
1 answer
MariaDB: Disable the GSSAPI plugin
How can i disable the GSSAPI plugin? I do not need authentication via Kerberos on my server.
This is my environment:
Centos 7.3 with SELinux mode enforcing
MariaDB Server: 10.1.19
In my log file /var/log/mariadb/mariadb.log i see the next…
Lenin Meza
- 133
- 1
- 1
- 5
3
votes
1 answer
MySQL can't import a custom library for udf
I am working on Linux Mint 17 Qiana with MySQL Ver 14.14 Distrib 5.5.53, for debian-linux-gnu (x86_64).
Following the instructions found here:
http://dev.mysql.com/doc/refman/5.7/en/adding-udf.html
and subsequent pages, I have created a library file…
Julien Ferté
- 71
- 6
2
votes
1 answer
SQL Management Studio - Add-on / Extension to view Column Data Type
Is there any way (built in) or free/paid add-on/Extension for SQL Management Studio that allows us to know exactly a data type of a column when we are writing a query?
In this specific project I have had situations where by looking a the query…
Dryadwoods
- 211
- 2
- 10
2
votes
1 answer
MySQL reads Date columns in Excel as DateTime?
I'm trying to export Excel sheets to MySQL as new table using the plugin.
The export fails on "MySQL error 1064" when I tried to change the data type to Date.
I have a few columns in Excel that are formatted as Short Date, although some of them are…
cxwf
- 141
- 2
- 2
- 4
1
vote
1 answer
MySQL 5.1: Upgrade innodb plugin
My application is running on MySQL 5.1.58 community edition. As I studied on SO websites that After acquisition by Oracle, new InnoDB plugin has been released and MySQL 5.1 with InnoDB plugin is the best for performance. Below is the command which…
ursitesion
- 2,061
- 8
- 32
- 45
1
vote
1 answer
mariadb 5.5.36 with innodb plugin
I installed mariadb 5.5.36 on a win32 system. Everything runs fine except innodb requests are 2 x slower than an identical MySQL installation. So I want to switch back to original innodb plugin to test the performance with it.
In my.ini I put under…
user212901
- 11
- 2
1
vote
0 answers
Does MariaDB support server-side query rewriting?
MySQL has something called "The Rewriter Query Rewrite Plugin". I've tried to find info about anything similar in MariaDB but so far found nothing. Is there any way in MariaDB to examine and modify SQL statements received by the server before the…
Grzegorz Adam Kowalski
- 131
- 6
1
vote
1 answer
MySQL Plugin "mysql_old_password" not loaded
In an attempt to fix another issue I had, I ran the commands below (as per https://dev.mysql.com/doc/refman/5.6/en/old-client.html)
mysql> UPDATE mysql.user SET plugin = 'mysql_old_password'
mysql> WHERE User = 'root' AND Host = 'localhost';
mysql>…
The Royal Guardian
- 31
- 5
1
vote
1 answer
Is there some plugin that would reconnect query tabs to original DB's in SSMS?
It's a minor thing, but annoying one.
I'm currently working on about 5 different databases, and every time I restore db's from snapshots or run my restore from backup scripts, all of the queries get disconnected.
Sure, I can just rerun them, but the…
veljkoz
- 195
- 1
- 6
1
vote
1 answer
Unable to change root user unix_socket to mysql_native_password
Server version: 10.1.41-MariaDB-0+deb9u1 Debian 9.9
I have installed a LAMP stack on my Debian 9 machine and can not log in with the root user. From my searching, it seems that it's because the install commonly creates a root user without a…
Schwim Dandy
- 25
- 1
- 5
1
vote
1 answer
How to use mysql_plugin utility?
I tried to follow this official documentation to install unix_socket plugin using mysql_plugin utility but getting an error that
Cannot read plugin config file unix_socket. Bad format in plugin
configuration file.
FROM alpine:edge
RUN set -ex…
SkyRar
- 125
- 6
1
vote
2 answers
Ubuntu cannot open shared library mysqlx.so
MySQL Server version:
Ubuntu: 5.7.23-0ubuntu0.18.04.1-log (Ubuntu)
MySQL installed using apt-get.
When installing a plugin with the following command:
mysql> INSTALL PLUGIN mysqlx SONAME 'mysqlx.so';
...I receive the following error…
vishnu
- 21
- 1
- 8