MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

1
vote
1answer
91 views

Centos 6; phpMyAdmin 'Cannot log in to the MySQL server' after moving mysql.sock

I recently moved my mysql datadir from /var/lib/mysql to a new directory /home/mysql mounted on a new hard drive. For neatness sake I thought it'd be nice to place the tmpdir and socket on this new ...
0
votes
0answers
11 views

MySQL server crashes weekly for over a year on Ubuntu with error log entries [duplicate]

My client has a basic LAMP web-server running on Ubuntu 14.x.x at Digital Ocean used to host a WordPress blog site. Very unfortunately for the past year there has been a random MySQL server crash 2-4 ...
1
vote
4answers
149 views

Is it possibble to reboot a remote MySQL server on Ubuntu from a program or script on a Mac? [closed]

I have a client who has a web server hosted with Digital Ocean and they have a weird random MySQL database issue... 1-4 times a month there database server crashes and has to be manually rebooted. I ...
1
vote
1answer
51 views

MySQL (MariaDB) crashing

Good morning - I have reviewed a previous post regarding changing the performance schema to "Off in the configuration settings. It looks as though our configuration is already set to this. So not sure ...
1
vote
0answers
120 views

Unable to login to MySQL on ownCloud using PHP - SQLSTATE[28000] [1045] Access Denied

I get a SQLSTATE[28000] [1045] Access Denied error every time I try to connect my ownCloud instance to my MySQL database as <user>@localhost. This is on a clean, newly installed copy of Ubuntu ...
3
votes
0answers
40 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; ...
0
votes
1answer
19 views

ubuntu - Postfix mail sent from server not logged in mail.log or phpmail.log

I am having server which hosts 70-80 websites and also using relay server for smtp using postfix using mysql database for domain and email boxes. I have also activated the phpmail.log for sendmail. ...
0
votes
0answers
8 views

MariaDb hangs on insert from SELECT with subquery

I have the following query: INSERT INTO lists (list, entity_id) SELECT '13633' list, entity_id FROM ( SELECT must1_entity.id entity_id FROM entity must1_entity WHERE ...
0
votes
1answer
68 views

PHP not able to connect to MySQL

I just compiled PHP 7.0.4 on a Fedora 23 box, created a test script to connect to MySQL on localhost and all I get is: Error: Unable to connect to MySQL. Debugging errno: 2002 Debugging error: No ...
0
votes
1answer
93 views

Auto-start MariaDB using systemd after it has crashed

I am trying to set up MariaDB in a way that it automatically recovers -- basically restarts, from a crash. Based on this article -- scroll down to Auto-starting Services with systemd, I opened ...
0
votes
0answers
18 views

MySQL Cluster: Too Many Connections

We have our java application directly connected to the MySQL cluster (NDB engine) with 1 SQL Node. We also have another SQL node. We had a requirement to load balance our 2 SQL Nodes with the physical ...
0
votes
0answers
16 views

Trouble getting automysqlbackup to keep connection to mysql server

I am trying to follow the instructions from the following page to set up backups for mysql. https://www.howtoforge.com/tutorial/mysql-incremental-backup-point-in-time-recovery/ However, once I get to ...
0
votes
0answers
17 views

MariaDB replication- slave with high loadavg

We recently set a master-slave replication with MariaDB 10.1.12 on RedHat 6.7 fully patched. Master and slave are powerful Dell R730 with 2 RAID arrays- 1) 2 x 15k SAS drives for OS in RAID1 2) 4 x ...
1
vote
0answers
20 views

Recover MySQL MyISAM BAK files

I had some hard disk issue on my server and I noticed a MySQL table is missing lots of rows (5k instead of about 200M). In the MySQL directory I have a BAK file for that table : ...
0
votes
2answers
91 views

How to detect slow code or plugin

I don't have much experience with WordPress and I don't know where to start. There is a website which is running very very slow. The hosting company helped me to detect that it's because some piece of ...
0
votes
0answers
13 views

Kernel killded MySQL daemon due to “Out of memory” although there is a free ram

Today about 10:45 AM my Ubuntu Linux server had killed the MySQL daemon due to "Out of memory". The following lines of Syslog shows what had happened. Mar 15 10:45:43 server1 kernel: Out of memory: ...
-4
votes
1answer
104 views

