An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
1answer
1k views

MySQL startup errors: ERROR 1005

My Debian MySQL installation gives this: Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 ...
0
votes
1answer
38 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 ...
0
votes
3answers
137 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
2k views

how to ignore a MySql error and go on to the next query?

I have created a shell script to connect to a DateBase and INSERT IPs and MACs from dhcpd.log file by connecting to the DB only once: #/!bin/bash dhcpLogFile="/var/log/dhcpd.log" NumberOfLines=$(awk ...
0
votes
2answers
190 views

Yum- upgrading packages that are running

Is Yum designed in such a way (or is the underlying system) that you can safely upgrade a binary while it's running? For example, you have MySQL 5.5 and you run yum -y install mysql56-server to ...
0
votes
3answers
1k views

How to know list of applications installed in my server? [closed]

I got one LINUX server in which Oracle LINUX 5 is installed. I have installed MySQL 5.1.73-community version. Now, I have to configure the variables. When I checked available memory through cat ...
0
votes
1answer
441 views

Wordpress won't recognize the MySQL database

I want to install Wordpress on Archlinux but I have this error: Your PHP installation appears to be missing the MySQL extension which is required by WordPress. I un-commented this line in ...
0
votes
3answers
371 views

Why “Linux Generic” use RPM extension in MySQL download page?

I need to install MySQL 5.5 from source in Ubuntu 10.04. So I'm trying to find tar.gz source from here. But when choosing "Linux Generic" from the drop down menu, it is showing an RPM extension I ...
0
votes
2answers
694 views

Need to install MySQL Client libaries but RPM not installing them

I'm trying install the MySQL Client libraries for the Perl Mod of the same name but when I run sudo rpm --install -v --allfiles MySQL-client-5.5.16-1.linux2.6.i386.rpm and querying the rpm ...
0
votes
1answer
47 views

Verifying output of a command not quite working via BASH script

In attempting to verify if a remote database exists or not, I'm seeing mixed behavior with a conditional statement. Technically the statement is working (it correctly reports if database is found), ...
0
votes
1answer
32 views

Reroute mysql connection through external machine

I want (as a first step towards an external mysql proxy) reroute traffic from the local connection of mysql (on a VM) to an external proxy (on the host) which then routes it back to the VM which will ...
0
votes
2answers
34 views

how to create table with fields in command line Centos

How do I do this in command line? Below is code i saw imported to PhpmyAdmin but i don't use any interface... CREATE TABLE IF NOT EXISTS `products` ( `id` int(11) NOT NULL AUTO_INCREMENT, ...
0
votes
2answers
70 views

Mysql server not starting

I installed Mysql server 5.7.9 on RHEL 6.5 using mysql57-community-release-el6-7.noarch.rpm Repo. And installation was successfull but when i try to start it up and gives errors. And from ...
0
votes
1answer
41 views

Sabayon 16 - MySQL Server unable to start

After installing Sabayon 16, I needed to install MySQL Server. I have followed two tutorials, but both of them fails to me. The first tutorial says to install dev-db/mysql and then execute sudo ...
0
votes
1answer
668 views

mysql-workbench error while loading shared libraries (libzip.so.2)

I'm trying to use mysql-workbench on my Fedora 23 machine but it fails. When I try to start it, I get the following message: [daniele@localhost ~]$ mysql-workbench ...
0
votes
1answer
69 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 ...
0
votes
1answer
72 views

Linux Swap Space

I have 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 memory ...
0
votes
1answer
189 views

Appending to a CSV file after obtaining datum from a database

I can [finally] extract data from the MySQL DB my_database_query="SELECT * FROM my_database.database" mysql -uUSER -p'PASSWORD' << EndOfFile $my_database_query EndOfFile How can I append this ...
0
votes
1answer
426 views

How to move mysql database and mysql server to another machine

I am having Ubuntu 14.04 desktop in which i develop software. Due to some reasons my hard disk has developed many bad sectors. I want to move my mysql server software and all the databases to a new ...
0
votes
2answers
387 views

Bash Mysql Command Substitution Login Failure

Bash and MySQL versions: GNU bash, version 4.2.25(1)-release (x86_64-pc-linux-gnu) mysql Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.2 I have a bash script that tries ...
0
votes
1answer
258 views

Mysql Database files read access

Right now I'm trying to set read access to the files of one of my databases. I'm using debian with basic mysql installation so the database location is /var/lib/mysql. I want ...
0
votes
1answer
566 views

Linux iptables DNAT 53306 to 127.0.0.1 3306

mysql real port is 3306。 I want public network using 53306 to visit mysql, and 3306 is not allowed access from public network. How to write the iptables rules DNAT 53306 to 127.0.0.1 3306?
0
votes
1answer
596 views

Creating operating system (OS) user in Oracle LINUX

I am a user with sudo access. To install MySQL, I have to create an operating system (OS) user called MySQL. Can I create a user which also has sudo access on this machine?
0
votes
3answers
511 views

Where Is MySQL installed on My Machine?

What is going on, everybody? Recently I have installed MySQL server on my Debian machine using Advanced Packaging Tool, and I am curious where it is installed and how I can find all the source files ...
0
votes
2answers
1k views

Cannot apt-get - Package install issue

I was halfway through updating my machine when it crashed and I had to reboot. It was updating new packages while it crashed. When I try to use apt-get it always fails because of a mysql package. ...
0
votes
2answers
30 views

mysql USER unclear about what can be dropped?

