An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
1answer
842 views

Iptables rules for remote mysql server

I have a local mysql database on a centos server which causes a lot of load because there are a lot of queries made towards it. I want it hosted on its own server but i dont want every single ...
1
vote
1answer
516 views

How do I properly bind directories inside chroot jails using fstab?

I'm running nginx, PHP-FPM and MySQL on Debian Wheezy. I've set up chroot jails (with debootstrap) for each individual virtual host in /srv/. Everything is working like one would expect, but after ...
1
vote
2answers
811 views

how to insert many similar records in mysql at a time?

we know that we can insert multiple records at a time using this query: INSERT INTO `TABLE1` (`First`,`Last`) VALUES ('name1','surname1'), ('name2','surname2'), ('name3','surname3'), ...
1
vote
1answer
1k views

How to alter stored procedure in a MySQL database using the Linux command prompt?

I want to alter the stored procedure in my server machine. I'm uploading the codes via SSH Linux command prompt, I need to alter an existing stored procedure in my server. I don't have c-panel or ...
1
vote
2answers
401 views

Is it possible for a OpenVZ container to interact with a MySQL database on the host?

Say every container and the host itself has its own dedicated, external IP. Is it possible to do this without any problems? And is this really a good plan? Instead of hosting a database per ...
1
vote
2answers
2k views

MySQL refuses to uninstall

apt-get remove mysql-server Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: ...
1
vote
1answer
360 views

Adding MySql Workbench to favorites in Fedora 19

I'm using Fedora 19 64 bit on my Samsung Series 9 Ultrabook and I have installed MySQL workbench 6 (mysql-workbench-community-6.0.7-1.fc18.x86_64) via the RPM downloaded from the MySQL website. I'm ...
1
vote
1answer
338 views

KMail extremely slow/frozen when operating on local maildir folder

KMail seemingly freezes when trying to open a message or executing any command on the local email folders (maildir) such as moving or marking of messages. Sometimes the triggered action is executed ...
1
vote
1answer
683 views

ERROR: could not find driver after changing from mysql to mariadb

mysql was working fine but I wanted to give mariadb a try on a new server I have going. However I am having an issue where all my php websites seem to have issues communicating with mariadb. Webmin ...
1
vote
1answer
132 views

Can anybody help me with MYSQL not starting

Here is a my error log file [localhost:local/mysql-5.5.15-osx10.6-x86_64/data] root# sudo localhost.err localhost1.err 130911 14:16:24 mysqld_safe Starting mysqld daemon with databases from ...
1
vote
1answer
36 views

Searching multiple mysql tables for the same 2 fields in each table

I am trying to figure out how to search mysql tables for the same 2 fields. What I have is 2 tables in the same database. Below is what I have currently:- single search works ok SELECT * FROM ...
1
vote
1answer
716 views

install mysql 5.5(remi) with centos 6.2 complains error

Finished Dependency Resolution Error: Package: mysql-server-5.5.31-1.el6.remi.i686 (remi) Requires: libz.so.1(ZLIB_1.2.0) I type yum --enablerepo=remi install mysq and these error ...
1
vote
1answer
26 views

See latest added data in MySQL DB, Debian

Is there any way I - via any commmand - can see which data have last been added to a MySQL DB and when that data was added? Dist: Debian 7.0 (wheezy)
1
vote
2answers
607 views

How to dump mysql dbs in live boot

I can't log in to my fedora linux because of I/O errors(system halts after grub). Now I want to create a backup from my mysql databases. I tried chroot /path/to/root and then mysqldump, but I get the ...
1
vote
1answer
299 views

Mint 12 - Error updating MySQL (mysql-client-core-5.1)

I have MySQL 5.5 installed via packages.dotdeb.org. When trying to update 5.1, which is also installed, I get the following error: E: ...
1
vote
1answer
1k views

AutoMysqlBackup --lock-tables=false

I'm trying to use AutoMysqlBackup script to perform daily backups of my application. Unfortunately on the first try it didn't served me how I thought it would. I believe that the script has used the ...
1
vote
1answer
2k views

How to fix this mysql permission problem?

I'm trying like mad to get rails dbconsole to work (Rails 3.2.6, if that helps). The problem is that when I run the command, I get: gems/railties-3.2.6/lib/rails/commands/dbconsole.rb:81:in `exec': ...
1
vote
1answer
1k views

