MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

1
vote
1answer
70 views

Identifying MySQL injection exploit [closed]

I know someone whose server with cPanel/WHM and phpBB 3.0.x was victimized by a MySQL injection attack against phpBB (or a plugin thereof). Certain information was leaked, but we do not know the ...
2
votes
1answer
45 views

Galera: Run slow ALTER without locking entire server

I have a 3-node galera cluster with a few hundred databases servicing various clients. I'm only using galera as an easy way to handle replication and fallover. I'm not actually using multiple masters ...
0
votes
0answers
82 views

Gitlab update from 7.2.0 centos(mysql) to 7.7.2 ubuntu(postgres), can't create ssh key, or new project

I had a CentOS server running gitlab 7.2.0, which uses mysql server. I updated to the omnibus version of 7.7.2 successfully porting the database from mysql to postgres using instructions found here ...
-2
votes
1answer
28 views

Set rules on exchange and save it to database [closed]

I wanna set exchange rules for my incomming backup mails. After receiving one message with "Backup Exec Alert: Job Success (Server: "SERVERNAME") (Job: "JOBNAME") " in the subject a script should be ...
0
votes
0answers
30 views

Application logs an INSERT into database but data is not there. Where to look for debug info?

I have a PHP shell application which essentially moves data from a MySQL table to a REMOTE MS SQL Server (2008 R2) server based on a number of business rules. This routine has been working flawlessly ...
1
vote
0answers
117 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 ...
-3
votes
1answer
64 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
47 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
105 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
77 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
133 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
148 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
68 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
23 views

Performance: Generating up to 2000 rows and email deliveries [closed]

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
24 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
110 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
35 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 ...
0
votes
2answers
794 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
23 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
36 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
87 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 ...
0
votes
1answer
59 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
21 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 ...
0
votes
1answer
99 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
131 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 ...
-1
votes
1answer
267 views

mysqltuner: Thread cache is disabled

Mysqltuner says " Thread cache is disabled" but according to my.cnf, it is not. Why is that? Here is the my.cnf content. [mysqld] log=/var/log/mysql.log datadir=/var/lib/mysql ...
1
vote
2answers
102 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
44 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
39 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 ...
1
vote
0answers
115 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 ...
1
vote
0answers
68 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
168 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
96 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
68 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 ...
0
votes
1answer
29 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
25 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
vote
1answer
123 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 ...
0
votes
1answer
95 views

ISPconfig / Dovecot - Mysql went down = Mails gone? [closed]

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
50 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
33 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
93 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 ...
0
votes
1answer
112 views

how to permanently increase innodb_buffer_pool_size on ubuntu

I have read lot of posts & manuals to try to find out how to increase memory in mysql 5.6 on Ubuntu, which say there are 3 methods: by editing innodb_buffer_pool_size in the my.cnf by command ...
0
votes
1answer
72 views

Two browser windows hitting same MySQL app, both can't run at the same time

I have a LAMP web application that has some pages that do quite a bit of processing and take a while to complete. Sometimes as the developer I like to do two things at once as I'm working on a ...
5
votes
1answer
699 views

Can I copy the entire /var/lib/mysql folder to a different server? (mysql vs mariadb, different versions)

I used to have a Linux system (LMDE) with MySQL. The system used innodb_file_per_table for most of the databases. (not sure about the version, whatever is the "latest" in LMDE) I am now on a new ...
-1
votes
2answers
131 views

Configure MySQL so it doesn't automatically change values in NOT NULL columns

Surprisingly (at least to me), the following queries will insert records. CREATE TABLE null_1 ( id INT NOT NULL, text1 VARCHAR(32) NOT NULL, text2 VARCHAR(32) NOT NULL DEFAULT 'foo' ); INSERT ...
0
votes
0answers
41 views

Database Organizational Structure, DB Groups

I'm setting up a web server where users can create their own databases. In order to prevent name clashing, I've typically seen hosting companies handle this by prefixing any DB name the user creates ...
3
votes
1answer
78 views

How can I drop a MySQL user whose username contains unprintable characters?

I have a user in MySQL 5.6 that was somehow created with a non-printable character in the username. How can I drop this user? mysql> select user,host from mysql.user where user like 'wiki%'; ...
0
votes
1answer
30 views

Force a connect to mysql

My Mysql server instance has crashed (I assume its been 10 hours and its not running) - I have tried show full processlist but the new connection can't connect. I've tried using mysqladmin and that ...
0
votes
1answer
39 views

Lowering MySQL Full Text Word Length

Hello I just installed MySQL 5.6 on my vps and I realized numbers were not searching in full text searches. Then I came across this article ...
-1
votes
1answer
38 views

MySQL recovery procedure [closed]

After the server die, I have "old" HD (it is external now) with sock file and data files in mysql directory. Where I should find information how to restore the data in fresh installed MySQL? What ...