An open-source, relational database management system.

learn more… | top users | synonyms

-2
votes
1answer
10 views

Executing MySql stored proc in Crontab

I have a MySQL stored proc named "item" and I want Cron to run it for me - in server of course. I'm avoiding using MySQL events to unify all my 'jobs' - backup,etc. Any how this is what I did in my ...
3
votes
2answers
77 views

Debian 8 - Install lastest version of MySQL

After downloading MYSQL APT Repository at http://cdn.mysql.com//Downloads/MySQL-5.7/libmysqld-dev_5.7.11-1debian8_amd64.deb I ran the command dpkg -i libmysqld-dev_5.7.11-1debian8_amd64.deb ...
1
vote
1answer
34 views

MySQL Access Denied (CentOS)

I have installed fresh MySQL server on CentOS, and started the MySQL server service with command. # /sbin/service mysqld start I checked the service and it is running. Currently I am logged in as ...
1
vote
3answers
29 views

How to automatically handle low disk space?

Currently one of our prototypes has a very bad caching system. In a matter of minutes it fills up it's harddrive and makes the system unusable. What I need to do then is to restart mysql service to ...
0
votes
0answers
13 views

What are the minimal MySQL grants for the debian-sys-maint user? [migrated]

What are the minimal privileges that debian-sys-maint@localhost needs for the mysql service to work correctly? This answer on ServerFault suggests granting RELOAD only, but this is incorrect, as it ...
0
votes
1answer
18 views

Sabayon 16 - MySQL Server unable to start

After installing Sabayon 16, I needed to install MySQL Server. I have followed two tutorials, but both of them fails to me. The first tutorial says to install dev-db/mysql and then execute sudo ...
1
vote
1answer
22 views

copy and symlink mysql to another disk partition

I'm using ubuntu 12.04 and have two disk partition named: /dev/sda and /dev/sdb. my home partition and other programs are in /dev/sda. therefor any work like database benchmark on my mysql databases ...
0
votes
1answer
36 views

limit of open files: Debian Jessies´ MySQL vs Community Oracle MySQL

I have just upgraded from MySQL Jessie 5.5 to MySQL Oracle Community Edition v5.6. I have a particular MySQL server, that has around 230 DBs, and > 32k files/tables. Whilst for two or three years, I ...
0
votes
0answers
19 views

MySQL Bin-Log Courupped [migrated]

In the recent time we have found that the bin log is getting corrupted, 20% binlog files were having errors, which couldn't even pass the sanity check by mysqlbinlog -u user -p mysql-bin.000021 | head ...
0
votes
1answer
11 views

unlang: sql results to local variable

I'm trying to save a resultset of a SQL query in unlang. (First time unlang for me by the way, so please don't judge me for mistakes) The corresponding line is Sql-Result-Set = %{expr: ...
0
votes
1answer
34 views

How do I prevent crashing my ec2 micro instance mysql db?

I have an Amazon ec2 micro instance that holds a WordPress site. Since yesterday, my mysql db keep crashing saying: [ec2-user@ip-xxx-xx-xx-xxx ~]$ sudo service mysqld status mysqld dead but subsys ...
0
votes
1answer
53 views

run multiple instances of MySQL CentOS7

I need to have multiple instances of MySQL running on my PC. I did this: yum install mariadb-server mariadb => install mysql mysql_install_db --datadir=/var/lib/mysql => use mysql_install_db ...
2
votes
0answers
16 views

PDOException: SQLSTATE[HY000]: General error: 23 Out of resources when opening file xxxx.MYD' (Errcode: 24) [duplicate]

I am getting this error message when trying to access a php page: PDOException: SQLSTATE[HY000]: General error: 23 Out of resources when opening file xxxx.MYD' (Errcode: 24) How can I solve this ...
0
votes
1answer
21 views

mysql error.log centralize logs

I'm developing a script where it will look into logs every 10 minutes and if there's any critical error it will send an e-mail to a certain adress. I have this problem i would like to solve more ...
0
votes
0answers
240 views

MySQL Workbench warning when connecting to MariaDB

When using MySQL Workbench 6.3 on Kubuntu 15.10 and MariaDB Server version: 10.0.22-MariaDB-0ubuntu0.15.10.1 (Ubuntu), I get the following warning. Is this expected? Incompatible/nonstandard ...
-1
votes
2answers
32 views

MariaDB: Create and grant a new user using unix sockets plugin (passwordless)

I just installed MariaDB on Kubuntu 15.10. I am able to log in with the root user via the plugin that authenticates the user from the operating system. (This is new to me, so I am learning about it ...
0
votes
1answer
219 views

mysql-workbench error while loading shared libraries (libzip.so.2)

I'm trying to use mysql-workbench on my Fedora 23 machine but it fails. When I try to start it, I get the following message: [daniele@localhost ~]$ mysql-workbench ...
1
vote
1answer
48 views

How to install a newer version of mysql workbench than is available in my distro's repos

I'm guessing this will be a quick fix for you. I am trying to install a version of mysql workbench that is NEWER than what is available to me through the regular debian repos. I started by adding ...
0
votes
0answers
34 views

FreeBSD - slow remote mysql

I have classic webhosting and VPS with FreeBSD. The website is on webhosting and mysql server is on VPS. When I try to remotely connect from webhosting to mysql server, page is loading very very slow ...
0
votes
0answers
42 views

The curious case of high 5 min load average

Looking for some expert advice here. I'm a first time sys admin on my own server and I can't figure the bottle neck in my server. Linux CentOS 6 Apache 2.4 PHP 5.5 I've been receiving tons of high 5 ...
1
vote
1answer
60 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
25 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
155 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
12 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
41 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
47 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
20 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 ...
0
votes
1answer
196 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
104 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
61 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
17 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
49 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
22 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 ...
2
votes
0answers
144 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
74 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
175 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
42 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 ...
0
votes
1answer
49 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 ...
0
votes
1answer
46 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 ...
1
vote
1answer
737 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
39 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
175 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
22 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
49 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
88 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
192 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
62 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
37 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 ...