MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
2answers
100 views

Repeated EC2 Apache 500 error

I'm running a Django website off Apache and MySQL. I'm using a t1.micro instance. After every couple of days, my server starts giving a 500 error. I solve this problem by restarting the Apache2 and ...
0
votes
0answers
92 views

Creating Table in mariaDB - ERROR 1429 (HY000)

I successfully integrated mariaDB-10.0.13 with Cassandra-2.0.8 and 2.0.9 I was able to created a table present in cassandra on mariaDB and was able to query successfully. But my problem is that ...
-1
votes
1answer
80 views

postfix how to setup local domain users as virtual users

How can I set up local domain users as virtual users? I have setup virtual domain and the users but when I sent an email it keeps telling me "User not found". To test to see what the problem is, I ...
0
votes
0answers
358 views

MySQL server would not start after config change

I have MySQL server installed on an AWS EC2 micro instance. The server was starting/stopping properly with sudo service mysql start/stop, but it stopped working since I made minor changes to the ...
2
votes
1answer
71 views

Default user for MySQL [duplicate]

With a fresh (but old) install of Ubuntu and MySQL, I found I could access the MySQL via command line client without being asked for any user or password. Logging in as root requires the root ...
0
votes
2answers
96 views

plenty of ram but still swapping

this is graph of my server ram you can see in graph that every time I restart mysqld, swap becomes zero. But increases over time. If i put innodb buffer pool in large size swap rises faster and if I ...
0
votes
1answer
144 views

Securing MySQL debian-sys-maint

With a fresh (but old) install of Ubuntu and MySQL, I found I could access the MySQL via command line client without being asked for any user or password. This bothered me as the default situation, ...
-1
votes
1answer
64 views

mysql dump file corrupted

I've been using the following command to dump my databases: $ mysqldump -uuser -ppass --all-databases | gzip > all-db.sql.gz A full dump of the database is around 130 Gb, and takes about 10 ...
0
votes
1answer
280 views

mysql crash on 512MB Debian server (memory problems?) How to fix?

I'm on a 512MB Debian 7.5 server. I woke up to find mysqld not running, and the syslog reveals lines like: Aug 9 09:00:58 web kernel: [1086155.903755] Out of memory: Kill process 2669 (m ysqld) ...
0
votes
2answers
104 views

MySQL performance problems on particular vhosts

I have a dedicated server setup (8 cores, 16 GB of RAM), running Ubuntu 12.04 LTS with latest updates, and I am experiencing some performance problems related to MySQL. I have multiple vhosts active. ...
1
vote
1answer
63 views

MySQL for Windows Memory Allocation

I am running some queries on some large tables. I tuned my settings so that innodb_buffer_pool_size = 16G and when I look at show variables, I see that 16G is allocated to the instance. I am running ...
0
votes
0answers
56 views

How to fix MySQL replication on one table

I have a rather large MySQL database with a handful of replicating slaves. Recently I ran the percona toolkit checksum and found a couple of tables out of sync. What is the best way to get them back ...
-2
votes
2answers
48 views

How can I estimate the request/second my server is capable of? [closed]

I recently built my own server to help me learn linux, Ubuntu and related technologies and to serve some small website projects I have been producing. How can I estimate the requests per second that ...
3
votes
1answer
122 views

`psql` expanded mode equivalency for `mysql`

Am frustated by things like: 0:33:1407402356:root@ahost:~# echo 'use wordpress_3_6_1; select * from wp_posts;' | mysql -u mysqluser -pmysqlpasswdord | wc -l -L 42 40585 SQL query results being ...
0
votes
1answer
228 views

Problems with a PHP include from the command line (or cronjob) [closed]

I am trying to setup a cronjob on my AWS EC2 instance. There is nothing wrong with the actual entry in the crontab file but when I try to run the command in the command line I get this response. PHP ...
2
votes
2answers
324 views

EC2 & MySQL security

The current infrastructure contains two servers located in Amazon EC2: application server, and MySQL server. Concern: security of communication between the application server and the database, ...
1
vote
1answer
226 views

Telnet 3306 fails to connect to Amazon EC2

Ok, I know this has been asked a lot, but I've tried every advice I can find and I still can't telnet to my Amazon server on port 3306. Add iptables entry for accepting connections on port 3306: ...
0
votes
0answers
87 views

