MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
18 views

Unable to install php5-mysql on Ubuntu 14.04

When I'm trying to install php5-mysql on my local PC with Ubuntu version: # cat /etc/*-release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=14.04 DISTRIB_CODENAME=trusty DISTRIB_DESCRIPTION="Ubuntu 14.04.4 LTS" ...
0
votes
1answer
44 views

Dovecot quota clone

I'm trying to use dovecot's quotas and share them via mysql with modoboa. I'm using the count module for that: http://wiki2.dovecot.org/Quota/Count To share the quota I'm trying to implement the new ...
0
votes
0answers
26 views

Configure auth with MySQL in Apache 2.22

I've got a raspberry pi 1 which serves web pages using apache 2.22. I've done some research and I found a way to secure "pages" using a database (mysql in this case). I've found this little guide to ...
0
votes
2answers
54 views

iptables - access to port 3306 timeout

I cannot connect to mysql from a remote server. I have bind-address commented out but when I add rules in iptables to block other connections the requesting server's connection times out. I tried ...
3
votes
0answers
45 views

When configuring rsyslog to log to mysql DB, what is purpose of SystemEventsProperties table?

I've configured rsyslog on my servers to log to a remote mysql DB. I did this essentially by following the rsyslog wiki and it essentially creates two tables: mysql> show tables; +----------------...
1
vote
1answer
52 views

MySQL server experiencing high stress/max connections

The Short: We're hitting max connections and seeing very poor performance from MySQL during peak business hours and cannot determine if it is a load problem or a configuration problem. The Long: To ...
3
votes
1answer
3k views

InnoDB “log sequence in the future!” crashing, won't start

I stopped mysql only to find that it wouldn't come back up, /etc/init.d/mysql start only outputs . . . . . . failed. I've narrowed it down to an issue with InnoDB. The database starts when ...
0
votes
0answers
121 views

--secure-file-priv Causes MySQL to not Accept LOAD DATA INFILE since Update

