MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
98 views

php unable to connect to MySQL via SSH tunnel

I have executed both commands via SSH with no error and than when I try to connect to the MySQL server via SSH tunnel I get no results even if I do a simple query like select * from table. I get no ...
1
vote
1answer
23 views

AWS RDS host instance creation fails: “hardware error”

I'm trying to create a MySQL RDS host instance on AWS (via Ansible) and getting the following error: The database instance has been put into STORAGE_FAILURE due to a hardware failure It happens ...
0
votes
0answers
30 views

Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

I installed MySql and when i try to start it , it stop with error 3534 here is my error from log 2016-05-19T19:29:20.416636Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql....
1
vote
0answers
57 views

MariaDB ignores root password completely

I just installed MariaDB (mysqld) on a fresh Ubuntu downloaded yesterday. Then I ran the script /usr/bin/mysql_secure_installation and set new root password and disabled passwordless login. However ...
1
vote
2answers
159 views

AWS WordPress site - OOM kills Apache

This question was originally asked on StackOverflow.com, and I've duplicated it to the more appropriate ServerFault.com site. The original question, which I've voted to close, can be found here I ...
0
votes
0answers
46 views

How to overload package_name in Chef cookbook using AWS custom JSON?

I never worked with Chef and OpsWorks before. What I'm doing, I'm trying to overwrite some Chef conf to use modern PHP 5.6. I wrote a JSON for Layer PHP App Server { "mod_php5_apache2": { "...
-1
votes
0answers
22 views

From MySQL Server 5.5.47 to 5.5.49 -> Huge performance drop

I have recently apt-get upgraded my Debian Wheezy server. In that update, MySQL updated from 5.5.47 to 5.5.49. I have many tens of hundreds hits per days, it hasn't changed recently. But since ...
0
votes
0answers
29 views

MySQL's console client does not display non-latin symbols

I have installed mysql 5.6 on debian 7.10 from official mysql deb repository: deb http://repo.mysql.com/apt/debian/ wheezy mysql-5.6 So i have these packages installed: # dpkg -l | grep mysql | ...
0
votes
1answer
87 views

Nginx php5-fpm varnish taking high CPU. Load average is over 32

I'm on a server with the following config: 32 GB RAM 12 core processor and it's running single wordpress on nginx, varnish, php5-fpm, fastcgi. Everything was running fine, but suddenly after ...
0
votes
0answers
31 views

InnoDB table takes more than 1 second for insert query

during an insertion it takes about an second for sometimes (not always) in MySQL 5.6.17-log which is causing performance issue How to over come this issue current set of parameters for innodb ...
0
votes
0answers
71 views

MariaDB 10.1.x Online DDL spaming error log files

Since our upgrade to a new mariadb/mysql version (previously the 10.0.x branch) we have tons of this messages in our error log. All of them are a type [note] messages but i cannot find any ...
0
votes
0answers
39 views

Laravel real time data add and send update from mysql

I have been developing a system which is on laravel, i need a few knowledge on technology i am not sure of which should i follow. On my laravel i have an end point link which hits whenever someone ...
0
votes
1answer
82 views

Fix PHP error Invalid argument supplied for foreach() after update PHP & Mysql

I have updated PHP from 5.3 version to PHP 5.6.21 (mod_fcgid) on my CentOs 6.5 vps. The vps holds 4 Prestashop and almost works but cart doesn't work as expected. The php error log contains this ...
0
votes
0answers
12 views

How to restore mySQL slave server that is lagging behind in transactions

I recently setup replication between two servers for the purpose of facilitating a fail-over scenario between the master and the slave. I'm using the mySQL utilities fail-over utility and it was ...
2
votes
2answers
1k views

Uninstall Mysql 5.7 from Ubuntu 16.04

I am having problems with mysql 5.7 in ubuntu 16.04 when it comes to giving users privileges, so I want to re-install it again but when I type the command for removing mysql I get the following ...
0
votes
1answer
63 views

How to import large mysql database (innodb , myisam tables) to MySQL NDB cluster

Mysqlcluster used:- GA 7.4, Centos 7 I have 30GB each physical memory in 2 datanodes and SSD 200GB each but the database size(cumulative size of multiple db's belonging to free radius ) is around ...
0
votes
1answer
28 views

Windows server 2012 IIS 8 php data post upload failure to mysql

I'm getting a php data upload fail when attempting to transfer data up to a mysql database from a html5/webgl built app off of Unity. All of the data downloads work regardless of the upload issue. The ...
-3
votes
2answers
77 views

High CPU load of my VPS [closed]

I use VPS from digitalocean. The configuration is: 8GB RAM, 4 Core Processor, 80GB SSD with cpanel installed. Most visitors are in the site http://www.secretdiarybd.com/bn . Which is on wordpress ...
-1
votes
1answer
349 views

Freshly installed MySQL server 5.7.12 fails to start on FreeBSD 10.3

root@w:/var/db # pkg install mysql57-server mysql57-client Updating FreeBSD repository catalogue... FreeBSD repository is up-to-date. All repositories are up-to-date. Checking integrity... done (0 ...
0
votes
0answers
9 views

courier-authlib not connecting on Gentoo

I may have 2 issues, or miss reading one. logs: May 15 11:17:17 r2d2 authdaemond[26904]: Installation complete: authpipe May 15 11:17:30 r2d2 postfix/smtpd[26986]: sql auxprop plugin using mysql ...
0
votes
2answers
145 views

MySQL - high RAM usage

I have VPS with 2GB of RAM running Ubuntu. There are three sites using database on this server - two on WordPress and one on custom script. All of them get max few hits per day. MySQL always had ...
0
votes
1answer
24 views

Connection between sql workbech on my Laptop and Mysql on Google cloud compute engine (not cloud sql)

Is there anyway to open a port 3306 between MySQL database running on compute engine in google cloud (not cloud SQL) and MySQL workbench running on your local machine to connect ? I was able to ...
0
votes
1answer
27 views

Setup MySQL replication of specific tables of a database to another mysql server

I have several production MySQL databases running on an RHCS cluster. I want to setup replication of one specific database, with only specific tables from that database, to another brand new mysql ...
0
votes
1answer
376 views

Having trouble installing MySQL Community Server on new RHEL 6.8 instance

I'm having trouble installing MySQL 5.7.12 on RHEL 6.8. The first RPM I downloaded was for RHEL 7.0. This is a brand new instance, and I stupidly assumed it would be RHEL 7. It's not. So my ...
0
votes
1answer
37 views

Configuring remote access to mysql via puppet

The problem: I want to connect to mysql from another host I have a mysql instance that I configure with puppet. I want to be able to access the instance from host 1.2.3.4. Part 1: I start by hand ...
0
votes
1answer
13 views

Selectively restore specific databases from a complete mysqldump

I have multiple Wordpress databases stored on a VPS. I am using the following command to back them up: # mysqldump -u root -p password --all-databases > /tmp/all-database.sql This creates a ...
0
votes
2answers
37 views

Recovering an EC2 instance

I was running an ubuntu EC2 instance for about an year and I lost SSH connectivity to it after installing the latest updates. I was running a Rails application with automated capistrano deployment ...
0
votes
0answers
26 views

Run mysql-workbench remotely, no proxy/or tunnel

We are on AWS, with a MySql RDS. The RDS is set up so that only clients that are on the VPC can access it. (Just being VPN'd in is not good enough) So I assume that I could set up a tunnel,proxy, ...
0
votes
1answer
17 views

MySQL long_query_time Seems to be Ignored

I added the following to MySQL config file... slow_query_log=1 log_queries_not_using_indexes=1 long_query_time=1 slow_query_log_file='slow_queries.log' So why would the log file contain entries ...
0
votes
1answer
23 views

MySQL processes gets killed after 900 seconds

I hope this is the right place to ask.. I am facing a strange issue where the connection to the mariadb server gets terminated after a certain time. Like I am trying to connect to the mariadb server ...
0
votes
1answer
127 views

ownCloud Unable to Connect to Local Database on Fedora 23 (LEMP stack, selinux permissive)

The Problem I am having a very strange issue where ownCloud seems unable to access my SQL database, using nginx, mariadb, and php-fpm running on Fedora 23. When I attempt to access the page, I get ...
0
votes
0answers
40 views

How can I add SHA512-CRYPT support to SOGo 2.3.10?

I am trying to connect SOGo to an existing Dovecot/Postfix setup (trusty tahr) with a MySQL backend. I established the connection and so far everything seems to work except the login part since the ...
0
votes
2answers
25 views

MariaDB taking ages to restore backup

So I did a mysqldump of a pretty huge db and I'm trying to restore it now using: mysql db_test < db_test.sql but it looks like it's not gonna end by the end of this year. It's been about an hour ...
1
vote
1answer
65 views

Connecting to MySQL is taking a long time

Here is a normal client side sending an AJAX request to the server, without using any libraries. About The Database: There is only 1 table in the DB having 2 columns and 2 rows. The Storage Engine ...
0
votes
1answer
26 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
31 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
3answers
31 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
12 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
57 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
75 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
35 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
121 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
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
2answers
64 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
194 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
38 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
38 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
39 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
151 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
120 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 ...