MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
2answers
35 views

Cannot install mysql-devel on centos

Everytime I try to run sudo yum install mysql-devel I am met with the following error: Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package ...
0
votes
2answers
29 views

Allow mysql user to be used just by specified user

Currently any system user can run: systemuser$ mysql -u mysqluser -p (assuming he knows the password). Is there a way to deny mysql (cli) to use particular mysql user? eg. systemuser$ mysql ...
0
votes
1answer
59 views

MySql Membership provider - Missing or incorrect schema

We have an ASP.NET site running on IIS 7.5 with a MySQL database using the .net connector, the membership/role providers are set in the web.config correctly and they work - but only temporarily. ...
0
votes
1answer
32 views

Password less mysql access to specified user/script only

In addition to this question: Performing root mysql operations in bash scripts I'd like to ask how to limit/allow this action (performing root administrative actions): mysql --local-path=mypath -e ...
0
votes
0answers
10 views

Updating mysql trigger via information_schema — access denied? [migrated]

I have some wrong "definer"s for some triggers in MySQL (actually MariaDB). I figured the easiest way of correcting them would be some version of: use information_schema; update triggers set ...
0
votes
1answer
58 views

Apache can't connect to remote MySQL, but mysql command line from same server can

Symptoms: I am running CentOS 6. I can connect to the remote MySQL from the command line: mysql -h a.b.c.d -u user -p -D db. Laravel artisan commands run on the local command line can also connect: ...
0
votes
2answers
70 views

cent os fail to install mysql-devel [closed]

I want to install python-mysqldb. But it tells me that I must install mysql-devel first, and then I have this problem: [root@iamca yum.repos.d]# yum install mysql-devel Loaded plugins: fastestmirror, ...
0
votes
1answer
65 views

Postfix cannot authenticate against SASL

My system is Debian 7 aka Wheezy with postfix, courier, and mysql installed. Courier works well and if I issue testsaslauthd -u user@domain -p password -f /var/spool/postfix/var/run/saslauthd/mux -s ...
0
votes
0answers
14 views

Percona connectivity issue, user cannot connect?

I am trying to authenticate a user in percona but I am seeing the error message below each time I try... 2014-09-29 12:43:37 5028 [Warning] The plugin '0' used to authenticate user 'user@' is not ...
0
votes
0answers
33 views

How to restore a corrupted MySQL master database from a slave database?

I recently discovered that the master db in a setup I'm running became corrupted. The slave was getting all of the data correctly so I have a solid backup. What I'd like to do is use replication to ...
0
votes
0answers
64 views

OsTicket + IIS + mySQL + Extremely slow queries

Background: I am a .net developer, limited php coding knowledge Asking this question because I think it is a php/mysql/version/implementation issue, and not getting real information from the OSticket ...
0
votes
0answers
70 views

Mysql 5.6 not starting with init script (mysql pre-start process terminated with status 1), starts fine manually

I've been fighting with this all morning: On Ubuntu Utopic (same on trusty, upgraded just in case), when I run sudo service mysql start, or sudo start mysql, I get the single error: "mysql pre-start ...
-1
votes
0answers
26 views

Mysql Server Crashing Regularly [migrated]

Error Log : MYSQLD log 140925 20:47:19 mysqld_safe Number of processes running now: 0 140925 20:47:19 mysqld_safe mysqld restarted 140925 20:47:26 InnoDB: Initializing buffer pool, size = 56.0M ...
-3
votes
1answer
41 views

Urgent need of help - I changed unsafe inodb_log_file_size mysql parameter and now fails to start

I made a mistake and changed the inodb_log_file_size parameter value in my.cnf without shutting down the mysql first and moving the ib_logfile0 and ib_logfile1 out of directory. Now it fails to start, ...
1
vote
1answer
43 views

MySQL server hangs without reason

I have a server running web site with back-end database MySQL (more specific - 5.5.37-MariaDB, for debian-linux-gnu on x86_64). Sometimes it stops accepting connections and web site scripts report ...
0
votes
1answer
25 views

MySQL via SSL on VPC private subnet

Is an SSL connection recommended when connecting to a MySQL database server via a private subnet? SSL provides encryption but SSL causes a performance hit. The MySQL database server only serves ...
0
votes
2answers
54 views

MySQLD is using 175% of the cpu

