Questions tagged [mysql]

An open-source, relational database management system.

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

yum installing mysql-server 5.5 instead of 5.7 on Amazon Linux

My understanding of yum is that it should default to installing the latest version of a package available in all the repos enabled. The default repos installed in Amazon Linux 1's AMI include the ...
2
votes
1answer
313 views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) but I have a password in place

I have been trying to install phpmyadmin on my Debian 9 (stretch) system, I already have apache, php and mysql installed and working. When I run sudo apt-get install phpmyadmin it downloads but the ...
0
votes
0answers
30 views

How to generate the conection string to mysql-server in linux

I have an asp.net core app with user authentification working fine in my windows machine (I've got MySQL server for windows). I want to deploy it on my Linux machine. Everything works fine except for ...
18
votes
3answers
33k views

How to pass password to mysql command line

I have MySQL password saved on a file foo.php, for example P455w0rd, when I try to use it: $ cat foo.php | grep '$dbpwd=' | cut -d '"' -f 2 | mysql -U root -p mydb -h friendserver Enter password: (...
1
vote
0answers
43 views

SSH Tunnel/Reverse Tunnel Question

I am attempting to daisy chain tunnels/ports to access mysql on a secured server. Without opening up iptables, I would like to, from my local machine: mysql -uadmin_user -p -hlocalhost:8002 and ...
1
vote
0answers
24 views

Port not available on the same network(MySQL with docker)

I have two servers in one network. 192.168.202.5 netmask 255.255.255.0 192.168.202.32 netmask 255.255.255.0 On second server I start MySQL using Docker Compose. docker ps CONTAINER ID ...
0
votes
1answer
2k views

Modifying SELinux settings to allow for MySQL to run on CentOS7

I'm trying to install MySQL 5.6 on Cent OS 7 with SELinux enabled and am trying to get past the error (in /var/log/audit/audit.log): type=AVC msg=audit(1424111345.853:558): avc: denied { execmem } ...
-1
votes
1answer
24 views

mysqldump have issue in cPanel cron job

To create auto backup of database, I am using this command in cPanel cron job mysqldump --opt -Q -u {mysql_user_name} --password='{password}' {database} | gzip > /home/[account_name]/db_backup/...
0
votes
1answer
15 views

How to make a Mysql request to get GLPI data?

I have an ip of host where glpi database is installed. I have to make a mysql request to get data from glpi database. I have also a login and a password. The basic command like this mysql -h 192....
0
votes
2answers
1k views

PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/www/html/

I am working with php(7.3) and mysql in linux machine. But I am getting PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/www/html/ error in apache2 log file (/var/log/error.log). I ...
0
votes
0answers
26 views

Error using mysqlfrm to restore database

Good afternoon. I need to restore a base named "bignew", and I have .frm and .ibd files only. As my SGBD, I'm used XAMPP in a Linux Mint 19. Reading many posts, I opted for install and try mysqlfrm. ...
0
votes
1answer
62 views

SElinux configuration of symlinked /etc/my.cnf -> /app/program/my.cnf

Please advise me of whether it is possible to configure SElinux context in a way that MariaDB would pick it up. current configuration: ls -lZ /etc/my.cnf lrwxrwxrwx. root root system_u:object_r:...
5
votes
4answers
11k views

Is it possible to install mysql 5.7 on Amazon Linux AMI?

I tried installing and I am seeing the error Error: Package: mysql-community-server-5.7.17-1.el7.x86_64 (mysql57-community) Requires: systemd You could try using --skip-broken to work around ...
0
votes
0answers
121 views

mysql taking 100% of CPU

I had a problem with my VPS like a week ago, and I had to completely reinstall it for it to work. It worked, but just for a while. Everything was alright until now, I really don't know what the ...
4
votes
1answer
97 views

AWS EC2 infrastructure

I was on a job interview today and one question I faced was: I have my application running within a docker container on an EC2 instance (AWS Linux 64bit). The docker containers we use for the ...
1
vote
1answer
143 views

Bash Parallel MySQL Dump

I have a project on AWS which will eventually have over 100 client databases each estimated in the 1~2GB size. I need to do daily backups of each database via mysqldump not the standard AWS RDS daily ...
0
votes
2answers
4k views

Bash script using mysql command with variables failing

I have a script to clone a vhost and associated db - however one of the mysql commands doesn't work. It fails and ends up outputting the mysql version number and 'how to use' info as if it hasn't been ...
4
votes
5answers
12k views

No space left on device on CentOS7

My machine which OS is CentOS7 have to backup 50G data into MySQL. But, there is no space left on the device. But there are many spaces on /home. How can I make user that there are enough space for ...
0
votes
0answers
28 views

Mariadb running out of memory

I have an old web server that's been running for some time, with regular updates. For the last month it's been crashing every few days. I tracked it down to: $ dmesg Out of memory in UB 136: OOM ...
0
votes
0answers
32 views

MySQL Replication from older master to newer slave - Unknown system variable 'binlog_checksum', 'SERVER_UUID'

So, here is the master: [04:18] [master ~] # mysql -V mysql Ver 14.14 Distrib 5.5.62, for Linux (x86_64) using readline 5.1 And slaves: [08:37] [slave1 ~] # mysql -V mysql Ver 14.14 Distrib 5.7....
5
votes
1answer
18k views

ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded mysql

mysql is giving me this error when I try to access it for the first time. It's not working for me; I have Parrot OS, which is based on Debian Jessie. The problem started with adding the mysql ...
0
votes
0answers
166 views

Pacemaker cluster service can't start properly Couldn't mount filesystem

I have 3 nodes MySQL cluster on RHEL 7.5 with DRBD, Pacemaker and after start cluster getting following error. How can I overcome ? [root@db1 ~]# pcs status Cluster name: mysql_cluster Stack: ...
0
votes
1answer
28 views

MySQL - OS tied users

So, I'm trying to find this option and I can't find it in the docs. I need to know if there is a way in MySQL in which every user on the OS is also a User on the dB. Just to clarify, when using ...
0
votes
1answer
44 views

How to script SSH connection using keypair and password?

I managed to login to my hosting provider manually with this command: ssh -i /path/to/key-ssh me@mydomain.com The server then asks for a password, and login succeeds. Now I want to automate a ...
1
vote
1answer
199 views

problem with apt upgrade when install MySQL in Ubuntu 19.4

i trying to install mysql in ubuntu 19.4 but i can't upgrade with sudo apt upgrade this is the output ; astrix@astrix:~/Downloads$ sudo apt upgrade Reading package lists... Done Building ...
1
vote
1answer
30 views

How to get CPU usage in MySQL per user? [closed]

I want to know is there anyway to get CPU usage per user in MySQL? for example I have 3 different users 'user1', 'user2' and 'user3'. I want to get the average/real time memory usage and CPU usage of ...
0
votes
1answer
186 views

nextcloud on docker - error initializing database

When starting my nextcloud container with docker-compose up I encounter the error: db_1_7bb6e5f5b725 | Initializing database db_1_7bb6e5f5b725 | mkdir: cannot create directory '/var/lib/mysql//mysql':...
0
votes
1answer
203 views

fetch dependencies while install deb with ansible

i'm trying to install mysql 8.0.15-1debian9 on a debian 9 server the problem is that mysql only provides the latest version of mysql in their apt repository which is 8.0.16-1debian9 however 8.0.16-...
0
votes
0answers
28 views

How much space does it require to install php, mysql and phpmyadmin on CentOS 7? [duplicate]

I use ovh.com self managed VPS. The plan name is 'VPS 2018 SSD 1'. It offers 2 GB RAM and 20 GB disk space. I have only php 5.5 installed. When I try to install phpmyadmin, it throws an error saying '...
0
votes
2answers
3k views

CentOS define same date and timezone for system and MySQL

I realized that some of my droplets in Digital Ocean have different timezone between OS and MySQL. By default, I've configured all vms to Brazilian timezone (America/Sao_Paulo) through tzselect, and, ...
0
votes
1answer
212 views

Save daily mysql row count change in RRD

EDIT: To make things clear: I have an integer called $blocks or something, which increases everyday. I want to make a graph with RRDtool, that shows the "increased" amount for everyday. So if my $...
0
votes
0answers
17 views

Truncated incorrect DOUBLE value: 'null'

When I am running the query in MySQL from Linux server I got the error i.e Truncated incorrect DOUBLE value: 'null' Same query run in MySQL from Windows server it was working. UPDATE ...
0
votes
1answer
66 views

sed: Match this comma or that, but not both

I have a huge mysql dump that I'm using sed to delete unneeded rows (very much faster than deleting from table) and each line of the dump is in the format INSERT INTO table_name VALUES ("somevalue", ...
0
votes
2answers
124 views

Open source MySQL performance tool

Are there any open source MySQL performance tools for optimizing SQL queries?
0
votes
1answer
1k views

limit of open files: Debian Jessies´ MySQL vs Community Oracle MySQL

I have just upgraded from MySQL Jessie 5.5 to MySQL Oracle Community Edition v5.6. I have a particular MySQL server, that has around 230 DBs, and > 32k files/tables. Whilst for two or three years, I ...
1
vote
1answer
2k views

How to install mysql-server 5.6 on RHEL 5.8 (when MySQL-server 5.0 is already installed)

I want to install mysql-server 5.6 on RHEL 5.8, but when trying rpm -i or rpm -Uvh it complains that I already have version 5.0 on there. I am happy to replace, upgrade or install another instance.
0
votes
1answer
104 views

Pass output from metadata call to MySQL

Reference: How to pass password to mysql command line I want to grab returned metadata from an AWS EC2 instance and set a new mysql password based on this data. I need assistance with the script ...
12
votes
4answers
41k views

cronjob for automatic DB backup to date prefixed file

I am using the latest Linux Mint. I was wondering if it's possible to create a special cronjob for a database backup. In my /etc/cronjob file I have the following code: # Minute Hour Day of ...
1
vote
2answers
4k views

How to view a list of previously run MySQL queries in a live feed format?

How do I view the last run queries in MySQL in a live feed format? I want to leave my terminal window open and just have MySQL queries pop up on the screen whenever something is run. I know I can do ...
2
votes
6answers
4k views

I can not install MySQL using yum on Centos7

I've installed centos7 recently, but, when I am trying to install MySQL using the command: yum install mysql-community-server I keep getting Exiting on user cancel while I am not hitting any ...
1
vote
1answer
69 views

How to know if a mysql user has all (or some) privileges on a certain DB?

How to know if a mysql user has all (or some) privileges on a certain DB? Of course, I don't ask how to do so with phpmyadmin, rather, with the mysql CLI. I aim to gather as much as basic data on a ...
0
votes
3answers
2k views

How to know list of applications installed in my server? [closed]

I got one LINUX server in which Oracle LINUX 5 is installed. I have installed MySQL 5.1.73-community version. Now, I have to configure the variables. When I checked available memory through cat /proc/...
0
votes
0answers
417 views

Mysql failed because a configured resource limit was exceede CentOS 7

Mysql is down on my vps server and i tried to restart, stop then start, but nothing works. The error i am seeing every time is this [root@vps ~]# service mysqld restart Redirecting to /bin/...
0
votes
1answer
603 views

How to reconfigure PHP

We have a new linux server CentOS 6.5 with Plesk. Default PHP is 5.3.3, I have installed PHP5.4 & 5.5 on the server. I have to install PHP by using this guide PHP installed successfully but ...
0
votes
1answer
41 views

Incorrect syntax near '@DB_DATABASE_NAME'

I'm trying to create a MySQL database and tables by sending commands to mysql(1) through a text file. The file is simple: $ cat test.sql SET @DB_DATABASE_NAME = "test_db"; SET @DB_TABLE_NUMBERS = "...
0
votes
1answer
13 views

remote mysql login using username / password not working when adding password to command line

I am running the following command to connect to a remove mysql server (it is part of a bash script that will connect automatically) mysql -h slave1 -u monitor -pvP!KnK4* And I receive the following ...
2
votes
1answer
3k views

Cannot access MySQL Database - PID file could not be found

I am using a Linux Server from GoDaddy, and without any known reason, PID file could not be found! These are the errors I got: # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through ...
0
votes
1answer
215 views

How to send data from Raspberry pi to Remote SQL DB without installing mysql or mysql Client

I would like send some port checking data and a timestamp ( both saved as a variable) to my remote Mysql DB running on a linux Node machine . I don't want install sql or sql client in Pi because the ...
1
vote
1answer
94 views

mysqldump on mariadb 10 extremely slow [closed]

I'm running a MariaDB 10.1.34 instance on AWS RDS. Instance specs are as follows: Instance Class: db.t2.large Storage: 100GiB gp2 DB Size: 1.2 GiB I'm trying to create a mysqdump from an EC2 ...
8
votes
2answers
7k views

SSH tunnel via MySQL Workbench

my new production server is only visible via ssh double tunnel. I can reach targetHost over Ubuntu's 14.04 console simply executing command ssh targetHost and than executing mysql cli on remote ...