All Questions
692
questions
0
votes
2
answers
57
views
Not able to connect to MySQL from postfix
opensource community
I am using Postfix, dovecot and Postfix Admin for my complete email setup
I am using virtual users so I have installed postfix-mysql and dovecot-mysql
Issue:
My postfix service is ...
0
votes
0
answers
73
views
Can't access MySQL DB after failed import
Set off a mysql import which ultimately failed due to HD space being maxed out.
Since then, I'm not able to drop either the table it was being loaded to or the DB the table belongs to (only one table ...
- 101
0
votes
1
answer
201
views
Not able to connect to local MySQL install after using Docker and MySQL image to connect to secondary DB on external drive
Huge appreciation for help in advance. Using Ubuntu 22.04 and MySQL 8.
I have a legacy MySQL DB on an external hard drive as well as a local install on my Ubuntu machine, both using MySQL 8.
I set up ...
- 101
0
votes
0
answers
190
views
MariaDB not starting after a server restart
I'm running a LEMP stack for my websites and they were running fine. Monitoring showed that the server wasn't responding to the pings, I restarted it. Now MariaDB service isn't running, my websites ...
- 1
0
votes
0
answers
118
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....
- 33
1
vote
0
answers
392
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 ...
- 33
0
votes
1
answer
412
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....
- 33
1
vote
0
answers
198
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. ...
- 11
0
votes
1
answer
138
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 '...
- 5
1
vote
1
answer
1k
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]: ...
- 93
1
vote
1
answer
205
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 ...
- 93
0
votes
1
answer
1k
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 ...
- 1
0
votes
0
answers
60
views
Web server returning high number of 502 and 504s
We have a web application (LAMP stack) with traefik as a reverse proxy that is suddenly giving HTTP 502 and 504 errors on >50% of requests, both for static files and php scripts. In the traefik ...
- 101
0
votes
1
answer
539
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
545
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 -...
- 93
1
vote
2
answers
381
views
Forward default mySQL port to a different port for outgoing traffic to a specific IP or Domain
We're using a hosted mySQL Database server which generates a port other than the default 3306, which we have no control over.
We'd like to not have to make changes to our existing connection scripts ...
- 11
-1
votes
2
answers
282
views
How can I stop my MySQL server from going down?
I have a website based on a MySQL server on an Ubuntu machine. Every several weeks, one of my users complains that the site does not work, and I find out (using service mysql status) that it is ...
0
votes
1
answer
260
views
PuTTY Reverse Tunnel to MySQL
I have:
A local Windows 10 PC running MySQL Server 8.0.33 on port 33060.
A remote Ubuntu 20.04.6 LTS VPS running MySQL Server 8.0.33 on port 3306.
I want to create a reverse tunnel using PuTTY on my ...
- 221
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
1k
views
Diagnosing mySQL Random CPU Spikes
Our organization has a fairly advanced (as in many moving pieces) web application that's been working great up until recently, yet no noticeable changes have been made.
There is the Apache Web Server, ...
2
votes
1
answer
664
views
Extremely slow MySQL writes in Ubuntu (ext4) guest on Promox 7.3-3 (ZFS) host
I'm trying out Proxmox 7.3-3 as a hypervisor and managed to install it using ZFS on my NVMe (Samsung_SSD_970_EVO_Plus_2TB_S6S2NS0T505403V)
I also installed a Ubuntu 22.04 VM and its filesystem is ext4
...
- 154
1
vote
1
answer
387
views
PHP-FPM static max_children amount doesn't seem to matter much during stress tests
I've been stress testing PHP-FPM set up as static using wrk, with NGINX running on Ubuntu Server 22.04 for the past few days, writing down results for every scenario. When I look at them, it seems to ...
-2
votes
1
answer
309
views
How to fix MySQL installation in Ubuntu:20.04 Docker container
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of start.
...
Cannot stat file /proc/3352/fd/0: Permission denied
Cannot stat file /proc/3352/fd/1: ...
1
vote
0
answers
483
views
MYSQL Server fails to start with no logs - Ubuntu on WSL
I'm running Ubuntu in WSL on Windows 10.
I'm trying to get an owncloud server going but I've been unable to get mysql working.
When I run sudo service mysql start it takes it's time before reporting: [...
- 123
0
votes
0
answers
546
views
Undestanding how to connect remotely to a Mysql database
Even if I found many old questions around this topic, I'm still unable to connect to a mysql database remotely.
Beside my own specific issue I'd like to point out what are my doubts, in hope to serve ...
- 1
0
votes
1
answer
424
views
Ubuntu can't start/configure mysql-server after upgrading ubuntu from 18.04 to 20.04
I've got a problem with Ubuntu that I can't resolve. I was upgrading my Ubuntu from 18.04 to 20.04 and during the installation process and error occured:
apparmor parser error for /etc/apparmor.d/usr....
0
votes
2
answers
425
views
MySQL shuts down
Got unexpected shutdown of mysql in my VPS server (with 40GB SSD, 2GB ram and 2 vCPU's). Hosted only one website (with LAMP stack). Of course - increased some mysql limits for bigger queries which are ...
- 1
0
votes
0
answers
68
views
Can't login with a unique username into mysql
I am trying to connect a existing server files with my new machine. I need to be able to connect with a username "????", but for some reason mysql is not accepting that.
Using root as ...
1
vote
1
answer
571
views
Keep MySQL strict mode disabled after server restart (Hostinger VPS with Ubuntu 18.04)
So I have a site hosted on VPS Hosting Plan 2 of Hostinger, and it uses MySQL for the database, with the OS of my Virtual Machine being Ubuntu 18.04.
I have to keep MySQL's strict mode disabled ...
- 113
1
vote
1
answer
80
views
Jaguards database configured incorrectly
After following the steps given in the README of the open source tool provided by Jaguards, I always get the "Database configured incorrectly" warning icon, and can't manage to login with ...
- 21
1
vote
0
answers
115
views
Swap space extensively used while enough RAM is available on Ubuntu 20.04.01
On a new dedicated root server with Ubuntu 20.04.01, running only MySQL 8.x the system starts to swap extensively while enough RAM is available.
System:
RAM 230GB
Swap space 64GB
InoDB_Buffer set to ...
- 2,192
2
votes
2
answers
866
views
MySQL keyring component configuration
I am having the exact same issue as described by user nerdgeekdork here:
MySQL keyring component (not plugin) not loading on server startup
I have tried setting up the component in the same way, as ...
- 21
0
votes
0
answers
1k
views
ERROR 2003 (HY000): Can't connect to MySQL server on '1.2.3.4' (10060)
I've tried to look for a solution and there are many similar questions but somehow none of the solutions are working.
I have a laravel app running on one of my ubuntu servers at 1.2.3.4 IP. I ...
- 1
0
votes
0
answers
819
views
MySQL 8 won't autostart at boot on Ubuntu 20.04: Can't start server: Bind on TCP/IP port: Cannot assign requested address
I've a fully up-to-date Ubuntu 20.04 with MySQL 8.0.30 provided by mysql.com.
MySQL is set to autostart at system boot (systemctl enable mysql).
Lately I've a problem when I restart the server: MySQL ...
0
votes
1
answer
1k
views
ib_logfile0 size 44895232 is not a multiple of innodb_page_size after Ubuntu upgrade
I was upgrading Ubunto from 18 to 20, and lost SSH during mysql upgrade.
Mysql won't start now. It has the error:
ib_logfile0 size 44895232 is not a multiple of innodb_page_size after Ubuntu upgrade
...
- 99
0
votes
0
answers
214
views
Are there any big performance boost when upgrade from Ubuntu 16.04 to 22.04?
If I run the server as MySQL database. (Assume using the same MySQL version).
Are there any big performance boost when upgrade from Ubuntu 16.04 to 22.04?
- 6,101
2
votes
4
answers
1k
views
MySQL keyring component (not plugin) not loading on server startup
Problem:
There is no indication mysqld is actually reading the server manifest and/or the keyring component configuration file. Any help would be greatly appreciated.
System Info:
Ubuntu 20.04
...
- 21
0
votes
1
answer
187
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 ...
- 1
3
votes
1
answer
4k
views
Mysql constantly writing to binlog, rapidly using up disk space
My Ubuntu server started running a high amount of IO operations. The server has a few WordPress websites on it, but they get at most a few dozen views per day. In a couple of days 30GB of disk space ...
- 133
0
votes
0
answers
178
views
MySQL Replication Master => Slave => Master
I have set up MySQL master-slave replication successfully. But I realized it doesn't work if I would like to simulate the real-world case. Here is my scenario:
Make sure the data have been fully ...
- 171
0
votes
0
answers
2k
views
MySQL doesn't start
Today I wanted to restart mariaDB because I couldn't connect to the database anymore. When I tried to restart it, I got these errors:
● mariadb.service - MariaDB 10.7.3 database server
Loaded: ...
- 101
0
votes
0
answers
294
views
mysql service crash (ubuntu server)
mysql service craches and the server becomes down everyday or every two days and I do not know the reason (I am using apache and innodb).
mysql error log:
2022-03-12 11:11:22 140142364764096 [Note] ...
- 101
0
votes
1
answer
3k
views
Failed to Import MySql database from phpMyAdmin as well as Command line
Well, I have tried to import small size database, it works. However, when I am about import a large database it shows the following error from phpMyadmin.
Static analysis:
1 errors were found during ...
1
vote
3
answers
8k
views
Cannot acces to localhost mysql server. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
I have inherited an ubuntu machine with mysql installed and I don't know how. My problem is that i can't access to mysql.
Here some info of my host:
cat /etc/os-release
NAME="Ubuntu"
VERSION=...
- 11
1
vote
2
answers
2k
views
How to downgrade mysql-client from 8.0.27 to 8.0.26 on Ubuntu
MySQL 8.0.27 has a bug when used to connect to Azure, where it uses all CPU resources and never connects.
Therefore I would like to downgrade to 8.0.26
What I have tried so far:
#uninstall any mysql ...
- 253
0
votes
1
answer
1k
views
MySQL Dump on Ubuntu 20.04 returns 0 byte file and runs indefinitely. Works on Ubuntu 18.04
I am using identical configs on Ubuntu 20.04 as I was previously on 18.04; however, on 20.04 the CPU shoots up to 50% usage and the process runs indefinitely, and by indefinitely I mean it was running ...
- 253
1
vote
1
answer
149
views
MySQL is 100% CPU over the past week, no idea why, details below
I'm trying to work out why MySQL is hitting 100% over the past week:
It's a server that does network/server monitoring called LibreNMS.
Top:
https://pastebin.com/1qypfm0n
Here I access MySQL and look ...
- 11
0
votes
1
answer
65
views
Multiple Website Lampp Stack [closed]
I currently have a Xampp on my local machine(ubuntu) for web developpment, this one is for study.
Then I have, before the Xampp, a lampp stack with wordpress for work.
After setting up Xampp my ...
1
vote
2
answers
967
views
Hide my password in Ansible Playbook
I would like to run mysqldump in the Ansible playbook by the shell module. Trying to find a way to hide my MySQL root password in the ansible playbook or Ubuntu.
I currently have a file that was ...
- 171
2
votes
1
answer
1k
views
MYSQL is at 197% CPU usage ~ not allowing site to run
Spec: 8 GB memory / 4 vCPUs / 25 GB ssd
Ubuntu 20.04
My website got hit with a DDoS recently and had this continuous high CPU usage error for 4 days and the site will not load up, I take a look using ...
- 21