Questions tagged [mysql]
An open-source, relational database management system.
843
questions
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:
...
