MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

-1
votes
1answer
65 views

MySQL gives error “SSL connection error: Unable to get private key”

I keep getting the errors "SSL connection error: Unable to get private key" when using mysql client. In order to get it to work, I have change the permission 444. However, I would like to lock it ...
-1
votes
2answers
32 views

How to avoid 'too many connection' error in MySQL

It often happens that when trying to load the data from the database i`m getting an exception 'To many connection'. I do not know the internal features of the database work, so i do not understand ...
0
votes
0answers
12 views

Can’t load file into MySQL, even though local_infile is set

I’m trying to import a file into a MySQL database. I’ve added local_infile to my my.cnf file, and restarted the mysql service. In my PHP script, if I run phpinfo() then I can see ...
1
vote
1answer
31 views

Is it possible to safely edit mysql-bin.index file while mysql server is running

I changed location of mysql bin-log files. I copied them so mysql started fine, because they where in both locations, but then removed them from old location. I forget about correcting the path in ...
0
votes
2answers
47 views

Dedicated server stalls at 80 req/s - is MaxRequestWorkers the cause?

I have a physical Ubuntu server (see some of the specs here), with Apache 2.4.7, PHP 5.5.9, mysql 14.14, mysqlite and Yii framework 1.16 installed. The server performs amazingly at first, but ...
0
votes
0answers
28 views

Cannot start mysql on vagrant CentOS machine

I am getting the following problem doing "vagrant up" ==> default: [2015-03-10T16:31:03-04:00] INFO: template[default :start /etc/init.d/mysql-default] mode changed to 755 ==> default: ...
0
votes
2answers
98 views

elasticsearch-river-jdbc inserting duplicate record in mysql db

Sorry I am newbie to Elasticsearch and I am using elasticsearch-river-jdbc to connect to myql database,everything is working fine except for the fact that everytime it run as per schedule its ...
1
vote
1answer
76 views

Server crashes with “huge task timeout”

First things first, I've read a lot about the "huge task timeout" kernel panic and know that this often happens if the server is out of resources. Error messages which appear only in the VNC console ...
-1
votes
1answer
54 views

Using multiple IPs on one machine for web and game server

We are looking to host a game server. The game we are going to be setting up a server for is subject to DDoS from other servers, players, etc. Many other server and administrators have pointed out ...
1
vote
1answer
27 views

How to implement table security without SUPER privilege?

A MAJOR provider of cloud-based MySQL does not grant the SUPER privilege to the master user. The provider is Amazon RDS, but my question isn't about Amazon RDS specifically, it's for the general case ...
1
vote
0answers
84 views

freebsd cannot start mysql for the first time

I am having the same issue as this person serverfault link but the solution completely does not work for me. I cannot start mysql5.5 for the very first time. At first start of mysql with cd ...
0
votes
1answer
13 views

innodb files in wrong directory

I have created a database called TEST with innodb tables. When I look in the /var/lib/mysql/TEST directory I see a .frm file for each table. However, there are no .ibd files in that directory. The ...
0
votes
0answers
53 views

Can't connect Windows Azure VM with MySQL On-premise

I have a VM on Windows Azure with Windows 2008 R2, and I'm trying to open a connection to an on-premise MySQL database hosted on another network. We cleared the VM's public IP (the one displayed on ...
-1
votes
2answers
24 views

MySQL configurations are not saved after restarting windows server machine

I have a PHP application hosted on a windows server 2008 R2 machine. I had a problem with strict mode in MySQL and solved it by disabling the strict mode using the following command set ...
0
votes
1answer
30 views

Will frequent insert make select queries slower with MySQL?

I have a table that's frequently written to. There is a crawler that keeps inserting new records. How will this affect the read performance of the same table in MySQL?
0
votes
2answers
108 views

How to let PHP connect to database by using UNIX socket (Joomla)

I'd like to have my PHP applications such as Joomla make use of the UNIX socket to connect to the local mysql database. I've already configured the php.ini with: mysqli.default_socket = ...
0
votes
0answers
39 views

EC2 instance can't connect to RDS

I have created an EC2 instance and an RDS instance. Using Ubuntu and MySQL, RDS instance is public and not A-Z. I have created a security group that allows 3306 from anywhere on both Ingoing and ...
0
votes
0answers
62 views

Is it better to store the MySQL database directory on a separate RAID 1 device?

We have a Linux server with a RAID 1 using two HDDs on which runs a Apache server managing multiple sites and some other services that interact intensively with the databases and produce massive ...
0
votes
0answers
30 views

MySQL Unable to cd to '/nonexistent'

After a server restart, our MySQL server completely broke. When trying to start Mysql with service mysql start we get the following: Unable to cd to '/nonexistent' ...... * MySQL Community Server ...
0
votes
1answer
31 views

Is there a way to find out why MySQL crashed or quit working?

I have MySQL running on an Ubuntu 12.04 web server. A basic LAMP stack. I just have a couple of small websites running. a WordPress site A SugarCRM app little apps here and there. Only 2 ...
0
votes
1answer
17 views

Microsoft Access Duplicates Auto Incremented MySQL Record When Info Identical

I've recently run into one of the most frustrating bugs I've seen with a Microsoft Access integration with MySQL. What happens is that if you type something in a record, and then quickly move to the ...
0
votes
0answers
35 views

Ubuntu MySQL won't start because disk is full, but it isn't

I've a Linode with Ubuntu (12.04.4 LTS) installed. The HDD is 200GB but when I log-in via SSH, it tells me this: Usage of /: 99.1% of 8.83GB MySQL fails to start because there is no free space... ...
0
votes
0answers
76 views

MySQL production server experiencing high traffic from debian-sys-maint user

I am running a MySQL server on Debian 7 in a production environment. I recently (more or less accidentally) took a look into the server stats that can be shown in phpMyAdmin. I saw that the MySQL ...
0
votes
1answer
39 views

Reducing the size of MyISAM table

I have a MyISAM table that currently contains about 54 million records and is 20 GB in size. Poor choices were made when this database was designed. I'm no DB pro but since this table is constantly ...
0
votes
0answers
16 views

VServer Apache: Is 5s page load normal for ~100 clients?

I administrate a virtual server with 16x Intel(R) Xeon(R) CPU E5-2680 v2 @ 2.80GHz with a shitload of 32GiB system memory. The server is used as a web server and has 100 to 150 users at rush hour. In ...
0
votes
0answers
31 views

Lot's of dealocks since migrating to galera cluster

I recently migrated from a 1 node MySQL server, to a 2 nodes mariadb Galera cluster. (I know, 2 nodes is not recommended). At first, I enabled writes to both of the nodes, but realized it increased ...
0
votes
0answers
33 views

Given: iptables entry in place; my.cnf properly set up; MySQL user & permissions properly set - but still cannot access MySQL remotely: Suggestions?

I would like to access MySQL remotely on an Amazon EC2 CentOS instance (I assume it is CentOS because I use yum to update installed applications and libraries). I believe that iptables is set ...
0
votes
0answers
32 views

Change timeout only for particular instance of mysqldump

I'm trying to make frequent backups of my DB. But the DB is large and dumping take several minutes; in order for it to not have an impact in the server's operations regarding disk usage, I lower its ...
0
votes
0answers
69 views

MySQL/Percona Server sudden CPU usage spikes

I've got some trouble with Percona Server 5.5: suddenly abnormous MySQL CPU usage caused the system to become unresponsive as it was eating up all CPU with a large number of threads. It's a 24 core ...
0
votes
1answer
66 views

unable to login remotely in MYSQL

I am very new to mysql and I want to use remote login I followed this stack process but the command gives me nothing on the screen as listed on that link $ lsof -i -P | grep :3306 $ this is the ...
0
votes
0answers
6 views

Couldn't connect to MySQL remotly without skip-grant-tables option [duplicate]

I trying to connect to MySQL remotely over a Win Server 2012 EC2 instance, to do so I'd: Enabled inbound traffic to MySQL port 3306 in the EC2 Security Group; Disabled Windows Firewall service. ...
-2
votes
1answer
37 views

Import MySQL Database : No such file or directory

Im am trying to get the following script to import a database. Every time I run the script I get a mysql -u username -pmypassword my_database < /var/hostdata/databases/my_database.sql -bash: ...
0
votes
1answer
57 views

Can't add Nodes to Percona XtraDB cluster

In my case, I have two nodes in cluster, but when I use $service mysql bootstrap-pxc to start XtraDB cluster, I found nodes were not added to cluster. I also check /var/log/mysql/error.log, but no ...
0
votes
1answer
22 views

mysql tunnel restrict server login

We currently only allow external mysql access by using ssh tunnels (with a variety of read only/write/admin users) with each end-user having a different user login on the server. Is it possible to ...
-1
votes
1answer
19 views

Run two mysql process on one data directory

I would like to launch two mysql process on one data directory (/var/lib/mysql) I have two servers, web-01 and web-02 but web-01 locked mysql data directory, and i would like to break this security. ...
0
votes
0answers
27 views

MySQL binary log location Windows 2008 Server

I'm running a Windows 2008 Server with IIS, PHP and MySQL. MySQL is installed as a service. There's software on the server that uses a database that I need good backups of, including transaction ...
0
votes
1answer
42 views

cronjob executing mysql and get root access denied

cron job file: 46 13 * * * root /home/tmp/test_mysql.sh script: execute_query(){ query="$1" res=`mysql --skip-column-names -e "$query"` echo "$res" } res=`execute_query "show ...
0
votes
1answer
39 views

