An open-source, relational database management system.

learn more… | top users | synonyms

2
votes
0answers
28 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
13 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
19 views

getting started with lamp server [on hold]

I have successfully installed LAMP server on my machine running Ubuntu 14.10. Now, there is a location /var/www/html/. In this directory, I am supposed to place the HTML files and php files that I ...
0
votes
2answers
40 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/...
-3
votes
0answers
17 views

PHP application mysql giving error

Got the below error while implementing this. I have done every thing which is mentioned in the document, but still I get this error, previous implementation is working fine. The following error ...
0
votes
0answers
51 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-...
5
votes
3answers
258 views

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

Current Environment : mysql> show variables like "%version%"; +-------------------------+------------------------------+ | Variable_name | Value | +---------------...
0
votes
1answer
42 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
23 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
8 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
34 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 ...
0
votes
1answer
48 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 ...
2
votes
1answer
26 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
12 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
65 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 * ...
4
votes
0answers
114 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. ...
1
vote
2answers
58 views

MySQL Daemon failed to start on centos

I installed MySQL 5.7 in my CentOS and tried to start the service but that gives this error. MySQL Daemon failed to start. Starting mysqld: [FAILED] mysqld....
3
votes
1answer
44 views

Automating Master/Master replication setup and configuration on two servers

I'm in the middle of writing a script to automate configuring MySQL replication between two servers (Master/Master replication), and was looking for some advice on a few things related to MySQL. The ...
0
votes
2answers
43 views

Is the difference between mono-runtime and mono-complete related to whether MySQL inserts successfully take place on Ubuntu 16.04?

What is the difference between 1. sudo apt-get install mono-runtime and 2. sudo apt-get purge --remove mono-complete followed by sudo apt-get install mono-complete on an Ubuntu linux 16.04 instance? ...
0
votes
0answers
19 views

LAMP server Installation - httpd, mysql are 'unrecognized services'

I recently installed Bitnami LAMP server to have apache, mysql and php on my server with redhat 6.7. The installation was fine, I can see httpd and mysql processes; even the wget from localhost ...
1
vote
1answer
44 views

mysql server failed to start

I'm trying to connect to mysql server running on fedora virtual machine. Connection is established. But when I've restarted mysql server with this command : # /etc/init.d/mysqld restart stop is ...
1
vote
1answer
57 views

apparmor: mysql permissions--with no recent changes

UPDATE: I now know my issue was database corruption, but discerning it was somewhat tricky--apparmor appeared to be the cause for longer than it should've. I didn't note when first posting that even ...
2
votes
1answer
529 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 ...
1
vote
0answers
107 views

Can't MariaDB and Mysql install on the same machine?

I have to install Mysql as a metastore for the cloudera HUE. But on that machine, it seems MariaDB is on that machine. I use yum to install yum install mysql-community-server I got this error. ...
0
votes
1answer
45 views

Bash script using mysql command with variables failing

I have a script to clone a vhost and associated db - however one of the mysql commands doesn't work. It fails and ends up outputting the mysql version number and 'how to use' info as if it hasn't been ...
1
vote
1answer
19 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. ...
2
votes
2answers
75 views

No space left on device on CentOS7

My machine which OS is CentOS7 have to backup 50G data into MySQL. But, there is no space left on the device. But there are many spaces on /home. How can I make user that there are enough space for ...
0
votes
3answers
28 views

Does it matter if I'm root or not when installing apache?

I need to install a LAMP stack on a RHEL 6.7 server. Do I have to be root to install this or not?
1
vote
1answer
23 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
votes
2answers
60 views

How to convert a string into a date in a given format

Need a string in '9-2-1832' format in a '1832-09-02' format. Must be able to fill a 'date' type field in mysql.
0
votes
0answers
144 views

Installing mysqlnd for php 5.6 on CentOs 7

I get php warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50547 Library:50624 Also I read that I need to install mysqlnd to my server. I tried do it using: ...
-3
votes
1answer
26 views

How can get back to directory line from mysql line

So I'm not sure what exactly do but enter to mysql and now I cannot return to directory line. I show in picture what exacly I mean: My question is: How can from this directory go in: Here I ...
1
vote
1answer
34 views

