MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
2answers
64 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
40 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
29 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
115 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
95 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
37 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
69 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
46 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
46 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
1answer
47 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
15 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
92 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
106 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 ...
0
votes
1answer
24 views

mysqldump without SQL_BIG_SELECTS

Trying to dump all databases for replication creation using mysqldump --all-databases --master-data --single-transaction > all_databases.sql Results in the following error mysqldump: ...
0
votes
0answers
52 views

MySql server keep crashing inside docker

I am running mysql inside docker with its /var/lib/mysql mounted on HOST. Eveything was working fine . Then i upgraded the docker from 1.4 to 1.5 . I rebuild the mysql image and but /var/lib/mysql ...
0
votes
1answer
114 views

CentOS 7 : cannot create mysql.sock

I've installed MySQL on CentOS 7. It looks fine, start mysqld service and change root password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ...
2
votes
1answer
67 views

Sending Data extremely slow or RDS

I have the following two profiles for a basic SELECT STATEMENT: select count(*) from mturk_completion; Here are the two profiles: # My Local machine, using a local db Status ...
0
votes
0answers
42 views

Yet another “Can't connect to local MySQL server through socket” after a security update

SOLVED As yoonix pointed out, it was only an issue with the root partition being full... Thanks for your help! - So yes, this question has been asked several times, here and elsewhere. I apologize ...
0
votes
1answer
97 views

MariaDB Galera SST Fails

I am running a 3 node MariaDB 10 Galera Cluster on CentOS 6. I have use this set-up before without issue else where but now when adding a 3rd node the SST fails with this error in the logs: 150212 ...
0
votes
0answers
26 views

Django/Tastypie: RDS is damn slow compared to EC2-MySQL

Initially my setup was: EC2 (Apache -> Django -> Tastypie) -> MySQL on EC2 itself. One of our API (Tastypie) does almost 80 SQL SELECT queries to fetch related resources and attributes. For local ...
1
vote
1answer
29 views

Debugging a mysql connection

I am trying to figure out how to diagnose a mysql connection issue. When I run a group of queries locally on my machine it takes about 1s to run. When I run that same group of queries on an AWS ...
0
votes
1answer
74 views

MySQL crashing at service start. Hit a bug? DB corruption?

I've a web server that's offline at this moment because MySQL fails to start with an exception. I can't find the root cause of the problem, but I'm afraid of database corruption crashing the MySQL ...
1
vote
1answer
37 views

Why can't I connect to my remote MySQL Server?

I have a asterisk server that is set up in on a VPS provider. I need one of my local applications to connect to the database to pull reports, but I am having dificulty getting a read only connection ...
1
vote
1answer
59 views

MySQL 5.6 replicate live master WITHOUT down time

Following the steps to replicate an existing server, it seems most methods rely on the ability to either completely stop the master server or at least prevent it from writing using flush tables with ...
1
vote
1answer
410 views

mysql-apt-config takes a verry long time to install on Ubuntu 14.04.1

i'm trying to upgrade mysql from 5.6 to 5.7 using mysql-apt-config. i've downloaded the deb and trying to install it. but it 'hangs' on Setting up mysql-apt-config (0.3.2-1ubuntu14.04) ... and ...
1
vote
1answer
51 views

Catch 22 on moving from old-style passwords and mysql_upgrade [duplicate]

I have an ancient MySQL database that I've kept running for a very long time, probably about 14 years. Apparently, I'd missed to run mysql_upgrade on it long ago, perhaps during the upgrade from 4.x ...
-5
votes
1answer
34 views

Is running MySQL on a separate server on LAN is any slower then running MySQL server locally? [closed]

I wonder if there is any significant speed difference because of network latency when: running Apache + PHP against a MySQL server that runs locally running Apache + PHP against a MySQL server that ...
1
vote
0answers
25 views

mysql service status doesn't show started when it is started by monit

I installed monit on my Ubuntu 14.04 server and configured it to monitor mysql with the below config in monitrc. check process mysqld with pidfile /var/run/mysqld/mysqld.pid start program = ...
-1
votes
1answer
66 views

MySQL on iscsi drive CentOS7 wont start on boot

I configured Mariadb on CentOS 7 to run on iscsi drive mounted on /mnt/iscsi, but it wont start on boot with following error (it can be started manually): mariadb.service - MariaDB database server ...
0
votes
1answer
34 views

FTP and WWW services don't acknowledge connections

I have Lubuntu 14.04 LTS with vsftpd and the lamp stack (apache2, etc.) installed. Everything works fine on the LAN. Externally, the services don't acknowledge connection attempts. I can see packets ...
0
votes
0answers
18 views