When show databases there is the information_schema below it listing my created databases but what is 'USER' and 'mysql' listed in there? I don't know if ages ago I made a mistake and created them ...
0
votes
2answers
71 views

MySQL exact path

I am using whereis mysql in my terminal to get exact location of my MySQL installation, but it's showing too many locations: mysql: /usr/bin/mysql /etc/mysql /usr/lib/mysql /usr/bin/X11/mysql ...
0
votes
1answer
908 views

Catch all emails and save them in MySQL

I want to do something like Facebook has with it message system. When you reply to email sent from Facebook User, it automatically gets in his message box. This is done, because you reply to ...
0
votes
2answers
2k views

How to install MySql on Red Hat 6.1?

I am trying to install MySQL-server-5.6.12-1.el6.i686.rpm on a Red Hat Enterprise 6.1 server. I receive the following error: rpm -Uvh MySQL-server-5.6.12-1.el6.i686.rpm error: Failed dependencies: ...
0
votes
2answers
3k views

Run mysqld_safe in background

I have a bash script that installs mysql for me. One line, that executes mysqld_safe, makes the script to hang - it won't continue to the following code. Obviously there's ampersand at line's end, ...
0
votes
2answers
219 views

Is it not possible to store my local websites in my Dropbox folder?

I have a bunch of web sites that I develop, and I run an Apache server locally to do debugging and design. The web sites use Apache, PHP, and MySQL. To be clear, my Apache server is not serving these ...
0
votes
1answer
301 views

Use an existing wampserver from a windows partition on linux mint

I dual boot Windows 7 and Linux Mint 14. I have wampserver installed on Win 7 and have a couple of websites already set up there. Is it possible to use that same installation apache/mysql/php ...
0
votes
2answers
4k views

Cron job not running / not successful?

I have a couple of cron jobs set up to maintain a local copy of a remote database. The first one downloads the latest version of the database from the remote machine, which runs every day and is ...
0
votes
1answer
164 views

from a laptop with CentOS 6.3 what is the command line to talk mysql server on my pc?

I have CentOS 6.3 running on my laptop which is already connected to the net. What is the command line to talk to MySQL server on my PC? Both devices are connected via my router and they can talk ...
0
votes
1answer
1k views

Connecting from OpenVPN Server to MySQL Server

I have an OpenVPN server installed on a server. What I'm trying to do connect from the OpenVPN server using the mysql client to the MySQL server than is connected to the OpenVPN server using a ...
0
votes
2answers
162 views

phpmyadmin is listing my server version and client version as being different

In a continuation of this question, I have purged the 5.1 client via sudo apt-get purge mysql-client-core-5.1. I have reinstalled the 5.5 client - sudo apt-get --reinstall install mysql-client-5.5 ...
0
votes
1answer
581 views

Force users to change email password every six months

I'm going to build an experimental mail server with Postfix + Dovecot and Mysql for user accounts. The server will offer SMTP + POP3 + IMAP. Is there a way to force users to change their mail account ...
0
votes
1answer
564 views

Installing glibc 2.3 for mysql server

I need to install mysql server and client for a project of mine so I downloaded the MySQL-client-5.1.61-1.glibc23.i386.rpm for the client and MySQL-server-5.1.61-1.glibc23.i386.rpm for the server. I ...
0
votes
1answer
580 views

How to write script for automatic joomla installation in webhost

I want to create a script in Linux that automatically downloads the latest Joomla from their website and then installs it to the specified user. Is it possible in a shell script? I don't know how it ...
0
votes
1answer
20 views

Bash script using mysql command with variables failing

I have a script to clone a vhost and associated db - however one of the mysql commands doesn't work. It fails and ends up outputting the mysql version number and 'how to use' info as if it hasn't been ...
0
votes
1answer
205 views

Upgrading mysql caused broken packages

I have Debian Jessie, and MySQL 5.6 from the MySQL Debian repository. This installation installes an apt sources.list.d entry that after sudo apt-get install mysql-community-server, it asks whether I ...
0
votes
2answers
40 views

Tab completion does not work in MySQL command line client

I've installed MySQL 5.7.10 on my Mac using Homebrew. My Mac is running OSX 10.11.3. When I'm running the MySQL command line client, I cannot tab-complete keywords, table or column names. How do I ...
0
votes
1answer
92 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 ...
0
votes
1answer
27 views

mysql error.log centralize logs

I'm developing a script where it will look into logs every 10 minutes and if there's any critical error it will send an e-mail to a certain adress. I have this problem i would like to solve more ...
0
votes
2answers
29 views

Import New Database Into MySQL

I have to set up a local database on a number of people's Linux Mint lap- and desk-tops. The idea is to do this from the command line after installing MySQL Server and Client, and associated ...
0
votes
1answer
98 views

MySQL logs are not working due to permissions

I am having a issue regarding permissions in MariaDB (MySQL) log files. I had setup logs files to be on /var/log/mysql but any time I restart the MariaDB server I can see the following messages logged ...
0
votes
1answer
27 views

Security of password in a cron job on a VPS

I have a site hosted on a VPS and need to run a MySQL dump nightly. If I create the cron command: mysqldump -u user -ppassword database | gzip > /path/to/zip/file are there any security issues? ...
0
votes
1answer
45 views

Split MySQL query into an [executional part] and a [MySQL command part]

Following mysql -u root -ppassword -D database -s -N -e "SELECT id FROM myTable" with special password and database is working fine. I want to split the code into two parts: Executional part: ...
0
votes
1answer
151 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 ...
0
votes
3answers
91 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 ...