Questions tagged [mysql]

An open-source, relational database management system.

1
vote
1answer
286 views

MySQL SystemD Logfile Permission Denied

I've installed MySQL 5.6 on a CentOS 7 server and I'm trying to change the error log location from the default /var/log/mysql.log to /var/log/mysqld.err. MySQL is running properly when I use the ...
-2
votes
1answer
38 views

Mysql cannot make a user [duplicate]

So I am currently running kali linux 4.15.0 and I am trying to run DVWA ( Damn Vulnerable Web Application) I tried making the user as: MariaDB [(none)]> CREATE USER 'user'@'127.0.0.1' ...
2
votes
3answers
2k views

Any work-around to pipe zip files? [duplicate]

I use Ubuntu 16.04 with Nginx and Bash. I know that it's not possible to directly pipe data into zip. For example, if you host websites on Apache/Nginx webserver, this command set would fail after ...
0
votes
1answer
53 views

output formatting of shell script - mysql

When I run this script mysql -e "use sentry; select DISTINCT concat( 'CREATE ROLE \`', r.ROLE_NAME, '\`;') from SENTRY_ROLE r join SENTRY_ROLE_DB_PRIVILEGE_MAP rp on rp.ROLE_ID = r.ROLE_ID join ...
1
vote
0answers
551 views

ProFTPd serving FTP and sFTP using the same MySQL DB for users

I have 2 FTP servers running both mainly using sFTP on port 2222 AND FTP on port 21. On top of the ProFTPd system I have a proftpd_admin tool running: proftpd-admin link1 That uses a MySQL backend ...
0
votes
1answer
26 views

Docker to network VM networking

I'm experimenting with docker and I'm looking for the best way to have my container to communicate with a MYSQL DB running on a separate VM. The MYSQL DB is on the host's network. SO setup is: ...
-2
votes
1answer
62 views

How to install MySQL on Ubuntu with a particular IP address on a particular port?

How do I install MySQL on ubuntu 14.04 with the bind address as a particular IP address on port 1723?
0
votes
0answers
2k views

how to solve Linux symbol lookup error for undefined symbols

There are lots of similar issues on the web related to undefined symbol lookup errors, but none of them explains how to deal with the error. I am using RHEL7 and I tried to install MySQL-workbench ...
4
votes
1answer
8k views

Failed to connect to MySQL: No such file or directory

I wrote this docker-compose project. The docker-compose.yml looks like this: version: '3.1' services: db: image: mysql restart: always environment: - MYSQL_DATABASE=mgsv - ...
0
votes
1answer
1k views

Not able to install php5-mysql or php5-mysqlnd

I'm using Debian Jessie inside a docker container docker run --entrypoint /bin/bash -i -t php:5-apache. Unfortunately, I am not able to install php5-mysql or php5-mysqlnd . I did the following steps: ...
0
votes
1answer
572 views

Ownership of /var/www/html [closed]

So I've searched this a lot and found conflicting answers. I would appreciate, for everyone's sake, if someone could come up with a fully reasoned and cited answer for how to set ownership / ...
1
vote
1answer
34 views

Catch wrong password

I have written a script that handles all of the steps for setting up a website on our server. The problem I am running into is that, if someone enters the wrong MySQL password, the script keeps going ...
-1
votes
1answer
280 views

Cronjobs doesn't work but commands works [duplicate]

I have to command in my cronjob list. I for mysql backup, one for directory cp command. When I run commands, They work. But When I run command the below, I get error: run-parts /etc/cron.daily ...
0
votes
1answer
56 views

CentOS MySQL install

I am very new to Linux and I am having trouble with MySQL on CentOS. I got myself a CentOS virtual server. I would like to move a few WordPress sites from my dedicated Windows Server (too expensive ...
0
votes
1answer
613 views

DROP USER IF EXISTS syntax error in MySQL CLI

I use Ubuntu 16.04 with Bash and MySQL Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using EditLine wrapper. I try to create a DB stack for a webapp (WordPress) directly from command line and I share ...
0
votes
1answer
295 views

MySQL: Incorrect string value

I have been having some problems with some characters in webpages, that we have in UTF8, often in a while. I am running MySQL 5.7 with Debian 9. My databases are using the utf8charset. Today, when ...
1
vote
0answers
109 views

Is changing the system hostname on a server with a running MySQL / MariaDB service harmful?

I want to change the hostname of a running CentOS 7 server which is running MySQL (mysql Ver 15.1 Distrib 10.0.33-MariaDB, for Linux (x86_64) using readline 5.1). Although I can't find any sources ...
0
votes
2answers
690 views

New MySQL Installation on pfSense returns 'Bad -c option' when started

this is my first time actually using FreeBSD so there's a chance I might have missed something big, but it's unlikely. So I want to set up mysql on my pfSense server so I can enable historical ...
0
votes
1answer
373 views

Why has MySQL-python package been removed as part of the removal of MariaDB?

Recently I removed some MariaDB packages in order to install a new version from an RPM file. yum remove mariadb mariadb-server mariadb-libs And as part of the process yum also removed MySQL-python ...
0
votes
1answer
158 views

Copying MySQL Database via FTP (FileZilla, Ubuntu, Zabbix)

I have recently discovered that we are not backing up our Zabbix database and i was wondering if it is possible to take a backup via FTP on FileZilla by essentially copying the files from the mysql ...
2
votes
1answer
457 views

Mysql segfaulting when used from the shell

I have a Raspberry Pi server with Raspbian OS: Kernel: Linux 4.9.35+ #1014 Fri Jun 30 14:34:49 BST 2017 armv6l GNU/Linux Description: Raspbian GNU/Linux 8.0 (jessie) Release: 8.0 Codename: ...
1
vote
1answer
606 views

can we save mysql error to a file? [duplicate]

I would like to know is there any way to log the mysql query error which prints on screen. Example: mysql -u$UserName -p$Password -D $DBName -e "ALTER TABLE collect ADD path VARCHAR( 250 ) NOT ...
0
votes
1answer
111 views

Terminal Error While Installing PyMySQL

I'm working on a project with the Raspberry Pi that involves connecting it to a MySQL database. After doing some research, I have found PyMySQL to be what I need to install through the terminal. I've ...
2
votes
3answers
15k views

Install libmysqlclient on CentOs 7

I am trying to build mysql-shell 1.0.11 from src. RPMs are not an option when I am installing. One of the requirements is libmysqlclient 5.7+. I have installed mysql++, mysql++-devel, mysql-...
-2
votes
1answer
287 views

CentOS 7 Cannot Install MySQL 5.7 nothing I have done works still trys to instll mariadb

I have followed just about every instruction, including the instruction from MySQL and following instrucitons from around web including this site. I have downloaded the mysql57-community-release-el7-...
5
votes
2answers
5k views

Debian 9: After upgrade from 8, MySQL (MariaDB) does no longer work

I just upgraded from Debian 8 to 9. Apparently, it breaks everything database related. I now can't start MySQL, the error is: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/...
0
votes
2answers
344 views

Can't connect to local MySQL server through socket

All commands in debian9's interactive non-login shell (graphical mode). I want to backup mysql before reboot or shutdown. who test tty7 2018-02-01 18:26 (:0) test@world:~$ pwd /home/test ...
1
vote
1answer
1k views

Linux ports are blocked even when firewalld is disabled!

RHEL 7.4 I disabled the firewalld and also checked that SELINUX is disabled. But still when I use telnet to check the ports, port 3307 refused the connection. Even port 80 rejects the connection. ...
1
vote
1answer
224 views

Iptables blocking remote MySQL remote

I'm trying to set my server (CentOS 6.9) to accept remote MySQl connections and I'm stuck on the firewall config. I have everything set right on the MySQL side; I can connect through telnet if I stop ...
5
votes
1answer
16k 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
137 views

zabbix template mysql (800+item)

I use this template. template-mysql-800-items when i send parameter by this command zabbix_sender -z zabbix -s db1 -k mysql[innodb_queries_inside] -o 100 -vv On zabbix server i can see result. ...
0
votes
1answer
72 views

No package mysql-community *5.7*

I am very new to Cent Os. I have to install mysql on my cent os 6.9 version. I have tried almost all commands,But am getting one or the other issue while installing. yum localinstall https://dev....
0
votes
1answer
445 views

zabbix_sender error

What is the meaning of this error? [root@db2 zabbix]# zabbix_sender -z zabbix -s zabbix -k mysql[Threads_running] -o 100 -vv zabbix_sender [55944]: DEBUG: answer [{"response":"success",...
0
votes
1answer
615 views

Confused about using the Zabbix Template MySQL (800+ items)

Please explain the full use of this template.link template I searched very much on Google, I have configured as described but i can't use this yet. Can you fully explain? i have two centos 7. zabbix ...
0
votes
1answer
710 views

Slow server performance - mod_fcgid causing (104), (09) and (32) errors: mod_fcgid: ap_pass_brigade failed in handle_request_ipc function

I'm having trouble with tracking the source of slow web server performance for wordpress site and non-cached pages. Server OS: Debian 8 "Jesssie)" - Linux version 4.9.58-xxxx-std-ipv6-64 (kernel@...
0
votes
2answers
2k views

Php 5.6 and Mysql 5.6.x on Debian 8.10

Is it possible to run Php 5.6 and Mysql 5.6.x on Debian 8.10?
1
vote
2answers
594 views

Create a user and DB with the same name in one line

This is how I create a MySQL authorized, all privileged DB user and a corresponding DB instance with the same name, directly from Bash: echo "CREATE USER "${domain}"@"localhost" IDENTIFIED BY \"${...
2
votes
1answer
4k views

MySQL/Maria Database not loading: /var/run/mysqld/mysqld.sock (2 “No such file or directory”)

Setup Server computer Distro: Raspbian GNU/Linux 8 Kernel: 4.9.35-v7+ armv7l (32 bit) My MySQL database is not loading admin@Xroklaus:~ $ sudo systemctl status mysql ● mysql.service - LSB: Start ...
1
vote
2answers
2k views

MySQL High Ram Usage?

I'm trying to figure out what's using my RAM. I did some checks and it looks like that mysqld is causing high RAM usage. The output of free -g, htop, top, showprocesslist; isn't much helping. free -g ...
0
votes
2answers
41 views

Source multiple sql files with blank in name

I'm actually blocking on a stupid thing ... yet i can't get it throught. We've got a git repository on which we have our php files and our sql patch. Every time i update my repo, i have to check if ...
0
votes
0answers
77 views

In dovecot, what syntax to use if I have a space in mysql password?

I'm trying to configure Dovecot to access mysql, but it's not working because there is a space in the mysql password. driver = mysql connect = "host=localhost dbname=postfix user=postfix password=...
2
votes
1answer
3k views

MariaDB won't start, even after reinstalling

I've been reinstalling, update, upgrade but still didn't solve the problem. Been searching for answer on google but the problem persists. Here's the output when i ran systemctl status mariadb.service: ...
0
votes
2answers
2k views

Autostarting a python script whenever it crashes

I am trying to autostart a python script everytime it crashes on my raspberry pi. I am adhering to the shell script solution offered here: https://raspberrypi.stackexchange.com/questions/14735/how-do-...
2
votes
1answer
463 views

Install MySQL in the Debian Jessie (8)

I'm new in Linux, freshly installed a Debian Jessie (8) OS and need to work with MySQL. The hostname is, hostname -f It prints, debian8 When I type in the terminal, sudo dpkg --get-selections ...
0
votes
0answers
51 views

MySQL installation in Debian Jessie (8) [duplicate]

I was following a video about how to install the MySQL database in the Debian 8 from youtube, https://www.youtube.com/watch?v=Qg_wb_eZOrk It was the point when I tried to install MySQL server using ...
-1
votes
1answer
645 views

Variable won't get expanded when INSIDE mysql shell

Before creating a new mysql user and DB, I did: read sps -s # Inputing and saving the sps (password) value. echo ${sps} # sps password value echoed. mysql -u root -p[PASSWORD] mysql>...
0
votes
1answer
375 views

How to pass an argument containing double quote to a shell script function?

I have in pull_news.sh (variable declarations omitted): dump_table () { mysqldump --user=${REMOTE_USERNAME} --password=${REMOTE_PASSWORDS} --host=${REMOTE_HOST} --port=${REMOTE_PORT} --single-...
0
votes
2answers
110 views

mysql dump fails when done by root user

In Ubuntu server 16.04 xenial in a LEMP stack I executed mysql -u root -p (then root's password), and then, when inside the mysql shell: mysqldump --databases "${domain}" > test.sql but for some ...
0
votes
1answer
44 views

How could I restrict users to connecting to MySQL using only their unix username?

I'm working in an environment where I need to ensure that developers only connect to our application's MySQL database using the username of their Unix account. The driver behind this is to have ...
0
votes
3answers
49 views

Login into Mysql without startx

I have had install Damn small Linux(DSL) 10 in Virtual Box with MySQL 5. I created already a database with a Table and Data in it. I can access it over the terminal with the following line: mysql -u ...