MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

2
votes
2answers
3k views

MySQL: how to enable Slow Query Log?

Can you give me an example on how to enable MySQL's slow query log? According to the doc: As of MySQL 5.1.29, use --slow_query_log[={0|1}] to enable or disable the slow query log, and ...
3
votes
3answers
107 views

MySQL connection works with localhost but not with 127.0.0.1

I have a pretty standard MySQL installation on Debian Wheezy (apt-get install mysql-server mysql-client) which I have done successfully lots of times before. When I try to connect via localhost, ...
1
vote
1answer
80 views

Server locale C vs en_US.UTF-8

I am considering to change all of my server locale to C by "export LC_ALL=C" Is it a common practice? I am thinking will there be any side effect on a LAMP server, or should I just leave as using ...
1
vote
1answer
678 views

Issue with aborted MySQL connections (error code: 4)

Some of the connections between my application server (Ubuntu, Apache, PHP) and my DB server (Ubuntu, MySQL) are failing with error code 4. According to the documentation error code 4 is: OS error ...
3
votes
2answers
2k views

Mysql Export current configuration to a file

We lost our my.cnf file and were wondering if there is a way to export a copy from the currently running mysql instance. Thanks!
2
votes
1answer
136 views

Zabbix: How do I configure a Trigger which will check if a specific value has been changed in the last 10 minutes?

I've been given the task to monitor a specific value in some MySQL server database, I need to raise a notification if the value has not been changed in the last 10 minutes. I've added to the ...
1
vote
2answers
118 views

Spammer spoofed localhost? Or server fail? How do I secure against this?

I noticed a spammer got through postgrey AND SpamAssassin, which was very strange. I examined /var/log/mail.log and saw some suspect lines: Log below, or on Pastebin: http://pastebin.com/k7sKnvGE ...
0
votes
1answer
41 views

MySql Replication Stored to Central Database

Hi I maybe looking with the wrong terminology. But i have a situation where i need to replicate / copy data to a centralized database. Shop1.dbshop - > Central.dbshop1 Shop2.dbshop - > ...
0
votes
2answers
82 views

Recieving a 500 Internal Server error after login success? [closed]

Having issues creating login for website: PHP: mysql_connect($db_host, $db_username, $db_password) or die(mysql_error()); mysql_select_db($db_database) or die(mysql_error()); ...
10
votes
3answers
17k views

Connecting to MySQL from PHP is extremely slow

I just did a fresh install of XAMPP. When first opening PHPMyAdmin I noticed it was extremely slow. It didn't make sense that on localhost it should take almost 5 seconds for every page to open. I ...
0
votes
1answer
54 views

Configuring MariaDB to log to mysql.log using rsyslog

I'm a little stumped - there is something obvious I'm missing here. Recently I made the switch from mySQL to mariaDB. Everything is working so far - except for the logging, as I realized today. All ...
0
votes
1answer
56 views

mysql can't use locks with log tables

When I run mysqlcheck command in Debian MySQL 5.1, I get the below messages: Debian:~# mysqlcheck --all-databases -u root -p Enter password: mysql.columns_priv OK ...
2
votes
3answers
1k views

Moving MySQL data to another directory

I'm trying to move data files of a MySQL installation to another place, but it won't work. When trying to start mysqld, I get this in /var/log/mysql/error.log: 110922 7:27:40 [Note] Plugin ...
0
votes
0answers
31 views

How to create a new MYSQL charset?

I am trying to configure roundcube webmail and I get the error "Can't initialize character set utf8 (path: /usr/share/mysql/charsets/))" I fixed this before on my website by adding ...
0
votes
1answer
54 views

MySQL not accepting password, responds with using password: NO

I'm telling mysql to prompt for a password but it won't acknowledge it: mysql -h xxxxxx.xxxxxx.us-east-1.rds.amazonaws.com -P 3306 -u root –p response: Access denied for user 'root@%'@'10.10.1.1' ...
-1
votes
2answers
241 views

install mysql on centos7 with RPM

When I try to install mysql via the rpm: wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL- 5.6.19-1.linux_glibc2.5.x86_64.rpm-bundle.tar tar xf ...
0
votes
2answers
3k views

