Questions tagged [mysql]
An open-source, relational database management system.
945
questions
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?
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 ...
- 23
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 ...
- 1
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% ...
- 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 ...
-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: ...
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 ...
- 11
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 ...
- 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 ...
- 81
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 ...
- 209
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 ...
- 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 ...
- 13
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 ...
- 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 ...
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 ...
- 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 ...
- 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 ...
- 1
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:...
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 ...
- 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 ...
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 ...
- 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 "...
- 21
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 ...
- 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 ...
- 113
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 ...
- 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
- 1
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 ...
- 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 ...
- 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 ...
- 1
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 ...
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.
...
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&...
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 ...
- 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 ...
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% ...
- 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 (...
- 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 ...
- 101
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 ...
- 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 ...
- 113
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=''
...
- 11
-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 ...
- 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 ...
- 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 ...
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:
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=$(...
- 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 (...
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 ...
- 135
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.
...
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"
...
- 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 ...
- 111