An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
2answers
14 views

Installation of MySQL 5.7 on Debian 8 fails

I have a problem installing MySQL 5.7. I downloaded the file here with windows and put it with ftp in the temp directory of my server, because wget always timed out. Then I executed sudo dpkg -i /...
0
votes
0answers
16 views

Secure LAMP server [on hold]

I need to systematically secure/harden my LAMP server, Apache Postfix vsftpd MySQL sshd ... I have taken rudimentary steps; such as changing the port for sshd and using SSL for my site. But ...
-2
votes
1answer
35 views

How to read database name from file in shell script [on hold]

Is it possible to read MySQL database names from a file in a shell script to process multiple queries using the same database name? My Script is .. #!/bin/sh echo "----------------------------------...
3
votes
4answers
6k views

Cannot install mysql-server-5.5/the following packages have unmet dependencies

I'm using Ubuntu 14.04. I tried entering mysql with the following command: mysql -u root -p and I got the following message: The program mysql can be found on the following packages: mysql-...
0
votes
0answers
6 views

how to reduce the updated query and insert query in Execution time using mysql [on hold]

I Have 7lac records i have updated and inserted two tables but more time taking like 3h please give me solution.
0
votes
1answer
37 views

How to open mysql backend

I just installed mysql-server with sudo apt-get install mysql-server. How can I open the webinterface now from the browser? I did not found anything in the wiki. On windows with xampp I just had to ...
0
votes
1answer
960 views

Sending emails from AutoMySQLBackup from Linux Mint

I have set AutoMySQLBackup on a Linux Mint machine and I want to have the backups sent to an email, but I cannot make it work. I'm new to Linux environment and don't understand it very much. I ...
2
votes
2answers
182 views

MariaDB client has no prompt in Emacs sql-mode

I just upgraded from an old MySQL client to mariadb-clients-10.0.21-3 on Arch Linux. After the upgrade, I no longer see a prompt when using Emacs's sql-mysql function. It seems mysql is buffering ...
1
vote
1answer
1k 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
15 views

mysql service restarted during user being connected lead to failing service

I have performed a charset change via my.ini into utf8 and forgot a user loggen in in another terminal session, when I performed a service restart. Initially systemd reported a problem stopping the ...
1
vote
3answers
329 views

MySQL server on Ubuntu fails to start after changes made to my.cnf in Windows

I have MySQL 5.5 running on Ubuntu Server 12.10. When I run /etc/init.d/mysql restart, I get the following: mysql start/running, process 2754 However, when I open /etc/mysql/my.cnf in Windows via a ...
1
vote
1answer
36 views

Keeping services on EC2 alive

I'm using a MySQL database and Apache server with an AWS EC2 instance running AWS Linux. I start them both using the service command, but I am not familiar with any other tool that would come pre-...
5
votes
1answer
909 views

I get the Error “mysqld dead but pid file exists”

I get the Error mysqld dead but pid file exists This happens every couple of hours. If I restart it works fine and then goes down again. [root@ip-10-0-0-149 log]# df -h Filesystem Size Used Avail ...
0
votes
1answer
798 views

error on opening mysql workbench on fedora 23

I have installed mysql-workbench on Fedora 23 Virtual machine (VMware) using the command : yum install mysql-workbench Now when I tried to issue the command mysql-workbench from terminal I am ...
1
vote
1answer
137 views

How to update apache, mysql, phpmyadmin and php on Raspbian?

I have my own web server running on my raspberry pi, and all my programs are outdated. I would like to update my PHP, Apache, MySQL, and phpMyAdmin. Can anyone tell me how to update all of these? I'm ...
1
vote
2answers
74 views

A script to take data from csv file and perform related operations in a database

I am new to the world of shell scripting and don't have much idea of shell scripting . My work requires me to write a script which takes phone numbers from a list of records stored in an CSV file . ...
0
votes
1answer
19 views

Running a series of scripts in MySQL

