MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

-1
votes
0answers
17 views

table name “__ms_cons_tmp_xxx” in mysql database

There are huandreds of tables in the mysql database named like __ms_cons_tmp_1407998079_1182 and __ms_cons_tmp_1407998079_1182_done records in these tables are records that in the other databases. ...
0
votes
1answer
17 views

update time and create time of tables is showing null in mysql

The columns update_time and create_time is having the value NULL in the information_schema Tables of MYSQL. How can the value be NULL?. Can anyone please explain?
0
votes
1answer
21 views

Windows server and ddns which binding and sql hostname do i use?

i'm trying to connect to websites on this server from outside the network. i've opened ports in router and firewall and can ping the ports using portchecker. let's pretend i want to use wordpress or ...
0
votes
1answer
32 views

Openfire password forgotten - database hidden

I have set up an openfire server two months ago and I have forgotten if I had used the built-in database or my MySQL server on localhost. I am using Windows Server 2012 on Amazon EC2 with XAMPP ...
1
vote
0answers
42 views

Website down… due to sleeping MySQL connections?

I've just inherited the administration of a website, and I'm finding some problems: When the traffic in the site peaks (it happens when our posts are featured in some distribution lists/RSS feed), ...
0
votes
1answer
26 views

MySQL SSL: bad other signature confirmation

I am trying to enable SSL connections for MySQL-- SSL will show as enabled in MySQL, but I can't make any connections due to this error: ERROR 2026 (HY000): SSL connection error: ASN: bad other ...
-2
votes
1answer
12 views

Access denied for user 'diduser'@'localhost' to database 'diddata' (1044, 42000)

I am trying to setup a MySQL server and when I went to create a second user it wouldn't give it permissions for the database. I can connect fine as long as I don't specify a database. Access ...
-2
votes
0answers
30 views

Incredibly Slow Website Response When Outside of Network [on hold]

When I access my website from a computer within my network, I get very quick response times. When I access the site with my phone or run pingdom tools on it, the response takes over a minute to bring ...
0
votes
0answers
22 views

MySQL permission errors

It seems that on a Ubuntu 14.04 machine the user mysql cannot access anything. It is not writing logs nor reading files. Witness: - bruno():mysql$ cat /etc/passwd | grep mysql mysql:x:116:127:MySQL ...
3
votes
1answer
71 views

How do I configure rsyslog to deal with MySQL Slow Query Log multi-line messages?

Using rsyslog v8.2.2, I would like to group multi-line messages, such as those output by the MySQL Slow Query log. Each new message begins with three consecutive lines having '#' as the first char of ...
0
votes
1answer
200 views

Forced reboot caused /var/lib/mysql to 'disappear'

During the nigh my provider had to force reboot the server (pull the plug), after boot, there was a problem with the MySQL server (I'm using MariaDB). After hours of research I can't find the main ...
0
votes
1answer
24 views

How many incremental backups to keep with Percona xtrabackup?

I'm looking to replace an aging and decidedly suboptimal mysqldump-based database backup strategy with Percona's Xtrabackup. This all looks pretty straightforward, except that I'm wondering: how many ...
0
votes
2answers
43 views

MySQL remote connection - Access denied for user 'username'@'localhost' (using password: YES)

I am setting up a remote connection to a MySQL server but no matter what I try I am getting access denied error from the remote server. I added the user by: CREATE USER ...
0
votes
1answer
24 views

New MySQL 5.7 installation: Account “Any@%” with USAGE-only, no-GRANT? [duplicate]

I've a MySQL 5.7 brand-new installation (via Oracle official RPM) on CentOS 6.5. Via phpmyadmin, I see this strange "Any@%" account I didn't create, with only USAGE as GLOBAL PRIVILEGES and Grant: No ...
0
votes
1answer
23 views

MySQL on Mac OS is not listening on port 3306 [closed]

I've just installed MySQL 5.6.20 on Mac OS X 10.9.4 (Maverics) It is only accessible via a unix socket however, I would like to be able to connect to it with TCP/IP on port 3306. I have read about the ...
0
votes
1answer
24 views

MySQL stops running without reason in log file

I am running MySQL 5.6.17 on Centos 6.5 (2.6.32-042stab090.5 #1 SMP Sat Jun 21 00:15:09 MSK 2014 x86_64 x86_64 x86_64 GNU/Linux). Every couple of weeks MySQL stops running, the logs do not show ...
-2
votes
1answer
31 views

MariaDB service won't start on FreeBSD jail

Just set up a dedicated database jail running databases/mariadb55-server and for some reason it won't start on demand nor on boot. Any suggestions? # service mysql-server start Starting mysql. ...
0
votes
1answer
12 views

improvement on mysql server [closed]

I have a 2x Xeon Quad Core E5410 2.33 GHz with 24 GB of RAM. running 5.5.31 with the following my.cnf file. It supports lots of reads and writes and transactions(all INNODB). Are there any obvious ...
0
votes
1answer
20 views

Percona startup fails: mysql can't access directory for file creation

I found a few questions and suggestions for similiar problem, unfortunately nothing seems to work for me, so please excuse me if this is double (and point to right source)... Server is Fedora Beefy ...
0
votes
2answers
26 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
54 views

Connecting to MYSQL on an EC2 instance [migrated]

I'm trying to use Zapier to connect to our MySQL database in order to add results from forms (hosting with WordPress) directly into our internal database. The database is working properly and so are ...
0
votes
0answers
25 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
14 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
56 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
55 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
1answer
62 views

MySQL 5.6.17 running out of memory when opening table with many partitions [closed]

We are currently setting up a MySQL database (version 5.6.17) on an Amazon db.m1.large RDS instance for storing time series data. Each time series property of an object is stored in a separate InnoDB ...
0
votes
2answers
72 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
33 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
30 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
43 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
54 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
21 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 ...
-2
votes
0answers
14 views

SQL query to get the details [migrated]

We have a database with machine details such as ID, Hostname, IP Address, OS, etc... ID IP Address Hostname Protocol NetMask 1 10.216.16.47 Test123 DNS 255.255.255.0 1 ...
0
votes
0answers
4 views

Why/when does creating a mysql trigger require SUPER privileges? [migrated]

I'm attempting to parse and understand what the MySQL doc says about when SUPER privileges are required for creating triggers. They say: If binary logging is enabled, CREATE TRIGGER might require ...
0
votes
0answers
24 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
29 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
105 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
26 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
310 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
41 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
13 views

Openshift - Cannot connect to mysql with Java [migrated]

I am Harold and Im new in Openshift, Im using below code to connect to MySQL with java through example here https://www.openshift.com/forums/openshift/no-suitable-driver-found-error, Unfortunately, ...
0
votes
0answers
52 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
27 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
39 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
47 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
44 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
18 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
0answers
24 views

MySQL: Is it possible to run a search on a specific database for a specific string? [migrated]

I need to find a specific email address in a database. I don't know in which table the email is set so I'd like to run a search on the whole database. Is that possible? Thanks
1
vote
0answers
42 views

Godaddy “Lost connection to MySQL server during query” [closed]

I've got 4 queries that suddenly start timing out and nothing fixes it other than using another user or re-creating the one I use to connect to MySQL. Problem: Some queries get stuck at "Copying to ...
0
votes
2answers
73 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 ...