Questions tagged [mysql]

An open-source, relational database management system.

216 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
2k views

is THP good or bad for MySQL Server?

Linux kernel new feature called Transparent Huge Pages (THP) which is by default enabled on CentOS 6.x and above OS. Is THP good for MySQL DB machine? I am trying following to disabled THP but seems ...
3
votes
0answers
200 views

Using a NFS for gcc, Apache, PHP, MySQL, glibc

I have 7 SLES VM. I am compiling always the newest version of gcc and all dependencies. Apache and all dependencies. PHP and all dependencies. MySQL and all dependencies. glibc and all dependencies. ...
3
votes
0answers
803 views

what is the correct regexp for mysql filter in fail2ban?

I use the default filter file /etc/fail2ban/filter.d/mysqld-auth.conf for fail2ban service. But there are some errors in file /var/log/fail2ban.log as: Found a match for '150815 10:42:54 [Warning] ...
2
votes
0answers
374 views

MySQL Workbench and multi hop ssh tunnel

I have an issue with MySQL Workbench. This is how my connection looks like: laptop => bastion:22 => machineX:22 (10.10.10.10) => mysql:3306 So, I have two hops before I can reach the ...
2
votes
0answers
273 views

High Memory and Swap Usage but server running fast

Running a high traffic lemp web server on Centos 7 platform using nginx and mariadb. The server is running very nicely and load avg and cup usage is acceptable but from what I know it should not be. ...
2
votes
0answers
2k views

“You have held broken packages” when trying to update mysql

I'm tryng to update my mysql (currently at version 5.6) to 5.7 on my Debian 8, however I get this error when I'm reaching the last step. cat /etc/apt/sources.list gives the following: deb http://...
2
votes
0answers
94 views

How to control mysql with zpty?

I try to write a wrapper script for the mysql console client. While working on this, I stumbled upon zpty. It seems perfect. My first goal was to retrieve some table contents, but I already fail ...
2
votes
0answers
487 views

How to local user login(PAM) with MySQL?

The MySQL server has already been configured and can be remotely accessed from the client. The client is debian and has installed 'libpam-mysql'. What additional settings should I set for the local ...
2
votes
0answers
565 views

Killing processes in interruptible sleep state?

I'm inserting data from Server A, which is running a Node.js app, into a MySQL database on Server B. I first check for duplicate rows, and then INSERT or not depending on the result. This process can ...
2
votes
0answers
376 views

How do I decrease the amount of fsync that mysql does?

I am trying to import a database into a slave server. The process is being slowed because mysql calls fsync at a crazy rate. The jbd2/dm-0-8 runs at 80 - 99 % continuously but the throughput is quite ...
2
votes
1answer
536 views

OOM Killer keeps killing mysqld

I run a CentOS vps to host a few websites with cPanel/WHM but every now and then, my websites stop working because it can't establish a connection to the mysql database. Looking at the messages log, ...
2
votes
0answers
54 views

apt-get commands won't return

I am working on a Raspberry Pi running Raspbian, and I think I'm having a problem with my apt-get. The problem originated with a MySQL server I was running. The server stopped seemingly at random, ...
2
votes
0answers
838 views

Debugging Slow Queries in MariaDB/MySQL

I've set up a MariaDB server and everything is running well, with most queries executing in well under 20 milliseconds, but every so often a query will take half a second or longer (sometimes several ...
2
votes
1answer
536 views

Excessive amount of “select count(*)” from Zabbix to the MySQL database

I have some problems with my Zabbix Server as it is constantly slow. So I enabled the slow query highlighting in syslog in the Zabbix Server config. Why is it constantly doing select count(*) on these ...
2
votes
0answers
508 views

OpenSuse 13.2 mysql-workbench refuses to start

After running an zypper up mysql-workbench is broken. I get this error when trying to start it from CLI /usr/lib64/mysql-workbench/mysql-workbench-bin: symbol lookup error: /usr/lib64/mysql-workbench/...
2
votes
1answer
310 views

How Remove permission denied with GRANT USAGE ON mysql

I have a mail server in my ubuntu instance. I have a webserver management FROXLOR and i recieve errors for access denied when i try to login in mail account. The log for this: Aug 16 03:14:33 email ...
2
votes
1answer
844 views

How can I uninstall MySQL if I have compiled it from source?

I'm trying to uninstall MySQL but when I get inside the directory and type make uninstall It get: make: *** No rule to make target `uninstall'. Stop. I've read that I have to delete all the ...
2
votes
0answers
1k views

MySQL read only error but permissions set and SELinux AFAICT correct

I am new to MySQL and Linux and because I had issues with an old MySQL version (5.1) I used mysqldump and installed MySQL 5.6. I changed the datadir location by copying everything to the new folder ...
2
votes
2answers
972 views

MySQL won't start

I'm using a debian system. I could not start my mysql after the partition went full - I received the message "ERROR: The partition with /var/lib/mysql is too full!" I found a recommendation to delete ...
2
votes
0answers
926 views

How to properly install Apache, MySQL, and PHP on Ubuntu 10.4

I have followed a guide on how to install Apache, MySQL, and PHP on my laptop running Linux (Ubuntu 10.4) It appears I have it installed correctly but when I am not sure. I followed this guide here: ...
2
votes
0answers
110 views

Unable to install Mysql

When I install mysql on my Centos, I get the following error: Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached hostfile Could not retrieve mirrorlist ...
2
votes
1answer
2k views

phpmyadmin doesn't work after installing php5-mysqlnd

I am currently running into some problems with phpMyAdmin. I set everything up correctly and made sure everything worked. Then later after some developing on some pages I noticed I couldn't execute ...
2
votes
1answer
233 views

Linux Heartbeat options possibilities