ERROR 2002 (HY000): Can't connect to local MySQL server after mysql upgrade

I was running mamp on el capitan 10.11.3. I decided to update mysql to version 5.7.11, so I ran this: tar xfvz mysql-5.7* echo "stopping mamp" sudo /Applications/MAMP/bin/stop.sh sudo killall httpd ...
0
votes
0answers
46 views

Cannot get MariaDB running after migration from MySQL

For hours I have tried all the things in the book with no success. All the solutions seems to involve magic like rebooting or apt-get purge everything related to MariaDB and MySQL and started all over ...
1
vote
1answer
102 views

Compiling PHP7 with MySQL error

I'm setting up an alt-install for PHP7 on CentOS 6.7 with the configure options that were used for the original PHP version: ./configure --disable-fileinfo --disable-opcache --disable-posix ...
-1
votes
1answer
38 views

phpMyAdmin - make user which only sees databases they create

I am aware of how to grant a user access to only one database using phpMyAdmin, and I am aware of how to give a user access to create a new database using phpMyAdmin (using the Create privilege). ...
0
votes
0answers
14 views

Server auto disabling pdo

PDO mysql plugin wasn't enabled by default in my server , so i added a line extension=pdo_mysql.so to a php.ini file i created, and it works fine , but every once in a while it is ...
-2
votes
2answers
84 views

MySQL does not start anymore [closed]

unfortunately I am unable to start mysql after reboot: root@server:/etc/mysql# systemctl status mysql.service ● mysql.service - LSB: Start and stop the mysql database server daemon   Loaded: loaded ...
0
votes
1answer
67 views

Munin and mysql plugin

I've installed munin on a vps and I want to monitor mysql usage of 3 mysql servers, I have configured mysql_ plugin as follow: [mysql_*] env.mysqlconnection ...
1
vote
1answer
26 views

Unable to login to MySQL locally after remote changes

After doing the following two things to setup remote access to my database, I'm not unable to access the database locally: GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pass' WITH GRANT ...
-1
votes
3answers
78 views

MySQL uses 100% CPU - Not sure to configure

I'm running a VPS on DigitalOcean on a 8GB ram 4 Core. We're on Ubuntu 32 bit. Recently been running into the issue where the mysql process is taking up 100% of the CPU load and slowing our server. ...
0
votes
0answers
23 views

TRUNCATE drops a table sometimes

After TRUNCATE table, getting this error sometimes: Uncaught exception PDOException: SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine After it, I'm missing table which I was ...
0
votes
0answers
58 views

No longer able to connect by SSH

I'm using Google cloud with a couple of instances deployed. I was trying to resolve an issue with the MySQL database on the server and I couldn't get MySQL to start so I resorted to restarting the ...
0
votes
1answer
18 views

bacula catalog backup error

I have a Bacula (mysql) server on an Ubuntu-server machine. It backs up and restore without issues except for the catalog. Every time it runs the catalog backup it shows an error. My guess is that ...
0
votes
0answers
15 views

force mysql cleint to start SSL/TLS immediately without server's plaintext handshake

I am trying to get HAProxy to do the SSL for a MySQL Proxy in front of a MySQL Server, however my problem is the mysql client is waiting for the Initial Handshake Packets from the server, and the ...
0
votes
1answer
266 views

mysql authentification plugin is not loaded

Problem: I am encountering an login problem when setting up users in mysql. Old users can login as expected, for newly created users I cannot login and get an error message. Executed SQL: CREATE ...
0
votes
0answers
16 views

How do you speed up an SQL query on a huge database? [duplicate]

I'm currently dealing with a table that has 30 million rows of 8 columns. I'm only selecting the columns that I need. SELECT column_a, column_b FROM table_name This is happening from a python script ...
1
vote
1answer
118 views

Why does this “netstat -tln” output show entries for “0.0.0.0:22” and “127.0.0.1:3306” [closed]

When I run the command netstat -tln I see the following output: Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 ...
0
votes
0answers
49 views

High RAM usage by Apache without any visitors

