An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
1answer
28 views

Other Programs Cannot Connect To MySQL

So just recently when installing php-fpm, I had installed a few MySQL packages with it (I believe). I already had mysql installed. However now when any of my programs attempt to access the database, ...
0
votes
2answers
67 views

Can't start mysql service

Trying to start my mysql service. /etc/init.d/mysql start returns: Job failed. See system logs and 'systemctl status' for details. Further: systemctl status mysql.service returns: ...
0
votes
1answer
40 views

Unable to install yum and mysql,ssh

When I go to install mysql on CentOS 6,I get the following error: yum install mysql mysql-server Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached hostfile ...
0
votes
1answer
24 views

Immediately kill MySQL

I have a shared server that someone has compromised Wordpress. Is there an easy way to kill MySQL. I am stopping the service but it is just sitting and waiting.... to stop Shutting down MySQL ...
0
votes
1answer
30 views

mysql jdbc connection issues in RHEL 6

I have setup the mysql database in one of the RHEL 6 servers. I would like to connect to this server's database from any other machine using a java program. How should I do it?
0
votes
1answer
68 views

PHP on centos 6 not working

I have installed PHP, MySQL, Apache on CentOS 6, now I have restarted the Apache and mysql, to test PHP i have created a index.php on /var/www/html/test/ now once i go to localhost/test/index.php then ...
0
votes
1answer
178 views

How to install mysql-server 5.6 on RHEL 5.8 (when MySQL-server 5.0 is already installed)

I want to install mysql-server 5.6 on RHEL 5.8, but when trying rpm -i or rpm -Uvh it complains that I already have version 5.0 on there. I am happy to replace, upgrade or install another instance. ...
0
votes
2answers
51 views

MySQL 5.1.73 - community edition : Where is MySQL configuration file?

I have installed MySQL 5.1.73-community edition in my Oracle LINUX 5 server. I am able to start / stop and execute MySQL commands. But, I am unable to locate the MySQL installation directory as well ...
0
votes
2answers
583 views

WordPress installation with Docker

I have to migrate my WordPress installation to my own server in order to get SSL working properly. (It was originally on GoDaddy shared hosting, which doesn't allow for external SSL cert ...
0
votes
1answer
342 views

proftpd via mysql & web management of FTP users

I have installed prftpd and proftpd-mysql rpm on a linux machine. Intention is to have usermanagement of ftpusers via web. So I have installed proftpadmin from Here Now when I am adding the below ...
0
votes
3answers
120 views

mysqldump should prompt for password

When I'm executing mysqldump command from localhost or from remote host, it's not prompting me for password. I want the password prompt even though I'm running it from remote or from local. On my ...
0
votes
1answer
79 views

why is my php script slower on debian than freebsd?

We moved a web-based application to a new server recently, but the new server seems to run slower than the old one. The old server was FreeBSD 7 with Apache 2.2, mod_php 5.3, and mySQL 5.1. The new ...
0
votes
2answers
145 views

No package community-mysql-devel available

I'm trying to get this package because I need it to build software on CentOS 6, but I'm getting this error: No package community-mysql-devel available I'm logged in as root, using yum. Could it be ...
0
votes
1answer
630 views

MySql not accessible by root user

I have a local MySql server. It is started as I can access it with my local user like $ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 66 Server version: ...
0
votes
2answers
827 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
1answer
1k views

Error at starting mysql because lack of permission on /var/lib folder

OS : Redhat I try to launch the mysql database after a fresh installation. The problem is I am not root on this server and my user have not the permission to write in the /var/lib folder. When I try ...
0
votes
1answer
26 views

Reinstall mysql keeping db intact

basically on my vps somehow mysql.sock vanished in tmp as well lib folder. I want to reinstall mysql but will db get lost?
0
votes
1answer
436 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
1answer
295 views

Mysql server remove/install problem - horribily broken

I'm having the same issue as Ken did on this post. And I did pretty much what Ken did except to different packages. Now, I'm stuck with unclean hooks. I've detailed my problem here and the attempts ...
0
votes
1answer
264 views

Can someone provide an xargs example piping mysql query data into another command?

Can someone provide an example for the command xargs? I want to do a mysql query to return the ID field of a column then feed that result into xargs into another command say mysql query delete. How ...
0
votes
2answers
605 views

Problem with configure and build php 5.2 on redhat 5

I downloaded php binaries and tried to build the same using following command. ./configure --with-apxs2=/usr/sbin/apxs --with-mysql But i'm getting the error related to mysql client library. ...
0
votes
1answer
55 views

Mysql LOG only specific users

I need to set up some logging on my debian squeeze x64 mysql 5.1 Server: 1) logging when users logged in and logged off 2) logging only specific users commands set up logging which will not slow ...
0
votes
1answer
265 views

Debian Squeeze/MySQL error

I am a Unix/Linux noob, so please bear with me. I installed lighttpd and PHP on MySQL using the instructions in the accepted answer here: ...
0
votes
1answer
848 views

Install Mysql 5.6.4 or greater on web server with on CentOS / openSUSE with Plesk 10

I need to install MySQL 5.6.4 or greater on my web server because I'm using the full text innodb feature. I'm trying to move my local installation (WAMP server) to my dedicated server and I'm not able ...
0
votes
1answer
187 views

How to use a password as an external variable in shell?

I have this MySQL backup script that I use to back up MySQL databases. Very useful, and it runs on fixed intervals using a cron. However, I need somehow provide this script with the MySQL password. ...
0
votes
2answers
232 views

Linux (Debian) web server advice

