MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
12 views

MariaDB audit log empty host

I'm running MariaDB 10.0.23 with the audit plugin logging CONNECT type. The audit log is showing a failed connect with error 1042. Does the host field not show the IP address when a host cannot be ...
2
votes
3answers
47 views

Excluding/Including tables in mysqldump AWS

I'm trying to figure out how to exclude or include specific tables when doing mysqldump command on AWS via terminal. Background: I have a WordPress multisite but only need the tables with the first 3 ...
1
vote
0answers
65 views

Cannot connect to remote MySQL server (RDS)

When I am trying to connect to RDS from my vps, it says connection refused. When I tried connecting it from local or other vps, it worked fine. I figured out that it must be a firewall issue on my ...
0
votes
0answers
108 views

PHPMYADMIN Multi Server Setup Issue - Server Choice Never Displayed

I have a phpmyadmin installed in my Ubuntu-14.04 LTS server. I want to manage other MySQL databases in different servers (all Ubuntu) across my VPC. I have enabled access to the servers using the AWS ...
0
votes
0answers
38 views

DataTables warning: JSON data from server could not be parsed

This is my first post on ServerFault. I hope that this question is detailed enough for someone to help me. I have looked online for two days regarding, "DataTables warning (table id = '...
-1
votes
2answers
48 views

MySQL crashes due to memory related errors, but roughly 50% memory is unused

MySQL keeps crashing because of: InnoDB: Fatal error: cannot allocate memory for the buffer pool. This looks like a memory problem and the internet seems to confirm that. Also, my box has only 1GB of ...
0
votes
1answer
56 views

MariaDB refuse to start after VServer reboot

After I rebooted my VServer, MariaDB refuses to start. This are the error messages: # systemctl status mysql.service ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: ...
1
vote
1answer
24 views

Are both /etc/my.cnf and /etc/mysql/my.cnf needed?

I recently setup a new web server with Ubuntu 12.04. I noticed that there are two my.cnf files, and MySQL successfully reads both: /etc/my.cnf /etc/mysql/my.cnf Do I need to keep both of these ...
0
votes
1answer
28 views

Opening ports on a remote DB server

I'm running a RHEL7 box, running MySQL-5.7.11 and I'm simply trying to allow remote connections... I followed the documentation here on opening a port and have done so successfully. When I run ...
0
votes
0answers
10 views

SQL request in Bacula database

I would like to get all the files that are at least in one job which is now saved on one determined tape in the Bacula database. This could replace a tape listing. I have tried several request to ...
0
votes
0answers
91 views

MySQL Cluster: SQL node running but not connecting to cluster

I realize there are a number of questions already on this but I've done my research and couldn't find a solution that worked for me. I'm using a clean install of Ubuntu 12.04.5 with MySQL Cluster 7.4....
0
votes
1answer
84 views

mysqldump (using PHP exec) not dumping file but no error

I wasn't sure if this was a SO or SF question but I thought this might be the best place. I apologise if it is not! I am using mysqldump through PHP exec but it doesn't seem to be working. The code I ...
0
votes
0answers
23 views

MySQL Log to show users

I have a MySQL server running with about 50 users. I am looking for a way to tell which users are still actively accessing the server, which accounts are used. I already thought about grep-ping ...
0
votes
0answers
34 views

Mysql and user xfs quota and shared hosting enviroment

I spend to much on reading all over the internet of different methods about this but i solved on my way. Actually i use per user chroot environment and use make xfs project quota on user root. /...
1
vote
0answers
302 views

MySQL /nonexistent home vs “No directory, logging in with HOME=/”

The preinst script in the Debian/Ubuntu packages for MySQL sets the default home directory for the MySQL server to /nonexistent, presumably as a security measure - the MySQL server has its own datadir ...
1
vote
1answer
60 views

MySQL on udp port

I have searched around on the internet but could not find any satisfying answer. Can someone please guide, here are my confusions/questions. Can we run mysql on udp port instead of default tcp port? ...
1
vote
1answer
63 views

PHP-FPM crashes when having too many users while doing a heavy job

