MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

-1
votes
0answers
6 views

Application Instantiation Error: Could not connect to MySQL [on hold]

150129 6:33:39 InnoDB: 5.5.39 started; log sequence number 71735211 150129 6:33:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 150129 6:33:39 [Note] - '0.0.0.0' resolves to ...
1
vote
0answers
12 views

200 OK blank page setting up Wordpress on restore test VM

I'm testing a partial backup of a frankly rather outdated (legacy, what can you do?) CentOS/Apache/MySQL/PHP/Wordpress server by restoring to a VM with a fresh copy of the relevant packages. After ...
0
votes
0answers
14 views

pam_mysql missing in CentOS 7

So it looks like in Centos 7 the pam_mysql package has been removed from EPEL, but I'm still in need of this package do to my reliance on a remote mysql database used for vsftpd. I stumbled on a ...
-3
votes
1answer
29 views

bash script mysql reset pass

It seems that this code is not working I tried using it on my debian 7 machine and the password it gives me is wrong. # Please confirm that you want to reset the MySQL passwords CONFIRM="n" echo -n ...
0
votes
0answers
28 views

CentOS MySQL Problems

Im having trouble with MySQL on my centos5 server. When I try to connect to the server I receive the following message ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
0answers
21 views

Configure inbound email using postfix

Postfix logs show "unknown user" when I send what I would expect to be a local user. I have the users specified in a mysql database and postfix has been compiled with mysql support. Other variables ...
0
votes
0answers
15 views

MySQL suddenly 'crashed' but not stopped, mysqld_safe 100% cpu on CentOS 6

Suddenly, today i see the website down. Checking the cpu with "top" in command, i found the mysqld_Safe at the top using all of the cpu. After some google i found some different solutions, i made a ...
0
votes
1answer
22 views

Can't connect to local MySQL via TCP (Error 1045)

root@127.0.0.1 exists, but still can't connect to local MySQL. It looks like MySQL verifies hostname instead of lo ip(127.0.0.1). root@castle /v/l/mysql# mysql -u root Welcome to the MySQL monitor. ...
1
vote
1answer
38 views

Low load average, but high %user and %system cpu usage

Summed up question: Why do we see one set of servers perform significantly worse with the same database and workload as others? Symptoms other than longer execution time is low (near zero) load ...
0
votes
0answers
36 views

How to reduce Tomcat response time (OR increase throughput)?

I have Tomcat 8 and MySQL 5.6 running in 2 Azure virtual machines (8 cores and 28 GB RAM). My web application provides a REST API to insert several data fields into DB. The application uses a common ...
0
votes
0answers
9 views

Install latest mysql 5.6 update (update 19 to update 22) on Ubuntu 14.04

A while ago I installed Mysql 5.6.19 via "apt-get install mysql-server-5.6" on a Ubuntu 14.04 amd64 server, now I want to upgrade this Mysql 5.6.19 to the latest stable update (5.6.22). I can't do it ...
1
vote
0answers
20 views

Performance: Generating up to 2000 rows and email deliveries

I guess this belongs here better than in StackOverflow. I have the following scenario: Small database with users ( around 2000 only ) information, they participated in an event last year. This year ...
0
votes
1answer
23 views

'> instead of -> in mysql command line client?

Im using mac os terminal to insert data into the table of mysql database. I accidentally pressed something and instead of -> now i see '>. I have no idea what it means, what is it and how can i get ...
0
votes
1answer
30 views

MySQL replication or MySQL cluster?

Currently i'm running Rails 3 web application with MySQL on one first server and Rails API application on second server that connects to the MySQL database from first server. I'm not happy that API ...
0
votes
1answer
26 views

How to overwrite the database name set in the .sql file when importing