Install Mysql 5.6.4 or greater on web server with on CentOS / openSUSE with Plesk 10

I need to install MySQL 5.6.4 or greater on my web server because I'm using the full text innodb feature. I'm trying to move my local installation (WAMP server) to my dedicated server and I'm not able ...
1
vote
2answers
1k views

How would I direct local(127.0.0.1) MySQL traffic to an external SQL server?

Basically, I have two EC2 instances on Amazon Web Services. They are both running Ubuntu 11.10 x64. They both have a private and a public (Elastic) IP addresses. I'm having trouble setting up iptables ...
1
vote
1answer
2k views

Why don't I see the XAMPP page on Linux Mint?

I am trying to install PHP MySQL on Mint 12. I downloaded and installed XAMPP. According to the tutorial, when I go to localhost in a browser I should see this: Instead, I see: It works! This is ...
1
vote
1answer
556 views

Improved MySQL interface

Is there a MySQL terminal prompt that supports things like tab-completion and history? The standard one that comes with MySQL doesn't have those features
1
vote
0answers
25 views

apparmor: mysql permissions--with no recent changes

Mysql server is being blocked by (I think) apparmor, but I'm at wits' end to determine why/how. I'm not overly familiar with apparmor. I know I shouldn't uninstall apparmor--for at least two ...
1
vote
0answers
26 views

Can't MariaDB and Mysql install on the same machine?

I have to install Mysql as a metastore for the cloudera HUE. But on that machine, it seems MariaDB is on that machine. I use yum to install yum install mysql-community-server I got this error. ...
1
vote
0answers
13 views

PHP does not use MySQL default sockets

I am having a hard time understanding why PHP cannot connect with localhost as a host. I can connect by doing: mysql -uroot -p And also, through Sequel Pro I can connect with localhost as a host. ...
1
vote
1answer
12 views

Munin mysql plugin silently fails

I installed this Munin MySQL plugin on a RHEL 6 machine and I'm experiencing a strange behavior. I'm not getting any data in the Munin web page (the Categories list does not show a mysql link), but ...
1
vote
1answer
27 views

SELinux, MySQL, and shared memory

On an SELinux enabled Oracle Linux 6 host, I have a product using MySQL as its underlying database and, through the database, is trying to access /dev/shm. /dev/shm mounts with context tmpfs_t, by ...
1
vote
2answers
76 views

install mysql - has no installation candidate

I used to install mysql 5.6 in this way.. But now.. # echo "deb http://repo.mysql.com/apt/debian/ $(lsb_release -sc) mysql-5.6" >> /etc/apt/sources.list && echo "deb-src ...
1
vote
1answer
47 views

curl: (77) pbm with the SSL CA cert (path? access rights?)

I am in root in my directory on CentOS release 6.6 and I want to do the following in order to install mysql in upper version on centOS: rpm -Uvh ...
1
vote
1answer
31 views

Silent MySQL Server installation

I want to install a mysql-server on a Raspberry Pi (Debian) using a SSH-connection and a bash script, which contains the installation commands. The point is, that the installation need to be done ...
1
vote
0answers
58 views

Systemd: Running a script before msyql stops on shutdown

On my Ubuntu 14 vagrant box I use this upstart script to run automysqlbackup on every vagrant halt: description "run automysqlbackup" start on stopping mysql task exec automysqlbackup So ...
1
vote
2answers
63 views

MySQL Access Denied (CentOS)

I have installed fresh MySQL server on CentOS, and started the MySQL server service with command. # /sbin/service mysqld start I checked the service and it is running. Currently I am logged in as ...
1
vote
0answers
103 views

Reducing Number of MariaDB/MySQL Threads

So I'm running a MariaDB 10 database on a single core server; not super powerful, but then my needs aren't huge either. However, one thing I've noticed is that if I look in htop I have around 28 ...
1
vote
1answer
447 views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I am trying to copy data from CSV to mysql using shell script where I am all new. And I am working with my test server. mysql -u root -proot csv_imports -e "LOAD DATA INFILE ...
1
vote
1answer
20 views

Install mysql-workbench in fedora 21