MySQL replication across availability zones in AWS resulting in lag

I have 3 EC2 instances, each running MySQL. 2 are slaves replicating from the master. The master is located in the availability zone eu-west-1b. One of the slaves is in the same zone, and the other ...
0
votes
0answers
50 views

Percona MySQL LDAP authentication fails through .NET MySQL connector

Basically, MySQL uses its native authentication, where usernames and passwords are stored in mysql.user table. MySQL authenticates user against the credentials stored in mysql.user table. Our ...
0
votes
1answer
107 views

Error establishing a database connection due to curl_setopt

I have a Virtual Server (1 CPU 1020 MB RAM), with Ubuntu 12.04.4 LTS and Apache2, PHP5.5, Mysql, and four web projects inside with a low number of users. It has worked like a charm last year. But ...
0
votes
1answer
128 views

MySQL Master-Master Replication Issue

I have two databases that sync data through Master-Master replication. The setup was created using the following guide: ...
0
votes
1answer
206 views

mysql.sock error when deploying with AWS Ubuntu and RDS

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Rails.root: /opt/deployment.myproject/releases/20140805050704 I've spent the better part of 3 days trying to ...
0
votes
2answers
29 views

How to append mysql access to iptables

On one of my servers, I can see this: ACCEPT tcp -- distinct_server_ip anywhere tcp dpt:mysql By doing sudo iptables -L | grep distinct_server_ip And with ...
0
votes
2answers
940 views

Why won't iptables allow MySQL connections?

For some reason mysql connections from a specific IP address aren't allowed. This is the rule I have (grabbed from iptables-save): -A INPUT -s 12.34.56.78/32 -p tcp -m state --state NEW -m multiport ...
0
votes
1answer
145 views

MySQL: Error establishing a database connection

I'm running a DigitalOcean.com Virtual Server with the typical Ubuntu LAMP Stack for a few WordPress sites. Of course, every week or two the MySQL service seems to crash. If I restart MySQL or the ...
0
votes
0answers
93 views

pam-mysql: “Failed password” when using hash methods

today I installed mysql-pam in order to store user credentials for ssh logins in a mysql database. At first I set users.password_crypt = 0, which means that plain passwords are saved in the db. After ...
0
votes
2answers
2k views

how to get mysql.sock file, mistakenly deleted from “/mysql/tmp/”