I'm at the start of a new company in which the main activity is building internet web apps. I was very familiar with linux 8-9 years ago, but since then, I've lost a lot of touch with it (couldn't ...
0
votes
2answers
241 views

Installing MySQL 5.5 on Mac OS 10.6

I am trying to install MySQL from source on my Mac OS. I've expanded the source code, and am now trying to configure it. However, I can't get past that step: ...
0
votes
0answers
18 views

How to get ids from xml file into mysql?

I've got 8 xml files and need to do some work on these records in mysql. What is a good way to get these IDs into mysql? <?xml version="1.0" encoding="utf-8"?> <Records> <Record> ...
0
votes
0answers
11 views

MySQLWorkbench entity relationship diagram location [closed]

Do you know where does mysql Workbench store entity relationship diagrams in a WIndows 8 environment?
0
votes
0answers
19 views

Facebook's MySql fail to compile [closed]

I tried to compile Facebook's MySQL, but unfortunately it failed to compile on the latest Manjaro version: $ git clone https://github.com/facebook/mysql-5.6.git $ cmake ...
0
votes
0answers
35 views

Updating data sets from Online databases/Webservice

I want to have an idea as to how to update the data regularly from the source, if its stored locally in your server or local machine.Lets say MySQL database. Source:It will be a webservice data ...
0
votes
1answer
28 views

Moving from InnoDB to TokuDB

I'm running MariaDB 10.0.x and I would like to move from InnoDB to TokuDB. When using ALTER TABLE <> ENGINE=TokuDB; everything goes fine for the Wordpress websites. Unfortunately the Magento ...
0
votes
0answers
20 views

Installing MySQL 5.6 Validate password plugin

So I have installed MySQL 5.6.19 Enterprise Edition and have installed the validate_password.so plugin. My question I have is, Does the MySQL password policy notify the user of what the requirements ...
0
votes
0answers
90 views

Running MySQL in a Docker container

So my ultimate end goal is to run a MySQL Docker container (say tutum/mysql from the public registry) and then link a Gitlab Docker container (say sameersbn/gitlab) to it, where both containers use ...
0
votes
1answer
71 views

Installing mysql-server in vagrant bootstrap shell script (how to skip setup?)

I did try to install mysql-server on my Vagrant Ubuntu 12.04 LTS virtual machine. When I did so, the setup auto-starts. I can see this in the Vagrant output: While not mandatory, it is highly ...
0
votes
0answers
41 views

Why does “Connection Failed: 2002” display randomly on my PHP/MySQL website?

I'm running CentOS 6 with Apache/PHP/MySQL. PS. I'm sort of a novice at Linux, but I did my best to gather info before coming here. I'm now a bit stuck. I recently upgraded PHP to version 5.5.12. I ...
0
votes
0answers
13 views

In Ubuntu, what is the folder in which MySQL's UDF should be installed?

I am using Ubuntu 14.04. I wonder where should I install binary UDF for MySQL. Is there any way to discover the path of the UDF directory? Is there a standard for this in Ubuntu?
0
votes
0answers
20 views

Mysql Cluster Data node not started

I am working on Mysql Cluster in Fedora. I have three Fedora virtual machine. One is Management node and other two are Data node. My Management node started but my Data nodes are not started. When ...
0
votes
0answers
21 views

MySQL Failing Randomly

I have a problem with my MySQL database. consider this scenario: [/] remorseful:root> mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ...
0
votes
1answer
41 views

installing php-mysql on rhel6

I have rhel6 running on my server and installed mysql from Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 64-bit), RPM Bundle. Now I want to host a php site on that machine. And when I run yum ...
0
votes
1answer
38 views

How to reconfigure PHP

We have a new linux server CentOS 6.5 with Plesk. Default PHP is 5.3.3, I have installed PHP5.4 & 5.5 on the server. I am a beginner on linux. Actually, I don't know how to install software on ...
0
votes
0answers
25 views

MySQL is running out of cache

I installed MySQL Workbench on Linux Mint 17. When I enter the i character from keyboard MySQL runs out cache in MySQL query display. Then MySQL shuts down. I would appreciate it if you could help.
0
votes
0answers
239 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
67 views

Rooting Linux via mysql

I have a CentOS 5.6 x86 installed. I have full access to mysql but it seems I have forgotten Linux root password. How I can access the root via MySQL? Is it even possible? Update: MySQL Version is ...
0
votes
0answers
30 views

If a buggy application underperforms, it it possible server tuning could have no affect?

To set the stage, imagine if you will: A read-heavy Tomcat Application with MySQL on Red Hat Enterprise Linux with some problematic Java Class files which resulted in the application performing a ...
0
votes
2answers
49 views

php-mysql not working

I'm running on RHEL6. I have installed php and php-mysql. <?php phpinfo(); ?> is working perfectly. But I can't connect to MySQL is there a way to confirm that php-mysql is not working on my ...
0
votes
1answer
41 views

how can I replace a record in my DB (mySql) by new record?

I have created a shell script to connect to a DB and INSERT IPs and MACs from dhcpd.log file: #/!bin/bash dhcpLogFile="/var/log/dhcpd.log" NumberOfLines=$(awk '/DHCPACK/ { print $8} ' $dhcpLogFile | ...
0
votes
1answer
179 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: ...
0
votes
0answers
72 views

How Linux is implementing case sensitivity and what are its benefits over windows [duplicate]

Please do not mark it as duplicate ... I already read this post I am asking this question here because due to migration from Windows to Linux, I am facing multiple functionalities break. Linux is ...
0
votes
1answer
63 views

Can't seem to connect to my Debian Mysqli Server?

So I have a simple PHP script which I attempted to do something along the lines: $db = mysqli_connect("localhost", "root", "PASSWORD HERE", "database name"); mysqli_query($db, "SELECT STATEMENT ...