An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
0answers
7 views

Why is the config file in /etc/munin/plugin-conf.d/ ignored?

I have a Munin script /etc/munin/plugins/mysql_replag that queries a MySQL server to check the status of a master-slave replication: #!/bin/sh # Plugin to monitor the Seconds_Behind_Master of ...
-1
votes
0answers
20 views

Help with metasploit on kali linux

Everytime I try to use auxiliary/admin/mysql/mysql_enum the console displays this error: [-] Auxiliary failed: Rex::ConnectionRefused The connection was refused by the remote host ...
1
vote
1answer
887 views

phpmyadmin doesn't work after installing php5-mysqlnd

I am currently running into some problems with phpMyAdmin. I set everything up correctly and made sure everything worked. Then later after some developing on some pages I noticed I couldn't execute ...
0
votes
1answer
24 views

Does MySQL processes run in user or kernel modes?

I try to count IOPS and I/O size with SystemTap script and use MySQL to be workload. I found mysqld doesn't call systemcall but mysqld has read/write on VFS. So, do MySQL processes run in user or ...
1
vote
0answers
20 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
17 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
14 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, ...
0
votes
0answers
9 views

How to monitor mysql percentage disk utilization?

I am new to mysql world and not sure if there is a way to calculate mysql TableSpace/DiskSpace utilization in percentage. I am aware mysql does not provide upper limit or free space like Oracle DB, ...
0
votes
1answer
18 views

Can't install MySQL client libraries on Gentoo

I'm new in Gentoo. I'm trying get the mysql2 gem installed. But it's stuck. I found out that I need MySQL client libraries. I tried: emerge dev-db/mysql:minimal * IMPORTANT: 2 news items need ...
1
vote
1answer
996 views

How can I install mysql on an angstrom distribution?

I tried using a different distribution (debian) but the rest of my application did not work. I've tried opkg install mysql-client and opkg install mysql-server however I get the error Unknown package ...
1
vote
1answer
39 views

Apt-get hangs on “Setting up mysql-server-5.5 (5.5.44-0+deb8u1)” [closed]

I'm on Debian 8 (stable) (Linux zenbook 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt11-1 (2015-05-24) x86_64 GNU/Linux) and tried to apt-get update && apt-get upgrade yesterday. There was an ...
1
vote
0answers
36 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: ...
0
votes
2answers
1k views

Installing MySQL on CentOS throws error that cannot find mysqld.sock

I have yum install mysql in CentOS 6.4. Now, when I use mysql command, it throws the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
0answers
13 views

Does postfix support MySQL connections over SSL

I have a postfix server and a MySQL database server. I setup MySQL SSL and have it working successfully. I can connect from postfix to mysql with the user requiring SSL. The problem I have is, when I ...
1
vote
3answers
47 views

Check services running on the server and restart them if they have stopped?

I am trying to write a python script which shows me the services which are running on my server. The thing is that mongodb keeps going down on the server and each time it happens I have to manually ...
0
votes
1answer
139 views

Getting Minor Version Mismatch Error with Php and Mysql

I randomly started getting this error when trying to instantiate a new mysqli instance in php script: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50541 ...
3
votes
2answers
4k views

Cannot install mysql-server-5.5/the following packages have unmet dependicies

I'm using ubuntu 14.04. I tried entering mysql with the following command: mysql -u root -p and I got the following message: The program mysql can be found on the following packages: ...
2
votes
3answers
140 views

Shell script executed with cron results in different size file than executed manually

I have a RHEL server that I am running a MySQL database on. I have a Bash script that executes mysqldump that creates a backup file. The backup file created when executing the script directly in ...
0
votes
3answers
48 views

prevent repeated emails via bash to overquote user

I need some help to improve the idea/implementation.Scenario is local mini ISP. users accounts are stored in freeradius/mysql. The task is to send user email who have consumed 80% of there assigned ...
1
vote
3answers
362 views

Upgrade MySQL 5.0.88 to 5.1.69

I am upgrading my MySQL installation on a Fedora 10 (and 14) box (in test first.) I have made a system image (it is a VM) and have downloaded MySQL Server Community 5.1.69-1 from the MySQL site. Once ...
0
votes
2answers
96 views

Cannot Access LAMP Web Server on Ubuntu Server 14.04

UPDATE: So it seems that I can access the website from computers outside of the LAN, it's when I try to pull up from any computer on the same LAN as the server that I get an issue. From what I've read ...
0
votes
0answers
19 views

MySQL won't start at boot with bind-address set to IP [duplicate]

When I set the bind-address to the IP of the RPi, it will not start at boot. It will only work if I set the bind-address to '127.0.0.1', 'localhost' or 0.0.0.0. The syslog provides the following ...
0
votes
0answers
24 views

Is my Nginx,php-fpm and mysql config good enough?

