Questions tagged [mysql]

An open-source, relational database management system.

221 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
29 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
203 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 ...
0
votes
0answers
13 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 ...
0
votes
0answers
28 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 ...
0
votes
1answer
12 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
0answers
25 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
58 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
110 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
18 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
112 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
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
59 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
0answers
343 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
0answers
1k views

Wordpress site hosted on Digital Ocean - 100% CPU usage

TL;DR - when there's traffic (around 900) our sites' CPU reaches 100%, slow down and crush. INTRODUCTION Our company holds more than 40 content websites, hosted on Digital Ocean, using Wordpress CMS....
0
votes
1answer
238 views

Not able change MySQL password on the mac

I forget my MySQL password. and I followed almost all the ways on the Google. But I'm still not able to change MySQL password. and I correctly wrote commands. What's the wrong with this? I really ...
0
votes
0answers
17 views

How to set up query-cache-type in Percona server 8.0

I installed Percona server 8.0 on Debian 9 with memory 1 G. When I set up these in my config file : query-cache-type = 0 query-cache-size = 0 I got this error: [Server] ...
0
votes
0answers
24 views

How to safely handle gtid_purged when adding replication channel, but len(GTID_PURGED) > 1024?

I'm adding a channel to a multi-master mysql slave. In the past, the procedure has been: import new db from a mysqldump, stop slave, record value of gtid_purged, reset master, manually set ...
0
votes
0answers
30 views

How can i change mysql password. I tried it. But not work.?

First i login to my server using putty. and this is my server data uname -or 2.6.32-754.6.3.el6.x86_64 GNU/Linux uname -a Linux vps-xxx-xxx.example.com 2.6.32-754.6.3.el6.x86_64 #1 SMP Tue Oct 9 ...
0
votes
0answers
8 views

a lack of DTrace probes of mysql@5.6 installed via brew under macOS

I installed mysql@5.6 via brew (brew install mysql@5.6) under my macOS, but when I run sudo dtrace -ln 'mysql*:::', comparing to Table 5.6 MySQL DTrace Probes there are only a few probes listed, sudo ...
0
votes
2answers
89 views

I use `ps -ef` find a `mysqld` progress, but how can I know which conf file it using?

I use ps -ef find a mysqld progress, but how can I know which conf file it using? [root@controller data]# ps -ef | grep mysql mysql 8901 1 0 15:15 ? 00:00:00 /usr/sbin/mysqld root ...
0
votes
0answers
36 views

ionice vs nice for mysqlimport

I am trying to import a huge .sql file into a mysql server. What (if any) is a best option to speed up the process (all other parameters being equal) reducing the process niceness to -20? setting ...
0
votes
0answers
189 views

ownCloud with mariadb under docker-not avalable connection

I tried to use official documentation https://github.com/owncloud-docker/serverwith docker-compose. My .env file: OWNCLOUD_VERSION=10.0 OWNCLOUD_DOMAIN=localhost ADMIN_USERNAME=admin ADMIN_PASSWORD=...
0
votes
0answers
66 views

shell - mysqldump works with echo but not directly

Im preparing a shell script which will take mysql table dump with where clause. Im passing table name and where condition from a parameter. Backup command: mysqldump -u root-p'pass' db ...
0
votes
0answers
82 views

macOS - MySQLWorkbench “cannot start SSH tunnel manager” only when opened via command line

I'm trying to get two instances of MySQLWorkbench running simultaneously but I'm running into this issue. If I navigate to my applications and double click the application everything works fine and I ...
0
votes
0answers
101 views

face error in installing mysql on AMI linux centos 2017-09

how to fix "Error: Package: mysql-community-server-5.6.42-2.el7.x86_64 (mysql56-community) Requires: systemd You could try using --skip-broken to work around the problem You could try running: rpm -Va ...
0
votes
1answer
27 views

LOAD INFILE REPLACE Not working as expected

