An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
0answers
89 views

can't connect to remote host with MySQL…firewall problem?

I've granted privileges to thufir for remote access through the shell (correct?), but cannot seem to actually connect. The router firewall has SPI to off. I've disable the IPv6 firewall on the ...
0
votes
1answer
476 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 ...
0
votes
1answer
61 views

Combine the output of while loop into tar

I'm trying to create a script that mysqldumps all my databases, creating an individual .sql file for each database and combines the output into backup-DATE.tar.gz. I've gotten as far as being able to ...
2
votes
1answer
5k views

Start Mysql/Mariadb in Fedora failed

failed to start mysql in Fedora 17. I am using root account to run the below commands and selinux is disabled. service mysqld start Redirecting to /bin/systemctl start mysqld.service Job for ...
1
vote
1answer
37 views

FreeBSD Reinstall postfix with mysql support

I have installed postfix using the ports tree without making modifications to anything. In my main.cf file i can't specify any 'Mysql:/' arguments because postfix does not have mysql support. Now i ...
0
votes
0answers
20 views

Postfixadmin keeps loading while adding mailbox

I have configured postfixadmin 2.92. While adding mailbox postfixadmin keeps on loading and does not return any information like mailbox is created. But in mysql the mailbox has been added. Later when ...
1
vote
1answer
139 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 ...
4
votes
6answers
8k views

How to install MySQL Workbench on Fedora 21

Is there an easy way to install MySQL Workbench on Fedora 21? I could not find a RPM package and failed at compiling it from source because I am using MariaDB and therefore was unable to install ...
0
votes
1answer
39 views

Having problem with mysql dbdump when password starts with special character

I am trying to take a db backup with a php file that is running from a cronjob. It was running fine when I tested with sample db. But when I used the actual db there was an error. I am using ...
2
votes
1answer
5k views

How to install phpmyadmin 4.0 on Debian

Is there a way to install an up-to-date phpmyadin on Debian via apt-get? I only found a PPA for Ubuntu on the that you can install with sudo add-apt-repository ppa:nijel/phpmyadmin apt-get update; ...
2
votes
2answers
421 views

How do I install postfix with MariaDB 10.1? …Or mailserver…?

I'm using CentOS 7 x64. Log: There isn't mariadb-libs for 10.1, not that I'm aware of. There is MariaDB-compat which as I found out seems to provide the same functionality and I have it installed, but ...
1
vote
1answer
61 views

Calculating RAM/Swap Space Requirements [duplicate]

I have been developing a MySQL database that makes some use of BLObs. This has now been transferred on to a virtual machine (VM) in preparation for going fully into the 'cloud'. However some of the ...
0
votes
1answer
59 views

Is there any way to install MySQL 5.1 and PHP 5.3 on Centos 7

Is there any way to install MySQL 5.1 and PHP 5.3 on Centos 7. I researched a lot but could not find any link which gives step by step procedure. Can someone please give me steps to be followed to ...
0
votes
2answers
98 views

MySQL won't start

I'm using a debian system. I could not start my mysql after the partition went full - I received the message "ERROR: The partition with /var/lib/mysql is too full!" I found a recommendation to delete ...
1
vote
1answer
136 views

Data loss prevention ( or recovery) in a MySql db in embedded systems

I have a little ( big ) problem with a MySql application that write on a SD card or a Compact Flash. After a data loss ( a power failure , for example) , if I try to retrieve the data of my db , it ...
0
votes
0answers
30 views

How to access MariaDB on Debian Server from Win Machine on same network

I'm having trouble accessing my MariaDB server from my windows machine on the same network. When I try to create an ODBC connector from within MS Access using the local IP and the correct ...
0
votes
1answer
97 views

Respawn MySQL on Ubuntu? Server ran out of memory, killed MySQL & Apache, MySQL didn't respawn