My Setup: Intel(R) Xeon(R) CPU E5-2680 v3 @ 2.50GH 30 GB Ram 1 Gbps Premimum/Dedicated Line Softwares3 MariaDB 10.0.20 NGinx 1.8.0 PHP with FPM 5.6.8 Our servers gets a LOT of requests (more ...
0
votes
0answers
91 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 ...
0
votes
0answers
19 views

Uninstall MySQL without removing HHVM on Laravel Forge / Ubuntu 14.04

Since I maintain database and web servers separatly, I wanted to have my Forge's maintained web server without mysql, as it tend to use a lot of memory, even if I don't use it. Trying to run a sudo ...
3
votes
1answer
316 views

Add 30 days in date

Using bash or mysql , how can I add 30 days in user expiry table? Example I have DB name USERS and table expiry like this: USERNAME EXPIRATION JOHN 2015-09-26 I want the command to take ...
0
votes
2answers
4k views

MySQL service doesn't start

I have a CentOS 6.6, on the system there was a working Mysql and a mysql server already installed and a running mysqld service, but i needed a fresh install, so i did the whole removal through yum, ...
3
votes
3answers
71 views

Using `nohup` to Import MySQL Dump on Debian Server

I am trying to import a mysqldump file into my mysql database, but my (putty) connection to the server keeps timing out halfway through. I tried to use nohup . . . . & but this doesn't appear to ...
0
votes
1answer
19 views

How can I uninstall MySQL if I have compiled it from source?

I'm trying to uninstall MySQL but when I get inside the directory and type make uninstall It get: make: *** No rule to make target `uninstall'. Stop. I've read that I have to delete all ...
0
votes
1answer
186 views

PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/php_mysql.so'

I am running PHP 5.6 on Linux. When I try to load a PHP page, I'm getting the following PHP error. PHP Startup: Unable to load dynamic library /usr/lib64/php/modules/php_mysql.so' When I look ...
1
vote
1answer
258 views

unable to launch mysqld in arch linux

I have lately installed arch linux x64 and I wanted to install the LAMP stack everything worked fine until I arrived to the mysql part that I installed but can't launch. The outpout of sudo systemctl ...
0
votes
1answer
20 views

Getting the log from MySQL into a file when running MySQL commands from the command line

I am trying to get the log from MySQL into a file when executing a script from the command line. For example mysql -v mydb u- alex -p**** < please_run_me.sql > /tmp/file.log Now, the work ...
0
votes
2answers
56 views

Ubuntu mysql reinstall service status not working

I tried to reinstall my mysql server on ubuntu 14. After reinstall all seems to run fun until the service mysql status/start/stop command When the server is started the mysql status is stop/waiting ...
0
votes
2answers
3k views

What caused my CentOS 6.4 box to reboot itself?

I noticed that the MySQL daemon running on my CentOS 6.4 machine was suddenly not running anymore. I checked the MySQL log, but didn't see anything relevant: 121229 22:17:45 mysqld_safe mysqld from ...
4
votes
1answer
127 views

The file /usr/libexec/mysqld does not exist or is not executable

Whenever I try to start MySQL via the command service mysqld start I get the following error: MySQL Daemon failed to start. Starting mysqld: [FAILED] ...
0
votes
1answer
44 views

Linux Swap Space

I have got 32GB memory. SSD and NonSSD drives. I installed linux to NonSSD drive but i prefer SSD for /var directory and i didn't create swap space because there is high memory. I know physical ...
0
votes
1answer
13 views

Transfer Schema and Rebuild Databse on Another Server

I have made a number of changes to the database schema on my development including the addition of new tables and changes to others. Is there an easy way to transfer this schema to the server, build ...
3
votes
0answers
89 views

How can I fully remove a tablespace from MySQL?

I have a MySQL database called camera_main_live, which I administer using Adminer. It is, to all appearance, empty. So when I want to add some content, I begin by running this script (with Adminer set ...
1
vote
2answers
4k views

Can't start mysqld

I've installed mysql through $ sudo apt-get install mysql-server-core-5.1 $ sudo apt-get install mysql-client-core-5.1 This is my current conf file And the service won't start, at first the ...
0
votes
2answers
81 views

Install app on tiny core

How do you install mysql on tiny core? Also how do you install clamav? Can you install apt-get or yum on tiny core? All should be done in command line / terminal
-2
votes
1answer
65 views

linux shell command in Perl program

Hi friends here is some issue I want to write a script that restarts server which is in stopped status. Here I am using my MySQL server in future if it is in stopped status then it will be restarted ...
0
votes
1answer
40 views

Can't start mysqld (mariadb) on Fedora, if put a backup into /var/lib/mysql

After some terrible actions, I had to reinstall my Fedora (was 20, became 22). Unfortunately, I was unable to made mysqldump, so I backuped /var/lib/mysql folder. Now, I'm trying to put in on the ...
0
votes
3answers
75 views

Bash to match two variables for time difference

I have a bash command which gives me following result (Fetch user account details from the mysql using command select creationdate from users; Name Account Creation Date Mobile User1 ...
0
votes
1answer
64 views

Export mysql to remote server using one SSH session

I've come across a situation where I had to create a utilitary shell script that would be executed in many servers from different regions. The objective is to dump the local mysql database, copy it to ...
0
votes
0answers
20 views

Strange MySQL with WHM connection issue

I am not really the best way to explain this except state exactly what happened and my basic configuration. I have 1 VPS on Rackspace that has WHM installed on it. This has 3 sites/accounts, that ...
1
vote
1answer
130 views

How do I troubleshoot these SELinux AVC errors?

Background: I have a CentOS 6 LAMP server. Recently the server has started to become unresponsive every few days. Originally, mysqld would throw a nagios alert and I would be unable to even ssh into ...
0
votes
1answer
55 views

Freeradius: MySQL query to show account expired yesterday

I have freeradius with mysql.using CLI, I want to list user account which have expired yesterday. Currently I am using following command but it shows today account, mysql -uroot -pSQLPASS -e "use ...
2
votes
2answers
123 views

High IO wait - How to determine the root cause?

I have a MySQL instance on two dedicated servers. One for the production, the other for the test platform. The 2 servers are pretty the same, the only difference is the RAID controller and the ...
0
votes
1answer
171 views

Chromebook crouton LAMP

I'm trying to install a LAMP stack on Ubuntu through crouton on a Chromebook (Acer c720p). I was able to install the following packages apache2 mysql-client mysql-server php5 libapache2-mod-php5 ...
0
votes
1answer
53 views

MySQL process showing in top but no errors logged

I am seeing the following in TOP 2311 mysql 20 0 1324M 646M 9188 S 0.0 17.1 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin ...