An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
1answer
32 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
958 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
181 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
12 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
326 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
895 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
797 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
133 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
73 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
958 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
63 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
32 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
386 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
324 views

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

Current Environment : mysql> show variables like "%version%"; +-------------------------+------------------------------+ | Variable_name | Value | +---------------...
0
votes
2answers
120 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 ...
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
113 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
59 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
58 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
21 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
33 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
9 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
62 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
27 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
205 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
34 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
17 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 ...
2
votes
3answers
95 views

Mysql output format in Bash Script

I'm writing a bash script where I'm using mysql query in that script where the format which I'm getting is quite different. Query: root@debian:~# mysql -u root -ptoor super_market -h 0 -e "select * ...
5
votes
2answers
2k views

Convert mysql count(*) to int in bash?

I'd like to execute this and check if count is 0, 1 or > 1 in bash. mysql -e "select count(*) from mydb.mydb;" The output is: +----------+ | count(*) | +----------+ | 0 | +----------+ I ...
2
votes
1answer
736 views

can not install mysql-server on centos 6.7 32bit . Error: need rpm?

when I try to install mysql-server on centos with this command: yum install mysql-server server replies: Loaded plugins: fastestmirror, security Setting up Install Process Loading mirror speeds ...
3
votes
2answers
8k views

Problem Starting MySQL on new Centos 6 build

I have a VPS with ChicagoVPS that's running Centos 6. Official version of the build is: Linux RedHat 6.5(Final 2.6.32-042stab078.26 x86_64) I followed this guide to add the repository and ...