Questions tagged [mysql]

An open-source, relational database management system.

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

Mysql master/slave promotion of resources with Pacemaker not working

I'm trying to get a master/slave setup working with Pacemaker. However, I ran into a few problems. For some things I found a solution. I would like to have some feedback on this, because the official ...
0
votes
1answer
27 views

How to exit true from a heredoc command from MYSQL?

I have a script that exits on error using set -e and I can't figure out how to force it to return true despite || true #!/bin/bash mysql -h localhost -D test -ppassword <<-RENAME ...
-1
votes
0answers
4 views

Why moodle isnt allowed to overwrite config.php

I've been trying to install moodle via ubuntu. When its time to install it via http://localhost/moodle , I'm getting stuck at the configuration complete page. It says : Moodle made an attempt to save ...
-2
votes
1answer
23 views

mysql doesn't do anything, it just shows a “->” in a new line

I don't know what's wrong with MySQL. I'm on Debian, and no matter what command I enter, like CREATE DATABASE or USE it just jumps to a newline, showing a ->. What could be wrong here?
1
vote
1answer
26 views

MySQL SELECT into outfile Files are Locked

My program that's running on Ubuntu 18.04 executes a select statement into outfile into my /home/tmp directory, but all files that are created by mysql are locked. I can manually unlock them but our ...
1
vote
0answers
12 views

Is it possible to find out which process initiated a MySQL restart?

When I look at the file /var/log/mysql/error.log on my EC2 instance, I observe that there are two shutdowns and 2 restarts MySQL after the initial start. 2019-12-04T06:57:25.835650Z 0 [Note] mysqld: ...
0
votes
0answers
34 views

Installing MySql 5.7 on Centos 8

I am trying to install MySql 5.7 community server on Centos 8 but I can't figure out a way to configure any repo that works. yum repolist all | grep mysql CentOS-8 - AppStream ...
0
votes
0answers
14 views

Cant install MySql on a fresh aws instance

Installing MySQL on a fresh AWS Bitnami Wordpress instance crashes: sudo apt-get install mysql-server with mysql-server depends on mysql-server-5.7; however: Package mysql-server-5.7 is not ...
0
votes
0answers
29 views

ERROR 2002 (HY000): Can't connect to MySQL server on 'xx.xxx.xxx.xxx' (115)

I wanted to connect to memsql but when I try i wasn't able to connect , I get error as: mysql -u root -h 127.0.0.1 -P 3306 --prompt="memsql> " ERROR 2002 (HY000): Can't connect to MySQL server on '...
0
votes
0answers
34 views

MariaDB: ERROR 2006 (HY000): MySQL server has gone away

When i try to execute a query i got error: MariaDB [suitecrm]> select * from waiter_log; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... An error ...
-2
votes
1answer
38 views

FreeBSD 11.3. Cant start freeradius

Im trying to start freeradius on FreeBSD 11.3 FreeRADIUS Version 3.0.19 Copyright (C) 1999-2019 The FreeRADIUS server project and contributors There is NO warranty; not even for ...
0
votes
1answer
25 views

Unable to properly install mysql-server - password problems

So I installed MySQL-server following these steps: https://www.hostinger.com/tutorials/how-to-install-mysql-on-centos-7 Then it does not matter what I do, MySQL will just NOT accept any password. I ...
0
votes
1answer
22 views

mysql_upgrade - Can't create database 'performance_schema'

