MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

2
votes
3answers
3k views

MySQL-5.5.10 - Lost connection to MySQL server during query (Both Web Clients and MySQL Slaves)

We've just upgraded our existing MySQL5.1 DB servers to newer (much better) hardware with MySQL 5.5, and things have been going mostly smoothly for almost 6 weeks. Just the last few days, I've ...
1
vote
2answers
3k views

Can't allocate nodeid for API

I'm running a pretty minimal MySQL cluster with configuration pretty much taken straight from the documentation. The data nodes are connecting fine, but the management server refuses to accept the ...
1
vote
1answer
1k views

MySQL Extremely High Disk Activity (Read Operations)

I have 1GB Linode VPS with a standard LAMP stack. Apache is tuned fine but for some reason MySQL's disk usage is high. This is causing really slow site load times. RAM and CPU usage are fine. Can ...
0
votes
0answers
26 views

MySQL's console client does not display non-latin symbols

I have installed mysql 5.6 on debian 7.10 from official mysql deb repository: deb http://repo.mysql.com/apt/debian/ wheezy mysql-5.6 So i have these packages installed: # dpkg -l | grep mysql | ...
1
vote
1answer
10 views

In MySQL, what do I put inside my.cnf so that all tables are UTF-8 that works with emojis by default?

I'd like every table and database (to be created) to be utf-8 that works with emojis. I understand that there are a few variables I need to define inside my.cnf: init_connect='SET ...
0
votes
1answer
11 views

Update mysql.user from non-root yet privileged account?

This question might sound silly, but I wanted to make absolutely certain before I carried this out on a production MySQL instance. Currently, I have a MySQL master->slave setup on a production ...
0
votes
1answer
8 views

MySQL slave becoming a replication master for additional slaves

I have MySQL servers A, B, C, and D. Server A is the MySQL master who receives the write traffic, and my applications look at B + C for reads (current slaves). I have replication forwarding ALL ...
4
votes
2answers
10k views

MySQL: Allow both remote AND local connections

In my Ubuntu's /etc/mysql/my.conf, I have: bind-address = 192.168.2.20 # My external IP It works fine from remote, but when I want to connect locally, the app that uses on MySQL says: java.net....
0
votes
0answers
3 views

MAMP Local Network Database Users [on hold]

I am hosting our local development environment database that is shared with team members over our local network. I had to create a new user for others to connect to the database remotely. It works ...
-1
votes
0answers
11 views

MySQL MyIsam delete takes too long? [on hold]

I have a MySQL database with aproximately 700 mil rows and I have made a delete with 2 conditions ( which should delete aproximately 600 mil from the table). The problem is that the delete is working ...
0
votes
1answer
22 views

MySQL behaviour and disk space handling after deletions and insertions with MyISAM