Restore MySQL database dump on Windows machine using command line

I have mysql installed on my machine, and I have an empty database my_database. I'd like to restore a database dump, originally from my shared server, into this empty database. The database dump is ...
3
votes
1answer
154 views

Latency & speed considerations between 2 servers on Amazon EC2

I'm setting up a system that consists of: 2-4 database servers 2-4 webservers (running Node.js) The webservers use the database servers heavily. Aside from connecting to the private IPs of the ...
1
vote
1answer
60 views

MySQL service won't start, Error 5

The MySQL56 service will not start giving me the error: Windows could not start the MySQL56 service on Local Computer. Error 5: Access is denied. The last time I was able to get into MySQL was the ...
0
votes
2answers
60 views

What is the best/most secure way to download/send/keep offline backups?

I have a small app that uses MySQL. I'm on a small Ubuntu box using Apache on Digital Ocean. In case anything ever goes wrong, I would like to have something that periodically sends me or downloads in ...
-1
votes
2answers
32 views

Why can't I add / change permissions for mysql

Every time I try and add a permission I get the following error: ERROR 2013 (HY000): Lost connection to MySQL server during query This happens using mysql in the terminal and through PhpMyAdmin ...
0
votes
1answer
38 views

Mysql database restore

My mysql backup is running everyday at 4 am & accidently my database got corrupted at 7am. Now how to restore data updated between time period of 4am & 7am
-1
votes
0answers
25 views

Mysql fresh install access denied [duplicate]

After having a similar issue with an old install, I just installed MySQL freshly (on CentOS 6.5) and ran mysql_install_db. I am trying now to set the root password using mysqladmin. However, I get ...
0
votes
1answer
27 views

Tons of apache processes running on a very low traffic development server

I have a development server that is having memory problems. There is little to no traffic on this server because it is a dev environment, but apache is spawning tons of processes and using up a lot of ...
1
vote
1answer
43 views

Finding and removing old mysql-bin files

I am running a MySQL server on Windows 8. The MySQL directory requires 118 GB of space and has a lot of 1 GB mysql-bin files that haven't been modified for years according to the file system. All of ...
14
votes
3answers
877 views