Well I have .sql files which create their own new database when importing because they CREATE DATABASE /*!32312 IF NOT EXISTS*/ `something` /*!40100 DEFAULT CHARACTER SET$ USE `something`; i'm ...
-4
votes
0answers
28 views

Need assistance on MySQL configuration [on hold]

We are currently using the latest version of MySQL, with recent traffic increase to our website its now taking down/lagging the server due to too many MySQL requests. We run a website on Wordpress. ...
0
votes
2answers
40 views

Yum: No package mysql-server available in Cent OS 7

I just installed Apache on my new Digital Ocean Cent OS 7 x64 server. When following Digital Ocean's tutorial, yum cannot install mysql-server. # yum install mysql mysql-server mysql-libs ...
2
votes
1answer
14 views

Splitting MySQL General Query Log by Clients

I would like to know a solution to splitting very large MySQL general query logs by specific clients that have accessed the server. Ideally a separate log will be created for each client. Thanks
0
votes
0answers
16 views

Can I get a running list of executed queries from mysql to trace problems?

This question was formerly: "Mysql replication logs are filling disk and halting server". However, I'm asking the community if there is a command line trace or live log that I could tail -f and see ...
1
vote
2answers
54 views

Getting no query results in email

This is the powershell script below. I am trying to export the query's results into email body. However, the email contains nothing except the table headers. Could anyone help out what could be wrong ...
-2
votes
0answers
17 views

INNODB failure in MYSQL

I had faced an issue in INNODB Engine, but it get solved, when added buffer memory in /etc/my.cnf file, but there happened an unusual thing that the .HTACCESS file of some domains get modified as the ...
0
votes
1answer
32 views

CRUD with MySQL Master-Slave Architecture

I have setup mysql master-slave replication with 1 master and 3 slaves. Now that I have finished setting up the architecture I am curious as to the best way to make my reads. I realize all writes, ...
1
vote
1answer
15 views

Size of MYI index smaller on slave server

I've recently altered a huge MyISAM table (80 million entries) by adding a new value in an enum field. After I did this I've checked the health of the table on 2 slave servers which are used to ...
-3
votes
0answers
38 views

mysqli phpmyadmin Seems to be something going on here [closed]

Oddly I can find no help with this issue. I have a developer here who wants to use phpmyadmin. So I set it up on our server and get some errrors. I updated everything I get some errors. I swear some, ...
0
votes
0answers
16 views

How to recover MySQL database on xampp/windows using ib/frm files? [migrated]

I'm using xampp on Windows 7. Couple of tables of my Wordpress database got corrupted. When I view the database in phpmyadmin, the tables have the message "in use". I tried ...
0
votes
1answer
19 views

What is safe way to stop mysql docker container?

I run mysql container using Docker. I start it with like sudo docker -d --name mysql -p 3306:3306 -v /var/lib/mysql:/var/lib/mysql mysql_image I suspect that stopping mysql by stopping docker is ...
-1
votes
2answers
57 views

Data lost in MySQL DB when roll back happened after system restart [closed]

Few days back due to electricity outage, client's system got restarted, resulted in DB rollback. But due to this roll back, we lost around 2k existing records from various tables.( which were already ...
0
votes
0answers
7 views

How to modify the below script to take tables and its sizes for a particular databse to send via mail to a recipient? [migrated]

SELECT top 10 t.NAME AS TableName, (SUM(a.total_pages) * 8)/1024.0/1024.0 AS TotalSpaceGB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN ...
1
vote
2answers
66 views

MySQL with bind-address - possible to create an ip exception?

If you set the bind-address to 127.0.0.1 in my.cnf is there any way to manually allow connections from a specific ip address? Mostly my database is accessed by the server it is hosted on, but I also ...
0
votes
0answers
14 views

Cisco CallManager AXL SQL Toolkit - Retrieve directory number and user ID

I have the below SQL query to retrieve the list of userid and their telephonenumber using Cisco CallManager AXL SQL Toolkit: sql query="select d.name as deviceName, e.userid, e.telephonenumber from ...
0
votes
0answers
15 views

Linked Server Mysql to SQL Server 2008 32-Bit

I have an SQL Server 2008 64 Bit and a Mysql-Server, and would like to use a Linked Server. However I need the 32-BIT Mysql ODBC Connector for an extern Application. When I would like to connect to ...
0
votes
0answers
5 views

How to report durations of 100+ queries in MySQL? [migrated]

I have list of 142 SQL queries in an .sql file. At the beginning of this file I put SET profiling = 1;. At the end SHOW PROFILES;. I execute it with: mysql -u root live_copy < ...
1
vote
0answers
30 views

Apache 2.4 prefork, MySQL 5.6 and 2GB RAM

I think I'm having problem setting up Apache24 correctly. Apache seems to taking up to much RAM, and I'm not sure how to configure it. The FreeBSD server is using 50% of it's swap space. We are ...
0
votes
0answers
23 views

Copy mysql frm files to new server

I've read different tutorials about how to restore mysql databases by the .frm files but I am not getting it done. What I did, I created a new database by phpmyadmin. Copied the old directory from ...
1
vote
0answers
33 views

MariaDB 5.5 on Slackware 14 need to change to new password format

Strangely, this worked fine for a while, but my computer rebooted recently and now my php apps won't work: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an ...
0
votes
0answers
24 views

Google Cloud SQL - Lost connection and Timeout errors

I keep getting the following errors when attempting a simple connection to a Google Cloud SQL database instance from a PHP script. Lost connection to MySQL server at 'reading initial communication ...
1
vote
1answer
30 views

why is my mysql-proxy always doing selects on master?

My selects are always going to master and if i stop master I got some 'Cannot connect, all backends are down.' [read_query] 89.216.31.228:64166 current backend = 0 client default db = nivo client ...
3
votes
1answer
27 views

Is it possible to install MySQL extensions on Amazon RDS?

We are about to migrate our existing system from local MySQL instances on the same EC2 to a proper remote Amazon-RDS. Unfortunately there is a functionality called Median that MySQL is missing. Our ...
-1
votes
0answers
8 views

Mariadb refusing to read values on the my.cnf file [migrated]

today i was optimizing my mariadb since my website was running too slow My machine is a Centos 7 , 4 gbs ram 3 cpu i runned a script called mysql_tuner.pl and the results were: -- MYSQL ...
0
votes
1answer
16 views

How do I find out when a MySQL root password was last changed?

I have looked for solutions to this. I am able to change it, but I need to find out when it was last done and preferably also seeing who was logged in when it was done. Need proof for a security ...
0
votes
0answers
14 views

Why has MariaDB created database directories with @ in?

A backup script on a Debian server looked at /var/lib/mysql/*/ to find local database names. Having recently installed Seafile, this no longer works because although the databases are called normal ...
-1
votes
0answers
18 views

