MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
4 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
22 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
0answers
20 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
5 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
12 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
15 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
18 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
17 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. ...
-1
votes
0answers
14 views

I get the error message of: #2054 - Connecting to 3.22, 3.23 & 4.0 servers is not supported [on hold]

I have installed and uninstalled almost all of the versions of phphmyadmin. I have also tried to uninstall and install xampp few times. Every time I try to connect, I get the below error messages: ...
0
votes
0answers
18 views

MySQL ALTER TABLE table_name AUTO_INCREMENT=1 doesn't work [migrated]

I'm using yii and it's test system. Yii's fixture manager resets tables and their AI keys so: DELETE FROM table_name; ALTER TABLE table_name AUTO_INCREMENT = 1; It was working good on server before ...
0
votes
0answers
9 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
22 views

MySQL server stops. Cant find the reason in log files

I am running a Debian ISPConfig MySQL Php Apache server for hosting a web application and some of my websites. I am using uptime robot for monitoring too. The MySQL server gets stopped at times. ...
0
votes
1answer
18 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
14 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
13 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
26 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
11 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
43 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
votes
0answers
4 views

How to find the unicode character of a particular tamil word in mysql [migrated]

I need to find the length of particular tamil word in the mysql database. I used the command SELECT LENGTH(phrase)as Len FROM table WHERE Condition; But i did not get the correct length.. What is ...
1
vote
1answer
29 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
15 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 ...
-4
votes
0answers
20 views

nginx Query Driven Content per Every Page and Angular.js Frontend [closed]

I was originally considering nginx for a new project hosted on a Linux box. Every page on the website will be primarily dynamic, derived from numerous database queries. Most every page will contain an ...
0
votes
1answer
34 views

Tools for scanning database for viruses [closed]

I wonder if anyone knows some useful tool for scanning threats like sqlinjection, command injection in mysql databases? The db is for multiple wordpress, drupal installations. The first step obviously ...
1
vote
0answers
34 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
71 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
34 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
15 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
0answers
11 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 ...
-1
votes
0answers
23 views

MySQL databases, phpMyAdmin, exporting and importing = CORRUPTED :(

I tried to export all of the MySQL databases using phpMyAdmin as an SQL file. After downloading it, I did an SCP of it to the new server which is a local to remote transfer. Now, when I am trying to ...
0
votes
1answer
21 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
20 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
31 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
34 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
59 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
55 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
56 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. ...
1
vote
0answers
32 views

PHP requests to insert to database are missing [closed]

i have this code in PHP that insert the data to DB 1 table, for example: The DB Table CREATE TABLE IF NOT EXISTS `thistable` ( `id` bigint(20) NOT NULL, `code` varchar(7) NOT NULL, `sku` ...
0
votes
0answers
19 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 ...
0
votes
2answers
101 views

How to troubleshoot high CPU usage on a server?

On my cloud server, the MySQL CPU usage jumps to over 100% on Sundays at 1PM GMT. How can I troubleshoot the cause of this? I have been told to run the cmd 'top' on the server but this only tells me ...
0
votes
3answers
69 views

MySQL “Duplicate entry” Errors on the Slave break replication all the time

I followed this tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql Unfortunately the replication stops on the slave all the time with: ...
1
vote
1answer
24 views

Mysql Undocumented Default Setting for sort_buffer_size in Options File

From a recent install of MySQL Workbench V. 6.2 (MySQL 5.6), while inspecting the options file (Edit > Preferences > General) I see that sort_buffer_size is set to 256k\n256k. What does the \n256k ...
0
votes
1answer
44 views

mysql innodb crash assertion

I've got some very big trouble with my innodb database since friday. The mysql server crashes whenever I do some operations on a specific table which is about 22GB. inserting data works, all other ...
0
votes
0answers
29 views

Trying to replicate a MySQL 5.6 master, the replication server crashes

We run a MySQL 5.6 server that acts as a replication master. Recently, due to some other bug in upgrading from 5.5 the replication seems out of sync so we're trying to create a new replication on a ...
1
vote
1answer
30 views

MySQL Server fail to restart after trying to import database from command line

My server is CentOS 6.5 64bit, running MySQL 5.5.42 community server by Remi. I tried to import a database from command line by running mysql -u root -p website_database < website_database.sql ...
0
votes
0answers
4 views

How to create insert procedure with input parameters in xampp ? and where it is located in PHPADMIN [migrated]

how to create insert procedure in mysql using XAMPP and where it will be located ? how to see my procedure in phpmyadmin ? here is the query delimiter // CREATE PROCEDURE reg_db ( uname ...
0
votes
1answer
45 views

localhost != localhost for MySQL/PHP

System: Mac OS X Server 10.6.latest I just switched from the ancient MySQL (<5?) that came with Mac OS X Server to MariaDB 10.1, installed via MacPorts. (That was a whole 'nuther barrel of fun...) ...
-1
votes
1answer
13 views

Is there any way to backup all mysqldatabses in single file

Usually i have cron job to dump separate databases in separate sql file and then i can restore it. Is there any way , any command so that i run as cron job everynight and i have single file which i ...
0
votes
1answer
64 views

why won't mysql accept connections from local programs?

I am getting a "Host 'mydomain.com' is not allowed to connect to this MariaDB server" error whenever a program on my CentOS 7 server tries to access the MySQL/MariaDB database located on the same ...
0
votes
1answer
60 views

Ubuntu apache process consuming 100% cpu PHP/MySQL app

I have a server at Rackspace connecting to a Cloud DB instance running MySQL. I'm not a server admin so I apologize for not having enough data. I'm having a hard time determining what is causing my ...
-1
votes
0answers
15 views

mysql return true when int = 1 [migrated]

this seems a simple question, but i cannot find the awnser. I want to save a true/false in my mySQL database. So i'm saving 1/0 in a INT column. When i select this i get the 1/0, but i want it to ...