On one of the servers, I have mysqld running as slave DB. The CPU usage is 175% at the moment used by mysqld. Here are the results of SHOW PROCESSLIST; ...
0
votes
1answer
71 views

Lost connection to MySQL server during query (5.6.20)

I have a brand new install of MySQL 5.6.20 and now get these messages from my front-end when I am loading up the new database. [Err] 2013 - Lost connection to MySQL server during query [Err] Alter ...
0
votes
0answers
13 views

Querying node information from Foreman is very slow and I'd like to optimize it

I'm trying to set up Rundeck to query Foreman for node information. For example, the curl query: curl -k -u rundeckuser:rundeckpassword "https://foreman/hosts?rundeck=true&format=yaml" takes ...
2
votes
1answer
59 views

Performing root mysql operations in bash scripts

What is a good practice to execute root operations on mysql databases in bash scripts? For example, I want to create new database and grant privileges, I have to use: mysql -u $ROOT -p"$ROOTPASS" -e ...
1
vote
1answer
28 views

pure ftpd auth using crypt sha512

I've installed pure-ftpd-mysql and it works fine with md5 password hashing. This isn't very secure, so I'd like to use crypt with salted sha512, the way I'm using in dovecot. How to set up this in ...
0
votes
1answer
76 views

Wordpress and Apache crashing MySql (CLOSE_WAIT)

Last days mysql server on my vps start crashing, sometimes right after restart. I found that problem in wordpress website. After service mysql start many apache2 processes overload memory and cpu. ...
0
votes
0answers
17 views

Can an Amazon RDS instance serve as master for one schema and act as a read-only slave for another?

We have an Amazon RDS instance in production that caters to db requests for a set of tomcat servers. This is say schema1 on the RDS instance that is constantly accessed. Can we setup the same RDS ...
-1
votes
1answer
89 views

MariaDB 10.x on CentOS 7?

Why there is no MariaDB 10.x RPM for CentOS/RedHat 7? I'm trying to install the most recent stable version on my server, but it seems, that official repo is absent for so long since release. Why? ...
3
votes
1answer
31 views

MySQL keeps getting “connect” commands 100X per minute

My server was having performance issues, things loading slow, pages not loading, etc so I ran the "top" command after logging in via SSH. I noticed the CPU kept jolting up to 40%, on and off, when ...
0
votes
0answers
3 views

How to find non utf8 data in mysql [migrated]

Ok so I have a mysql database containing data that is input from various customers. The customers are told that their data should only be encoded as utf8 however I have become aware that this is ...
1
vote
0answers
38 views

Creating Event that execute at end of each month [migrated]

I need to create an event in mysql that runs at the end of every month 11 PM.I have tried creating an event that creates another events with code below: DELIMITER | CREATE EVENT ...
-2
votes
0answers
16 views

MySQL privileges not corresponding [closed]

I'm rather confused how MySQL privileges work. Here is the current setting: mysql> select host, user, select_priv, alter_priv from user; +-----------+-------+-------------+------------+ | host ...
0
votes
1answer
29 views

Insanely high mysqld write I/O on SELECT queries

I am struggling to find a reason for my mysql have this much of disk write, it just doesn't make any sense. It it doing mostly of the time SELECT queries, so the only reason I find to it write so much ...
0
votes
0answers
32 views

MySQL cluster data node restarts when its twin fails

Configuration: Server #1: 1 mgm node, 1 data node, 1 sql node Server #2: 1 mgm node, 1 data node, 1 sql node Specification: MySQL Cluster 7.3.6 x86_64 Debian 7.6 x86_64 It's been deployed by ...
0
votes
1answer
25 views

how to find cause of io spike

Everyday at around the same time, the IO usage on the server where our mysql slave goes up to 100%. I have setup a script that takes IO information every five minutes so I can find out why this ...
1
vote
1answer
76 views

MySQL error: “The partition with /var/lib/mysql is too full!” df -h shows otherwise

my rented server is currently saying that mysql is too full when trying to start it when using /etc/init.d/mysql start. However using sudo /etc/init.d/mysql start it works normally. Running df -h ...
-2
votes
1answer
22 views

Ubuntu server crashing frequently

i hope you can help me. i am running an ubuntu 12.04 server which i am using as a web/sql server. the server was running fine for month but now since two weeks the server is crashing almost every ...
0
votes
0answers
34 views

