MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

1
vote
2answers
59 views

MySQL is denying access to a legitimate remote user

I have created a user and given that user full access, but MySQL is still denying access to that user - why? Create user: create user 'myUser'@'Mikes-MacBook-Air.local' identified by ...
0
votes
0answers
18 views

If I put two Mysql instances in init.d Centos7 . will both start at boot?

I have two mysql instances in (init.d) all on (rc2.d) (rc3.d) (rc4.d) and (rc5.d). Before, one instance will start on boot but now that I have two instances in (init.d) all configured with different ...
0
votes
1answer
174 views

Postfix & Dovecot: Mailbox Quota Configurations

I'm running Postfix 2.11, Dovecot 2.2.9 and MySQL 5.6.27 under Ubuntu 14.04.3. I've configured Postfix to support virtual mailboxes but it seems that there're some problems with the quota settings. ...
0
votes
1answer
31 views

I have two Mysql servers running on Centos7 . both using different ports. have to manually boot on start.

I need help . mysql on port 3306 and mysql2 on port 3307. I copied my.cnf to my2.cnf I added the following in my2.cnf: datadir=/var/lib/mysql2 port=3307 cp /etc/init.d/mysql /etc/init.d/mysql2 ...
2
votes
3answers
72 views

Can't stop mysql, even after killing the process

On doing /etc/init.d/mysql stop I see the message * Stopping MySQL database server mysqld ...done. ....which seems mysql has stopped. But when i run ps aux | grep -i mysql , i still see ...
2
votes
2answers
146 views

PHP and MYSQL on Amazon EC2 server

I am trying to set up an amazon server to display my php files for a final for one of my classes. I followed this tutorial for setting it up and when I try to run my code I get "Fatal error: Class ...
0
votes
1answer
75 views

MariaDB won't start - fails to check integrity

I have a MariaDB installed with brew in my macbook. Worked fine till today. All of a sudden it wound not start: -> mysql.server start Starting MySQL ERROR! also, if I issue mysql -uroot or any ...
0
votes
0answers
20 views

mysqlfailover automatic failover is not enabled

i use mysqlfailover mysqlfailover --master=root@132.232.142.73:3306 --discover-slaves-login=root --slaves=root@12.32.53.2:3306 --report-values=health --verbose --failover-mode=auto ...
0
votes
1answer
17 views

Lock a specific mysql database in shared mysql database

I am trying to migrate a database from one cluster to another cluster. In order to avoid any data loss during the migration, I am trying to lock my database with the WRITE operations. But the lock ...
1
vote
3answers
99 views

mysql stops responding periodically

I run a site (Magento) on a Ubuntu 14.04.3 server running on a 32xCPU VMWare VPS. When it is under heavy load, it typically receives 20-25 requests/second. In magento there is a specific UPDATE query ...
1
vote
2answers
64 views

Configure MySQL server to minimize disk usage

I have a Raspberry PI computer with some measurement device and a script that takes a measurement every five minutes and stores the result in MySQL database. I have configured MySQL server to keep the ...
0
votes
2answers
25 views

mysql client connect to nginx error 10060