I have recently bought a VPS server with the below configuration Centos 6 64bit 20GB SSD 512MB RAM 512 VSwap I have hosted around 10 websites. In that 4 of them is WordPress. Others are ...
0
votes
1answer
50 views

ERROR In Importing Mysql DB dump On AWS RDS

I took Mysql DB dump from one RDS server and trying to restore in another RDS server.While importing the complete DB i am getting below error. ERROR 1419 (HY000) at line 2447: You do not have the ...
0
votes
1answer
32 views

mysql show databases; doesnt work it gives -> again and again after script

I have a script that I run to create my database. I run this with source <file> when it finishes it shows mysql> I then type show databases; and it goes to next line and puts ...
2
votes
0answers
25 views

MySQL slave index file corruption

I have a MySQL master-slave replication pair, and to take backups, I run a script that stops the slave, dumps the database, and then re-starts the slave. However, after restarting, the slave's MySQL ...
1
vote
3answers
78 views

mysqldump to remote mysql database using gzip

I'm trying to transfer data from one MySQL server to another with gzip compression. What I have so far is: mysqldump -u [user] -p[pwd] --no-create-db --no-create-info [db] [table] | gzip -c | mysql ...
1
vote
1answer
134 views

Import MySQL 5.6 database into 5.5 using MySQL 5.6 client tools

My local dev environment currently uses MySQL Server 5.5. However, one of my clients hosts decided to upgrade their server to 5.6. I sync my clients databases remotely using mysqldump over ssh. I have ...
0
votes
2answers
837 views

Error while installing mysql on centos 6.7

Error: Package: 2:postfix-2.6.6-6.el6_7.1.x86_64 (@updates) Requires: libmysqlclient.so.16()(64bit) Removing: mysql-libs-5.1.73-5.el6_6.x86_64 (@base) ...
0
votes
1answer
67 views

increase max_connections in mysql on ubuntu wily

I have ubuntu wily installed on my server. I'm trying to increase max_connections of mysql server to 1237 but when running mysql client and executing show variables like 'max_connections'; i get 214. ...
1
vote
1answer
73 views

Is there a way to make these two docker bash commands execute synchronously?

I am automating the setup of dev environments for my app and when I run these two commands manually from the command line I have to wait around 10 seconds after running the first one to run the second ...
1
vote
0answers
44 views

MySQL Multi-source replication from 5.6 masters to 5.7 slave

In MySQL 5.7 multi-source replication is finally available. Is it possible to use several MySQL servers running version 5.6 as multiple masters for a single MySQL slave running 5.7? Or do you have to ...
0
votes
1answer
45 views

MySQL logs different time than NOW()

MySQL server logs entries with different time than system or mysql itself: mysql> select @@global.time_zone; +--------------------+ | @@global.time_zone | +--------------------+ | SYSTEM ...
0
votes
1answer
38 views

Stop numproc exceeding the limit

We are running magento on VPS, which is facing a Numproc issue. According to our hosting provider, our server is exceeding the limit of numproc "400" & memory usage is also high. Because of this ...
-3
votes
2answers
72 views

MySQL wont start after updating

My MySQL server (Located in /mysql) refuses to start after i updated it from 5.1 to 5.6. Permissions: -rwxr-xr-x. 1 mysql mysql 10485760 Dec 29 18:20 ibdata1 drwx---rwx. 2 mysql mysql 16384 Dec ...
0
votes
0answers
9 views

Duplicate mysql datadir on Windows

I have a development server running Mysql 5.1 (together with other services). During an urgent cleanup I found, using SequoiaView, two identical mysql data folders. C:\ProgramData\MySQL\etc.... is ...
2
votes
2answers
193 views

MySQL doesn't start after upgrading to Debian Jessie

I have a server with Proxmox 3.4 with several OpenVZ-containers. Host and all guests are running Debian 7 x64. Now I want to migrate my old setup to a new server with Proxmox 4 (based on Debian 8). I ...
-1
votes
1answer
65 views

MariaDB always show SSL not in use when I start mysqld with --ssl

CentOS 7.2.1511 Linux 3.10.0-123.9.3.el7.x86_64 MariaDB: 10.1.11 /etc/my.cnf # # This group is read both both by the client and the server # use it for options that affect everything # ...
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
40 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 ...