I run out of space on my VPS where I host many production sites. I discovered there is a 2GB+ file in /var/log/mysqld.log This file constains similar lines: 2019-11-01T12:21:57.708857Z 30600 [...
0
votes
0answers
31 views

Connect to a mariadb running on host from docker

I am trying to install nextcloud on a pi. So i installed the docker container, and i can access the first visit page. So i want to use mariadb as database backend. Then i typed: host: 192.168.178.62:...
1
vote
1answer
71 views

mysql database won't allow tcp connections on localhost at the default port

Trying to connect to a database with a c++ program. I am using the mysqlcppconnector with the connection strings tcp://localhost:3306 and tcp://127.0.0.1:3306. The program works on my local machine, ...
0
votes
0answers
17 views

bcp command unable to escape the black slash forward slash and special characters - \ / ä

I am using the cbp with mysql command as below. I am facing issue in my for back slash \ and forwas slash / and special characters ä , within the string which | pipe separated. sample file: |...
0
votes
1answer
57 views

mysql - importing Tablespace: Lost connection during query

iam trying to recover innodb table which has 1.5M rows from ibd file ( 5.5 GB ) this is the exact steps i do: getting create table query using mysqlfrm command create the table discard tablespace ...
-2
votes
1answer
33 views

Apparent different sizes when attempting to export a particular mysql database

In a quite old-versioned CentOS-Bash "shared server" environment, I ran the following commands: current_date="$(date +%F-%T)" db_user_name_and_db_name="db-username_db-name" war="$HOME/public_html" # ...
2
votes
2answers
133 views

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

I'm running on an Ubuntu 19.04 distro and have a Dockerfile which when we reach step 7; Step 7/11 : RUN (/usr/bin/mysqld_safe &); sleep 5; mysqladmin -u root -proot create wordpress we get; ...
-2
votes
1answer
30 views

JSON_TABLE problem

I have a JSON structured like that ... { "market_order_line_details__c":[ { "PriceItem__r.Catalog_Item__r.Parent_Catalog_Item__r.Parent_Catalog_Item__r.Calendar__r":{ "...
0
votes
1answer
24 views

MySql Community Server port changing

I've installed mysql-community-server 8.0 on Oracle Linux 7 using official documentation It have been installed successfully, but: # service mysqld start resulted in: Redirecting to /bin/systemctl ...
0
votes
1answer
24 views

script to get all long running mysql queries

I need to get the long running queries on mysql server for alerting purpose. Found a way but it doesn't work: show full processlist; It shows Select sleep(10); but doesn't show select * from ...
0
votes
1answer
41 views

How to write MySQL query in text file and run in linux

I would like to call a .sql file from a .sh file in linux. The .sql file will contain queries to MySQL database. I am able to call the .sql file by running .sh file in linux, but the sql query is not ...
0
votes
1answer
98 views

Installing mysql in debian10

I am new in debian and I'm trying to install mysql, But when I do these commands : sudo apt-get update sudo apt-get upgrade sudo apt-get install mysql-server then this error will come up : ...
1
vote
0answers
31 views

How can I separate MariaDB's mysqld from MySQL 8's mysqld process to solve A mysqld process already exists error?

My goal is to have MariaDB 10.1 and MySQL 8 on the same Ubuntu 18.04 server. I was able to setup MySQL 8 successfully, and got stuck almost at the end while setting up MariaDB following this guide: ...
1
vote
3answers
65 views

Convert mysql response from VM into specific format

Using a shell job I am getting a response from mysql in below text format, In a text way as requested +-------+ |    A    | +-------+ |   36   | +-------+ +-------+ |    B    | +-------+ |  ...
2
votes
3answers
2k views

How can I install Mysql on Debian 10 (buster)?

I've tried to follow the official guidance on installing MySQL on a fresh Debian install. So I went to https://dev.mysql.com/downloads/repo/apt/, downloaded mysql-apt-config_0.8.13-1_all.deb, Run ...
0
votes
1answer
32 views

Why does gunicorn w/ workers as a daemon kill MySQL?

So, I've recently deployed my first Flask app with gunicorn. During deployment, I encountered the most peculiar issue. I had created a systemd unit file (the following is the working, functional ...
0
votes
1answer
726 views

“E: Sub-process /usr/bin/dpkg returned an error code (1)” while trying to install mysql-server-5.6

Trying to install mysql-server-5.6 for 16.04 with sudo apt -f -y install mysql-server-5.6 but am getting the following return WARNING: apt does not have a stable CLI interface. Use with caution ...
1
vote
0answers
13 views

Xampp isn't working properly!

I have been facing a problem for 3 days. When I install xampp on my windows-10, it's only working for the first time. But when I shut down my pc, then I can't find it on installed app and also it wasn'...
1
vote
1answer
36 views

Sandbox-HDP The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

I installed MySQL and the MySQL community server on my Hortonworks HDP. I started service and tried to change password /usr/bin/mysql_secure_installation Securing the MySQL server deployment. ...
1
vote
1answer
203 views

MySQL&PHP - Aborted connection to db: (Got an error reading communication packets)

PHP version 5.6 I have a PHP program (running in CodeIgniter 'CI_VERSION', '2.1.3') looping through 100 items to process. Apache (via Codeigniter) will give me 500 Error and no indication anywhere ...
0
votes
0answers
17 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 ...
1
vote
0answers
48 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
26 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
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 ...
-1
votes
1answer
33 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
19 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
2k 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
32 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
69 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:...
0
votes
0answers
136 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 ...
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
41 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....
0
votes
0answers
233 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
48 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
32 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
239 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':...
1
vote
1answer
253 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 ...
0
votes
1answer
232 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-...