An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
1answer
145 views

MariaDB - dependency problems - leaving unconfigured

I have tried to install ISPConfig3 on Debian Jessie 8.1, and it couldnt connect to mySQL (mariaDB 10.1). So I CTRL+C to kill the install and I tried to manually login to mySQL, but I failed. It was ...
0
votes
1answer
27 views

mysql monitoring tool

Is there any monitoring tool for mysql which will send a notification mail to mentioned email ID ? It must monitor below parameters. 1. mysql more than 500 concurrent connections. 2. mysql deadlocks. ...
0
votes
1answer
251 views

Failed to open the bootstrap file in MySQL

After doing an installation of MySQL Ver. 5.7.10 for RH/Oracle Linux I get an error that during the initialization the bootstrap file was not found. I'm not sure where this may come from, as it is a ...
0
votes
1answer
18 views

stop unknown instance for mysql

I have to reset a mySQL root password but when I try to run this command: sudo stop mysql and it outputs: stop unknown instance
1
vote
0answers
102 views

Reducing Number of MariaDB/MySQL Threads

So I'm running a MariaDB 10 database on a single core server; not super powerful, but then my needs aren't huge either. However, one thing I've noticed is that if I look in htop I have around 28 ...
0
votes
0answers
77 views

Installing mysql-server always prompts me to configure mysql-server-5.5

This is so confusing, I am trying to install mysql-server using this command sudo apt-get install mysql-server but it displays these lines Reading package lists... Done Building dependency tree ...
2
votes
1answer
24 views

Postfix database unreachable behaviour

I have a server running postfix and dovecot with a local mysql database to store virtual domains and users. I'm considering to move the database to another server and perhaps switch to using ldap ...
1
vote
1answer
438 views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I am trying to copy data from CSV to mysql using shell script where I am all new. And I am working with my test server. mysql -u root -proot csv_imports -e "LOAD DATA INFILE ...
1
vote
1answer
339 views

mysql-server-5.5 unmet dependencies each time running apt-get

Each time I run "sudo apt-get install package-name", the following error happened, even if I tried to install other packages other than mysql ones: You might want to run 'apt-get -f install' to ...
1
vote
1answer
95 views

How to use SSH tunnel to connect to remote MySQL server?

I am trying to connect to remote MySQL server, which runs on CentOS 6.6 cPanel server. I am creating tunnel this way: ssh -L 3306:xxx.xxx.xxx.xxx:3306 user@xxx.xxx.xxx.xxx -p PPPPP Where ...
1
vote
1answer
19 views

Install mysql-workbench in fedora 21

I already install mysql-workbench in fedora 21 from rpm: yum localinstall mysql-workbench-community-6.3.5-1.fc21.x86_64.rpm But when I tried to launch apps by command: /usr/bin/mysql-workbench ...
0
votes
0answers
14 views

Allow non-localhost access mysql [duplicate]

I have been researching how to find a way to let non local host access mysql server, and I was looking at a few things online and so far what I have found is people saying to edit my /etc/mysql/my.cnf ...
1
vote
0answers
98 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 ...
0
votes
2answers
29 views

Import New Database Into MySQL

I have to set up a local database on a number of people's Linux Mint lap- and desk-tops. The idea is to do this from the command line after installing MySQL Server and Client, and associated ...
1
vote
0answers
249 views

MariaDB Dependencies issue after isntall/remove

I tried to "upgrade" MySQL 5.5 to MariaDB by removing MySQL altogether. Then I installed MariaDB 10.1 as follows: sudo apt-get install software-properties-common sudo apt-key adv --recv-keys ...
1
vote
0answers
131 views

Mysql 100% 1 core CPU load

I have 8 cpu in server, and Mysql works only on 1 cpu core on 100%. How can I use all cores? my my.cnf [mysqld] safe-show-database query_cache_limit=1M query_cache_size=64M ## 32MB for every 1GB ...
1
vote
1answer
385 views

Mysql Isn't starting

