An open-source, relational database management system.
1
vote
2answers
12 views
MySQLdump via crontab - Pass --password=/hashed/password/file so I can use via crontab w/o using plain text password
So I'm setting up a WordPress backup guide/making a backup schedule for myself for real.
I want to do MySQL dumps daily, but the command either requires
-p then user input
or
...
0
votes
1answer
21 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
53 views
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
48 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
43 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
178 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
108 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
123 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
22 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
83 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
23 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
217 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
329 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
59 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
139 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
95 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
70 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
95 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
57 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
362 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
495 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
146 views
Update mysql database specific field with this bash script
I am using the following bash script to update an email address "[email protected]" but the problem I have is that the field could be anything, not necessary "[email protected]" 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.