I have files named like: File1_01.sql File1_02.sql File2_01.sql File2_02.sql I need to run all the scripts for File1 first (but these can be done in parallel), then all the scripts for File2. What'...
0
votes
2answers
289 views

Linux (Debian) web server advice [closed]

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 ...
2
votes
1answer
1k views

How can I install mysql on an angstrom distribution?

I tried using a different distribution (debian) but the rest of my application did not work. I've tried opkg install mysql-client and opkg install mysql-server however I get the error Unknown package ...
1
vote
6answers
972 views

I can not install MySQL using yum on Centos7

I've installed centos7 recently, but, when I am trying to install MySQL using the command: yum install mysql-community-server I keep getting Exiting on user cancel while I am not hitting any ...
3
votes
1answer
166 views

How to interpret the following pattern of uptime data?

I have a small web server running mysql and wordpress which after a while appears to stop processing web requests. I can't even log into the server via ssh as ssh client times out when trying to ...
4
votes
1answer
3k 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
2answers
66 views

Suppress warning messages from MySQL in shell script but allow errors

My log files are getting dumped with following message while running shell scripts using some underlying MySQL commands. Here is the message: "Warning: Using a password on the command line ...
4
votes
2answers
2k views

Debian 8 - Install lastest version of MySQL

After downloading MYSQL APT Repository at http://cdn.mysql.com//Downloads/MySQL-5.7/libmysqld-dev_5.7.11-1debian8_amd64.deb I ran the command dpkg -i libmysqld-dev_5.7.11-1debian8_amd64.deb ...
1
vote
1answer
2k views

Why don't I see the XAMPP page on Linux Mint?

I am trying to install PHP MySQL on Mint 12. I downloaded and installed XAMPP. According to the tutorial, when I go to localhost in a browser I should see this: Instead, I see: It works! This is ...
2
votes
3answers
4k views

Troubles installing php with MySQL support

So I wasn't sure if this question would go best here or on Overflow or Server Fault, but decided to try here first. I'm installing LAMP on a VPS, and am running into issues configuring and building ...
2
votes
0answers
35 views

apt-get commands won't return

I am working on a Raspberry Pi running Raspbian, and I think I'm having a problem with my apt-get. The problem originated with a MySQL server I was running. The server stopped seemingly at random, ...
0
votes
0answers
14 views

Log Slow Query not working

I'm trying to log slow query, here's my mysql config on /etc/my.cnf: [mysqld] slow_query_log = 1 slow-query_log_file=/var/lib/mysql/slow_queries.log long_query_time = 5 log_queries_not_using_indexes=...
-1
votes
0answers
24 views

unable to insert a row in mysql [migrated]

I am using LAMP server and a PHP script to connect to an existing Mysql server (local server i.e. host=localhost:3036). I have created a table called depositor using $sql2="create table depositor(...
0
votes
1answer
391 views

Disable MySQL startup in Linux

I have KDE, and it has software to manage startup packages. But, I don't see any mysql, mariaDB or mysqld service. How can I disable or prevent the mariaDB and mysql daemons from starting ...
0
votes
1answer
2k 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 Library:...
1
vote
2answers
2k views

Installing MySQL on CentOS throws error that cannot find mysqld.sock

I have yum install mysql in CentOS 6.4. Now, when I use mysql command, it throws the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld....
0
votes
1answer
22 views

How can I get Wordpress functioning from its new address?

I have a Wordpress installation which I wish to redirect from http://dev.example.com to https://example.com I can get an unstyled page like the below; the browser balks at loading HTTP content for an ...
5
votes
3answers
339 views

How to change MySQL 'root' password using MySQL v5.7?

Current Environment : mysql> show variables like "%version%"; +-------------------------+------------------------------+ | Variable_name | Value | +---------------...
0
votes
2answers
141 views

How to install specific mysql 5.6.21 version on redhat?

My requirement is Mysql 5.6.21. I tried to install Mysql but it installed 5.6.31 version. I tried following steps: $ yum repolist all | grep mysql It gives following output: mysql55-community/...
0
votes
1answer
2k 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
0answers
119 views

