Questions tagged [mysql]

An open-source, relational database management system.

222 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
202 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
809 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
401 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
290 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
100 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
501 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
574 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
390 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
551 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
848 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
541 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
512 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
316 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
853 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
978 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
111 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
22 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
33 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
34 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
24 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
113 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
104 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
215 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
337 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
359 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
344 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
222 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
685 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
140 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
273 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
193 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
63 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
228 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
403 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
550 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
745 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
748 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 ...