MySQL spends too much time cleaning tmp tables

I'm running some Django migrations on an AWS RDS MySQL instance. My team has tested the migrations very thoroughly and they ran fine (even taking less than 30 minutes when run on our laptops against a ...
0
votes
1answer
18 views

Linked MySQL Server Hanging on Insert

I'm running a task every 5 minutes on MS SQL Server 2008 that links to MySQL on another server in the network. It works probably 80% of the time. The remaining 20% results in MySQL hanging, and a ...
0
votes
1answer
28 views

Where do you edit the MySQL config?

Hi I am looking to change the minimum amount of characters MySQL needs to do a full text search and I can't seem to find that file. The code I am looking to paste in is ft_min_word_len=3 What file do ...
0
votes
0answers
29 views

Percona xtradb cluster MASTER MASTER asynchronously

I have setup a percona master-master cluster the same way as detailed here: http://www.percona.com/doc/percona-xtradb-cluster/5.5/features/multimaster-replication.html The document doesn't say but I ...
0
votes
1answer
134 views

MySQL in CentOS can't start service

after I reboot my server, I can't start mysql: $ sudo service mysql start $ Starting MySQL. ERROR! Manager of pid-file quit without updating file. "/var/log/mysqld.log" shows: 150225 21:39:49 ...
1
vote
1answer
73 views