Just as above, I increased the RAM (it's a VM), but that doesn't give me a safety net. I was under the impression by default it should respawn, but that doesn't seem to be the case. *Ubuntu 10.04 ...
-1
votes
1answer
90 views

replace text in a file

are there any usefull command to replace all text that contain number and remove those number . Ex: myimages-202x250.jpg width="202" heignt="250" replace to myimages.jpg width="217" height="317" ...
0
votes
0answers
66 views

Modifying SELinux settings to allow for MySQL to run on CentOS7

I'm trying to install MySQL 5.6 on Cent OS 7 with SELinux enabled and am trying to get past the error (in /var/log/audit/audit.log): type=AVC msg=audit(1424111345.853:558): avc: denied { execmem } ...
0
votes
2answers
69 views

how do I find the location of mysql drivers on CentOS 7?

MariaDB is installed on a remote CentOS 7 server. How can I find the location of the nearest equivalent to mysql-connector-java-5.0.8.jar in the server's file system? grep seems to only search ...
2
votes
2answers
5k views

cronjob for automatic DB backup to date prefixed file

I am using the latest Linux Mint. I was wondering if it's possible to create a special cronjob for a database backup. In my /etc/cronjob file I have the following code: # Minute Hour Day of ...
0
votes
1answer
20 views

Mysql: remote and local access

I have a gentoo where is installed a mysql server. I need a remote access to this server, so I have modified the option bind address in the file /etc/mysql/my.cnf bringing it from bindaddress: ...
3
votes
1answer
1k views

MySQL server won't install to a new os (Debian, Ubuntu)

Today I wanted to install (on a new VPS with new OS) a MySQL server. I used this command: apt-get install mysql-server mysql-common mysql-client-5.5 I tried with Debian 7 (x64 and x86) and Ubuntu ...
0
votes
0answers
17 views

put second instance of mysql in autostart

System: Debian GNU/Linux 6.0.10 I have two instances of MySQL running on my Server. The default one is (probably) already set in autostart, since there are some files in the /etc/rc.X named S03mysql ...
0
votes
1answer
91 views

mysql high availablity for LAMP application (ubuntu 14.04)

im trying to achieve HIGH Availability (HA) for a LAMP application(News Portal website) which might be of interest to many unfamiliar users.For files im using Glusterfs (replica) for redundancy ...
1
vote
0answers
15 views

Finding out the script causing MySQL failed connections

I see lot of lines in mysql.log Connect Access denied for user 'M'@'localhost' (using password: NO) I am sure I don't have such a user on my system. I need to figure out what script is ...
5
votes
3answers
5k views

Will yum remove mysql-server delete my databases?

My MySQL server has broken down, and I can't figure out why. Trying to do a yum reinstall I get this: Error: mysql-server conflicts with mysql-server I figure that's because the server already had ...
4
votes
1answer
713 views

Linux : Alternative of install_name_tool of MAC in CentOS

I am looking for alternative of install_name_tool of MAC in CentOS. Exactly I want to build MySQL on non default location. Also the shared libraries of the mysql binary should be on non default ...
0
votes
2answers
725 views

What does “task mysqld:xxx blocked for more than 120 seconds” mean?

We are troubleshooting a MySQL issue where some queries are taking a very long time complete and I see many of these entry in /var/log/messages: Jan 28 05:52:15 64455-alpha01 kernel: [2529273.616327] ...
0
votes
0answers
80 views

Disabling strict mode does not take effect from the config file

I am trying to disable the MySQL/MariaDB strict mode in the variable sql_mode. But it doesn´t work. My my.cnf in section [mysqld] got this line: sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" ...
1
vote
1answer
23 views

Tool for migration of service configuration

Is there a tool that handles generic migration of config? For example if I have httpd, postfix, MySQL and users and groups data, is there a tool that can extract the config data for each service so ...
0
votes
1answer
388 views

Creating MySQL database and user without password

I am building a set of bash scripts which basically prepare apache virtual hosts, git repositories and other stuff on a cloud server. So far so good, everything is working, but a big problem occurred: ...
1
vote
1answer
213 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 ...
0
votes
0answers
95 views

/usr/include/mysql/my_config_x86_64.h:653:2: error: #error <my_config.h> MUST be included first!

Hi I am trying to install this software on Cent OS. I am getting the following error. [root@localhost root-master]# make bin/rmkdepend -R -fsql/mysql/src/TMySQLServer.d -Y -w 1000 -- -pipe -m64 ...
0
votes
0answers
89 views

open Mysql connection for long time to execute queries in block

I am writing one script which execute bunch of queries in block. here block means version number, each version have different different queries. I write two shell script. 1 version.sh version.sh ...
0
votes
1answer
12 views

Different DB Package Installation Calls

I've read/seen various DB installation tutorials and one thing often perplexes me... sometimes I see people install both mysqldb & mysqldb-server, or only one or the other. My question is: are ...
0
votes
1answer
62 views

Selectively record commands and output from terminal to MySQL table

In some situations I would like to store complete commands and output from terminal sessions in a MySQL database. Ideally I would just copy the command and output from the terminal to my clipboard ...
0
votes
1answer
110 views

From Mysql query output to retrieve files in the file system and rename the files

I have to call a SQL query from bash that outputs 1000 rows of two columns File_Path (Eg., /opt/files/dest/2.bin) Name_of_the_file (Eg., fax attachment.pdf, invoice.docx... yes, there are spaces). ...
0
votes
0answers
113 views

hooking up dovecot/postfix to mysql on CentOS 7

On a CentOS 7 web server, a java web application with a mysql database needs to be able to process incoming email. This means that each email message received by a specific email address needs to be ...
0
votes
0answers
1k views

completely clean re-install of mysql on CentOS 7

I have encountered problems with a mysql installation on CentOS 7. All the data is backed up, so I just want to completely erase every remnant of mysql on the machine and then do a clean install. My ...
0
votes
1answer
81 views

Apache / php config for production & staging & development

I have a server that has a production server a staging sever and a development server. I maintain code by changing it on the development server testing it. Then staging it and testing it and then ...
1
vote
0answers
98 views

I Need Find A Mac Address from a client connected to my Teamspeak

I have a dedicated server and from it I am running a teamspeak 3 server. In teamspeak server there is a client who need to be banned. I have banned him from teamspeak but if you change your windows ...
0
votes
1answer
320 views

compiling php 5.4 and higher with mysql

i'm running a pile of mediawiki instances on oracle enterprise linux and i'm trying to upgrade from 1.19.x to the latest LTS version, 1.23.x. i'm currently using php 5.3 and due to some odd issues ...
0
votes
1answer
57 views

How to slow down MySQL service autostart on boot (dependency on another service)

I'm running a MySQL database on Debian on RaspberryPi (Raspbian). I would like to use the RaspberryPi as a local MySQL server, but to have the MySQL database datadir outside RaspberryPi's SD card - ...
-1
votes
1answer
438 views

php: command not found on centos

I've currently installed CentOS (6.5 version), nginx, mysql and php. I've tried to navigate to index.php in a browser, and it looks fine, but if I try to run the script via the command-line I get: ...
1
vote
2answers
223 views

Shell: How to uninstall all related packages to a specific one? / Ubuntu

Recently I asked to my hosting provider to reload the OS to Ubuntu 12.04 64 bit minimal assuming minimal would have the minimum required packages installed, but I realized that mysql was installed so, ...
0
votes
0answers
124 views

writing mysql output to file in CentOS 7

I am trying to run the following command from inside the mysql command line client in the CentOS terminal: SELECT Concat('TRUNCATE TABLE ',table_schema,'.',TABLE_NAME, ';') FROM ...
0
votes
0answers
62 views

Sharing MySQL data between Windows and Linux?

I'm trying to share my MySQL database files between a Windows and a Linux distro (Mint). I have a dual boot plus a separate data partition (NTFS). I've tried mounting the partition with ownership on ...
0
votes
2answers
53 views

Substituting \ for \\ in column

I exported a column of thousands of salts from Mysql for hashcat. Every instance of the character \ was replaced with a double character \\ in the exported column. Is there a way to either sed or awk ...
0
votes
1answer
118 views

If I install MySQL-python using pip, does that means that I can use MySQL server/client?

I have installed MySQL-python using pip. Does that mean Mysql has also been installed in my system? If than, how can i access it through terminal command?