I have a Server running Apache/2.2.22 (Debian), PHP 5.6.17 as FPM and MySQL 5.6.25. The project runs using a CMS called Redaxo (I don't think it's that important, but I'll tell ya anyway). In Redaxo ...
0
votes
0answers
34 views

Mysql NDB Cluster 7.4 on CentOS 7

I am trying to configure NDB Cluster with 5 nodes on CENTOS MGMD Node =1 DATANode =2 SQLNode = 2 MGMD & DataNodes are up. mysql service failing on startup ERROR! The server quit without ...
0
votes
1answer
34 views

MySQL Backup Cron Job

I have a cron job which backup up my MySQL database by exporting it. The script includes the root password to get the job done. I get the message: Using a password on the command line interface can ...
0
votes
0answers
17 views

Ubuntu/Apache2 - Virtual host stops my MySQL server [duplicate]

I have really strange problem. I have an Apache2 server on Ubuntu 14.04 with installed MySQL server. Everything was working fine. I have multiple domains hosted on one server and i believe i received ...
1
vote
3answers
53 views

Can't get MYSQL to be visible from outside

I know there's a lot of topics about this but i've read them all and still can't access MYSQL from outside... Any help will be apreciated I'm using Centos 6.7. This is my /etc/my.cnf: bind-address =...
1
vote
0answers
27 views

RTC/UTC was innacurate on MySQL (MariaDB) server. I fixed it - was that bad?

I'm pinch hitting as an admittedly green server admin. I installed a bunch of security patches on a MariaDB server that had an incorrectly configured repo (not by me) and wasn't getting patches for a ...
0
votes
0answers
46 views

Starting MySQL/TokuDB with missing recovery log

I've lost TokuDB recovery log(HDD has died) and TokuDB won't even start complaining about missing recovery log: /var/log/mysql/error.log: ... [ERROR] TokuDB: Recovery log is missing (persistent ...
0
votes
1answer
111 views

Connecting to an AWS RDS behind a NAT with an SSH tunnel

I've set up a MYSQL RDS on AWS, in a private VPC behind a NAT. With Workbench, I can connect successfully from a remote client into the RDS no problems - so all of the RDS, the NAT and the security ...
1
vote
0answers
87 views

SYN flood on mysql server

Consider this structure: DB <-TCP3306- WEB{1,2,3,4} All servers are CentOS 6/7 Web servers are running PHP (using php-fpm) that connects to the MySQL server. Occasionally, I get this error ...
0
votes
0answers
46 views

trouble with change data dir on ubuntu mysql

Install zabbix on Ubunutu server with MSQL 5.6.27. After mount new part in /var/lib/mysql and copy all db files, mysql not started. What i done: 1) stop mysql 2) copy /var/lib/mysql to partition 3)...
0
votes
0answers
10 views

Schedule MediaWiki database maintenance job?

We run a MediaWiki installation for a single site on a VM. We find that we have to repair the mywiki_revision table weekly. It seems to be related to the Sunday backup that runs. We were OK with a ...
0
votes
0answers
31 views

xtrabackup/innobackupex: Full/Incremental backup advice

OS: Centos 7 Database: Mysql/MariaDB I have written my own shell script to produce Full and Incremental backups using innobackupex. I have read through the man pages for innobackupex and tried to ...
0
votes
0answers
39 views

Exporting privileges from Mysql - Something is missing

