An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
2answers
166 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
1answer
1k 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
775 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
150 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
1answer
4k 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
1answer
4k 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
579 views

Python Web interface for simple mysql database

We need a new web interface for our internal car booking system, which is implemented in mysql database. Could somebody please advise, what would be a suitable solution (which framework, if any). The ...
0
votes
1answer
29 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
2answers
3k views

What caused my CentOS 6.4 box to reboot itself?

I noticed that the MySQL daemon running on my CentOS 6.4 machine was suddenly not running anymore. I checked the MySQL log, but didn't see anything relevant: 121229 22:17:45 mysqld_safe mysqld from ...
0
votes
1answer
395 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
359 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
1k 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
59 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
342 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
199 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
268 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
253 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
1answer
17 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: ...
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
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
163 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 ...
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
104 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
114 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 ...
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
200 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 ...
0
votes
1answer
20 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
57 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
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 ...
0
votes
1answer
40 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 ...
0
votes
1answer
68 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
20 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 ...
0
votes
2answers
90 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
144 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 ...
0
votes
1answer
94 views

php server can't connect to the remote mysql server

We have two servers. server 1 and server 2 they are running with Directadmin / CentOS6 my plan: server 1 is running php and html, images...etc. server 2 is running mysql and phpmyadmin They are ...
0
votes
1answer
49 views

MySQL: connection refused…coudn't find mysqld.service

I am trying to install MySQL onto a Fedora 14 VM. I successfully installed it using yum install mysql mysql-server after which I tried to start it with systemctl start mysqld.service which ...
0
votes
0answers
116 views

HAProxy with Roundrobin working only on 2 of 3 MySQL servers, why?

Good day. I'm following this article to configure HAProxy to balance with roundrobin between 3 MySQL servers (db1, db2, db3) in a MariaDB Galera cluster (working perfectly). However I have a ...
0
votes
0answers
814 views

Error starting MySQL in a MariaDB Galera cluster in CentOS 7

I'm trying to setup a MariaDB Galera cluster following this tutorial exactly as it is, and I'm stuck in the Step 7– Initialize the first cluster node, I'm doing so with sudo /etc/init.d/mysql start ...
0
votes
1answer
61 views

Rebooting Centos Servers configured with MYSQL Master/Slave Replication

Sometime ago we configured MYSQL replication on our main web server to another CentOS 6 server. All is working perfectly and we can see the replication is working fine. My question is how to safely ...
0
votes
1answer
47 views

Looking for an email server that supports mysql ssl connection

I am trying to secure connections to my MySQL server. I have SSL set up but I am looking for programs that support a SSL connection to MySQL. Specifically I am currently looking for an email server ...
0
votes
2answers
259 views

import .sql file into a remote server from a local machine

I've created a database in the remote machine. Currently, the database is empty and I need to import using a backup(.sql) file. The backup file is in my local machine, it is a 40gb file. And the ...
0
votes
1answer
133 views

Mysql exited with status 1 and restarted every 24 hours? How to debug?

After upgrade, MySQL on Ubuntu 14.04 keeps crashing and is restarted every 24 hours according to the dmesg. I would expect to some reason for the failure in MySQL logs, but all are empty. Any ideas ...
0
votes
1answer
177 views

Chromebook crouton LAMP

I'm trying to install a LAMP stack on Ubuntu through crouton on a Chromebook (Acer c720p). I was able to install the following packages apache2 mysql-client mysql-server php5 libapache2-mod-php5 ...
0
votes
0answers
319 views

Installing owncloud8 on CentOS 6

I'm trying to install owncloud 8 on CentOS 6 - the problem is that the default CentOS repos have only php 5.3 - but owncloud 8 requires php 5.4. So following this guy: How to install Owncloud on ...
0
votes
0answers
23 views

MYSQL dump of tables that start with docs_ from one server to another

The headline says it :) I would need script that dumps all tables from 'ads' database on different server(s2) starting with 'docs_' copied to my server(s1). Any hints? The reason that I need script is ...
0
votes
0answers
119 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
2k 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 ...