MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

1
vote
1answer
83 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
57 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
29 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
99 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
68 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 ...
0
votes
3answers
40 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
32 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
214 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
57 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
1answer
73 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
39 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
39 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
28 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
36 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
101 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
45 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
18 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
45 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
38 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
45 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
79 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
78 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
52 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
87 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
23 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
20 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
40 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
57 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
53 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
21 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
29 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
48 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
214 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
105 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
25 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
280 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
286 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
42 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
32 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
56 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
76 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 ...
0
votes
1answer
57 views

InnoDB “Table xx Is Full” during database alterations

I am running Percona Mysql Server 5.6.14-56 on CentOS 6.3 64bit. Server has plenty ram (96gb) and storage free. File system type: ext4 dev/sda6 ext4 1093623528 56576512 981494148 6% ...
1
vote
1answer
111 views

granting database permissions in mysql

I have a new mysql installation and am trying to create a separate user to have have access to their own database. mysqladmin -u root -p create people mysql> create user 'cgp'@'localhost' ...
0
votes
1answer
115 views

phpMyAdmin can't import file exported from command line [closed]

I have two web servers: a live server (Server A) and a development server (Server B). I am often required to export the entire database contents from B and import into A. This was previously done from ...
0
votes
1answer
134 views

Can't boot Mysql on Centos 7

I've installed mysql on Centos 7 (mysql-community-server) as root. The problem is that I can't start the daemon with "service mysqld start", It never return me to prompt and even if I try to use ...
-1
votes
2answers
95 views

Can't log into mysql server root user using password?

root@DS-S007:/etc/dspam# mysql -u root –ppassword ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) root@DS-S007:/etc/dspam# I clearly specified a password. Why ...
0
votes
2answers
66 views

Is it OK to have database name the same as user name in MySQL?

Many web services require a database and quite often that is MySQL. Typically, the installation instruction of the software tells you to create a database and a user with permission for that database. ...
0
votes
0answers
34 views

Mysql sed error

I upgraded mysql from 5.5 to 5.6 in Debian 7 Wheezy box via apt-get command and all seems fine, but when I restart mysql, I get: [info] Stopping MySQL Community Server 5.6.23. ...... [info] MySQL ...