Questions tagged [mysql]

An open-source, relational database management system.

Filter by
Sorted by
Tagged with
0 votes
0 answers
12 views

How to upgrade MySQL 8 community server minor versions?

Currently I have installed MySQL 8.0.26 in Oracle Linux server. But due to the security vulnerabilities I have to upgrade it to 8.0.27. Is there way to do it?
user avatar
0 votes
0 answers
8 views

Install phpMyAdmin on hostname in Webmin/Virtualmin for all accounts (on hostname) automatically like cPanel does?

The way Webmin seems to install phpMyAdmin is to install it inside the public_html directory. e.g. https://mydomain.com/phpMyAdmin I don't want to debate the vulnerability, instead I want phpMyAdmin ...
user avatar
0 votes
0 answers
18 views

crontab - mysqldump is using different socket [duplicate]

First, I have already permanently set the PATH directory of MySQL in my .bashrc so I can use it in terminal in any directory. To verify this process, I restarted my computer, open the terminal and use ...
user avatar
0 votes
1 answer
17 views

Interpret the top command in ubuntu

I am attaching a screenshot of a top command launched on my server, I cannot understand how to interpret it. I would like to understand if the RAM is in trouble. Also I see mysql which is over 100% ...
user avatar
  • 101
0 votes
0 answers
15 views

The error message was : 'error:brokencount>0'. this usually means that your installed packages have unmet dependecies

I have tried sudo apt-get update (it is working fine) After that when i do sudo apt-get upgrade this error is displaying: Reading package lists... Done Building dependency tree Reading state ...
user avatar
-1 votes
2 answers
60 views

How to solve NO_PUBKEY 8C718D3B5072E1F5

I am facing a problem now when I do the following command on debian version 9.13: sudo apt-get update I get this error: Fetched 21.6 kB in 0s (34.9 kB/s) Reading package lists... Done W: GPG error: ...
user avatar
1 vote
0 answers
35 views

How can I reset my lost MySQL root password? [duplicate]

I created a new DigitalOcean droplet and stupidly deleted the env file in the root to clear it out so I could setup my application. The only recorded place that had the root user's password. I'm ...
user avatar
0 votes
1 answer
66 views

APT-KEY GPG --recv-key process hangs without any network traffic

On Debian 11, running as root. I am attempying to add the mysql repository public key (due to the expiry in Feb) and update to mysql 8.0, but every apt-key or gpg command I run just HANGS. Even adding ...
user avatar
  • 97
0 votes
2 answers
298 views

Unable to install MySQL Workbench

When i try to install the official MySQL Workbench, it shows dependency issue of the unavailabilty of libproj19. However the repos only has libproj22 when i tried to install from APT. Can someone help ...
user avatar
0 votes
1 answer
18 views

ssh reverse mysql tunnel with a aliased host

I am trying to ssh into my server and then access the mysql on localhost for quick prototype development when testing on live. Here is my connection in the server: mysql -h db_master_www -u game -D ...
user avatar
0 votes
0 answers
23 views

Our MySQL is read heavy, but iostat reports that almost no reads are taking place. How come?

According to MySQL's STATUS command, we have about 500 reads and ~20 writes to our DB per second. But iostat is reporting that ~70 writes (w/s) and ~0.5 reads (r/s) are taking place on the ...
user avatar
  • 103
1 vote
1 answer
21 views

How to determine if mysql is using directory under mounted directory?

I currently have MySQL using /home/foo/data/database as its datadir. With /home/foo/data/database being a mounted raid 1 array. The problem I am having is that every once in awhile on boot MySQL is ...
user avatar
1 vote
0 answers
17 views

Why does mysql-server installation not request root password from me?

I have recently ran into a problem, I was trying to change root password, which I forgot, but it seems that I somehow managed to completely break the mysql service itself and due to the fact many of ...
user avatar
  • 11
0 votes
0 answers
7 views

How can I sort the itmes in group_concat?

I have on table id name 6305 MUG 6305 TUG 6350 TUG 6350 MUG With my buggy command select replace(GROUP_CONCAT(p.name),',','; ') from p where p.id in( 6305,6350) GROUP BY id order ...
user avatar
0 votes
1 answer
48 views

How to send systemd Start - Stop - Reload syslog messages to a file

I'd like to send Start/Stop/Reload systemd messages to a specific file. Specifically, mysqld doesn't seem to send daemon start/stop messages to the log-error file, so I'd like to have... something in ...
user avatar
  • 684
0 votes
1 answer
75 views

Why does this init.d script sometimes not run at shutdown?

I'm on Debian 10 Buster. I can't figure out what's wrong with this init.d script? Sometimes it doesn't run at server shutdown. My MySQL error_log fills up with "Status information" when the ...
user avatar
  • 684
0 votes
0 answers
24 views

How to restore mariadb to default after DB corruption

