Questions tagged [mysql]

MySQL is an open-source database owned by Oracle. ServerFault topics include how to run the server. For more MySQL specific questions like backup/restore/recovery/configuration, dba.stackexchange.com is probably a better home.

Filter by
Sorted by
Tagged with
-1 votes
0 answers
14 views

VPS hosting: React + Java (SpringBoot) + MySql application does not load data from the database

I have an application developed in React, Java (with SpringBoot) and Mysql. On my local machine it is working perfectly. When upgrading to VPS hosting with Linux Ubuntu does not load the database data....
Édião's user avatar
0 votes
0 answers
93 views

How can I fix this Mysql login?

I have installed MYSQL community edition on Windows server, I also added the Environment variable to execute the mysql command. The scenario is: When I try to connect to mysql using the CMD I get the ...
sysalam0's user avatar
0 votes
0 answers
38 views

mariadb 10.3 not sending CA certificate, so clients can't verify the server [duplicate]

I've partially successfully installed a Let's Encrypt certificate for mariadb 10.3.34 I've configured a user with REQUIRE SSL and that works fine with local command line. Server system is Ubuntu 20.04....
Danny's user avatar
  • 1
0 votes
0 answers
20 views

MySQL Database refusing connection to user with USAGE privileges

I have a user 'salesman'@'%' trying to connect to my database with USAGE privileges on *.*, and SELECT privileges on one view within the database. Whenever I try to connect to the database whether via ...
o0V0o's user avatar
  • 1
1 vote
1 answer
55 views

Slow MySQL inserts on one specific machine - what might be wrong with it?

My application runs in docker, so I can be sure it's always the same version of MySQL, same DB structure, same collations and so on. I run it on several machines. On all of them my benchmark script ...
Paflow's user avatar
  • 187
0 votes
1 answer
96 views

MySQL Update Statement taking long time to update small table with 4 rows

I've got a ridiculously small table in MySQL that consists of four rows of data. Updating this table is taking a long time, often upwards of 50 seconds. CREATE TABLE log_CacheQueueEntity ( ID int(11)...
LinuxGnut's user avatar
  • 217
1 vote
1 answer
95 views

yum install mysql-devel causing openssl11-devel conflicts with 1:openssl-devel-1.0.2k-24.amzn2.0.10.x86_64

I am tring to install RMysql Package however it throughs below error - which says mysql libraries are not installed. I tried installing them using the yum command but there is a conflict with openssl....
surpavan's user avatar
  • 169
0 votes
0 answers
25 views

Proxy Error - Java Web Applications / Glassfish / MySQL / Apache

I have some Java Servlet Web applications running on Glassfish, on an AWS Linux server. The applications are integrated with a MySQL database, installed on the same server. Also, access management is ...
EduOK's user avatar
  • 1
0 votes
0 answers
29 views

have_openssl and have_ssl changed to disabled

after i created prerequisite files for having connection with mysql using SSL with commands: openssl genrsa 4096 > ca-key.pem openssl req -new -x509 -nodes -days 9999 -key ca-key.pem > ca-cert....
sina kzm's user avatar
0 votes
0 answers
37 views

mysql SSL is required but the server doesn't support it

i generated these files in my master machine : openssl genrsa 4096 > ca-key.pem openssl req -new -x509 -nodes -days 9999 -key ca-key.pem > ca-cert.pem openssl req -newkey rsa:4096 -days ...
sina kzm's user avatar
0 votes
1 answer
63 views

connection refused mysql with telnet

i have 2 machines that can see each other and ping my issue is i want to telnet from slave machine to master machine and this is what i get: slave@slave:~$ telnet 192.168.1.131 3306 Trying 192.168.1....
sina kzm's user avatar
1 vote
1 answer
44 views

Postfix Dovecot connection with MySQL8 SSL mode disabled

I have a production running installation of Postfix 3.1 and Dovecot. Recently upgraded to a new version of MySQL, passing from 5.6 to 8 hosted in a new server. The problem now is that postfix and ...
Sergi's user avatar
  • 113