I recently asked this question the reason mysql wasn't starting is because there was no disk space. After a long discussion with casey in chat room and after following his answer, I freed about 10 GB ...
0
votes
0answers
62 views

Linux huge IOPS difference - same disks

I've been investigating for some time regarding some IOPS issues I've been experiencing.. And my mind is getting crazy! I have two servers (one bought 2 weeks ago, another 1.5 years ago) that I ...
1
vote
1answer
94 views

Linux Mint 17 Cinnamin + MySQL + turn OFF autostart

I have tried all the suggestions in hours of googling and still when I reboot and run service mysql status my server is running. since i only use mysql for database testing with my java apps i don't ...
1
vote
1answer
78 views

get mysql count of id in shell script

I am trying to get count of column user_Id using count(user_Id) from mysql as follows: count=$(mysql -uroot -proot csv_imports -e "select count(user_Id) from test_data where user_Id=\"12345\";") I ...
0
votes
1answer
777 views

error on opening mysql workbench on fedora 23

I have installed mysql-workbench on Fedora 23 Virtual machine (VMware) using the command : yum install mysql-workbench Now when I tried to issue the command mysql-workbench from terminal I am ...
0
votes
1answer
92 views

How to update apache, mysql, phpmyadmin and php?

I have my own web server running on my raspberry pi, and all my programs are outdated. I would like to update my PHP, Apache, MySQL, and phpMyAdmin. Can anyone tell me how to update all of these;? ...
0
votes
1answer
351 views

Unable to remove mysql-server on Fedora 23

I'm trying to do : sudo dnf remove mysql mysql-server The process is getting stuck at : Dependencies resolved. ...
0
votes
1answer
32 views

Mysql init.d to systemd

I have two mysql instances on a centos 7 machine. init.d handles start on boot. problem is, only one instance starts on boot. both instances uses two different ports. Can someone help me with how to ...
2
votes
1answer
93 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 ...
3
votes
2answers
2k views

Install mysql workbench community on fedora 23

The mysql-workbench-community package is available for Fedora 22 in the official repos, but unfortunately not yet for Fedora 23. Trying to install the fc22 version results in mysql-workbench not ...
0
votes
1answer
144 views

Cann't start MySQL on my Linux server with Centos 7 OS

I have already installed MySQL in a Server (Centos 7) by the following commands: yum install -y mysql yum install -y mysql-server yum install -y mysql-devel After the installation, I type mysql and ...
0
votes
1answer
298 views

Install libmysqlclient 5.5.3 on Centos 6

I'm installing Drupal 8 on my Centos 6 server. To do this I needed to upgrade both PHP and MySQL. However, I'm now getting the following error message: The libmysqlclient driver version 5.1.54 is ...
0
votes
1answer
99 views

MySQL logs are not working due to permissions

I am having a issue regarding permissions in MariaDB (MySQL) log files. I had setup logs files to be on /var/log/mysql but any time I restart the MariaDB server I can see the following messages logged ...
3
votes
1answer
43 views

ssh port forwarding through pseudo terminal

Here's a situation: I do all my work on a Mac. There's a certain linux server 'server01' that provides access to another linux server 'server02' via a pseudo terminal So, to ssh into ...
1
vote
0answers
92 views

httpd and mysqld used out of memory

I choose 512mb ram for my Centos VPS with very low traffic new website .but after 2,3 hours after rebooting, i have only 24mb free memory. when i use top command: 2981 root 20 0 37176 10m ...
1
vote
1answer
128 views

Script not working but command works outside of script

I have a very simple script that basically runs a command and then emails the report to a user: #!/bin/bash FROMDATE=`date -d "last week 13:00 " '+%Y-%m-%d'` TODATE=`date '+%Y-%m-%d'` ...
1
vote
3answers
116 views

yum ignoring exclude directive in yum.conf

I need to hold back mysql from being updated in yum update. I added exclude=mysql* to /etc/yum.conf as below: [main] cachedir=/var/cache/yum/$basearch/$releasever keepcache=0 debuglevel=2 ...
0
votes
1answer
27 views