my DB got corrupted after that there was no free space available. I have tried many solutions, but nothing works so far. I have a backup of my application DB but not of the whole mysql DB. Despite ...
user avatar
0 votes
1 answer
21 views

restricted ssh tunnel through external facing server to mysql on internal server

Using my user I'm able to set up an ssh tunnel to mysql (port 3306) on an internal server by tunneling through an external server using: ssh -L 33306:localhost:33306 me@external.com ssh -L 33306:...
user avatar
0 votes
0 answers
38 views

installing mysql-community-server end with mysql-community-server

I am installing mysql-community-server on kali but receiving following error: Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using ...
user avatar
  • 1
0 votes
1 answer
2k views

Please help! Sub-process /usr/bin/dpkg returned an error code (1) Installing MySQL on Ubuntu

I'm trying to install mysql with Ubuntu and I've spent the last 3 days purging MySQL and redownloading to no avail. Most of the solutions I found didn't work for me, and they are all some variation of ...
user avatar
0 votes
0 answers
74 views

What is eating up my CPU?

I am facing a difficult situation. 100% CPU but I cannot see a singular process using much in top or htop. I run this command: :~$ ps -eo pcpu,pid,user,args | sort -k 1 -r | head -10 %CPU PID USER ...
user avatar
  • 407
1 vote
1 answer
101 views

Can't login to phpMyAdmin on Centos, Google Cloud

In my MySQL database, I've created two users, one regular user (who has privileges for one database) and one superuser. When I want to login via any of these accounts to phpMyAdmin I get a "...
user avatar
0 votes
0 answers
14 views

Any clues for using a mysql installation on a bitlocked W10 drive, from Linux OS on dual boot?