i use nginx for mysql the http { include /etc/nginx/mime.types; default_type application/octet-stream; log_format main '$remote_addr - $remote_user [$time_local] "$request" ' ...
1
vote
1answer
36 views

mysqlimport file not found error in Windows but exists a file

I have a problem with (Oh, I am using Windows 7, MariaDB 10.1.7) mysqlimport -u root -p --fields-terminated-by="," --local db_name textfile.csv; which founds an ERROR 29, FILE ...
2
votes
1answer
45 views

Empty space in MySql database

Forgive me if I'm not using the appropriate vocabulary. I'm planning on implementing a MySQL database with a PHP front end so I can enter work order details and files (screengrabs, ZIPs, etc.) into ...
1
vote
0answers
39 views

MySQL persistent tmpdir on slave: use tmpdir or slave_load_tmpdir only?

While setting up a replicated MySQL database I looked at the manual about tmpdir and was somewhat confused about the two variables tmpdir and slave_load_tmpdir. I know the slave needs some data to be ...
1
vote
0answers
123 views

MYSQL DB not starting

I have VPS where I run apache and mysql and since yesterday I can't launch the mysql server anymore: sudo service mysql start start: Job failed to start output of error.log at ...
-2
votes
1answer
25 views

mysql repair myisam table give a error 127

My server have an hdd fault. Due to this one table of DB was corrupted. I've tried to use myisamchk -r /path/to/table_name.MYI to repair it. After executing i have a message myisamchk: error: 127 for ...
0
votes
1answer
30 views

mysql GTID replication

i try to use GTID and backdump mysql -u root -h xx.xxx.xxx.xx -p < 2015-10-30_all_database.sql Enter password: ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when ...
-1
votes
1answer
59 views

CentOS7 mysqlserver download error

[root@localhost bin]# rpm -qa httpd httpd-2.4.6-31.el7.centos.x86_64 [root@localhost bin]# rpm -qa php php-5.4.16-36.el7_1.x86_64 [root@localhost bin]# rpm -qa mysql [root@localhost bin]# I am a ...
1
vote
2answers
59 views

Unable to Locate MySQL Server

So there is this ancient legacy server running MySQL somewhere in our office. I can connect remotely using: # mysql -u someuser -p -h ancientserver.domain.com I see the tables I expect. However, ...
0
votes
1answer
49 views

we have MySQL Enterprise Server - Advanced Edition (Commercial) installed on Centos7

I always have to start it manually on boot everything the server is down and boots up. Someone help me set it to start on boot with systemctl enable [root@localhost ~]# systemctl enable mysqld ...
0
votes
0answers
49 views

Setting up phpMyAdmin on a 1&1 Managed Dedicated Server

I'm trying to set up phpMyAdmin on my Managed Dedi Server from 1&1 so that I don't have to log into my 1&1 Account to access the databases / so that my developers don't have to know my account ...
1
vote
3answers
243 views

CentOS installing MySQL 5.6.26

My server is CentOS 6.7 x86_64. I installed mysql by yum -y install mysql-server. But this install v5.1.73. Installed: mysql-server.x86_64 0:5.1.73-5.el6_6 Dependency Installed: mysql.x86_64 ...
0
votes
1answer
104 views

MySQL creates huge files every night, bringing down the server

I have an Ubuntu 12.04 LEMP server with shop app ontop, running MySQL 5.5 as DB (currently since this problem started I've already switched to Percona with no success). So, current facts: every night ...
-2
votes
2answers
146 views

Is it safe to reboot Linux every night? [Being attacked] [closed]

Is it safe to use reboot command to reboot VPS every night? I'm under attack everyday for ~30 mins and I'm pretty sure if they could attack, they would do it non-stop. I contacted hosting provider, ...
0
votes
0answers
50 views

Mysql table keeps crashing. How to debug the cause and prevent it?

My wordpress wp_users table keeps crashing and when I get up on the morning is : wp_users' is marked as crashed and last (automatic?) repair failed So all my users can't access the site. If I do a ...
0
votes
1answer
17 views

How to find the latest binlog of MariaDB by shell script?

I want to find the latest mysql binary log in /var/log/mysql/, but I found the name of binlog is mariadb-bin.0000*, and we also have mysql-bin.index, so it's really hard for me to use shell script to ...
2
votes
1answer
29 views

split filename in loop and reference each part

I have a directory with a list of files in it, e.g. file.name.aaaaaa.111111 file.name.bbbbbb.222222 file.name.cccccc.333333 I need a way to take each file, split it at the "." and then using each ...
2
votes
2answers
121 views

How is server replication implemented when setting up a reverse proxy environment?

I've been reading and having a go at setting up some different server cluster environments. I have it working correctly using various Linux distributions. The basic set-up goes as follows: ...
-1
votes
1answer
45 views

Migrate my mysql database to AWS RDS

I have my MYSQL server running in my google instance. My server have vesta control panel where I'm currently managing servers.. I would like to migrate my database to Amazon RDS. How I can do it ...
1
vote
2answers
111 views

MySQL and high jdb2 io/wait

I am running MySQL 5.5 with InnoDB tables. There are about 200 queries per second. There are also tables with 500 000 or more rows. But I have big issues with server load and io/wait especially with ...
0
votes
2answers
52 views

Connect by mysqldump to a mysql server only allowing one ip

I have a cloud server with MySQL in it. In this moment, i can't connect from my pc to the server using any of the users. What it want is allow to use mysqldump with an specific user and only allow ...
0
votes
2answers
33 views

Script to connect Mysql from EC2 to AWS RDS [closed]

I'm writing a script to connect mysql server on an EC2 to RDS, normally I do this: mysql -h $RDS_ENDPOINT -P 3306 --user=$RDS_MYSQL_USERNAME --password=$RDS_MYSQL_PASSWORD and then exit I just want ...
1
vote
1answer
75 views

Cannot connect to the MySQL remote server. Debian 8

I have issue that I cannot reach the 3306 port (mysql) even if I set it in iptables. How can I resolve this issue? root@vps191532:# iptables-save # Generated by iptables-save v1.4.21 on Thu Oct 22 ...
0
votes
0answers
46 views

'/var/lib/mysql/mysql.sock' (2) Issue with apache remotely connecting to mysql

Every now and then, I will get this issue where my Apache server cannot connect to my mariadb server remotely. It seems to occur at least once a month and I can't pinpoint the problem. It does however ...
1
vote
0answers
105 views

MySQL encryption at rest

Context: Rackspace CloudServers. The options I can find are rather slim. Amazon will encrypt the whole disk (meh), Gazzang could encrypt a virtual partition with just the DB files on it (if the ...
0
votes
3answers
43 views

Mysql master slave replication fail PID error

I have Master on 5.6 & Slave on 5.5, this will be the test ENV to check if 5.6 can replicate on 5.5 on PROD. I am getting this below error when starting mysql ERROR! MySQL server PID file ...
1
vote
2answers
452 views

ERROR 2006 (HY000): MySQL Server Has Gone Away… (HaProxy / Galera)

I setup a cluster of 3 MariaDB servers in a multi-master setup which is working fine. I added a 4th server for HaProxy to load balance and round robin so that we can have a little redundancy which is ...
0
votes
1answer
57 views

MySQL using more memory than it can?

FROM: -- MYSQL PERFORMANCE TUNING PRIMER -- MySQL Version 5.6.24-72.2-log x86_64 ... MEMORY USAGE Max Memory Ever Allocated : 70.35 G Configured Max Per-thread Buffers : 972 M Configured Max Global ...
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
12 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
186 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
116 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 ...