Security of password in a cron job on a VPS

I have a site hosted on a VPS and need to run a MySQL dump nightly. If I create the cron command: mysqldump -u user -ppassword database | gzip > /path/to/zip/file are there any security issues? ...
1
vote
1answer
33 views

Keeping services on EC2 alive

I'm using a MySQL database and Apache server with an AWS EC2 instance running AWS Linux. I start them both using the service command, but I am not familiar with any other tool that would come ...
0
votes
1answer
45 views

Split MySQL query into an [executional part] and a [MySQL command part]

Following mysql -u root -ppassword -D database -s -N -e "SELECT id FROM myTable" with special password and database is working fine. I want to split the code into two parts: Executional part: ...
1
vote
0answers
390 views

MySQL Daemon failed to start. Starting mysqld: [FAILED]

Help me! problem : sudo service mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED] vi /var/log/mysqld.log : 151015 05:46:26 mysqld_safe ...
0
votes
3answers
104 views

How to create a script to run mysql commands

Is it possible to use a shell script to run this following command? mysql -u user use mydb delete from mydata where row='xx'
2
votes
1answer
245 views

How do I create a SSH user that can only access MySQL?

I want to set up an SSH tunnel to my MySQL database on a remote server. Can I create an SSH user that has only the minimum permissions that are strictly necessary to access MySQL, for example with a ...
2
votes
1answer
121 views

MariaDB client has no prompt in Emacs sql-mode

I just upgraded from an old MySQL client to mariadb-clients-10.0.21-3 on Arch Linux. After the upgrade, I no longer see a prompt when using Emacs's sql-mysql function. It seems mysql is buffering ...
1
vote
0answers
169 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: ...
2
votes
1answer
593 views

How to compress a mysql dump using 7z via a pipe?

I've been attempting to compress my mysqldump output via 7z using the pipe operator (I have seen this question, but its answer uses xz not 7z). This is what I have tried so far: mysqldump -u root -p ...
0
votes
1answer
672 views

mysql result to bash variable

My script is like this: #!/bin/bash mysql dbname -N -uroot -p -hhost -se "SELECT COUNTRY, COUNTRY_NAME FROM server ORDER BY COUNTRY" output=$(mysql dbname -N -uroot -p -hhost -se "SELECT COUNTRY, ...
0
votes
0answers
32 views

SSL/Secure MySQL access with Postfix/Dovecot Mail Server

I have two MySQL servers setup, one in each data center in the US. The east coast db is the master and replicates to the west coast slave db over SSL. When I try to connect my mail server to the ...
1
vote
3answers
192 views

MySQLdump via crontab - Pass --password=/hashed/password/file so I can use via crontab w/o using plain text password

So I'm setting up a WordPress backup guide/making a backup schedule for myself for real. I want to do MySQL dumps daily, but the command either requires -p then user input or ...
0
votes
1answer
242 views

Can't find job mysql on crouton, ubuntu precise

I'm using Ubuntu precise as chroot in my chromebook machine. I'm trying to install mysql through apt-get install mysql-server. The thing is, when I try to start it, it can't find the job: ...
4
votes
1answer
502 views

forward all mysql traffic to a ssh tunnel

I have a local application that needs to connect to a remote mysql server at 40.40.40.40:3306 The main firewall blocks all connections but ssh, I can set up a ssh tunnel and connect to the server ...
0
votes
1answer
152 views

Why is the config file in /etc/munin/plugin-conf.d/ ignored?

I have a Munin script /etc/munin/plugins/mysql_replag that queries a MySQL server to check the status of a master-slave replication: #!/bin/sh # Plugin to monitor the Seconds_Behind_Master of ...
0
votes
1answer
38 views

Does MySQL processes run in user or kernel modes?

I try to count IOPS and I/O size with SystemTap script and use MySQL to be workload. I found mysqld doesn't call systemcall but mysqld has read/write on VFS. So, do MySQL processes run in user or ...
1
vote
0answers
140 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] ...