I am trying to import a txt file using LOAD INFILE like below. LOAD DATA LOCAL INFILE '/home/xxxx/cloud_20181003.txt' INTO TABLE cloud_log_test FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (...
0
votes
0answers
98 views

installing mysql on ubuntu 18.04, what is root password

I installed MySQL on ubunto 18.04 and it is asking me to root password, but I don't have it. Mysql version is: mysql Ver 14.14 Distrib 5.7.23, for Linux (x86_64) using EditLine wrapper what I ...
0
votes
1answer
27 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
16 views

Database Directory storage is full need to change link it to new Partition

My mysql Database Directory size is full. So I want to change it to another partition where there is large amount of space. The database version am using is MySQL 5.7.23 and OS is CentOS 7. After ...
0
votes
1answer
312 views

Missing mysqld.sock file on linux server

I have this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") Anyone know what is wrong? It seems it isn't ...
0
votes
1answer
57 views

ERROR 1071 (42000)

I am trying to do this: CREATE UNIQUE INDEX name_index ON domains(name); But when I do, I get the error below. ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes I tried ...
0
votes
1answer
323 views

Can access /var/lib/mysql-files but not /home/username/Desktop/temp?

I'm using mysql workbench to export my mysql database table to a .csv file using the statement. SELECT * INTO OUTFILE '/var/lib/mysql-files/temporary2.csv' FIELDS TERMINATED BY ',' OPTIONALLY ...
0
votes
2answers
529 views

Error upgrading MySQL 5.5 to 5.6 CentOS 6.6

I wish to upgrade MySQL 5.5 to 5.6 on my CentOS 6.6 server and I am receiving an error after command yum update mysql as per the below output. I am following the guide here. I have also tried to ...
0
votes
1answer
90 views

Which program creates the /etc/mysql directory and its contents?

I was trying to install mysql-server and while trying to set a password I messed up the debian.cnf file and then deleted /etc/mysql hoping that dpkg-reconfigure would recreate it. Now dpkg-...
0
votes
0answers
88 views

Setting MySQL/MariaDB data directory to a directory in `home`, how can I make sure the `/home` is mounted before mysql daemon starts at boot time

On openSUSE Leap 15, I install MariaDB by: > sudo zypper in mariadb Right after installing MariaDB and right before starting it, I add this line to /etc/my.cnf, to set the MariaDB data directory ...
0
votes
1answer
28 views

Problem while installing LEMP on Linux Mint

I have been trying to install the LEMP stack on Linux Mint following these instructions: https://www.digitalocean.com/community/tutorials/how-to-install-linux-nginx-mysql-php-lemp-stack-in-ubuntu-16-...
0
votes
1answer
248 views

Why can't I connect to mysql remotely?

I need to configure mysql so I can connect to it remotely. Here is part of /etc/mysql/my.cnf file: [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket ...
0
votes
0answers
326 views

MySQL Bash for loops

I have a bunch of directories created as per "lesson column" example: /tmp/Caldera/ /tmp/Basic Navigation/ /tmp/Signs and Symbols/ I have a bunch of json files example: 0e689686-4f5a-4800-90ac-...
0
votes
0answers
108 views

Do something if mysql command fails

I'm trying to get the below command to do something if sql is not true for filename in test.txt do mysql -N -e "SELECT ROLE FROM SENTRY WHERE ROLE = '$filename';" exitcode=$? if [ $exitcode -ne 0 ]; ...
0
votes
0answers
3k 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 ...
0
votes
1answer
132 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 ...
0
votes
1answer
82 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
0answers
155 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
726 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
0answers
87 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=...
0
votes
1answer
22 views

Calculating MyQL PXC gcache

I was trying ti figure out how to calculate the right gcache for my server and came across the following post discussing just how to do that: https://www.percona.com/blog/2014/09/08/calculate-correct-...
0
votes
1answer
447 views

2002 - Network is unreachable - The server is not responding (or the local server's socket is not correctly configured)

I can't login to PHPMyAdmin getting error as #2002 - Network is unreachabl, I installed PHPMyAdmin from source. Configuration I tried in config.inc.php to fix the issue. $cfg['Servers'][$i]['host'] =...
0
votes
0answers
501 views

Does CentOS 7 stop services upon shutdown?

I have installed several services such as MySQL database and nginx on a CentOS 7 machine. I would like to know if CentOS automatically stops all of the installed services upon receiving a shutdown ...
0
votes
1answer
237 views

MySQL NDB Management Node Got Different Node IP Address Against the config.ini

I am engaging with a MySQL HA configuration. Currently, I setup the config.ini on my management node: root@ndb-mgmd:~# cat config.ini |grep -v ^# [tcp default] SendBufferMemory=2M ...