MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
24 views

What to use as DB Host when installing WordPress?

I am aware of how daft this question seems. I am installing WordPress on two load balanced servers (hardware load balancer), with MySQL set up in Master-Master configuration with an installation on ...
0
votes
1answer
28 views

MYSQL datadir renames itself after rebooting server

I've mounted MySQL datadir to separate disk due to space constraint in the Redhat server. The problem occurs whenever I rebooted my Server. After the reboot, the existing MySQL datadir i.e., Mysqldata ...
0
votes
2answers
23 views

MySql query returns null on ocassions

I'm not sure what exactly is causing this but on occasions a mysql query that I know has to return results will sometimes return null as a result. I've seen this happen twice before but as I couldn't ...
0
votes
0answers
5 views

How do I get to write exim delivery result in mysql

Good evening. I have such a scheme. The main server and multiple mail servers. Each mail server installed exim is realized through sending phpmailer. Logs are parsed delivery in php and then recorded ...
1
vote
0answers
36 views

PHPmyadmin Login without a password is forbidden by configuration even when entering password

Basically it is all in title. I did a clean install of CentOS7.2 (needed CentOS7 for running ARK). I made a LAMP server and it is working with tests, and then I installed PHPmyadmin. Whenever I try to ...
1
vote
1answer
42 views

“Committed Bytes In Use” is high when there are plenty of “Available Bytes”

My windows computer keeps showing low on memory message so I used performance monitor to check memory status. The results are: Commit Limit: 25,758,334,976 (bytes) Committed Bytes: ...
1
vote
0answers
22 views

MySQL on Ubuntu. 10061 error on 3306

A fresh install of Ubuntu inside of a Virtualbox with LAMP option selected. I am unable to connect to the server via telnet on this port or via ODBC from my host machine. I can ping and SSH both ...
0
votes
1answer
93 views

Mysql conflicts on Centos 6.7

I am trying trying to install RMySQL on Centos 6.7 however I am not very experienced with server stuff so bear with me. I use this command sudo yum install mysql-devel However I keep getting the ...
0
votes
0answers
17 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
2answers
44 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 ...
0
votes
0answers
49 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: ...
0
votes
0answers
16 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 ...
0
votes
0answers
23 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 ...
1
vote
0answers
21 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/ ...
1
vote
1answer
109 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 ...
-1
votes
2answers
57 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
50 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
30 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 ...
1
vote
1answer
45 views

convert plain text passwords to sha512-crypt in dovecot + postfix's mysql mailbox table

I have an old postfix + dovecot + Roundcube mailserver (mail.domain.Tld). Server clock is loosing time and adjusting it causes dovecot to kill itself, we cannot install more memory, bigger ...
0
votes
1answer
45 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 ...
1
vote
1answer
65 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 ...
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
19 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 ...
0
votes
1answer
74 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 ...
1
vote
1answer
43 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 ...
1
vote
2answers
92 views

Yum dependency available but not marked for install

I'm trying to install a specific version of MySQL: mysql-community-server-5.6.29-2.el6 on RedHat 6.6. When I run yum install, I get dependency errors, but the dependencies are clearly available. I'm ...
0
votes
0answers
15 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 ...
0
votes
1answer
23 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
3k 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, ...
0
votes
1answer
102 views

mysql_upgrade - ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES) [closed]

After backing up my Plesk (12.5.30) server, I received the following error: Not all the data was backed up into /var/lib/psa/dumps/domains/example.com/databases/example_database_1 successfully. ...
2
votes
3answers
33 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
0
votes
2answers
47 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 ...
1
vote
2answers
229 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
0answers
36 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
43 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
33 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 = ...
1
vote
1answer
16 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 ...
0
votes
1answer
30 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 ...
1
vote
1answer
105 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 ...
0
votes
1answer
136 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
0answers
23 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
1answer
64 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
32 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 ...
-3
votes
1answer
95 views

I think I'm Hacked. MySQL Server Too Many Connections Made my Server CPU load 100% [closed]

I'm having a very urgent problem. Suddenly today My Server can't send email, after i checked out the log turns out there are many errors from MySQL which says too many connections. I checked out my ...
0
votes
0answers
79 views

ownCloud 9 MySQL not supported

I'm trying to install ownCloud 9 to FreeBSD 10 with nginx as web server. I am using this official manual, which tells me to use this command: sudo -u www-data php occ maintenance:install --database ...
4
votes
1answer
412 views

Can I tell MySQL to store specific databases in specific folders?

Lets say I have 2 databases, "foo" and "bar", and I want MySQL to store "foo" in "/media/foo", and "bar" in "/media/bar", can this be done in MySQL 5.5 or later?
0
votes
2answers
61 views

Accessing MySQL Remotely - Best Practices

Sorry if this is a bit of a broad question, but are there any best practices regarding accessing a remote MySQL via remote desktop versus locally through some other method? The goal here is to access ...
-2
votes
1answer
35 views

Running on two servers vs. one with more memory? [duplicate]

I currently have one small VPS which I am using to host a Wordpress site (Nginx,PHP5,MariaDB). I have started to run into some memory issues (DB crashes) indicating it's probably time to move to a ...
0
votes
0answers
34 views

My wordpress/MYSQL is consumming way too much memory, how do i act on it?

I have a Ubuntu server running apache + mysql + PHP +postgres + passenger Mysql is often crashing, putting wordpress out of service. I asked the question here : Wordpress + PHP+ apache +mysql, mysql ...
-1
votes
1answer
43 views

Wordpress + PHP+ apache +mysql, mysql crash every 1/ month [duplicate]

On a server i have multiple rails apache + postgres apps and a mysql + php. The only PHP app is a wordpress. Except for wordpress everything runs fine. Every 40-50 days, mysql stop to work. Here is ...