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.
8,730
questions
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 ...
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 ...
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 ...
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 ...
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:
- ${...
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 ...
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. ...
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 ...
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 ...
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 ...
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@[...
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 -...
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 ...
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 ...
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 ...
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 ...
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
...
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
...
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: ...
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 (...
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,...
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 ...
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 ...
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-...
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:
...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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: ...
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/...
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 ...
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 ...
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 ...
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 ...
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 ...
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,...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...