I have a question about the way MySQL with MyISAM engine handles the free/empty space after deletions and how it behaves when new records are inserted. For example, think about a new and empty DB (...
-1
votes
0answers
8 views

Icingaweb2 IDO db

enter image description here Hey everyone! As u can see on the picture, I got problems with logging in to the Mysql ido.I have already tried every password and combinations. regards
-1
votes
0answers
9 views

android using jdbc driver connecting to mysql server takes time sometimes works fine [on hold]

I have used JDBC driver for mysql connectivity in android . Sometimes it works fine but sometimes it takes too much time to connect. Is it because of jar file - (mysql-connector-java-5.1.35-bin) that ...
-1
votes
0answers
19 views

Reliable backup system with Ubuntu and ISP Config [on hold]

I'm new mounting servers and I have finally a functionally Ubuntu Web Server on EC2 Amazon AWS with: - ISPConfig - MySQL - Postfix - Bind - Amavisd-New - OpenDKIM Some domains are in Route 53 DNS ...
0
votes
1answer
16 views

How can I export a database from phpMyAdmin when the “Export” tab is missing?

My Webhost has disappeared, possibly because the company has gone out of business. I no longer have access to cloud-based backups which my host created on a daily basis, however I still have access to ...
3
votes
2answers
750 views

Store the MySQL client password, or setup password less authentication

I am using the mysql command line client and I do not want to need to provide the password every time I start the client. What are my options?
11
votes
5answers
14k views

Using mysqldump in cron job without root password

If I login with the root password on my box I can simply type mysqldump --all-databases and I will get th expected "Dump". I setup a job in cron.daily to run and dump this to a backup drive. The ...
8
votes
2answers
8k views

mysqldump prompting for password in shellscript

I wrote a simple shell script to dump a specific mysql database. problem is it is prompting me for a password even though I provide on. The mysql db is version 5.0.27 if that matters. Here is the ...
1
vote
2answers
116 views
+50

Postfix(admin), Dovecot, MySQL: Aliases not working

I'm able to send mail to the mailboxes i've setup with postfixadmin. This is working correctly and i can send and deliver mail on them. But now i'm in need of Aliases to work properly as well. I've ...
0
votes
0answers
15 views

Mysqld terminates, system low on memory

I've been getting this error repeatedly: "The process “mysqld” was terminated because the system is low on memory". I have a blog running on WordPress and a forum running on XenForo In the log, I ...
0
votes
1answer
18 views

cannot login to mysql root from vagrant, but can from sudo

I just reinstall mysql, which is now running 5.7.9. I'm using vagrant. I try to login to mysql with mysql -u root -proot and I get: ERROR 1698 (28000): Access denied for user 'root'@'localhost' I ...
0
votes
0answers
44 views

Laravel 5.2 deployment issue on EC2 Linux AMI

Environment health is OK (green check). I have setup my environment variables according to advice given here and here. I created a separete .env file for production environment, so it's all good on ...
0
votes
0answers
6 views

grafana / collectd Write Graphite plugin change timestamp

I am using collectd with write_graphite plugin to monitor mysql. I am using EDT on my server and when creating dashboards on grafana I can only use UTC/browser time. I want to know if there is an ...
0
votes
1answer
2k views

Apache not loading: libmysqlclient.so.18: file too short

I have installed MySQL and PHP, and I tried restarting apache and here what happens when I run # service httpd restart: Stopping httpd: [FAILED] ...
0
votes
0answers
6 views

Dovecot passdb fetch “unknown user”

I am using passdb backend for passdb { driver = sql args = /etc/dovecot/dovecot-sql.conf } userdb { driver = prefetch } Content of /etc/dovecot/dovecot-sql.conf password_query = \ SELECT ...
0
votes
0answers
11 views

MYSQL error: IP address could not be resolved

My website is hosted with Linode, I installed webmin on Ubuntu 14.04 to manage it. Recently my database server keeps shutting down, when I look at /var/log/mysql, there are several log files in there ...
2
votes
3answers
428 views

restoring myisam mysql db on a different machine

I have copied the web db directory(/var/lib/mysql/data/web/), when mysql is not running. I transferred this directory to another machine, where mysql is running. web db's stuff is myisam based. I am ...
0
votes
0answers
18 views

Having trouble connecting to mysql on Redhat

I'm having issues connecting to mysql on Redhat. The server is running Red Hat Enterprise Linux Server release 7.2, and the mysql server is rh-mysql56-mysqld systemctl start rh-mysql56-mysqld....
0
votes
1answer
21 views

MySQL won't allow login from normal user account

When connecting to MySQL as root from the linux user user user@computer:~/$ mysql -u root -p Enter password: ERROR 1698 (28000): Access denied for user 'root'@'localhost' When doing the same exact ...
17
votes
3answers
23k views

MySQL: creating a user that can connect from multiple hosts

I'm using MySQL and I need to create an account that can connect from either the localhost or from another server, i.e. 10.1.1.1. So I am doing: CREATE USER 'bob'@'localhost' IDENTIFIED BY '...
1
vote
2answers
547 views

Dynamic column enumeration for preventing SQL injection

I have an application which is completely for internal use but I'm trying to make sure I have my bases covered on SQL injection. Unless someone else has some information to point me otherwise there ...
13
votes
4answers
5k views

In Puppet, how would I secure a password variable (in this case a MySQL password)?

I am using Puppet to provision MySQL with a parameterised class: class mysql::server( $password ) { package { 'mysql-server': ensure => installed } package { 'mysql': ensure => ...
1
vote
2answers
2k views

How can I lower MySQL single-page reads?

My innodb buffer pool size is 8GB and my database is 6GB in size but I see this: Innodb_buffer_pool_reads 263.5k - The number of logical reads that InnoDB could not satisfy from buffer pool and had ...
-2
votes
0answers
21 views

Mysql script using lot of memory, connected with open port

I am facing problem by the php - mysql script that is connected to the server open port via xinetd. Php mysql script is a simple script that connects to server inserts the data and at the end it ...
0
votes
0answers
3 views

Setting sql_slave_skip_counter is not working on Percona 5.6.24 [migrated]

I am currently running a master - slave replication where on my slave there is an sql error due to which my replication was stopped. when I tried to run the following good old solution SHOW SLAVE ...
4
votes
2answers
396 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
86 views

How to Diagnose Random “Error establishing a database connection” with WordPress

I maintain a Linux VM in Azure which contains one MySQL instance and 8 databases within that instance. Each database is used by a WordPress front end also hosted in Azure App Services. When using my ...
0
votes
2answers
1k views

'PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

I'm getting 'PDO Connection Error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' error when I'm trying to make too much update and ...
16
votes
4answers
34k views

How to export result of a MySQL query using phpMyAdmin 3.4.3?

I've got a 30K row table When I run a long, 50-line query on that table, a GROUP function reduces the number of rows to 7K I want to export the grouped 7K rows as a new table, or save them as a CSV ...
0
votes
1answer
13 views

Setting group_concat_max_len in Sphinx config is not being applied

I ran into a problem whereby our Sphinx SQL queries are getting truncated. This was due to the default limit for the Group Concat function in MySQL being 1024 bytes. I used the following in my ...
0
votes
1answer
4k views

installing mysql5.6.12 in ubuntu 12.10 error:/etc/mysql/conf.d is missing

I am trying to install mysql in ubuntu 12.10. Downloaded 'MySQL-5.6.12-1.linux_glibc2.5.i386.rpm-bundle' from http://dev.mysql.com/downloads/mysql/. Extracted it and tried to install using rpm -i ...
0
votes
1answer
46 views

yum install error nothing to do (MYSQL, CentOS 7)

I'm trying to install MYSQL instead of MariaDB on my CentOS 7. I used this command: wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm yum install http://dev.mysql.com/get/mysql-...
0
votes
2answers
11k 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 ...
-1
votes
0answers
10 views

Switch to Redis or use Redis as cache for mySQL [closed]

I have been using mySQL to make an multi-platform application. I am looking upscale the app and so I am looking into noSQL alternatives. I have been getting the hang of Redis and I really like it. I ...
0
votes
1answer
33 views

How to avoid MySQL replication corruption while executing flush-logs command

I have three servers running MySQL, let's say A, B and C. Server A is the master, and server B is the slave. I want to do mysql replication between server A and B, at the same time, I also want to use ...
2
votes
1answer
34 views

MySQL SSL Connection

I'm trying set ssl connection with MySQL Server. I've read this and many more articles https://dev.mysql.com/doc/refman/5.7/en/using-secure-connections.html There is one thing i still don't know, ...
3
votes
3answers
19k views

How to sync two MySQL tables (on demand or via cron)

I have seen Cron sync mysql tables . But I cannot use replication. I used to use percona-toolkit and it worked perfectly. I could run the sync command on demand or just run it via cron. It would ...
1
vote
1answer
1k views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have MySQL installed on Ubuntu 11.10. I has been working fine for months but yesterday I started getting the following message ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
1answer
10 views

serverspec if statement for mysql version on server

Is there a way to check which package installed on server by command output? describe command('mysql -e "select version();"') do if its(:stdout) { should =~ /5.6.27-76.0-log/ } describe ...
0
votes
6answers
12k views

Can't connect to mysql server (13) using php function

I opened every links google results had thrown to me in regards to this MySQL error. I have been spending hours to get this to work.. I have a web server (apache in centos installed in host B, and ...