Can't create thread to kill server (errno= 11)

I can't restart mysql service. I got the following error: [ERROR] Can't create thread to kill server (errno= 11) Any idea what causes the error? Im using CentOS 6.6.
-1
votes
0answers
30 views

Can not start mysql server

After some messing around with mysql files and removing a lot of them, I just installed mysql-server as follows: root@server:/var/lib/mysql# aptitude install mysql-server The following NEW packages ...
1
vote
1answer
39 views

How to remove MySQL from Ubuntu 14.04?

I tried to move my datadir on a working MySql install, which apparently I messed up. I have tried to uninstall / reinstall numerous times, only to get the same errors on reinstall. The ...
1
vote
1answer
53 views

ISPconfig / Dovecot - Mysql went down = Mails gone?

So im running ISPconfig with Dovecot as mail-server (storing mails via mysql). Yesterday i made some changes to the mysql-config. I wanted the server to answer also External Requests. The Problem ...
1
vote
0answers
21 views

enable logging of password-like patterns in mysql client history [migrated]

From MySQL 5.6.8 onwards, statements containing the pattern *PASSWORD* or *IDENTIFIED* are not logged in the mysql command line client history. I know I can add to this list with --histignore or ...
1
vote
0answers
15 views

Destination Host Unreachable and Communications link failure when I connect to MySQL database using D2RQ library

I have a question: I have a web service which runs on a virtual machine located on a remote server with Ubuntu 12.04 operating system. Now, I want to test this Web Service and I'm using this code ...
0
votes
0answers
28 views

Local MySQL connection using eth0 rather than lo loopback

We've installed MySQL 5.6.22 on RHEL6.6 and noticed terrible performance compared to a previous install on RHEL6.5 and MySQL 5.6.20 The main thing that we've noticed is that all the traffic appears ...
-2
votes
2answers
33 views

How to start mysql automatically if that stop for any reason? [closed]

I have a digitalocean ubuntu vps for development use only, But sometimes the mysql server stop working. As per my investigation I don't have enough memory to handle few laravel installation. As I use ...
-1
votes
0answers
28 views

mysqld is generating a lot of disk IO writes. How can I figure out why? [migrated]

I have a Ubuntu 14.04 server running half a dozen wordpress sites. Total traffic to the server is on the order of 30k page views a day. Over the past couple months, with page views and network ...