yum install error nothing to do (MYSQL, CentOS 7)

I'm trying to install MYSQL instead of MariaDB on my VPS CentOS 7. I used this command: wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm yum install http://dev.mysql.com/get/mysql-...
1
vote
1answer
1k views

Mod_Auth_MySQL will not compile under Slackware 13

I tried to add the auth_mod_auth (3.0.0) module to my Slackware 13 (apache 2.2 & MySQL 5.0) system. I ran the usual command line for apxs (as mention in the BUILD file) apxs -c -L/usr/lib/mysql -...
1
vote
1answer
3k views

MySQL aborting during initial db installation

Linux version: shell> cat /proc/version Linux version 3.2.0-4-686-pae (debian-kernel@lists.debian.org) (gcc version 4.6.3 (Debian 4.6.3-14) ) #1 SMP Debian 3.2.46-1+deb7u1 Installing MySQL 5.6....
0
votes
1answer
63 views

Install mysql-server 5.6 on Debian Wheezy

I had a messy mysql installation on my Debian server. I got rid of everything using the dpkg --force all --purge packet on any mysql packet I could find (mysql-common, mysql-server, mysql-client, ...
0
votes
1answer
59 views

CentOS define same date and timezone for system and MySQL

I was watching that my droplets have different timezone between OS and MySQL. By default, I've configured all vms to Brazilian timezone (America/Sao_Paulo) through tzselect, and, assuming that MySQL ...
1
vote
1answer
24 views

PHP does not use MySQL default sockets

I am having a hard time understanding why PHP cannot connect with localhost as a host. I can connect by doing: mysql -uroot -p And also, through Sequel Pro I can connect with localhost as a host. ...
0
votes
1answer
35 views

Couldn't connect to Larvel homestead database with MYSQL workbench

I am unable to connect to laravel homestead via mysql workbench here is how i connected but i am facing the below issue Plz Plz help me !!! Edit: Here are the details as requested by Gerath ...
0
votes
0answers
11 views

Pmacct resource usage and remote data push capability

Firstly, I am interested in hacking pmacct into some Asus router firmware (n14U). I will build it from source, etc so that should be big deal. However, I am a little concerned about the resource usage ...
1
vote
0answers
67 views

Using yum to upgrade from MySQL 5.1.73 to 5.7.13

I've picked up an IT role and I'm new to yum so please forgive me. yum list shows these mysql packages installed: mysql.x86_64 5.1.73-5.el6_6 @base ...
1
vote
1answer
29 views

Munin mysql plugin silently fails

I installed this Munin MySQL plugin on a RHEL 6 machine and I'm experiencing a strange behavior. I'm not getting any data in the Munin web page (the Categories list does not show a mysql link), but ...
1
vote
1answer
210 views

Reducing Number of MariaDB/MySQL Threads

So I'm running a MariaDB 10 database on a single core server; not super powerful, but then my needs aren't huge either. However, one thing I've noticed is that if I look in htop I have around 28 ...
4
votes
0answers
119 views

Using a NFS for gcc, Apache, PHP, MySQL, glibc

I have 7 SLES VM. I am compiling always the newest version of gcc and all dependencies. Apache and all dependencies. PHP and all dependencies. MySQL and all dependencies. glibc and all dependencies. ...
2
votes
1answer
36 views

MySQL command line - bind <UP> key to a backward command search

With mysql command line client on Ubuntu 14.04 I could bind UP to a backward command search by adding the following lines to ~/.inputrc # type a word, hit up and a search is performed # "\e[A": ...
0
votes
0answers
18 views

How to force rsyslog ommysql use UTF8?

I'm using ommysql in rsyslog for transferring data into MySQL $ModLoad ommysql local6.* :ommysql:localhost,Syslog,rsyslog,1 but Cyrillic data goes like "·Ð¾Ð²Ð°Ð½Ð¸Ðµ иÑ�точнÐ" in ...