Sysbench MySQL cannot cannoect

I have created a user named sbtest, with no password, with all rights on sbtest, and the following error occurs. What am I doing wrong? $ sysbench --test=oltp run --debug sysbench 0.4.12: ...
2
votes
2answers
120 views

Hide list of MySQL databases [duplicate]

I'm trying to configure MySQL 5.1 on CentOS 6.6 in such a way that users will not be able to see databases to which they do not have any privileges. If they execute the command [SHOW DATABASES] it ...
1
vote
1answer
76 views

Can't grant MySQL privileges to Debian system maintenance user

I have a dedicated Debian 7 server running multiple websites with MySQL as the database server. When I tried to install the latest updates, MySQL couldn't be updated because the server failed to stop. ...
0
votes
0answers
52 views

Wordpress on Apache - Pageload Increased up to 30 Sec. - How to Debug?

I running a Wordpress Theme on a Google Compute Engine with Cloud SQL and Apache2 (W3 Total Cache which is off at the Moment). Actually no Visitors than me because it´s in development. The Problem ...
0
votes
0answers
49 views

COLLATION 'utf8_swedish_ci' is not valid for CHARACTER SET 'latin1'

When I try running the following full text search query SELECT * FROM Organizations WHERE (MATCH (name1) AGAINST ('."skå".') COLLATE utf8_swedish_ci) I get the following error: Error Code: 1253. ...
0
votes
1answer
71 views

How to tune MariaDB/MySQL in a docker container?

I understand that it's easy to get a MariaDB docker container up and running, and using nsenter to edit config files is possible. But how can I tune the config files in this container, e.g. the ...
-1
votes
1answer
60 views

Load balancing not possible with Zend Framework due to MySQL Adapter Error

I recieve the following error message when I set up load balancing between two servers that are running the zendframework called "SocialEngine" As it looks there is a problem that I can't connect ...
0
votes
1answer
89 views

Apache2 Serverload / CPU increase from 1% up to 90% - How to debug?

I´m using: Google Cloud Compute Engine Linux Debian + Apache2 Google Cloud SQL Wordpress Yesterday my CPU started increasing from 1-5% to 80-90%. I was developing on a wordpress site as it ...
0
votes
1answer
67 views

Mysql replication lags

I am 2 slaves and 1 master on aws, 1 slave is already in sync with master but 2nd slave create huge slave lg behind, after investigation i found , this slave create numerous relay log in Kb's but ...
0
votes
2answers
100 views

Replication server crash - > 18:39:32 UTC - mysqld got signal 11

Below you can see the part of the log showing the crash. The replication server is 5.6 and the master 5.5 but this setup has worked with warnings for the last week or so. Now, after trying to change ...
1
vote
1answer
27 views

How do I know if Postfix has MySQL/PostgreSQL support?

I'm not sure if my Postfix installation has MySQL or PostgreSQL support. How do I find out?
1
vote
0answers
103 views

error creating database using ansible on centos 7

I am trying to install mysql AND setup database using ANSIBLE on CentOS7(i have no idea why every documention in the world now ONLY talks about Ubuntu and NO CentOS anymore...really SAD!) here is my ...
-1
votes
1answer
36 views

How to open a mysql port for 2 server connected in LAN

I have 2 servers connected togheter in LAN, and both on external network too. One eth0 and the other eth1 adapter. On both servers I've installed mysql. I'm able from both server to connect to their ...
0
votes
1answer
39 views

mysql my.cnf is empty with webmin [closed]

mysqltune said that I need to make some changes in the my.cnf file Variables to adjust: query_cache_size (>= 8M) tmp_table_size (> 16M) max_heap_table_size (> 16M) thread_cache_size (start ...
0
votes
0answers
38 views

Can't connect to MySQL server on '127.0.0.1' (110)

I'm randomly getting a 110 error when connecting to a local mysql instance ( -h 127.0.0.1 ). Checking perror I see that it's a timeout: # perror 110 OS error code 110: Connection timed out The ...
1
vote
1answer
34 views

Any way to import MySQL tables with indexes intact?

Currently our live database server does daily downloads of large data dumps (on the order of 10GB), imports them into MySQL, normalizes the data, and builds a number of indexes (full-text indexes ...
0
votes
0answers
36 views

PHP & MySQL config for IIS server under heavy load

I am running a PHP/MYSQL website on Windows Server 2012 using IIS 8. I had performance issues on my old server with the CPU spiking above 100% during peak times. So I've just upgraded my server to a ...
1
vote
1answer
61 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
33 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
70 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 ...