I was stuck with a PDO Exception PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in lock_may_be_available() (line 167 of ...
0
votes
2answers
72 views

Mysql/Apache stops working once in a while

My problem: My webserver stops working once in a while. Apache still responds to requests, but it can't connect to mysql server. According to how I read the syslog it's because of insufficient RAM. ...
2
votes
2answers
625 views

403 Forbidden when trying to access a folder in document root of nginx

When I access index.php, it works fine. But on localhost/pset7, it gives a 403. Here is the permission log, -rw-r--r--. 1 root root 51 Jul 31 14:21 index.html -rw-r--r--. 1 root ...
-2
votes
1answer
92 views

Cannot connect to DB server

I have been getting this issue constantly while attempting to set up a database on another computer. I have tried looking up solutions, but nothing I have tried so far has worked, and I have no idea ...
0
votes
1answer
75 views

Apache2 using up all my memory and stalling my wordpress instance (mysql)

Environment Ubuntu 12.04 / 1GB RAM / 40GB DISK / 1 CPU (RACKSPACE) Wordpress 3.9 mysql Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (x86_64) using readline 6.2 Apache2 mod_php5 mod_rewrite When ...
-1
votes
1answer
3k views

Lost connection to MySQL server at 'reading initial communication packet', system error: 0 with windows

I found similar questions but none of them helped me with a windows machine. I originally posted this on stack overflow but it was suggested that I ask here. I was able to connect to mySQL through my ...
2
votes
2answers
56 views

How can I use Augeas to manage the `!includedir` directive for MySQL?

I have a MySQL configuration file with an !includedir directive. The directive seems to show up properly when the lens examines the file: $ sudo augtool print /files/etc/my.cnf | fgrep includedir ...
3
votes
2answers
4k views

Running MySQL in a Docker container

So my ultimate end goal is to run a MySQL Docker container (say tutum/mysql from the public registry) and then link a Gitlab Docker container (say sameersbn/gitlab) to it where both containers use ...
0
votes
1answer
48 views

Restore InnoDB to different machine

I currently have backups that were taken with Percona XtraBackup of all my mySQL databases. My specific scenario is that I want to restore a month old InnoDB database snapshot to my local machine for ...
0
votes
0answers
56 views

How to make permission of mysql log file stick?

I am running a custom cron script to do log rotation and email newly compressed log files. Due to permission problems, I have to set the group user to root instead of the default mysql so that the ...
0
votes
1answer
183 views

check_mysql_query cannot connect to mysql, but works from the command line

I have Nagios 3 running on Debian Wheezy. I am able to run the query the following query from the command line. The credentials for the mysql db are stored in ~nagios/.my.cnf nagios@intranet:~$ ...
9
votes
3answers
312 views

Is it possible to extract last month's values from a MySQL server and build a new database from those values?

I have an assignment to build a development virtual machine template. I need to add to the server MySQL databases from each one my company's products so that new developers will have the ability to ...
-3
votes
1answer
213 views

How to install from source PHP5.5, Apache2.4, Mysql5.5 [closed]

i have a centos 6.5 running locally as my webserver via virtual box, i only used this to test my website and wanted to simulate the real server, as much as possible i wanted to have the latest php, ...
0
votes
0answers
202 views

MySQL CPU high usage on Windows Server 2008 r2

I am using mysql for an instant messenger server. It was working fine when the user count was at 600-800 but for the past two days when traffic increased to 1000+ users, mysql server is constantly ...
-2
votes
1answer
91 views

MYSQL : Connecting to mysql from : 127.0.0.1 + telling ip tables to allow only 127.0.0.1 for mysql port : Logic vs Common Sense

if i make 1 billion or 1 trillion queries to MYSQL database.. from 127.0.0.1 via port 3306.. vs.. if i make same amount of queries to MYSQL database also from 127.0.0.1 via port 3306.. but with 1 ...
0
votes
1answer
70 views

DRBD/Corosync mysql clutser

I have configured HA cluster on two nodes host1 and host2. host1 is master and host2 is slave. If I shutdown host1 then host2 never comes up as master until I restart openais service. Some time I ...
0
votes
1answer
723 views

Ubuntu 12.04 LTS: Changing Mysql root Password

I did an upgrade from 10.04 to 12.04 today. I wanted to access MySQL afterwards, but I've forgot the root password... So I tried some guides from the net but none is working for me. Im not even sure ...
0
votes
0answers
28 views

MySQL Cluster replication: NDB$MAX_DELETE_WIN() changes always applied in primary

I am building TWO mysql clusters (A & B) with master-master replication: A --> B --> A I followed the official MySQL doc to setup conflict resolution. Eventually we may have more than 2 ...
1
vote
1answer
317 views

Squid3 - Cannot authenticate username/password with Mysql

I am testing both authentication with squid_passwd file and Mysql. This is my configuration auth_param basic program /usr/lib/squid3/basic_ncsa_auth /etc/squid3/squid_passwd # auth_param basic ...
2
votes
0answers
189 views

OpenLDAP with MySQL works but need schema advice

So, I have downloaded the latest source of OpenLDAP, compiled with —-enable-sql, messed around with the slapd.conf, configured the odbc files, added the tables to my current DB, spend a week debugging ...
1
vote
1answer
94 views

s3cmd: on-the-fly backup

To do backups I created a script that makes an archive of all the folders I need to backup, sends it to S3 (through s3cmd) and then deletes it after upload has been completed. I'm looking for a way ...
0
votes
1answer
571 views

Is it possible to install MySql 5.1.69 on Ubuntu 14.04? [closed]

I need this MySql version running in my local enviroment, but couldn't find a way to install it so far. Is it possible?
0
votes
0answers
90 views

MariaDB inside Ubuntu OpenVZ CT: Error on delete of '/tmp/#sql' (Errcode: 1 “Operation not permitted”)

I've installed MariaDB 10.0.12 on a fresh OpenVZ container: ubuntu-14.04-x86_64-minimal.tar.gz. Unfortunately when I browse tables via Adminer I keep getting errors like these: Error on delete of ...
0
votes
1answer
12 views

Crossserver SQL Procedures Failing Mid Process

Really need help understanding whats happening. We have two LANs at work with a shared subnet between them acting as a bridge (migration from A > B underway) we recently migrated the server subnet ...