SELinux, MySQL, and shared memory

On an SELinux enabled Oracle Linux 6 host, I have a product using MySQL as its underlying database and, through the database, is trying to access /dev/shm. /dev/shm mounts with context tmpfs_t, by ...
0
votes
1answer
467 views

Upgrading mysql caused broken packages

I have Debian Jessie, and MySQL 5.6 from the MySQL Debian repository. This installation installes an apt sources.list.d entry that after sudo apt-get install mysql-community-server, it asks whether I ...
0
votes
0answers
19 views

shell connection mysql connection appears to be blocked

See mysql master-slave synchronization status. I error occurs in connection with the following shell mysql: $(mysql -h${Mysql_Server} -u${Mysql_Slave_user} -p${Mysql_Slave_passwd} -e 'show slave ...
0
votes
0answers
20 views

Automatic Set Up of MySQL

I sometimes have call to install some bespoke software onto Linux systems and am using 'distutils' for this. In addition to this I also install some Python packagers that are not in the default set-up,...
0
votes
1answer
166 views

Can't connect to local MySQL server

I want to run a website from my computer. I use XAMPP on a Kali Linux. I installed MySQL server with the command: apt-get install mysql-server After it successfully installed, I entered the command ...
0
votes
1answer
33 views

Why is crontab executing on one server but not the other?

I have two servers on linode that have some websites on them. I created a script to see if mysql is running on the server and if it's not running then the script will start mysql. The script is on ...
1
vote
2answers
180 views

install mysql - has no installation candidate

I used to install mysql 5.6 in this way.. But now.. # echo "deb http://repo.mysql.com/apt/debian/ $(lsb_release -sc) mysql-5.6" >> /etc/apt/sources.list && echo "deb-src http://repo....
0
votes
1answer
35 views

Backup mysql database via sftp

I have recently messed up my debian server and I have only sftp access for my files. I rescue almost everything except of my database. I have no longer direct ssh access, other than in rescue mode, ...
0
votes
2answers
66 views

Tab completion does not work in MySQL command line client

I've installed MySQL 5.7.10 on my Mac using Homebrew. My Mac is running OSX 10.11.3. When I'm running the MySQL command line client, I cannot tab-complete keywords, table or column names. How do I ...
1
vote
1answer
115 views

curl: (77) pbm with the SSL CA cert (path? access rights?)

I am in root in my directory on CentOS release 6.6 and I want to do the following in order to install mysql in upper version on centOS: rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-...
0
votes
1answer
54 views

Verifying output of a command not quite working via BASH script

In attempting to verify if a remote database exists or not, I'm seeing mixed behavior with a conditional statement. Technically the statement is working (it correctly reports if database is found), ...
0
votes
1answer
56 views

Reroute mysql connection through external machine

I want (as a first step towards an external mysql proxy) reroute traffic from the local connection of mysql (on a VM) to an external proxy (on the host) which then routes it back to the VM which will ...
0
votes
2answers
42 views

How to automatically feed two arguments to program after startup? [duplicate]

I have this following script which works fine on ubuntu for starting and creating a new table for MySQL database: echo "CREATE DATABASE database_name" | mysql -u root -p After this command is ...
0
votes
2answers
38 views

how to create table with fields in command line Centos

How do I do this in command line? Below is code i saw imported to PhpmyAdmin but i don't use any interface... CREATE TABLE IF NOT EXISTS `products` ( `id` int(11) NOT NULL AUTO_INCREMENT, `...
1
vote
1answer
38 views

Silent MySQL Server installation

I want to install a mysql-server on a Raspberry Pi (Debian) using a SSH-connection and a bash script, which contains the installation commands. The point is, that the installation need to be done ...
1
vote
0answers
66 views

Systemd: Running a script before msyql stops on shutdown

On my Ubuntu 14 vagrant box I use this upstart script to run automysqlbackup on every vagrant halt: description "run automysqlbackup" start on stopping mysql task exec automysqlbackup So ...
0
votes
0answers
15 views

How to configure sympa with plesk root access using mysql usename admin@localhost?

I'm trying to use MySql, but username is admin@localhost. It was root but plesk changes it to admin. I also tried PostgreSQL but after it asks for the root password there is another request to access ...