Special characters in mysql password using mysqldump

I have the following ssh script: #Here I am getting the mysql password for the root user password=$(cat /root/.my.cnf | grep "password" | awk -F\" '{print $2}') #here I am trying to dump the ...
0
votes
1answer
24 views

http requests working on KVM virtual machine, mysql not?

I have an Ubuntu server with KVM virtual machines. I allowed SSH in the firewall so I could access the host. Also I allowed incoming traffic that has state related, established. This is the full ...
1
vote
0answers
186 views

Mysqldump complains about chosen databases regardless of command line

Mysqldump complains about command line options I have never specified. I don't have shell aliases nor a custom .my.cnf file set. What am I doing wrong? Using the --database long option: $ mysqldump ...
-3
votes
1answer
202 views

Can't start MySQL on CentOS 7 [closed]

The system had MariaDB before which I couldn't start either. Now I deleted MariaDB and installed MySQL. $ mysql --version mysql Ver 14.14 Distrib 5.6.23, for Linux (x86_64) using EditLine wrapper ...
0
votes
0answers
40 views

Database import error with no reason

Can't import dump of bd because of error importing with no reason! CREATE TABLE IF NOT EXISTS `phpbb_acl_users` ( `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `forum_id` mediumint(8) ...
0
votes
1answer
28 views

Concurrent MySQL processes

I have a file, let's call it a.php, which executes a long cycle of iterations, each one of them makes some queries to the database. To complete the cycle, it takes quite some time (some hours). My ...
0
votes
1answer
42 views

Testing MySQL 32-bit ODBC connection via CMD

I'm going to make a batch script to do some basic troubleshooting. Among other things, I want to test 32-bit MySQL ODBC's for connectivity. This script will run locally on each workstation. There ...
0
votes
2answers
42 views

How to install only mysql client on solaris?

I have a mysql server already running on RHEL 5 server. I have other Solaris 10 and Solaris 11 machines (SPARC based T4-4 servers) which need to connect to the server. I downloaded a pkg ...