An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
1answer
20 views

Can't find job mysql on crouton, ubuntu precise

I'm using Ubuntu precise as chroot in my chromebook machine. I'm trying to install mysql through apt-get install mysql-server. The thing is, when I try to start it, it can't find the job: ...
4
votes
1answer
50 views
+100

forward all mysql traffic to a ssh tunnel

I have a local application that needs to connect to a remote mysql server at 40.40.40.40:3306 The main firewall blocks all connections but ssh, I can set up a ssh tunnel and connect to the server ...
0
votes
1answer
14 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
26 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 ...
0
votes
1answer
25 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
21 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
19 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
19 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
47 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
42 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
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 ...
0
votes
1answer
170 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 ...
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 ...
1
vote
3answers
53 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
3answers
50 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 ...
0
votes
0answers
25 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
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
105 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
2answers
122 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
21 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
320 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 ...
3
votes
3answers
81 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
22 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
209 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
311 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
21 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
58 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
1answer
45 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 ...
4
votes
1answer
138 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] ...
-2
votes
1answer
67 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
42 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 ...
3
votes
0answers
94 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 ...
0
votes
1answer
69 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
21 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 ...
0
votes
1answer
61 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
136 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
3answers
82 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
2answers
94 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
0
votes
1answer
56 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 ...
1
vote
1answer
358 views

Permission denied writing to mysql log

I am just testing out a new Ubuntu (Vivid 15.04) install on Vagrant, and getting problems with mysql and logging to a custom location. In /var/log/syslog I get /usr/bin/mysqld_safe: cannot create ...
1
vote
0answers
487 views

libmysqlclient.so.18: cannot open shared object file: no such file or directory [closed]

I am using Slackware 14.1 x64 and when I want to run a program that is using mysql.h over C I read the following error: bash-4.2$ /home/normal/Proyectos/a.out /home/normal/Proyectos/a.out: error ...
0
votes
2answers
28 views

How can I find where a program is installed or run from?

I installed centos and now I want to get into mysql via the command line, but I forgot my root password for mysql as its not the same as the root password I made to login to the system. I googled and ...
1
vote
0answers
73 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. ...
0
votes
1answer
145 views

Update mysql database specific field with this bash script

I am using the following bash script to update an email address "currentemail@email.com" but the problem I have is that the field could be anything, not necessary "currentemail@email.com" I have tried ...
1
vote
1answer
29 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 ...
-2
votes
1answer
32 views

Replace mysql field with X

I would like to update a MySQL database table column with x. 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 simple command.
1
vote
0answers
20 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 ...