MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
29 views

How to create MySQL user that doesn't require password under same linux user

I want to create a MySQL user called "vagrant" that under linux user "vagrant" does not require password, that has ALL PRIVILEGES. So I can execute something like the following command without failing ...
-3
votes
1answer
67 views

List MySQL database connections

Does anybody know how can I find a list of all users on all web servers who are using a Database connection? I tried to search through mysql and also through writing stored procedure , but nothing ...
-2
votes
1answer
34 views

Share the database with another person in same network [closed]

I am a newbie to the database topic. I need to create a database and share the database to another person in my office so the other person can also create/delete tables in the same database. I created ...
1
vote
0answers
17 views

Replication Setup what will be the value of MySQL auto_increment and offset in my.ini

I have setup master master mysql replication to sync changes in both server. But now I want to setup 6 server it is possible? I'm making 6 because when an area lost it connection over WAN it will ...
-3
votes
1answer
45 views

Edit MySQL my.cfn With phpMyAdmin [closed]

I want to edit my.cfn file. Can I do it with phpMyAdmin (Version 4.4.15) and where can I find this file?
0
votes
0answers
13 views

MySQL execute every query on a second server

I have a Web-application on a Linux Debian 8 Server saving in MySQL. I need a backup which is always the latest version(not even a minute behind) so the only way i could think off to archive this is ...
1
vote
2answers
194 views

Change MySQL root password with bash script

I'm attempting to create a bash script to change the MySQL root password, below is the current snippet of code I am working with: #!/bin/sh clear echo "Enter the current password for the root mysql ...
2
votes
0answers
43 views

Delay in starting Database services on Server 2012 R2

We have found in the past couple of days (unknown when this first appeared) that services for MYSQL and SQLAnywhere 16 are taking 20 minutes to start when a windows 2012 R2 server is rebooted. After ...
3
votes
1answer
158 views

Pages hanging on waiting for query, consuming memory and take 2 hours to fail

See attached picture of Fusion Reactor, showing pages that just keep on running. Times have gone up into the millions and I've left them to see if they'd complete but that was when there were just 2 ...
0
votes
0answers
17 views

Upgrade Artifactory with Mysql Storage defaults to derby

I've just upgraded Artifactory to version 4.1.3 and I followed the instructions here https://www.jfrog.com/confluence/display/RTF/Upgrading+Artifactory and then here ...
0
votes
0answers
117 views

Error enabling TokuDB - Percona Server not running with jemalloc enabled

I have installed: Ubuntu 14.04.3 LTS (GNU/Linux 3.13.0-63-generic x86_64) Percona Server 5.6.26-74.0-1.trusty Percona Server TokuDB 5.6.26-74.0-1.trusty libjemalloc1 3.6.0-2.trusty In ...
0
votes
1answer
95 views

zabbix user unable to execute sudo mysqladmin ping

I am trying to check whether MySql is up by using a UserParameter in zabbix. UserParameter looks like this. UserParameter=mysql.ping,sudo mysqladmin ping | grep -c alive | wc -l When I execute ...
0
votes
0answers
51 views

Adding to tar archive /var/lib/mysql is it enough for backup restore task?

In every docker project, I have a backup.sh and restore.sh file I want to find a good way for backing up and restoring mysql backup using only ./restore.sh ${timestamp} My backup.sh look like ...
0
votes
0answers
39 views

Need to do partial restore from a full xtrabackup

I'm using percona xtrabackup to do full DB backups on mariadb 10 and now i'm testing the restore. I want to restore just some databases (the important DBs) and ignore others (big archive DBs), ...
0
votes
0answers
25 views

mysql keeps lossing user permisions

We have a mysql database on ubuntu 14.04 server. It was working really fine for months until some weeks ago, when it started with this thing. It suddenly losses all user permisions and we have to set ...
-1
votes
1answer
65 views

mySQL keeps crashing with a specific Wordpress theme enabled

nice people ;) I have a problem with my server after I setup a new theme on one of my wordpress sites. At first mySQL started to crash once in a while, then it became more and more often and now you ...
0
votes
0answers
11 views

Workbench Connects/Auths to Database but Application Fails

Why can mySQL Workbench Connect to the database but my app can not using the same pc? I can connect to my database using mySQL Workbench and manipulate the data however my .NET app using the same ...
0
votes
0answers
8 views

Is it possible for an user to run a cluster job (PBS cluster, for instance) that keeps alive a connection to an external mysql server?

In the case it is not, which is correct way to address such dependency on a DBMS as a cluster admin? Is it necessary to resort to an internal database server somehow suitable to redirect the ...
0
votes
2answers
50 views

Start an uninstalled MySQL server

Our server just crashed after a 140 day uptime reboot (not booting). It was running Plesk and since it's hosted by Online.net, I'm able to run a recovery system and access my data. It was running a ...
0
votes
1answer
276 views

libmysqlclient.so.18: cannot open shared object file: No such file or directory

I am trying to launch a script off of server I have which is running 64 bit CentOS 7, however whenever I launch the script I am getting this error in the server log. Loaded log file: ...
0
votes
1answer
120 views

libnss-mysql gone in Jessie?

I was happily using libpam-ldap and libnss-mysql (authenticating clients directly against LDAP, with NSS data such as UID/GID/home dir kept in a mysql database). Now I tried to install Jessie on ...
-3
votes
1answer
60 views

Amazon EC2 vs Google App Engine [closed]

For a Vaadin App, that uses a MySQL database and must have lots of files uploaded, which cloud platform is better? Amazon EC2 or Google App Engine? Can I use phpmyadmin in both? Better in terms of: ...
0
votes
0answers
56 views

Error when connecting to a server with

I have a web server (RHEL 6.5) with not enough disk space for one of our user database, so his website (php/html/etc.) is on our server but his database (mysql) on his. He created the necessary ...
0
votes
1answer
96 views

Puppet doesn't configure MySQL

I have a following Puppet class using puppetlabs/mysql module: class hg_playground::makowals::brains::db { class { '::mysql::client': package_name => 'mariadb', } $override_options = { ...
0
votes
3answers
66 views

moving live innodb db from one server to another

I need to move an innodb db from one server to another - it is also going from mysql > mariadb. I want to ensure there are no problems at all and with that I will be using mysqldump to export and ...
1
vote
1answer
18 views

Change MySQL “lob_bin_trust” variable definitely

I've seen this topic earlier, but it doesn't fit in my needs. Is there anyway to set variable "log_bin_trust_function_creators" definitely in my system, except specifying it on mysql initiation ...
0
votes
0answers
44 views

Debugging Ansible's support for compressed database imports?

The documentation for Ansible's mysql_db module says, "Uncompressed SQL files (.sql) as well as bzip2 (.bz2), gzip (.gz) and xz compressed files are supported." However, when I try to import a .gz ...
0
votes
0answers
21 views

MySQL mysqld error --wait_timeout requires an argument

I simply wanted to restart my MySQL server (MariaDB) and it failed. It runs on Ubuntu 14.04. So I went to the error log and saw this: [ERROR] /usr/sbin/mysqld: option '--wait_timeout' requires an ...
1
vote
1answer
249 views

Error updating mysql with apt-get (Debian)

I'm running a Debian 7 (wheezy) machine and I was doing my normal package updates with apt-get update && apt-get upgrade and everything seemed to have updated alright except for mysql server. ...
1
vote
1answer
90 views

Syslog-ng with mysql destination - increase log retention

I have this dusty syslog-ng 3.1.3 that writes to a database and all is working well however it seems to keep only 30 days of logs (last table is logs20150826) How can I increase that? I see nothing ...
-1
votes
1answer
32 views

Server performance abysmal, should mysql have many instances running?

Mysql appears to be sucking a good chunk of memory up. Should mysql be running so many instances? I've considered upgrading the server's memory (because it's maxed) but I'm concerned there is a ...
0
votes
3answers
47 views

How to find a word in SQL? [closed]

Lets say you are filtering on rows in a column that contains the word Engineer in a phrase. How can I exclude words like 'Engineering' or 'Engineered' or 'Engineers' when I wouldn't know all the ...
2
votes
1answer
85 views

Facing hacking activities on my server [duplicate]

I have recently switched my hosting server to AWS. and in initial all was working fine but recently I am facing issues with my server that its get down several time. I have monitor it closely and get ...
1
vote
0answers
33 views

mysql-cli - force quit on timeout / connection drop

I have set timeouts in /etc/profile.d/ to disconnect inactive users using TMOUT and this works great however now I am seeing users just holding their connection open by keeping some foreground process ...
0
votes
1answer
204 views

Connecting To Remote MySQL Server - Connection Refused

So, I have a problem in trying to talk to a remote MySQL server, which is on a Digital Ocean host (Ubuntu). My other host is on IPOWER, but their SQL capabilities are not so great so I wanted my PHP ...
0
votes
1answer
172 views

tcp_tw_reuse and tcp_tw_recycle not working in specific environment

We are running HAProxy to direct mysql traffic from PHP to a set of mysql servers. However, due to an issue with the way the mysql-client sends TCP packets, we get a ton of connections in TIME_WAIT ...
2
votes
1answer
59 views

How to secure the db dump taken from daily run script

In one of my mysql slave servers I have written a daily run script, which 1) stops slave, 2) takes a db dump, 3) starts slave again, 4) encrypts it, 5) copies it to my s3-bucket. I am using aws-cli ...
0
votes
1answer
25 views

Nginx Passenger MySQL connects only locally

Fresh server, installed using the digital ocean guide here. Ubuntu 14.04 Passenger 5.0.18 Nginx 1.8.0 I can deploy my app to the server via capistrano no problem. I can also load the rails console ...
0
votes
2answers
253 views

MySQL master-slave replication not updating

This is my first time setting up master-slave replication. I am using this as a guide. I followed the steps and all works till the last part when i need to verify the replication. When i create a new ...
-2
votes
1answer
81 views

MariaDB will not start on reboot after changing data directory

I'm running a local vagrant setup with Centos 7. I recently changed the data directory to persist data across destroys of the box. However, now MariaDB will not start on reboot. My setup is as ...
0
votes
1answer
166 views

phpmyadmin fails to load “PHP message: PHP Fatal error: Class 'PMA_Message' not found in /usr/share/phpMyAdmin/libraries/Message.class.php”

After upgrading some of the php libraries on our server phpmyadmin failed to load. I see the following error on my web browser when trying to access browser phpMyAdmin - Error Cannot start session ...
0
votes
0answers
21 views

mysql connect fails with CA specified

I used to run a service, which accesses mysql by certificate and key, but without password. Now my root cert was expired, which put me into deep trouble. However, this is what is running: mysql --ssl ...
0
votes
0answers
114 views

SSL verification problems with MySQL 5.6.21 Community Server

I'm attempting to set up SSL with MySQL 5.6.21 MySQL Community Server (GPL) with wildcard certificate signed by RapidSSL. MySQL is hosted on CentOS 7.1.1503. Following configuration is defined in ...
3
votes
2answers
137 views

How to specify target directory in Postfix with MySQL?

I have setup a mail server with Postfix, Dovecot and MySQL. Dovecot works perfectly. Postfix sends mail, but I have a problem with receiving mail. After 2 days of debugging and tweaking ...
0
votes
0answers
24 views

MySQL queries redirection

I have to redirect queries addressed to a server (Let's say Server A) to another server (Server B). Firstly I will briefly explain my topology Users and Server A are in the same network. The users ...
0
votes
0answers
359 views

MySQL Yum repository instalation and file not found

I'm installing MySQL server on Linux server following the instructions on this page. I used this version of yum : mysql-community-release-el6-5.noarch.rpm and the server OS version is ...
0
votes
0answers
86 views

load php extensions in apache

*reposting from stack overflow as this is more a server setup than a programming issue. http://stackoverflow.com/questions/32523320/load-php-extensions-in-apache * Hi folks, I think i am almost ...
0
votes
1answer
93 views

MySQL proxy or Master-Master replication?

I currently have a MySQL database hosted on a remote server (Server A). This database have to stay there because this remote server is very secure. Our online website use this database to display ...
0
votes
0answers
37 views

Mysql on a remote sever: iptables - allow access only for the application server

I am migrating my MySQL Database to t new server on Ubuntu 14.04. It is working fine at the moment. I am trying to set up the right iptables for both server (web application server and mysql server). ...
0
votes
1answer
167 views

How does read/write splitting work with MySQL replication?

I know how to setup a master->slave replication but I am a bit confused on how I would do read/write splitting between the two MySQL servers with a PHP application. When I have MySQL replication ...