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
0 votes
2 answers
2k views

Login Using MS SQL Express: Success! Migration Toolkit login: fail?

(no responses from my identical post on the MySQL forums & StackOverflow, so I'm hoping to have better luck here) I'm trying to migrate a MS SQL database for a friend. I do not have physical ...
jmccartie's user avatar
  • 153
0 votes
2 answers
2k views

MySQL NDB Cluster on FreeBSD 7.1

Got a problem with a MySQL Cluster, All the nodes connect fine to the ndb management node, however when I try to create a table on one of the nodes it returns this error : mysql> use foo; Database ...
Bruce Grobler's user avatar
0 votes
1 answer
31 views

Loading data with new lines into MySQL fails [closed]

I'm loading data into a MySQL database. It is a shared calendar that is used with the baikal calendar. I dumped the DB, and vim checked it and I can see recent events. When I load the data into MySQL ...
gstlouis's user avatar
  • 119
0 votes
1 answer
66 views

Is there a way to house one MySQL DB in one location and others in another?

Have any existing MySQL 8.0 server installation on a Ubuntu 22.04 machine. Existing works without issue, but looking to import a very large DB but doing so in its current data directory will max out ...
Chris's user avatar
  • 101
0 votes
2 answers
866 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
80 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
2 answers
109 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,108
0 votes
1 answer
179 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
1 answer
666 views

MySQL doesn't start on Ubuntu 22.04; unknown variable 'mysqlx-bind-address=127.0.0.1'

I'm facing an issue with installing MySQL server on Ubuntu 22.04. When I try to start the MySQL service using the command sudo service mysql start, I get the following error message The error message ...
SAAD 34's user avatar
0 votes
2 answers
2k views

Why /var/lib/mysql takes too much space whereas actual db is small enough

In my server Db takes too much space: Filesystem Size Used Avail Use% Mounted on /dev/root 58G 58G 461M 100% / tmpfs 966M 0 966M 0% /dev/shm tmpfs 387M ...
Dimitrios Desyllas's user avatar
0 votes
1 answer
445 views

Why is mysql-server not installing correctly?

I just launched a brand-new t4g.nano instance on AWS EC2. The first thing I typed in is apt update; apt upgrade; apt install mysql-server-8.0. Here's the full log: $ ssh -i ~/downloads/*.pem ubuntu@[...
Ryland Goldman's user avatar
0 votes
1 answer
389 views

How to back up mysql/mariadb database as mysql root when using unix socket for sql access in a bash script?

I am running Ubunutu Server 20.04. I have secured mariadb by using the unix socket for authentication, which means, I need to enter sudo mysql to be able to access mysql as root. 1) If I enter mysql -...
DanRan's user avatar
  • 123
0 votes
1 answer
669 views

MariaDB 11.0.2 fails to start after upgrade from 10.11.4

I am on Debian Bullseye and just upgraded (or at least attempted to upgrade) MariaDB from 10.11.4 to 11.0.2. Unfortunately, the service fails to start now. All I'm getting through systemctl status ...
Chaeska's user avatar
  • 51
0 votes
1 answer
163 views

Connecting to MySQL on GCP CE instance (WordPress)

I installed WordPress from the Google Cloud Marketplace into a Compute Engine instance, and am trying to connect to the MySQL instance on that machine using DataGrip on my local machine (macOS). I can ...
serlingpa's user avatar
  • 109
0 votes
2 answers
260 views

Starting MySQL standalone works but as windows service it fails

I have an xampp-portable directory that contains mysql/mariadb. The xampp directory is located directly on d:, so path is d:\xampp and mysql is d:\xampp\mysql I want to run mysql as windows service so ...
Michael's user avatar
  • 103
0 votes
1 answer
148 views

How to add a new database on replication?

I have a mysql replication with two servers. There are actually 3 databases on it. On master : server-id = 1 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days ...
erwann le guevedec's user avatar
0 votes
1 answer
1k views

Setting mysql using ansible in ubuntu remote machine

I have written one ansible playbook for installing MySQL server in ubuntu remote machine but is not working here is the yaml code --- - name: setting mysql in ubuntu hosts: web01 become: yes ...
Nikhil Chopra's user avatar
0 votes
1 answer
588 views

why mysql bin logs are not expiring even though expiry was set

I am using 5.7.37-log MySQL Community Server. my mysqld.cnf looks below: server_id = 11 log_bin = bin.log log-bin-index = bin-log.index binlog_format = row max_binlog_size = 100M socket = mysql.sock ...
santhosh's user avatar
  • 103
0 votes
1 answer
1k views

Monitoring of MySQL replication and alerting when replication is not working

I have a question about monitoring of MySQL replication and in particular about alerting using Grafana/Prometheus. We have 2 MySQL(MariaDB to be exact) instances for which replication is configured: ...
Dmitry's user avatar
  • 11