I used a little bash function to export MySQL privileges from a server (see http://serverfault.com/a/13050/238291). Works well, used it multiple times and never had an issue (although I do have to sed ...
1
vote
1answer
27 views

Small queries wait for large queries to resolve MYSQL PHP on Centos 6.5

I have a Centos 6.5, and I'm running Vaadin on Tomcat, This application has really heavy queries for reports and stuffs. My problem is, when I'm connect to MYSQL from PHP, when I made a small query, ...
1
vote
0answers
22 views

MySQL proxy authentication options

I have a farm of production mysql servers that are currently protected by restricted passwords. I would prefer to restrict access to these systems at network level, but have to account for the fact ...
0
votes
1answer
230 views

SQLSTATE[HY000] [1130] Host xx.xxx.x.xxx is not allowed to connect to this MySQL Server

I have 2 servers with digitalocean - web (nginx) and database (mysql) servers - and can't get a connection from the web to the mysql server. From what I've read in other SO posts on the topic, the ...
0
votes
0answers
98 views

InnoDB causing mysqld to crash on Amazon Linux AMI

This Amazon Linux server is running a single WordPress site that is constantly crashing. The way to resolve it seems to be to run service mysqld restart and it resumes operation until it crashes again....
1
vote
1answer
179 views

Mysql listens to wrong port on restart

I'm working on a 'local' PHP project. It's a PHP app running in a Debian VM intended for use on the user's own PC. I have a couple of python scripts running as root services from /etc/init.d which ...
0
votes
1answer
35 views

mysql replicate-* data transfer from master

I have been playing with MySQL replication for a new project of mine. I am using row based replication. I have a particular confusion with replicate_do_db which is to be written in the my.cnf of the ...
1
vote
0answers
21 views

Using a py file as an API endpoint on a hosted server

I need a bit of help and clarity involving how to set up an API service on my web server. I have written a Python script that is able to do some calculations and string parsing, and I need to make ...
1
vote
1answer
95 views

Postfix can't connect to MariaDB on 127.0.0.1

(Yes, this question seems very similar, but I understand why I get the message. What I don't get, and can't find any palpable information about on my own, is what to do about it. So here I am.) I ...
0
votes
0answers
58 views

Socket.io w/ node.js + nginx +mysql + php5-fpm Memory Leak?

I have a Debian VPS running node.js socket.io server + nginx + mysql +php5-fpm and the socket server seems to freeze with no messages and no errors. I noticed that the memory usage grows over time but ...
0
votes
0answers
78 views

innobackupex: InnoDB: Log file ./ib_logfile0 size 14754304 is not a multiple of innodb_page_size

I did a backup using innobackupex: innobackupex /mnt/aws/backup It completed successfully: ... 160131 11:40:03 Executing UNLOCK TABLES 160131 11:40:03 All tables unlocked 160131 11:40:03 Backup ...
1
vote
1answer
54 views

MySQL keeps crashing at unknown intervals

Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 160130 08:29:38 mysqld_safe Number of ...
-2
votes
3answers
131 views

Linux mysql server 5.6 will not start, or restart

I have a problem with mysql server; it doesn't want to start do you have an idea thank you. janv. 29 10:51:15 clicshopping mysqld_safe[20076]: 160129 10:51:15 mysqld_safe Can't log to error log ...
0
votes
0answers
98 views

MySQL 5.7 under Debian Jessie with postfix-mysql

I currently have MySQL installed from the MySQL APT repository and am on the 5.6 branch. It comes with libmysqlclient18 and postfix-mysql requires it. If I want to switch to the 5.7 branch, APT will ...
0
votes
1answer
122 views

Mysqld.exe crases on startup with error 0xc000007b

I've just deployed a new VM on Microsoft Azure with Windows Server 2012 R2. It is identical to other two I have (it was created from scratch though, not duplicated or from an pre-existing image), all ...
0
votes
1answer
108 views

high mysql CPU usage more than %1500 on centos 6

I am running a high traffic websites on a Dedicated-Virtual 24GB RAM CentOS server hosted by the planet. Very often the server dies because of high CPU usage (%1500) When i check the running ...
0
votes
2answers
984 views

PHP 7 cannot connect to MySQL

I have compiled LAMP servers for hundreds of times. However I am facing issues with PHP 7. I compiled it properly, but it cannot connect to MySQL in localhost. phpinfo shows PDO and mysqli are ...
1
vote
0answers
188 views

mysql-workbench installation error

I have ubuntu 14.04 and try to install mysql-workbench. and getting an error as The following packages have unmet dependencies: mysql-workbench: Depends: libgcc1 (>= 1:4.1.1) but 1:4.9.3-0ubuntu4 ...
0
votes
1answer
331 views

Mysql innodb_buffer_pool_size in relation to innodb_buffer_pool_instances

I run a virtual server with an Owncloud installation on it. Now Owncloud has the problem that the way it's developed at the moment, each file upload causes a little MySql overhead. So is very ...
3
votes
3answers
4k views

How can I install MySQL 5.7.9 to Ubuntu 14.04?

I tried to install with these inscturctions, but installation installed version 5.5. $ sudo apt-get install software-properties-common $ sudo add-apt-repository -y ppa:ondrej/mysql-5.7 $ sudo apt-get ...
0
votes
1answer
121 views

GTID have been turned off But I have error in replication

I just upgrade from mariadb5 to mariadb10. Then I have error on my slave replication Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't ...
0
votes
0answers
93 views

MySQL replication - invalidating query cache entries (table)

We lately mved to MySQL V5.5 on CentOS release 6.7 with master and 2 slaves. Since then the replication process lags a lot behind the master with the line in the process list of: invalidating query ...