Questions tagged [mysql]

An open-source, relational database management system.

Filter by
Sorted by
Tagged with
0
votes
1answer
26 views

Problem with initializing user while installing MySQL Server

I'm trying to install my first community MySQL server instance and seems to be stuck on symlink not working. I'm following the procedure for installing MySQLfrom Installing MySQL on Unix/Linux Using ...
0
votes
1answer
28 views

python script not running from crontab

This is one of the so many questions asked in the forums. I've a script that runs perfectly if I run it from the linux terminal. However when I let it run from crontab at a reboot it doesn't work. I ...
1
vote
1answer
21 views

Why is there a ROOT (as opposed to root) account for MySQL and MariaDB?

As far as I can tell, the MySQL and MariaDB database "ROOT" account is completely separate from the operating system's "root" account. Why did someone consider it a good idea to create the ambiguous ...
0
votes
0answers
33 views

Why Is `dnf` Showing Me Incorrect Dependencies

I'm trying to remove mysql-community-server from one of my desktops. It was installed by using an rpm from dev.mysql.com. However, when I run dnf remove mysql-community-server then dnf claims that ...
0
votes
0answers
15 views

Why does MySQL give me “ERROR 114 - Table Full”?

I have a MySQL database table with 31,107,600 rows in it. It's using InnoDB. This is on a CentOS 7 system. The table has these columns: id timestamp mac data direction site_id I want to create an ...
0
votes
0answers
41 views

I have “deleted” /var/log folder. What can I do to repare this mistake?

My / partition vas full, so I needed to make some free space... The quickest solution I've found was to "move" /var/log to another partition and make a symbolic link to it. In fact I did a cp of the ...
0
votes
1answer
24 views

How to determine the User account that causes the many mysql and apache processes?

I have a server with no more that 40 websites on it. Many are Wordpress which is a high resource CMS. I used to get alerts of the sites going down a lot. Look like MySQL crashing. It was a 8Gb ...
0
votes
0answers
10 views

Function connect mysql and launch query

I've made a bash script for making an audit of a server, and I am trying to create a function with the following goal. The function get the mysql parameters (it's a pm file), store as variables and ...
0
votes
1answer
12 views

MySQL on RAMDisk not starting

I'm trying to move all execution of the mysql program (all table data, indexes, etc) onto a RAM Disk for a performance experiment that excludes file IO from my regular SSD. I started by installing ...
0
votes
0answers
13 views

galera mysql single node recovery issue

We have 3 node galera cluster and it was functional until last night one of node crashed because of hardware failure and after fixing hardware i am not able to start mariadb and getting following ...
0
votes
1answer
164 views

SQLSTATE[HY000] [2002] Connection refused - docker-compose exec app php artisan migrate

Docker containers are up and running; It's a Laravel install with docker, mysql and nginx. I want to run the migrations within the docker container i.e. docker-compose exec app php artisan migrate ...
0
votes
1answer
62 views

apt upgrade not working for mysql-client

apt is not upgrading mysql-client. Instead getting message: $ sudo apt upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... ...
0
votes
1answer
63 views

Ubuntu MySQL Failing install with Apt-Get

I previously had MariaDB installed and I'm wanting to install MySQL 5.7 on my server. I purged all files with mariadb and mysql. Though when I install MySQL-Server-5.7 I get the following error. (When ...
1
vote
2answers
36 views

Move mysql folder to another partition: symlink, fstab or mysql.conf?

I want to use a separate volume for my mysql folder. Now there are several options: creating a symlink mounting via fstab reconfiguring /etc/mysql/mysql.cnf and setting another data dir Are there ...
0
votes
0answers
20 views

List all crowd users in DB without the root or write access credentials

Hi I want to run a query on the Crowd DB with a read permission access. However, I ran a query on my Linux CLI to get the list of all active users with write access credentials, whereas I want to use ...
0
votes
0answers
27 views

Bad mysql install: mysqld doesn't exist so I can't run it, and pacman won't uninstall it

I installed mysql this morning, and when I ran mysql, I got the following output: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2) Further ...
0
votes
1answer
30 views

Apache and mysqlamin showing blank

Hi I am running a website for over 2 years and suddenly it showed up out of memory issue from last week. So I tried to allocate more memory but now apache and mysqladmin pages are blank and I get this ...
1
vote
0answers
24 views

Debian (Buster) Nextcloud Error While Trying To Create Admin User - Access Denied

I am performing a manual installation of Nextcloud on my personal machine running Debian (Buster). I've followed all of the steps of the instructions, up to the point where it wants me to complete ...
1
vote
1answer
27 views

Prevent SIGINT from reaching mysql subprocess

I have a perl script, which indirectly invokes mysql (to execute a long SQL script). I would like to disable Ctrl+C while that script is running, but somehow the signal still reaches mysql, which then ...
0
votes
1answer
303 views

Ubuntu 18.04 mysql Installation error: Error: dpkg: dependency problems prevent configuration of mysql-server

I'm on Ubuntu 18.04, I'm installing Mysql, i typed: sudo apt-get install mysql-server i received this with an error at the end: Reading package lists... Done Building dependency tree ...
0
votes
0answers
11 views

VirtualBox Startup errors MySQL Community Server error

Hi I am trying to start my virtual box and all of a sudden I am getting the following error: Previously I was fiddling with nvidia cuda installation and all of a sudden when I switched off my VM and ...
0
votes
0answers
34 views

MariaDB 10.2.15 SET GLOBAL max_allowed_packet not working

I am running 3 node galera cluster and everything is good but when today i am trying to change max_allowed_packet size without restarting any services it doesn't work. what i am missing? Version: ...
0
votes
2answers
69 views

Backup script is being executed in cron job but no backup is being produced

If I run my backup script manually from the command line it works fine. No issue backup is created. In the crontab log, I can see the entry for running the backup at 2:00 AM, /home/sgaddis/copy-...
0
votes
1answer
61 views

Ubuntu 18.04 mariadb access error

I'm on ubuntu 18.04, i have installed maria-db, maria-db is running with the command: sudo service mysql status but when i write this command: sudo mysql -u root -p ERROR: i get this error: ...
1
vote
0answers
25 views

How I can detect whether the database layer is either mysql or mariadb using only netcat

Sometimes on docker entrypoint files I need to detect whether the database layer is either mysql or mariadb in order to provide the correct configuration for my application whilst I develop docker ...
0
votes
1answer
16 views

Syntactical error with csvsql query?

I have a csv file attributes.csv from which I want to retrieve all records to a new file attributes_withoutPIDate.csv excluding records for which the Name column has "PI Date" as the value. ...
0
votes
0answers
40 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
48 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 ...
-2
votes
1answer
26 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
47 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
20 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
3answers
928 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
16 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
154 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
83 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
73 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
31 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
42 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
1answer
101 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
185 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
20 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
98 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
34 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
639 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
32 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
37 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
42 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
75 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
315 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
48 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
2 3 4 5
17