After upgrading from mysql 5.6 to mysql 5.7 (due to update from Ubuntu 15.10 to Ubuntu 16.04 and using purge before, because of a bug in the update: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/...
0
votes
0answers
31 views

changing dovecot/ispconfig mail user password via mysql prompt

I want to change mail user pass of a dovecot/ispconfig system via mysql prompt. I was using a script with the following query in another machine (just dovecot) : UPDATE mailserver.virtual_users ...
0
votes
0answers
32 views

InnoDB: Table contains 1 indexes inside InnoDB, which is different from the number of indexes 2 defined in the MySQL

The error: 2016-05-02 21:41:43 31491 [ERROR] Build InnoDB index translation table for Table ./pureperms/groups failed 2016-05-02 21:41:43 31491 [ERROR] InnoDB: Table pureperms/groups contains 1 ...
5
votes
2answers
1k views

Nagios alert based on scheduled MySQL queries results

I have installed Nagios 4.0 on my Ubuntu 14.0 and i want a plugin to alert me based on daily scheduled MySql queries .. if the result of ( select count(*) from tableName > 10 ) raise a critical ...
1
vote
0answers
26 views

Percona XtraDB Cluster 5.6 does not start

All the good days. I want to run for test purposes Percona XtraDb Cluster on ubuntu 14.04. The basis here took these two articles https://habrahabr.ru/post/152969/ https://www.percona.com/doc/...
1
vote
1answer
139 views

MySQL root password not working as expected

I am running MariaDB 10.0.24 on Ubuntu 16.04. I installed it via the xenial repo apt-get install mariadb-server. The root password doesn't seem to be working properly. I ran through these steps to ...
3
votes
3answers
4k views

Can't install mysql on ubuntu 12.04, Can't find messagefile '/usr/share/mysql/errmsg.sys'

Trying to install mysql, using apt-get but it fails # apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done The following extra ...
0
votes
2answers
50 views

MariaDB dying regularly

I've recently switched from MySQL do MariaDB to host WP website. Everything was smooth and I even noticed speed increase (which might be just placebo ;). From then on though MariaDB started dying ...
4
votes
2answers
4k views

MariaDB Galera Cluster falls out of sync easily

We're trying to debug an issue with a MariaDB cluster. We're running Maria 10.0.19 on c4.large instances in Amazon EC2; the OS is Ubuntu 14.04 (Trusty). There are three machines clustered together, ...
-1
votes
2answers
84 views

Linux init script service - delay until mysql socket is ready

How does one go about delaying a service init script in Linux until the MySQL socket exists? Does the sleep command in a startup script delay the entire boot process, or are init scripts each ...
-1
votes
2answers
51 views

Removed ib files to make mysql start but now it does not recognize tables

I had problem starting innodb and read somewhere that deleting ib_logfile0,ib_logfile1 files works. It worked and mysql started again and when I use "Show tables" it shows all tables of my database ...
0
votes
1answer
41 views

MySql Server does not start with innodb_force_recovery set to value 1-6

I have an ubuntu 14.04 KVM that was running as server LAMP till today when I have installed a Wordpress Plugin and the MySql Server 5.5 stopped working. I have tried to start the server multiple ...
0
votes
3answers
2k views

MySQL permissions error when showing databases

I was trying to install homebrew and very very stupidly did this: sudo chown -R $USER /usr/local The Homebrew instructions say to do this and I'm not much of a sysadmin so I took their word for it. ...
1
vote
1answer
83 views

How to completely remove volumes/instances from OpenStack Kilo database

We're having some troubles deploying Kilo on a system with 3 controllers and 3 computes, through mirantis fuel 7.0. The problems involve creation and attaching of volumes, specially the ones stored ...
55
votes
4answers
67k views

How do I load a sql.gz file to my database? (importing)

I'm trying to import a gzipped SQL file into mysql directly. Is this the right way? mysql -uroot -ppassword mydb > myfile.sql.gz
0
votes
1answer
51 views

When Dealing with Databases on Docker

I've been using docker locally for a while and one of the issues I've had is when, inexplicably, the docker container dies and it takes all the data with it. Obviously, this can not happen in ...
0
votes
3answers
3k views

Xubuntu Desktop 14.04 - service mysql start unknown job

I installed fresh XUbuntu desktop 14.04 (as a dev system) and then lamp server using sudo apt-get install lamp-server^. I can type mysql and mysql console run but if I try service mysql start I got: ...
1
vote
0answers
16 views

Mysql query log is empty after boot

I can't figure out why is general and slow query log empty after computer restart. After restarting the server with systemctl the logs get populated. After reboot the files are created just empty. $ ...
0
votes
1answer
25 views

importing self signed certificates mysql/mariadb and tomcat how to?

trying to use certs for securing connections between Tomcat 8.x and mysql/mariadb. I'm going to use a self-signed cert. What follows is what i think i should be going and appreciate you to jump in and ...
17
votes
3answers
78k views

How do i find out what my IP Address of my MySQL host is?

I have a free domain running at x10hosting (x10.bz), and I want to find out the IP Address of my MySQL host for it, so I can contact the MySQL database from another host. I've already added that host ...
1
vote
2answers
12k views

phpMyAdmin error #2002 “Cannot log in to the MySQL server”, but works from console

The MySQL service on my CentOS 6.3 server works well. I'm using phpMyAdmin-3.5.8.1 from default repository. I have sites that can connect to the databases and are using them successfully. I can also ...
0
votes
1answer
105 views

Can't mysql_secure_installation a fresh MariaDB on fresh Ubuntu 16.04 LTS

I am trying to run mysql_secure_installation on a fresh install of MariaDB on a fresh Ubuntu 16.04 LTS server. I installed via the exact instructions found here. When prompted for Remove anonymous ...
0
votes
0answers
20 views

mysql ndb cluster - Management node and data node go down together

I have an NDB scenario with the following details: Blade 1: VM 1 : Management Node (Active) VM 2 : Data Node VM 3 : SQL Node Blade 2: VM 1 : Management Node VM 2 : Data Node VM 3: SQL Node If ...
1
vote
2answers
490 views

Failed to start MariaDB database server

Since / partition is only 50G, and my data is larger than that. And there are 500G space in /home. So, I move all the data of MySQL into /home. The following are my steps(under root account): shout ...
0
votes
1answer
27 views

php-cgi.exe CPU load jumps after MySQL Backup

I'm running Windows 2012r2 on a new server, with Plesk 12.5 and MySQL 5.6 installed. There's a backup script which takes a DB dump and zips website data files that runs each day. However, it brings ...
4
votes
1answer
4k views

Ubuntu upgrade from 14.04 LTS to 16.04 failed - mysql-server-5.7 dependecies fail

I am trying to upgrade existing Ubuntu 14.04 LTS to Ubuntu 16.04 LTS and it seems I am stuck somewhere in the middle. When I turn on my workstation, I get Ubuntu 16.04 LTS welcome & login screen, ...
1
vote
1answer
231 views

How to tune MySQL server when big peak of usage is expected

I'm having pretty big issues trying to tune my MySQL server. I was expecting a lot of people on my website after buying a tv ads between 5pm and 6pm, I have more or less 300 persons at the time on the ...
2
votes
3answers
37 views

How to escape a - in a table name in mysqldump

If I want to exclude a table in a schema which contains a minus -, how do I escape that in mysqldump? Or do I not need to? mysqldump --ignore-table=foo-bar.tl_log does not seem to work
15
votes
1answer
7k views

Constantly have to reload PHP-FPM

We have a fairly heavily loaded server running nginx and PHP-FPM. We have 6 websites on this server, running PHP-FPM and nginx. Software is all vBulletin 3.8 and WordPress. Databases are on a separate ...
0
votes
1answer
36 views

Debian Jessie mySQL 5.5 upgrade to testing 5.6 issues?

I need to upgrade from stable mysql-server5.5.x to 5.6.x on Debian Jessie to run Magneto, but I am also running a high volume forum on 5.5.x. If I enable testing repos and pull 5.6.x (currently 5.6.28-...
0
votes
0answers
38 views

MySQL server is unreachable from OpenVZ container

Writing out of despair. Yesterday, as usual and having done this for thousands of times before, I'd installed MySQL server in the Head Node for using it from the OpenVZ container. I've created user, ...
0
votes
0answers
77 views

Zabbix Can't Connect to MySQL

I just install zabbix-server on my server with MySQL running on it. I follow step from official website. And finished well. Then i try to access its page using http://my-server-IP/zabbix but it shows ...
1
vote
1answer
45 views

MySQL 5.7 Failed to update target: In aggregated query without GROUP BY this is incompatible with sql_mode=only_full_group_by

MySQL 5.7.8rc Ubuntu 14.04 I have modified the my.cnf to add this line: sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,...
1
vote
1answer
19 views

How to exclude specific table from innodb buffer pool?

Here's my situation. I have one really large table that holds about 90 GB of data. I've utilized DATA DIRECTORY to place that table on another drive, as I rarely use the table and don't want it ...
7
votes
8answers
2k views

Preventing brute-force attacks on MySQL?

I need to turn on networking for MySQLd, but every time I do, the server gets brute-forced into oblivion. Some mean password guessing script starts hammering on the server, opening a connection on ...
9
votes
4answers
6k views

MySQL Workbench with Debian Jessie - TCP/IP over SSH does not work

I use to connect with Windows 7 Pro x64 to my MySQL server hosted on a Debian Wheezy with the MySQL Workbench client using the "TCP/IP over SSH" but it does not work on my new server on Debian Jessie, ...
1
vote
1answer
435 views

2006: MySQL server has gone away

I am getting 'Lost connection to MySQL server' and '2006: MySQL server has gone away' errors so frequently that the server is unusable. There are questions related to this issue, but none that apply ...
0
votes
1answer
287 views

How to disable ssl plugin on MySQL 5.7 server?

New introduced SSL connections on MySQL Server is now default installed on CentOS 6.7 default rep. Just removing the certificate files can solve it accoding with Docs: "If the server does not ...
0
votes
1answer
68 views

VPS Server getting offline - CentOS

I have a VPS CentOS Server hosted by GoDaddy. The database for my website is going down once everyday. I have two websites hosted on that server, a Wordpress and a Magento website. The connection to ...
-2
votes
2answers
41 views

Create a non root user for Linux MySQL with minimal right as using root is not secure

General rule for root MySQL user is from security point of view: "Do not use root for any web application for MySQL connection, Select, Update, or Delete queries. Instead of create and use another ...
65
votes
10answers
86k views

How can I export the privileges from MySQL and then import to a new server?

I know how to export/import the databases using mysqldump & that's fine but how do I get the privileges into the new server. For extra points, there are a couple of existing databases on the new ...
1
vote
3answers
12k views

ERROR 2002 MYSQL socket /tmp/mysql.sock

A have already read everything about this error but I coundn't solve the problem. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38) I'm trying to install ...
0
votes
2answers
3k views

setsockopt EOPNOTSUPP (Operation not supported)

When I strace my MySQL process, I keep finding the same error over and over: setsockopt(240, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported) futex(0x87ab944, FUTEX_WAKE_OP_PRIVATE, ...