An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
1answer
76 views

can't connect to mysql as admin from outside

I have a dedicated server (CentOS 5.3) but I can't log on to mysql as admin from outside, however I can do that when I'm on server's command line. I assume there's a setting somewhere that can give me ...
1
vote
1answer
2k views

Install MySQL workbench on ubuntu

I am using Ubuntu 9.10 - the Karmic Koala - released in October 2009 I downloaded mysql-workbench-gpl-5.2.33b-1ubu1004-i386.deb from here But when I run this package it show me following error: ...
1
vote
1answer
1k views

Mod_Auth_MySQL will not compile under Slackware 13

I tried to add the auth_mod_auth (3.0.0) module to my Slackware 13 (apache 2.2 & MySQL 5.0) system. I ran the usual command line for apxs (as mention in the BUILD file) apxs -c -L/usr/lib/mysql -...
1
vote
2answers
73 views

A script to take data from csv file and perform related operations in a database

I am new to the world of shell scripting and don't have much idea of shell scripting . My work requires me to write a script which takes phone numbers from a list of records stored in an CSV file . ...
1
vote
2answers
83 views

MySQL Daemon failed to start on centos

I installed MySQL 5.7 in my CentOS and tried to start the service but that gives this error. MySQL Daemon failed to start. Starting mysqld: [FAILED] mysqld....
1
vote
1answer
49 views

mysql server failed to start

I'm trying to connect to mysql server running on fedora virtual machine. Connection is established. But when I've restarted mysql server with this command : # /etc/init.d/mysqld restart stop is ...
1
vote
1answer
186 views

limit of open files: Debian Jessies´ MySQL vs Community Oracle MySQL

I have just upgraded from MySQL Jessie 5.5 to MySQL Oracle Community Edition v5.6. I have a particular MySQL server, that has around 230 DBs, and > 32k files/tables. Whilst for two or three years, I ...
1
vote
1answer
171 views

How do I prevent crashing my ec2 micro instance mysql db?

I have an Amazon ec2 micro instance that holds a WordPress site. Since yesterday, my mysql db keep crashing saying: [ec2-user@ip-xxx-xx-xx-xxx ~]$ sudo service mysqld status mysqld dead but subsys ...
1
vote
1answer
246 views

MariaDB - dependency problems - leaving unconfigured

I have tried to install ISPConfig3 on Debian Jessie 8.1, and it couldnt connect to mySQL (mariaDB 10.1). So I CTRL+C to kill the install and I tried to manually login to mySQL, but I failed. It was ...
1
vote
1answer
205 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
696 views

mysql-server-5.5 unmet dependencies each time running apt-get

Each time I run "sudo apt-get install package-name", the following error happened, even if I tried to install other packages other than mysql ones: You might want to run 'apt-get -f install' to ...
1
vote
1answer
122 views

How to use SSH tunnel to connect to remote MySQL server?

I am trying to connect to remote MySQL server, which runs on CentOS 6.6 cPanel server. I am creating tunnel this way: ssh -L 3306:xxx.xxx.xxx.xxx:3306 user@xxx.xxx.xxx.xxx -p PPPPP Where xxx.xxx....
1
vote
1answer
542 views

Mysql Isn't starting

I recently asked this question the reason mysql wasn't starting is because there was no disk space. After a long discussion with casey in chat room and after following his answer, I freed about 10 GB ...
1
vote
1answer
134 views

How to update apache, mysql, phpmyadmin and php on Raspbian?

I have my own web server running on my raspberry pi, and all my programs are outdated. I would like to update my PHP, Apache, MySQL, and phpMyAdmin. Can anyone tell me how to update all of these? I'm ...
1
vote
1answer
5k views

warning: mysqli::real_connect(): Headers and client library minor version mismatch. Headers:50537 Library:50623

warning: mysqli::real_connect(): Headers and client library minor version mismatch. Headers:50537 Library:50623 How do I do with it? I think I have a different version between mysql client and server,...
1
vote
2answers
1k views

How to Subscribe a Bash Script as a MQTT Client

From my understanding: Client can be any device as long as it has an MQTT library running on it, from a microcontroller to a server, but must be connected to an MQTT broker over any network Broker ...
1
vote
1answer
911 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
577 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
1answer
806 views

Mysqld_multi doesn't recognize groups

I am trying to configure a MySQL server to run multiple instances of the daemon (I wish to duplicate it onto different drives). I've been trying to use the mysqld_multi script. However the script is ...
1
vote
2answers
863 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'), ('name4','...
1
vote
1answer
441 views

Rooting Linux via mysql

I have a CentOS 5.6 x86 installed. I have full access to mysql but it seems I have forgotten Linux root password. How I can access the root via MySQL? Is it even possible? Update: MySQL Version is 5.0....
1
vote
1answer
2k views

proftpd via mysql & web management of FTP users

I have installed prftpd and proftpd-mysql rpm on a linux machine. Intention is to have usermanagement of ftpusers via web. So I have installed proftpadmin from Here Now when I am adding the below ...
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
422 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 container,...
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
374 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
343 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
714 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
135 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 /usr/...
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
728 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 appears....
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
684 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
303 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: /var/cache/apt/archives/mysql-client-core-5.1_5.1.66-0ubuntu0....
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
562 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
62 views

Using yum to upgrade from MySQL 5.1.73 to 5.7.13

I've picked up an IT role and I'm new to yum so please forgive me. yum list shows these mysql packages installed: mysql.x86_64 5.1.73-5.el6_6 @base ...
1
vote
1answer
65 views

apparmor: mysql permissions--with no recent changes

UPDATE: I now know my issue was database corruption, but discerning it was somewhat tricky--apparmor appeared to be the cause for longer than it should've. I didn't note when first posting that even ...
1
vote
0answers
135 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
1answer
21 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
27 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
34 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
237 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 http://repo....
1
vote
1answer
223 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 https://dl.fedoraproject.org/pub/epel/epel-release-...
1
vote
1answer
39 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
69 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 ...