Never ending transaction problems after mysql 5.0->5.6 upgrade

I upgraded our entire backend mysql db from 5.0 to 5.6, including changing a few tables to innodb, and we've been having nothing but problems with never ending transactions since. I still have a ...
0
votes
1answer
39 views

My local MySQL server was temporary down for unknown reasons

My local MySQL server 5.5.38 (on CentOS 6.5) has been temporary down and the mysql log file was filled with this kind of details: This could be because you hit a bug. It is also possible that this ...
1
vote
0answers
21 views

Postrotate “error running shared script”

Morning all, I realise this question has been answered already but the fix does not seem to work in this case so I'm hoping you guys can help. This this is the error I'm getting: error: error ...
-2
votes
1answer
324 views

Can't connect to local MySQL server through socket '/var/mysql/mysql.sock [closed]

Recently, I've started getting this error when trying to login to mysql: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I read on another ...
-1
votes
1answer
150 views

my.cnf configuration in mysql 5.6.X [closed]

Server information 64GB RAM Intel(R) Core(TM) i7-3930K CPU @ 3.20GHz Mysql Server version: 5.6.20-log - MySQL Community Server (GPL) I have 20 websites on this server like share hosting my big ...
0
votes
3answers
81 views

Exim won't start - Error loading lookup module mysql.so

I had to change the root password for MySQL on a server. Exim also uses MySQL for users etc. I didn't think Exim/Dovecot used that password, but now things are not working well and I'm pretty sure ...
-2
votes
1answer
113 views

phpMyAdmin displays blank page

I have gone through all links related to a blank page displayed by phpMyAdmin but none of them helped my solve my issue. I have installed phpMyAdmin and deployed it on the Apache server. I have also ...
0
votes
1answer
62 views

Strange CPU spikes with MySQL

On my server (ubuntu 12.04) mysqld started to show some strange CPU spikes. I've logged some of it as a sample: http://pastebin.com/4MwKUVwL The value after the triple dash '---' is the cpu usage ...
0
votes
1answer
36 views

Production server (cluster) configuration

I have a problem, that i'd like to address to you. We are creating an webapp that shows infos and statistics. And we have a problem about how to 'do right' our server configuration The thing is that ...
2
votes
1answer
37 views

MySQL replication slowing master

We are currently running MySQL 5.1 Quick Overview We use 5 web servers ( Apache ) all connected to 1 DB server ( MySQL ) hosted on the cloud. The DB server running on the cloud ( Master ) ...
0
votes
1answer
52 views

RDS very slow and storage incosistencies [closed]

A couple of hours ago one of our AWS EC2 instances spike in CPU usage to 90 - 100%. That server, along with several other production servers, use one main RDS instance for the databases. All server ...
0
votes
1answer
45 views

New nagios/cacti monitoring setup, should I use a dedicated VM?

Currently we have 4 bare metal servers and one small VM server (all running centos6) and I'm looking at setting up monitoring for the Percona MySQL db server and replication slave (bare metal), as ...
0
votes
1answer
26 views

Is there any CLI tool to connect to MySQL server using a URL (mysql://xxx)?

I know how to use mysql -u username -pPASSWD -h hostname -P port databasename to connect but I need a tool that can use the RFC 1738 URL ...
0
votes
2answers
560 views

No mysqld or mysql.server after mariadb-server install

So... likely I'm an idiot, but I'm stuck. I just set up a CentOS 7 on Digial Ocean and I can't seem to get the MariaDB/MySQL server running. Some output [root@hostname ~]# yum list installed |grep ...
0
votes
0answers
21 views

Unable to access MySQL account on Win2008 R2 cluster

I have created a MySQL WFC service on my two-node server, the MySQL server is doing fine until I created an account using the MySQL Workbench of one of the nodes. When I try to connect to the server ...
-2
votes
2answers
96 views

Cannot start MySQL server following upgrade [closed]

Cannot start MySQL server following upgrade I've just upgraded MySQL from 5.1.59 to 5.6.20 (OSX 10.7) and now the MySQL server will not start. In MySQL Workbench (v6.1.7), in the startup/shutdown ...
1
vote
0answers
14 views

Auditing connections using certificates

We would like to have clients connect using client certificates from a trusted (internal) issuer and then log which user connected. Unfortunately, the following limitations are preventing success: ...