0 votes
1 answer
516 views

Automysqlbackup does not use the configured password

I have automysqlbackup installed on debian. I added USERNAME and PASSWORD to /etc/default/automysqlbackup, but when automysqlbackup runs, I get the output: /etc/cron.daily/automysqlbackup: ERROR 1045 (...
allo's user avatar
  • 1,713
0 votes
1 answer
4k views

How to fix MySQL 8 replication error 1062 after system reboot?

after a system reboot my replication stopped suddenly. So I'm trying to bring the slave back to the most current state. To do this I create a dump from the master's database and import it on the slave,...
Lars's user avatar
  • 135
0 votes
1 answer
36 views

Real time synchronization of databases with different data structure

I'm rewriting a legacy web application. At some point in time, I want old and new app, to work in parallel, on databases with different structure (both mysql). The troublesome part is that the ...
Maarduk's user avatar
  • 133
0 votes
1 answer
791 views

Can anybody explain the output of "mysql -V"?

For example, # mysql -V mysql Ver 15.1 Distrib 10.3.37-MariaDB, for Linux (x86_64) using readline 5.1 I think "Ver 15.1" means the version of the mysql client. But why does the client ...
peter's user avatar
  • 123
0 votes
1 answer
1k views

couldn't find key MYSQL_KEY in Secret default/mysql-secret

I have the following file that creates a mysql-secret for mysql deployment pod. apiVersion: v1 kind: Secret metadata: name: mysql-secret type: Opaque data: mysql-password: MTExMTEx mysql-root-...
best_of_man's user avatar
0 votes
1 answer
95 views

When and How we should specify "clusterIP" inside the "service.yaml" file?

I tried to deploy mysql and cassandra databases using kubernetes.io/docs instructions. In both of them, within the service.yaml files, they use clusterIP: None like following: For cassandra: ...
best_of_man's user avatar
0 votes
1 answer
568 views

MySQL client 8.0 showing "fwrite: Broken pipe" on large query when using a pager

I have always been using a pager (--pager="less -SFX" to be more specific) for MySQL client. Previously I was on version 5.6 of MySQL client/server and it was doing great. Recently I ...
goodbyeera's user avatar
0 votes
1 answer
271 views

How to tell which versions of TLS MYSQL (windows) is using?

I have another question about a pair of servers that I cannot turn off TLS 1.0/1.1. Even though IISCrypto showing them off and made right reg entries. The servers run an IIS10/PHP7.4/MySQL8 stack. ...
blankip's user avatar
  • 129
0 votes
1 answer
328 views

Running MySQL server as slave for one DB and master for another

I have two MySQL server having master-slave replication for DB1. The slave server holds DB2. Because the slave server is not so powerfull I want to run analytics upon DB2 on the third server. Is it ...
Ralfeus's user avatar
  • 121
0 votes
1 answer
590 views

MySQL + php due to high CPU usage app crashing

Just recently the application that I maintain started crashing, mysql's CPU usage is 100%... or more :) The application itself is quite old and has a lot of slow queries but before blaming it I want ...
Maarduk's user avatar
  • 133
0 votes
3 answers
661 views

How to grant persmission for this sql?

How to grant permission for this? Thank you for your help! ERROR is : ERROR 1142 (42000) at line 2: CREATE command denied to user '@'localhost' for table 'student' CREATE TABLE STUDENT( ID INT ...
bigstreet's user avatar
0 votes
1 answer
246 views

Enable mysqlx plugin on AWS RDS

Is there any way to enable the mysqlx plugin on an AWS RDS running MySQL 8? When I do a SHOW plugins, it shows that the mysqlx plugin is installed, but DISABLED. I have some C++ code that's using the ...
txtechhelp's user avatar
0 votes
1 answer
43 views

Clearing the mysql database with mysql chmod

I have a short URL website that i getting quite popular. I keep statistics of short urls created on the site for every user up to one year back so they can check visits on their urls. The database i ...
Erisson J's user avatar
0 votes
1 answer
1k views

ERROR 1034 (HY000): Incorrect key file for table 'mytable'; try to repair it

After upgrading mysql from 5.5 to 5.7, a compressed innodb database seems corrupted. I followed the method in this post to create a new database/table, drop the tablespace, copy the old .ibd file, ...
peter's user avatar
  • 123
0 votes
1 answer
119 views

iptables wont let me connect to mysql from remote server [duplicate]

I have 2 servers, DB_server (1.1.1.1) and app_server (2.2.2.2) created a user on DB_server for app_server (with 2.2.2.2 as hostname) But I am not able to connect from app_server to db_server. When I ...
MrG's user avatar
  • 103
0 votes
1 answer
174 views

Get usernames and IP addresses via tcpdump (or another capture tool) connecting to a MySQL server

I've MySQL installed on my Ubuntu server. Because I would like to clean up my users they're currently active in MySQL, I would like to check first which users - and from which host - are connecting to ...
Tim's user avatar
  • 1
0 votes
1 answer
367 views

error editing an item (impossible editing)

In some tables (either myisam or innodb) I get this error: CODE: SELECT ALL Warning in ./libraries/classes/InsertEdit.php#1765 implode(): Invalid arguments passed Backtrace InsertEdit.php#1765: ...
Duns's user avatar
  • 1
0 votes
1 answer
250 views

mysqldump - username takes "-p" as well

I use the following script to read database credentials from a Wordpress installation: DB_NAME=$(sed -n "s/define( *'DB_NAME', *'\([^']*\)'.*/\1/p" wp-config.php) DB_USER=$(sed -n "s/...
Torben's user avatar
  • 123
0 votes
1 answer
252 views

Use mytop as a root user, without specifying a database

Is it possible to use mytop without specifying a database? That is to say, can I use it as a root mySQL user, in order to monitor all of the databases on the server? For example, I can use the same ...
FiddlingAway's user avatar
0 votes
1 answer
797 views

Why would my WordPress website be so slow?

Goal: Make WordPress webpage load faster on local network. Currently pages load fine but take about 4-5 seconds to load. I want to cut that down to half the time or smaller. I have a two new VMs ...
Arvo Bowen's user avatar
0 votes
3 answers
771 views

MySQL connector/ODBC connection error following a DNS mismatch

I have troubles configuring a new MySQL connection with ODBC Data Sources (64bits) utility on a Windows Server 2019. I'm using MySQL Workbench to define remote accesses as follow: The user is granted ...
wiltomap's user avatar
0 votes
1 answer
73 views

MySQL Server Scaleing with AWS issues

MySql server doesn't seem to be scale up correctly when scaling up my AWS instance. Its almost like MySql is cacheing the instance sizes. This happens after a scale down the AWS instance and then when ...
Tom's user avatar
  • 101
0 votes
1 answer
217 views

postfix container kubernetes - setting up encrypted secret, configmap for successful db connection

I am trying to run postfix as a container in k8s. The container starts (including the svcs) but my config maps and secrets don't want to play nice. I tried the following: setup the config map with ...
realShadow's user avatar
0 votes
1 answer
286 views

MySQL errors after reinstalling

At first, I wanted to reinstall MySQL to repair ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) problem with command apt-get purge mysql-server,...
Thwade's user avatar
  • 1
0 votes
1 answer
160 views

Unable to connect to Azure MySQL from Ubuntu 20.04

mysql -h foobar.mysql.database.azure.com -u me@foobar -p From 18.04 and Windows 11, connection is successful. From 20.04, connection seems to hang, or never complete. I enter the password and get a ...
93196.93's user avatar
  • 291
0 votes
1 answer
952 views

OPTIMIZE TABLE innodb file per table while system is running

I had an 800 GB Moodle mdl_logstore_standard_log.ibd database file. I deleted around 900 million rows in 10-15 days. The .idb file was around 800GB and still the same size after deletion. I want to ...
Sukru Ozdemir's user avatar
0 votes
1 answer
61 views

MySQL CPU usage difference between my local server and Linode server

I have 2 similar servers, one on my local computer, the other on Linode. OS is Ubuntu 20.04 LTS on both. When I import a large database into MySQL, my local computer uses less than 10% of CPU while ...
Sam Kong's user avatar
  • 933
0 votes
1 answer
335 views

mysql_install_db wrong charset and collation

I am creating a new server with the mysql_install_db tool. It sets the correct datadir, port, password, service etc. But My problem is that the charset and collation of my base tables are wrong. They ...
Niels's user avatar
  • 101
0 votes
2 answers
3k views

High CPU usage by Apache/MySQL

I have a problem with CPU usage on the website that uses WordPress, Apache, and MySQL. During the day, from time to time, CPU usage by MySQL and Apache goes up to 2400% (I have 24 cores in total), the ...
a b's user avatar
  • 101
0 votes
1 answer
921 views

Server disk full, Mysql service can't start, how can i shrink the database?

I'm currently having a major issue. VPS disk is full, mysql database grew unexpectedly, and can't buy more space from the hosting because it's already maxed out. The mysql service can't start anymore ...
SebaSbs's user avatar
  • 113
0 votes
2 answers
515 views

WordPress unable to connect to MySQL from GCP Compute Engine VM

I have a Google Cloud Platform Compute Engine VM instance where I have Apache installed. I wanted to put WordPress on here and have the MySQL database created locally instead of using another GCP ...
dokgu's user avatar
  • 139

1
113 114
115
116 117
175