MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
41 views

Why can I not re-create a dropped database?

I'm on a Debian host, and dropped a database from a Django project and then tried to re-create it. I've tried variations on a same basic theme from mysqladmin and mysql to create a database, and ...
-1
votes
0answers
14 views

php with mysql and IIS not working

I have followed online tutorials and installed PHP, and pypmyadmin on my windows server but when i am trying to install the mySQL server instance window its just freezing on "prepare configuration", ...
0
votes
0answers
14 views

MYSQL Database Crashes

My MYSQL DB Crashes from time to time, and I don´t know why exactly. I was reading the logfile from var/log/mysql. 2016-05-25 08:05:42 1160 [Warning] Using unique option prefix myisam-recover instead ...
0
votes
1answer
17 views

MySQL Replication Errno1146 Table doesn't exist

Here's the setup: I have a MySQL DB cluster in Rackspace that I'm already using for replication to multple slaves in multiple datacenters. I am trying to use AWS' Aurora with a MySQL front-end, which ...
0
votes
0answers
10 views

Connection failed: php_network_getaddresses: gethostbyname failed. errno=0

I need you'r help please... I created php web site in google engine. I open connection to mysql server using appharbor. When i run it local it connect very good and there was no errors in my web ...
0
votes
0answers
5 views

Unable to connect to locally ran SQL DB in Docker Container

I have a mariadb (mysql) running in a docker container with a test db, table and dummy data. I very it's running with docker exec fcd12bf1da81 /etc/init.d/mysql status and it outputs the uptime, ...
0
votes
0answers
27 views

Is there a simpler way to manage this Private Tuition classes' system? [on hold]

I'm making a website for a private tuition classes. Here, the concept is that a teacher goes to teach to the student's house. There are many teachers operating this way teaching many students at their ...
1
vote
0answers
14 views

Inconsistent CPU load on debian

This server runs Apache2, Tomcat6 and MySQL.(if that makes any difference you tell me :) Using htop i can see the cpu load on each of the 4 cores. What I do not understand is witch processes are ...
0
votes
0answers
15 views

postfix dovecot, lda(admin@domain.ltd) Error: user admin@domain.ltd: Couldn't drop privileges: Mail access for users with UID 150 not permitted

i install postfix, dovecot, mysql on Ubuntu 12.04. and.. see https://www.exratione.com/2012/05/a-mailserver-on-ubuntu-1204-postfix-dovecot-mysql/ by the way.. omg a error. temporary failure. ...
0
votes
1answer
44 views

RDS Performance slow compared to local mysql install

I have a RDS server (rd3.medium) on AWS that is running basic configuration. I'm trying to run this query, which runs in a few milliseconds on my local computer, as well as a basic web server where I ...
0
votes
1answer
31 views

shell script for geting mysql user grants details

I am trying to get mysql user grant details and echo it to out file hari=mysql -sN -e "show grants for mysqladm"; echo $hari GRANT ALL PRIVILEGES ON *prod_server_list.txt stage_server_list.txt ...
0
votes
1answer
11 views

Insert multiple sql files

I've 297 sql files, I want import them to mysql but it must be in different databases. I tried: find . -name '*.sql' | awk '{ print "source",$0 }' | mysql -u <db_user> -p --batch -D ...
0
votes
0answers
70 views

Getting “Can't create/write to file '/var/lib/mysql/is_writable'” using docker (inside vagrant on OS X)

I am trying to use docker-compose/docker inside a vagrant machine hosted on OS X. Running 'docker-compose up' always fails with mysqld: Can't create/write to file '/var/lib/mysql/is_writable' ...
0
votes
1answer
27 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
17 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
15 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 ...
1
vote
0answers
26 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
120 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
12 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": { ...
0
votes
0answers
13 views

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

I have installed mysql 5.6 on debian 5.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
57 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
22 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 ...
-1
votes
0answers
36 views

MYSQL very slow on a huge server

I have an ecommerce with a lot of products (more than 100K). And around 2000 visits every day. My Database is very slow, but I have a huge server (for this amount of visits). Server: 16GB Memory ...
0
votes
0answers
40 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
11 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
30 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
11 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 ...
-1
votes
0answers
26 views

Is it possible to restore mysql database from frm myi and myd files only?

I accidentally deleted my database while testing mysql work bench.as its a relatively new db on a new server I had no back up running. Luckily I can see some frm, myi ,and myd files. afaik i had ...
1
vote
2answers
250 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
30 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
18 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
51 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 ...
-2
votes
1answer
104 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
8 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 ...
-2
votes
1answer
55 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 ...
-2
votes
1answer
35 views

MySQL Issue with Wordpress Running on EC2 Instance [on hold]

This past week, my Wordpress site that's installed on a EC2 instance has become unresponsive and began displaying the message "Error establishing a database connection." I eventually discovered that ...
0
votes
1answer
18 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
17 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
89 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
25 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
11 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
35 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
24 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
21 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
57 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
20 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 ...
-1
votes
0answers
15 views

Wifi, remote connection, mysql

I am having this really strange error on my connection to my mysql server from a remote host. It basically hangs out large queries with blob or throws the following Warning: Empty row packet body; I ...
0
votes
2answers
17 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
32 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 ...