MySQL Error: (2003, “Can't connect to MySQL server on '2001:db8:81:2c::2' (-9)”)

I'm trying to set up Zenoss 4.2.0 on CentOS 6.3 to monitor a remote MySQL 5.5.25a server via IPv6. The firewall is open for the monitoring server and I can connect fine from the command line: ...
10
votes
3answers
12k views

Can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied for 'cond_instances'

I am having trouble running mysqldump as the mysql root user. When I try to backup the mysql table I get this error: mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user ...
-1
votes
2answers
80 views

CENTOS Vs Windows 2008 R2

We have an application running on Windows Server 2008 R2 with Apache WAMP, Tomcat, Mysql, PHP and java SE for last 4 years. Its a Web based ERP application. I would like to know if it makes sense to ...
0
votes
1answer
31 views

debug mysql crash

I have a production server which I am managing and I have been running a rails application on this server. The issue has happened twice in the past month or so and I am not sure how to debug this. ...
11
votes
4answers
23k views

Unknown/unsupported storage engine: InnoDB | MySQL Ubuntu

I recently upgraded from the previous LTS Ubuntu to Precise and now mysql refuses to start. It complains of the following when I attempt to start it: ╰$ sudo service mysql restart stop: Unknown ...
3
votes
2answers
168 views

Cannot Establish Remote Connection to MYSQL Database

want to access the MYSQL database remotely but when checking on yougetsignal(dot) com I get a message that port 3306 is closed. Configuration: Fresh Server (Centos 6.4 64 bit with Zpanel installed) ...
0
votes
1answer
46 views

Zenoss - install.sh doesnt ask for mysql password

i'm trying to install zenoss on a ubuntu-14.04 virtual machine. I followed the following guide "https://help.ubuntu.com/community/Zenoss". After some errors with dependencies, I have the following ...
-1
votes
1answer
34 views

Telnet to localhost 3306 looses connection to host after few seconds

When I try to telnet into my localhost port 3306 which belongs to mysql, it shows me the hello packet, then looses connection after a few seconds. My skip networking is set to OFF, I have started and ...
3
votes
1answer
741 views

Deleting MySQL rows causes lock table error

I had a couple million rows to delete but they can't be deleted at once without this error ERROR 1206 (HY000): The total number of locks exceeds the lock table size So I wrote a script to delete ...
-1
votes
2answers
49 views

how do I move where percona mysql stores the databases? [closed]

I'm running low on disk space and want to move my database's to a new disk (NAS). I have no clue how to do this. Any help is appreciated. I'm using Ubuntu 13.04 and the latest version of Percona ...
0
votes
0answers
52 views

How to correctly recompile PHP?

Using Ubuntu Server 14.04 x64 / PHP 5.5.9-1ubuntu4 (cli) w/ FPM / MySQL InnoDB version 5.5.35 Incredibly frustrated with what was supposed to be a minor issue. Basically, I'm being forced to ...
0
votes
2answers
44 views

Performance hit from moving DB to another drive symlink?

We're considering moving one database (there are 4 of them in total) with InnoDB tables, to a separate partition in a Ubuntu 14.04 VPS. This DB gets read/write intensive (500 writes per sec, about ...
-1
votes
0answers
19 views

Performance hit from moving DB to another drive symlink? [duplicate]

We're considering moving one database (there are 4 of them in total) with InnoDB tables, to a separate partition in a Ubuntu 14.04 VPS. This DB gets read/write intensive (500 writes per sec, about ...
1
vote
3answers
2k views

MySQL Startup Error - Root element missing

I have had MySQL installed for about 2 months on Windows Server 2003 R2. On start up we get presented with an error that says "High Severity Error - root element missing" followed by another high ...
4
votes
2answers
278 views

Aborted connection (Got an error reading communication packets)

The mysql error.log shows [Warning] Aborted connection 320935 to db: '...' user: '...' host: '...' (Got an error reading communication packets) While the client side get's: Lost connection to ...
1
vote
1answer
151 views

AWS RDS. Upgrade MySQL from 5.5 to 5.6, external replica and Access denied

I want to create external read replica for my RDS instance using this doc: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html My old instance is running ...
0
votes
1answer
491 views

Updating phpMyAdmin that works with MySQL 5.1.73

I have recently setup a Xen VPS hosting (CentOS 6/512MB RAM/20GB HDD) for my WordPress based website. My current phpMyAdmin version is 4.1.7 and the current MySQL version is 5.1.73. I wanted to ...
1
vote
2answers
136 views

php pdo connection cannot be established, but mysql command line client can

situation as follows: php script on server a, run by user 'web' (nginx + php-fpm) should access mysql on server b via pdo library, but gets SQLSTATE[HY000] [2003] Can't connect to MySQL server on ...
0
votes
1answer
28 views

Dovecot MySQL Authentication SlowDown

I have an IMAP/POP3/Webmail server with Dovecot1 2.2.10 with a MySQL backend located on another server. The server runs with default configuration. ... driver = mysql default_pass_scheme = plain ... ...
3
votes
4answers
3k views

how to know all users that can access certain database (mysql)?

how to know all users that can access certain database ?
2
votes
2answers
899 views

mysql-python with MySQL 5.6

I am having problems installing the mysql-python module in my server (CentOS 6.4 x86_64) with MySQL 5.6 installed and Python 2.6.6. [python@localhost ~]$ rpm -qa | grep SQL ...
1
vote
3answers
271 views

Changing the mysql bind-address within a script

What would be the best way to change the mysql bind-address in the my.cnf from a shell script? Is there a way using a tool like mysqladmin or should I use sed or should I simply append it to the ...
4
votes
6answers
14k views

How to undo DROP Table?

I accidentally dropped all tables. Can I restore back? I don't have the backup copy.
1
vote
3answers
114 views

localhost webserver vs separate server for small office [duplicate]

We have a small office (4 people at the moment) and work exclusively with healthcare data (HIPAA protected). For the past 2 years we've been storing all client data on a mysql database on my local ...
0
votes
0answers
69 views

Error: Trying to add tablespace 57 to the tablespace memory_cache

I was wondering if you could help me out repairing a Mysql database: InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Error: trying to add ...