0 votes
2 answers
156 views

Docker Mysql container: Connection Refused

So I have the following docker-compose.yml and .env file. version: "3" services: cx_cache: container_name: ${APP_NAME}_cache image: redis:7.2.2-alpine networks: - ${...
mondo's user avatar
  • 383
0 votes
1 answer
79 views

Mariadb active passive failover doesn't work with HAProxy

What is wrong with my HAProxy config? This thread kind of similar, but still not the same: Haproxy mysql failover load balancing I have an active-passive Mariadb galera cluster. Today on the master ...
Badb0y's user avatar
  • 115
0 votes
0 answers
30 views

Importing mysql database into Oracle OCI Ubuntu instance

I recently spun up a Ubuntu instance on Oracle OCI (https://cloud.oracle.com) to host a Laravel application. I need to be able to import a large-ish mysql database, but every time I try, it hangs up ...
mpemburn's user avatar
  • 101
0 votes
1 answer
60 views

Script is not taking systemctl commands

I have created a custom service to {start|stop|restart|reload|force-reload|status} for StoneDb(A MySQL modified version), but when checking the status then I get this error: Which is clearly means ...
H Aßdøµ's user avatar
0 votes
0 answers
35 views

E-Mails are not storing. Postfix, Dovecot & MySQL

I am trying to set up a mail server with Postfix & Dovecot using MySQL to store the aliases, domain & user. The issue is, users are not receiving emails. According to the log files, the ...
Noaah's user avatar
  • 1
0 votes
0 answers
22 views

MySQL Database errors with deadlock when restoring backup

we recently wanted to switch from a single MariaDB server to a replicated Percona XtraDB instance. For this purpose I set up an XtraDB cluster in our kubernetes cluster with 7 nodes distributed across ...
Tobias Grether's user avatar
0 votes
0 answers
41 views

Can AWS NLB be used to load balance requests to Read Replicas?

This article from Nginx describes how Nginx TCP load balancing can be used against MySQL cluster. In the first diagram, I would like to replace the Nginx LB with AWS NLB where, the MySQL cluster runs ...
cogitoergosum's user avatar
2 votes
1 answer
89 views

Is there any way to encryption password?

I'm trying master-slave replication in MySQL, and I have a question about plain text passwords. When I created an account on the master server I tried select * from mysql.slave_master_info; and the ...
game streamer's user avatar
0 votes
2 answers
83 views

MySQL getting overwhelmed after restart after an apparent crash

I found my site dead this morning, with every request timing out. systemctl restart nginx made no difference - but systemctl restart mysql did. Last night I set a long-running UPDATE query running. ...
Codemonkey's user avatar
  • 1,088
1 vote
0 answers
347 views

Connecting to MariaDB server: ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 11

I am trying to connect to an AWS hosted (RDS) MariaDB database (engine version 10.6.14). The database is hosted on a private subnet but it's accessible through a bastion host. I use an SSH tunnel to ...
Benoît Fayolle's user avatar
0 votes
1 answer
77 views

Getting below error on ActiveMQ "Classic" message broker log. I'm looking for some solution to find the root cause and fix for this issue

Getting below error on ActiveMQ "Classic" message broker log. I'm looking for some solution to find the root cause and fix for this issue. Sep 6 16:10:46 SERVER activemq_db8159[1168628]: ...
unknown's user avatar
1 vote
0 answers
55 views

Replicating foreign keys with AWS DMS Full load Ongoing replication - MySQL

I am using AWS DMS Full Load Ongoing Replication (CDC) to replicate data from a MySQL RDS to an on-prem MySQL server (both of them running MySQL 8). Before starting the replication process I'm dumping ...
Mircea's user avatar
  • 11
1 vote
1 answer
108 views

MariaDB randomly crashes

I've encountered a peculiar issue related to my MariaDB database instance (version 10.2) that causes my MariaDB service to stop unexpectedly. I've attempted to investigate the problem by regularly ...
Harry Potter's user avatar
0 votes
0 answers
41 views

Fluentd logs not sent to Elasticsearch on K8s

I have a cluster in VirtualBox to learn kubernetes. I have a deployment that contains MySQL and phpMyAdmin. I created a DemonSet that has the fluentd image and collects the logs to transmit them to ...
vasile Berco's user avatar
2 votes
1 answer
112 views

MaxScale doesn't connect to Galera Cluster

I am working on a distributed HA cloud system and I have a Galera Cluster with 3 separated servers in Docker Swarm. It works as expected. I have 3 separated services for the Galera members due to ...
milanbalazs's user avatar
0 votes
1 answer
218 views

Can’t start mysql - error.log constantly written

Recently my sites hosted on an Ubuntu server started to display "Error establishing a database connection". Connecting to the server, it looks like mysql is being restarted constantly (3s ...
Sulli's user avatar
  • 153
1 vote
1 answer
179 views

XAMPP mysql (Mariadb) has become unreliable

I have used XAMPP for years in Windows without any problems, but lately, it has become unreliable due to mysql (MariaDB). In XAMPP Control Panel mysql sometimes starts alright, sometimes it will crash ...
Mica's user avatar
  • 11
0 votes
0 answers
69 views

Applying MySQL binlogs that are too large

I am trying to recover a MySQL crash. I have data as of Monday and binlogs since then, and want to apply the binlogs as the combination would be a complete set of the data. The trouble is that ...
MaKR's user avatar
  • 111
1 vote
0 answers
127 views

MYSQL use too much disk (read / write)

I have big problem with my server. I am using Ubuntu linux version 22.04. The problem is in the write / read disk (light for the disk is all the time ON) when I have turn on apache (PHP) and MYSQL. ...
Jure's user avatar
  • 11
1 vote
2 answers
127 views

Percona MySQL 8.0.25-15 filling up slow log with headers only

Has anyone experienced an issue where when the slow log is enabled with the following options: root@(none)> show global variables like "%slow_query%"; +-----------------------------------+...
Vladimir's user avatar
  • 331
0 votes
0 answers
158 views

Why does my Docker MySQL lose privileges for some users?

I am using the mysql 8 image in a docker compose file. Periodically I discover that the mysql user I set up for a database no longer has privileges on that database. The user still exists and has ...
brad.bulger's user avatar
0 votes
0 answers
139 views

Create SSH tunnel and route MySQL traffic through using NGINX reverse proxy

My company's goal is to route MySQL traffic through an SSH tunnel, but using a reverse proxy through NGINX. We created a Linux box in our Azure environment, but are struggling to complete the process. ...
Sam Taber's user avatar
0 votes
1 answer
81 views

Passing a user input to an ssh command

I'm currently trying to create a shell script that will execute a mysqldump on a remote mysql database and then copy the output file back to my local machine. The problem I'm running into is that I ...
pbuchheit's user avatar
  • 161
0 votes
0 answers
152 views

My PHP sites do not work with mysql router

I recently set up a mysql innodb cluster, and have configured mysqlrouter to sit in front of it. On my PHP applications, if I change the port from 3306 to 6446, the application hangs when it tries to ...
elyograg's user avatar
  • 249
0 votes
0 answers
50 views

MacOS MySQL Client Gets Stuck on Query That is a Certain Size

My MySQL client gets stuck on a query when the output is a certain size. When it's small enough, the query will successfully output. The client is connecting to a remote server (Ubuntu 18.04). When I ...
Grant Gordinier's user avatar
0 votes
0 answers
39 views

Which is the correct capability in Courier SMTP config to get user's password (encryption type)

MySql: 8.0.34-0ubuntu0.22.04.1 I have followed this guide: Postfix With Courier IMAP Mail Server Installation (unfortunately they do not answer questions). I had to change the encryption method for ...
Andrés Chandía's user avatar
0 votes
0 answers
100 views

Disable auto reconnect for remote client connections in mysql

I use below version of MYSQL in my DB server. root@XXXXXX-test-server:~# mysql -V mysql Ver 14.14 Distrib 5.6.16, for debian-linux-gnu (x86_64) using EditLine wrapper root@XXXXX-test-server:~# ...
Dhanushka Ekanayake's user avatar
0 votes
1 answer
362 views

MariaDB 10.3.38 does not start after change from MySQL 5.7.41

I replaces MySQL 5.7.41 with MariaDB 10.3.38 on Ubuntu 20.04. Unfortunately MariaDB does not start by itself over systemctl: sudo systemctl status mariadb ● mariadb.service - MariaDB 10.3.38 database ...
Clueless's user avatar
1 vote
0 answers
162 views

Using MySQL/MariaDB replication, how to know when the Replica is in a consistent state?

This is a question about MariaDB (mostly) and a replication that I am considering. For this replication, the Primary database is updated every minute by a process which can take about 15 seconds to ...
GingkoFr's user avatar
2 votes
1 answer
216 views

Is it possible to have MySQL/MariaDB bidirectional replication?

I am trying to install replication on several MariaDB servers. With no experience at all on this. I am wondering something. Would it be possible to have both servers acting simultaneously as master ...
GingkoFr's user avatar
0 votes
0 answers
35 views

Getting broken pipe error after spending significant time idle in mysql command line

I often spend a lot of time in my MySQL console - managing databases, making sure the integrity is in tact and browsing through recent records for possible vulnerabilities. Whenever I am active with ...
Dimitar Veljanovski's user avatar
0 votes
1 answer
49 views

Unknown MySQL syntax error during the WordPress installation

I'm trying to install Wordpress on my local server according to instruction described on this page And now I'm stuck on this step: GRANT ALL ON wordpress_db.* TO 'wp_user'@'localhost' IDENTIFIED BY '...
ghostone's user avatar
0 votes
1 answer
86 views

Unable to connect to my server

I'm unable to connect to my own server, which has a MySQL database which I want to access. I correctly opened the 3306 port on the router and called my internet provider that confirmed so. But when I ...
Zep's user avatar
  • 1
0 votes
3 answers
56 views

4 unicode chars appear as first few characters in file which don't seem to show in vim

vi data.sql : -- MariaDB dump 10.19 Distrib 10.4.28-MariaDB, for Win64 (AMD64) But when I do head -n 10 data.sql I get the first line as ��-- MariaDB dump 10.19 Distrib 10.4.28-MariaDB, for Win64 (...
anjanesh's user avatar
  • 337
0 votes
0 answers
666 views

mysqld[1108] [Warning] Aborted connection 7466 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1'

I am running Ubuntu Server 20.04. It is a LEMP server running Mariadb. When I run the command sudo service mariadb status I get the following warnings: Jul 28 00:18:59 mail.example.com mysqld[1108]: ...
DanRan's user avatar
  • 103
1 vote
1 answer
148 views

MariaDB / MySql Warning after Netdata installation. "Access denied for user 'netdata'@'localhost' (using password: NO)" How to fix?

I have configured Netdata on an Ubuntu 20.04 Server LEMP server, according to this Linuxbabe.com tutorial. After installation, I run the following command sudo systemctl status mariadb.service which ...
DanRan's user avatar
  • 103
1 vote
1 answer
146 views

Memory consumption on virtual server too large for applications being run

I have a Linux Ubuntu virtual server at Digital Ocean with the following specs: 1 vCPU, 2GB of memory, and 25GB of SSD storage. The server is running a single WordPress website with around 400 unique ...
Mike Hermary's user avatar
0 votes
0 answers
15 views

H3C server requirement [duplicate]

I am searching for a server that can best fulfill my requirements. I need it specifically for the best DB I/O performance for a 10-million record database. I am looking for generation-specific details ...
sysdev's user avatar
  • 1

1
2 3 4 5
174