Booting to Linux Mint 20, I just installed a LAMP stack on this machine, accepting all default choices. But I already have all my databases on a Windows 10 bitlocked partition (now unlocked and ...
user avatar
  • 1,042
0 votes
0 answers
20 views

How can I automatically copy automysqlbackup backups to another machine?

I have Ubuntu Server 20.04 LTS installed on a Hyper-V virtual machine which is on Windows 10. I use automysqlbackup utility to create backups of my database on Ubuntu. How can I automatically copy ...
user avatar
0 votes
0 answers
95 views

mysql fail to start after restarting mysql server on CWP

I restarted the MySQL server by pressing the "restart" button inside CWP web panel and the server stopped working and gave me this error. Warning: mysqli_connect(): (HY000/2002): Too many ...
user avatar
  • 101
-6 votes
1 answer
55 views

"Your password does not satisfy the current policy requirements" [closed]

I get this error after trying to open MySQL from the terminal: ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
user avatar
0 votes
0 answers
58 views

Use a virtualbox shared folder as mysql data storage

I am trying to use a vbox mysql server's (host: Debian 11, guest: Debian 11) shared folder to host its mysql data. Basically the guest machine runs mysql server and I would like to store its data in a ...
user avatar
  • 709
1 vote
1 answer
39 views

Bash non-interactive mysql database creation issue

I have a bash script that utilizes dialog to show the progress bar during non-interactive Mysql database creation. System OS: Ubuntu 20.04 server Mariadb: 10.5 The issue: Only the first Mysql command ...
user avatar
  • 43
0 votes
0 answers
15 views

Mysql Error on start

i have installed on an Ubuntu System an Maria DB Server with Plesk and i have received now this error from the maria db server: mariadb.service: Main process exited, code=exited, status=1/FAILURE how ...
user avatar
2 votes
2 answers
85 views

swap position of consecutive multiple lines in after pattern matching

I am trying to edit a big text file. What I am trying to achieve is swap lines from positions between 3 and 14 to positions between 16 and 27. I have extracted UPDATE statements from MySQL bin-logs ...
user avatar
1 vote
2 answers
623 views

MariaDB & Amazon Linux 2: ERROR: ld.so: object '/usr/lib64/libjemalloc.so.1' from LD_PRELOAD cannot be preloaded

Following AWS documents, I'm attempting to get a basic LAMP server up and running. Everything appears to be working fine. Logging into MySQL either through the terminal or phpMyAdmin (GUI) works. ...
user avatar
1 vote
5 answers
155 views

Append text on lines NOT matching pattern

INSERT INTO `db`.`table` VALUES ( 39741633 49302045 0 44 '{"CustomerName":"S","CustomerMobile":"8","CustomerEmail":"","VersionId&...
user avatar
0 votes
0 answers
304 views

Run mysql get code=exited, status=127

system:centos 7.2.1151 mysql:mysql-5.7.27-1 When MySQL is installed on the server, it cannot be started. There is only the error code code = exited, status = 127, and ,when I checked mysql.log and ...
user avatar
  • 1
0 votes
1 answer
97 views

Can't restart MariaDB after adding datadir line to my.cnf file

Having a issue getting MariaDB to restart after adding the following line to the [mysqld] section of my.cnf: datadir = /home/mysql It won't restart. Could this be a permissions issue. This is the ...
user avatar
0 votes
1 answer
44 views

Free up mysql space on low-disk PC

I have a PC with a small disk: Filesystem Size Used Avail Use% Mounted on /dev/root 3.5G 3.1G 249M 93% / devtmpfs 459M 0 459M 0% /dev tmpfs 463M 0 463M 0% ...
user avatar
  • 550
-1 votes
1 answer
80 views

mysql on artix linux gives the 'ERROR 2002 (HY000)'

I'm using artix linux with runit init system and I've stumbled upon this issue where I can't login into mariadb by using sudo mysql -u root -p because it gives me the following error: ERROR 2002 (...
user avatar
  • 21
0 votes
0 answers
363 views

Error installing MySql: E: Sub-process / usr / bin / dpkg returned an error code (1)

I can't install MySql. When I install sudo apt install mysql-server, I get an error. In the past I received this error that blocked any type of update for any software, but I solved the problem and ...
user avatar
1 vote
0 answers
41 views

Dovecot - password query syntax error

Whenever Thunderbird attempts to connect to my server I receive an error in the maillog of dovecot: auth-worker(32527): Error: sql(admin,xxx.xxx.xxx.xxx,): Password query failed: You have an error in ...
user avatar
  • 11
1 vote
1 answer
362 views

start mysql/mariaDB service after datadir change

I installed the mariadb server and create a root user with a password with sudo apt install mariadb-server sudo mysql_secure_installation Since I use a Rasperri Pi I want to swap the DB to an ...
user avatar
1 vote
1 answer
291 views

How to pass dynamic variables in a mysql query using shell script

This is the part of my code: sample_1='' sample_1_is_cancelled='' sample_2='' sample_2_is_cancelled='' sample_3='' sample_3_is_cancelled='' sample_4='' sample_4_is_cancelled='' sample_5='' ...
user avatar
-1 votes
1 answer
464 views

How to parse through the SQL output stored in a Shell variable in Bash

This is the shell script I have written to get data from report_data table from "merlin" database. data=$(mysql merlin -BNe 'select * from report_data') echo "$data" The Output ...
user avatar
  • 1
1 vote
1 answer
108 views

How to query mysql from cron script?

I have the following code in my script: mapfile results < <(mysql --batch -u $DB_USERNAME -p$DB_PASSWORD $DB_DATABASE < query.sql) and it works fine if running from command line. But if ...
user avatar
  • 2,617
1 vote
1 answer
236 views

Want to install MYSQL 5.7 in Ubuntu 20.04 : GET ERROR Start request repeated to quickly

I need to install MySQL 5.7 on an Ubuntu 20.04: I did this here. Before I did apt purge mysql-client mysql-server which removed the version 8.0.X from my system. But at installing the apt install ...
user avatar
0 votes
0 answers
131 views

Polkitd uses too much percent of CPU

Im using ispmanager panel on centos and noticed that polkitd uses almost 100% of the CPU, what could it be? Nginx, php-fpm, MySQL with direct access htop:
user avatar
0 votes
0 answers
38 views

Automating mysql_secure_installation on Oracle Linux 8

I'm trying to automate mysql_secure_installation for Mysql 8.0 on Oracle Linux 8. After searching on web I got the below script. #!/bin/bash MYSQL_ROOT_PASSWORD="test@123" SECURE_MYSQL=$(...
user avatar
  • 11
0 votes
1 answer
230 views

Problem configuring MySQL on Linux Ming ("Unit is masked")

I have a Linux Mint 20.2. I installed MySql Ver 8.0.26 (20.4). I got this message when trying to run: mysql.service Loaded: masked (Reason: Unit mysql.service is masked.) Active: inactive (...
user avatar
1 vote
1 answer
558 views

problem running mysql in Arch Linux

downloaded MySQL 8.0.36 from the AUR repository and then ran sudo systemctl start mysqld (after running sudo systemctl enable mysqld). However, it gives the following error: Job for mysqld.service ...
user avatar
0 votes
0 answers
26 views

Error when installing MySQL on Debian Linux

Today, we noticed our server went down and are attempting to reinstall MySQL. When doing so, we are presented with the following: You might want to run 'apt --fix-broken install' to correct these. ...
user avatar
1 vote
2 answers
210 views

Why can't paste or type special character into MariaDB shell?

My os info: uname -a Linux debian 5.10.0-8-amd64 #1 SMP Debian 5.10.46-4 (2021-08-03) x86_64 GNU/Linux Locale setting: locale LANG=en_HK.UTF-8 LANGUAGE=en_HK:en LC_CTYPE="en_HK.UTF-8" ...
user avatar
  • 85
0 votes
1 answer
24 views

Constant concurrent connections drain my server storage

I apologize in advance if this question is in a wrong forum, this is my first question here! My client has hosting with Aliyun Cloud (Alibaba Cloud in China). I've deployed a microsite to their ...
user avatar
  • 111

1
2 3 4 5
19