I would like to understand if my below scenarios are possible in Heartbeat in Linux. Setup: Two Database Servers running Mysql in Active/Passive mode in replication mode having Heartbeat setup for ...
2
votes
1answer
1k views

How can I install mysql on an angstrom distribution?

I tried using a different distribution (debian) but the rest of my application did not work. I've tried opkg install mysql-client and opkg install mysql-server however I get the error Unknown package ...
2
votes
0answers
2k views

MySQL socket and PHP (and other languages)

Background info I'm currently running CentOS (or Red Hat?). uname -a gives (I edited out my domain name) Linux XXXXXXXXX.com 2.6.32-71.29.1.el6.x86_64 #1 SMP Mon Jun 27 19:49:27 BST 2011 x86_64 ...
1
vote
0answers
20 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
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
30 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 ...
1
vote
0answers
28 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
23 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 ...
1
vote
1answer
98 views

MySQL Java connector still using old java version?

Installing mysql-connector-java-8.0.15-1.el6.noarch.rpm (available here ) shows libgcj package as a dependency. Installing libgcj creates below file: /usr/bin/gij $/usr/bin/gij -version java version ...
1
vote
0answers
90 views

mysqladmin generates “error” messages

Some time ago I installed NGINX, php7, mariaDB and Wordpress on my Raspberry Pi running Raspbian. I created a Wordpress database - which is working. Recently I installed ssmtp and mailutils on my ...
1
vote
0answers
203 views

Damaged repomd.xml for mysql56-community when installing mysql

I am getting an error when I try to install mysql. This error says: http://repo.mysql.com/yum/mysql-5.6-community/el/7/x86_64/repodata/repomd.xml: [Errno -1] Error importing repomd.xml for mysql56-...
1
vote
0answers
311 views

debconf-set-selections does not work in Dockerfile

I'm trying to set a root password for a mysql database in a Dockerfile like this: (short version) ENV DEBIAN_FRONTEND noninteractive RUN echo mysql-community-server mysql-community-server/root-pass ...
1
vote
1answer
347 views

mysqld not start after upgrading 5.1 to 5.7 in centos 6.9

I have upgrade mysql 5.1 to mysql 5.7 in CentOS6.9. But now when I try to start mysql, mysql not start File permissions: [root@Intern mysql]# ll /var/lib/mysql total 174104 -rw-r----- 1 mysql ...
1
vote
0answers
1k views

Mysql yum install how to get right dependencies Centos 6.9

I'm trying to get MySql 5.7 installed on a Centos 6.9 system. I've been following instructions here: I've downloaded this rpm: mysql57-community-release-el6.rpm and installed it with this command: ...
1
vote
0answers
326 views

mysql after sudo su works; mysql or sudo mysql fails

I was visiting a mysql installation (don't know the details) [user@host ~]$ mysql -u kco -p Enter password: ERROR 1045 (28000): Access denied for user 'kco'@'localhost' (using password: YES) ...
1
vote
1answer
205 views

Changing MySQL Temporary File - Permissions Error

At the moment, MySQL Server is using /tmp as it's temporary directory, and I'd like to change that, because it's running into storage issues. Following this post: https://encylia.com/2015/02/06/how-...
1
vote
0answers
649 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 ...
1
vote
0answers
133 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 ...
1
vote
1answer
267 views

Using MYSQLDUMP to backup automatically a DB server

I'm using the following in crontab: 36 22 * * * root mysqldump -u CENSORED -p CENSORED server | gzip > /home/samp/samp03/scriptfiles/sql-backup/server_backup_`date + \%d-\%m-\%y`.sql but I'm ...
1
vote
0answers
190 views

setup mysql with django

I am trying to setup mysql server with my django application but I am having trouble installing it correctly. I used brew install mysql to install mysql server Then I used pip install mysqlclient ...
1
vote
0answers
62 views

Creating usernames with duplication check and adding them to LDAP

I have script to export entries from database to LDAP, I'm exporting their first name and last name and other attributes. I want to add to this script generator usernames of let's say first ...
1
vote
2answers
226 views

How to work around a error in an eclass file located in a Gentoo overlay?

(cross-posting from the Gentoo forum) I try editing the .eclass file in order to correct the error, but it seems my edits are being defeated by a cache somewhere. The initial error occurs when I run ...
1
vote
0answers
400 views

bash escape exclamation character inside variable with backtick

I have this bash script name test.sh and located in /tmp: source $HOME/.backmeuprc databases=`mysql -h$DBHOST -u$DBUSER -p$DBPASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database` the ....
1
vote
0answers
546 views

mysql workbench for linux deepin 15.3

I have installed mysql workbench 6.3 on linux deepin 15.3, but the program appears to have squares instead of text, as shown in this image , any help please?
1
vote
0answers
24 views

Installing MySQL in CentOS without permissions

I need to install a MySQL that doesn't need root. The reason for this is that I'm a user in a cluster, so I don't want to mess other people work. Said that, is there a way to have a "portable" MySQL ...
1
vote
0answers
739 views

Problems with upgrading MySQL

In a bit of a mess here. I tried without success to upgrade my MySQL from 5.5 to 5.7. I am running a Mint 17.2 spin. The apt-get failed due to a network error and none of the usual apt "fix" routines ...
1
vote
0answers
97 views

Problem with MySQL timezone

I have installed MySQL,version 5.6.16.My OS is FreeBSD,version is 9.3.MySQL installed on jail.When I check date I see Thu Nov 17 15:22:14 AMT 2016,I see this output also on the system.In MySQL,when I ...
1
vote
1answer
726 views

Yum skip-broken problem

I'm trying to install mysql-connector-odbc using yum. It gives me this error. Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered to Red ...