I already install mysql-workbench in fedora 21 from rpm: yum localinstall mysql-workbench-community-6.3.5-1.fc21.x86_64.rpm But when I tried to launch apps by command: /usr/bin/mysql-workbench ...
1
vote
0answers
99 views

Debugging Slow Queries in MariaDB/MySQL

I've set up a MariaDB server and everything is running well, with most queries executing in well under 20 milliseconds, but every so often a query will take half a second or longer (sometimes several ...
1
vote
0answers
249 views

MariaDB Dependencies issue after isntall/remove

I tried to "upgrade" MySQL 5.5 to MariaDB by removing MySQL altogether. Then I installed MariaDB 10.1 as follows: sudo apt-get install software-properties-common sudo apt-key adv --recv-keys ...
1
vote
0answers
132 views

Mysql 100% 1 core CPU load

I have 8 cpu in server, and Mysql works only on 1 cpu core on 100%. How can I use all cores? my my.cnf [mysqld] safe-show-database query_cache_limit=1M query_cache_size=64M ## 32MB for every 1GB ...
1
vote
1answer
96 views

Linux Mint 17 Cinnamin + MySQL + turn OFF autostart

I have tried all the suggestions in hours of googling and still when I reboot and run service mysql status my server is running. since i only use mysql for database testing with my java apps i don't ...
1
vote
0answers
94 views

httpd and mysqld used out of memory

I choose 512mb ram for my Centos VPS with very low traffic new website .but after 2,3 hours after rebooting, i have only 24mb free memory. when i use top command: 2981 root 20 0 37176 10m ...
1
vote
1answer
33 views

Keeping services on EC2 alive

I'm using a MySQL database and Apache server with an AWS EC2 instance running AWS Linux. I start them both using the service command, but I am not familiar with any other tool that would come ...
1
vote
0answers
390 views

MySQL Daemon failed to start. Starting mysqld: [FAILED]

Help me! problem : sudo service mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED] vi /var/log/mysqld.log : 151015 05:46:26 mysqld_safe ...
1
vote
0answers
170 views

OpenSuse 13.2 mysql-workbench refuses to start

After running an zypper up mysql-workbench is broken. I get this error when trying to start it from CLI /usr/lib64/mysql-workbench/mysql-workbench-bin: symbol lookup error: ...
1
vote
0answers
141 views

what is the correct regexp for mysql filter in fail2ban?

I use the default filter file /etc/fail2ban/filter.d/mysqld-auth.conf for fail2ban service. But there are some errors in file /var/log/fail2ban.log as: Found a match for '150815 10:42:54 [Warning] ...
1
vote
0answers
61 views

How Remove permission denied with GRANT USAGE ON mysql

I have a mail server in my ubuntu instance. I have a webserver management FROXLOR and i recieve errors for access denied when i try to login in mail account. The log for this: Aug 16 03:14:33 email ...
1
vote
0answers
20 views

mysqld stops right after starting because of corrupted tables (disk full + hardware reboot) - how to fix it?

I'm dumb, I did the stupidest thing I could. On one of my servers, the SSD was full and I wasn't aware of it. The high-traffic website became working really slow, then started displaying errors, ...
1
vote
0answers
153 views

MySQL update failed (debian)

I have problem updating MySQL server (pkg mysql-server5.5) MySQL server "can't stop" [FAIL] Stopping MySQL database server: mysqld failed! invoke-rc.d: initscript mysql, action "stop" failed. dpkg: ...
1
vote
0answers
235 views

Unable to install mysql-server-5.6

My website was running fine on server version 5.5, but now it hangs on the installation of version 5.6. I've tried removing it, purging it, even removing the /etc/mysql folder, then reinstalling it ...
1
vote
0answers
173 views

mysql service exiting without error

I have installed mysql-community-server on openSUSE and am having trouble starting it as a service. I can start it using sudo mysqld --user=mysql without a problem and access the database normally. ...
1
vote
1answer
38 views

Update mysql database

How would I go about updating MySQL database X, table Y and column Z with "abc". How would I be able to do this without having to do so interactively from the mysql> prompt? I want to do this with one ...
1
vote
0answers
43 views

Zombie mysql process ? - linux Mint

I am having the following problem with MySQL and Mint: mysql is set to run at startup: sudo update–rc.d mysql defaults After startup the service is running and I can connect to the database through ...