An open-source, relational database management system.
0
votes
0answers
22 views
Script to run multiple sql inserts
I have a list of several insert statements for an sql table, and rather than inserting them 1 by 1, I wanted to create a sql script to run them.
Problem is, my script can only insert the first ...
0
votes
0answers
11 views
rlm_sql error log in freeradius radius.log [on hold]
I use freeradius with mysql
I see error logs in my radius.log file:
Error: rlm_sql: Failed to create the pair: Unknown value Acceps for attribute Auth-Type
Error: rlm_sql (sql): Error getting data ...
0
votes
0answers
19 views
Error log in radius.log [on hold]
I use freeradius with mysql
I see error logs in my radius.log file:
Error: [sql] SQL query error; rejecting user
If need I can attach my config files also. I don't find any info in google.Version ...
1
vote
1answer
38 views
How can I rebind shortcut for mysql client? — or: How to replace editline with readline for mysql client?
I am using the msyql-client, and I open a mysql prompt on a terminal via:
$ mysql -h localhost -uuser -ppassword
mysql>
I use the msql client version:
Ver 14.14 Distrib 5.7.17, for Linux (...
0
votes
2answers
25 views
How to work around a error in an eclass file located in a Gentoo overlay?
(cross-posting from the Gentoo forum)
I try editing the .eclass file in order to correct the error, but it seems my edits are being defeated by a cache somewhere. The initial error occurs when I run ...
1
vote
0answers
35 views
how to restore a mysql database from full database backup
I have all MySQL databases backup dump file (50 Databases) with in a server, and i want to restore a single database from this dump file.Is that possible? Any suggestions?
Thanks in Advance
0
votes
0answers
14 views
Installation of MySQL in Oracle Linux Cloud compute instance
I have created a compute instance and I am accessing this through Putty console.
As I try to install MySQL in it using the following command
[root@fa8987 ~]# yum install -y mysql
I am getting a ...
1
vote
2answers
43 views
using cat at input file
I have a file created with mysqldump that is 11GB. I need to use the "mysql" command to import it into a database, but I need to add:
USE db1;
at the top. It would take forever to rewrite the file. ...
0
votes
0answers
10 views
MySQL Error in opening ./ib_logfile0
I have MySQL running on an RPi 3. It has been running for several days without any problems under a moderate load.
Today I was working with iptables and ended up knocking out all network connections ...
1
vote
1answer
50 views
Bash script to install website [closed]
First of all, excuse me if this is the wrong place to ask this question.
I made a bash script which installs a DirectAdmin backup into apache.
The steps are working but in the end I get a 500 error ...
0
votes
0answers
10 views
Nextcloud 9.0.51 issue: no “instance id” created at install
I just installed Nextcloud on CentOS 6.8. Since I am on CentOS 6.8, I used a slightly older set of instructions (linked) that lead to an older verion of PHP getting installed (5.3), which led to me ...
0
votes
1answer
29 views
Trying to reset root password on mysql
Okay, so right after installing mysql, the root password given to me in the installation doesn't work. I tried uninstalling and installing again. Same thing. So I said, "let's try and reset the ...
0
votes
1answer
30 views
How can i automate killing processes labeled “Waiting” in MySQL with simple line of bash
I was trying to run following bash line without success, i've tried many variants of the same line without success, hope somebody see the error.
mysql -u user --password=\m\y\p\a\s\s -h myhost -e '...
3
votes
0answers
18 views
How to control mysql with zpty?
I try to write a wrapper script for the mysql console client. While working on this, I stumbled upon zpty. It seems perfect.
My first goal was to retrieve some table contents, but I already fail ...
0
votes
0answers
44 views
504 Gateway Timeout error
I have 2 Apache servers and 2 Loadbalance servers and one File server (CentOS 7) for moodle and I am using maria db cluster.
I want to download some file from students in moodle but I face a problem ...
0
votes
2answers
34 views
Wrong syntax in sql
I have a table called sp_en and this table has 2 columns: "no" and "value".
I want to change "value" of row with "no": 4433 to 1 so I enter the command below:
INSERT INTO sp_en (Say) WHERE no='4433' ...
0
votes
0answers
36 views
Mysql_config_editor + Nagios
I am trying to add a plugin (bash script) to the Nagios, which will use "mysql_config_editor" to send some queries. I set login-path on root. I also set 'root' as the user which runs Nagios plugins. ...
1
vote
0answers
118 views
bash escape exclamation character inside variable with backtick
I have this bash script name test.sh and located in /tmp:
source $HOME/.backmeuprc
databases=`mysql -h$DBHOST -u$DBUSER -p$DBPASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`
the ....
1
vote
1answer
26 views
Unable to find the OUTFILE of mysql query
I have an MySql query from which i generate a OUTFILE (.csv) which i save it in /tmp . Please find the query below :
SELECT 'Artifact ID' id, 'Related Links' new_value UNION select CONCAT(si....
2
votes
0answers
28 views
How to local user login(PAM) with MySQL?
The MySQL server has already been configured and can be remotely accessed from the client.
The client is debian and has installed 'libpam-mysql'.
What additional settings should I set for the local ...
0
votes
1answer
117 views
How to change root password for mysql and phpmyadmin-mint Linux
I have recently installed Linux Mint. I have installed
1) Lamp
2) Set up MySQL
3) Test Apache
4) Test PHP
5) Phpmyadmin
Everything was working fine. Unfortunately my password include $ ...
1
vote
0answers
34 views
mysql workbench for linux deepin 15.3
I have installed mysql workbench 6.3 on linux deepin 15.3, but the program appears to have squares instead of text, as shown in this image , any help please?
1
vote
0answers
15 views
Installing MySQL in CentOS without permissions
I need to install a MySQL that doesn't need root. The reason for this is that I'm a user in a cluster, so I don't want to mess other people work. Said that, is there a way to have a "portable" MySQL ...
3
votes
0answers
54 views
Killing processes in interruptible sleep state?
I'm inserting data from Server A, which is running a Node.js app, into a MySQL database on Server B. I first check for duplicate rows, and then INSERT or not depending on the result.
This process can ...
0
votes
1answer
15 views
Passwords in a LAMP installation on Debian
In a locally installed a LAMP stack, where are the passwords stored? If there is more than one, I only have the MySQL password from the previous installation, but the new one uses the same. Don't PHP5 ...
0
votes
1answer
32 views
Slow response of server
I have a local development server in the local network.
There are many instances of magento sites running there.
Developers work a 5-6 different magento's and when there is such use the server ...
0
votes
1answer
25 views
Multiply instances of MySQL on CentOS 7
I want to run two instances of MySQL on one CentOS 7 machine. And I need to run instances on different users. Reason for this approach is need for limiting resources (CPU and memory) for each instance,...
0
votes
1answer
26 views
how to use a two word password on a script variable?
I'm trying to build a script to automate the backup process for an existing database.
The problem I'm having is passing to the mysqldump command (see bellow) the database password that has two words ...
1
vote
0answers
33 views
How do I decrease the amount of fsync that mysql does?
I am trying to import a database into a slave server. The process is being slowed because mysql calls fsync at a crazy rate. The jbd2/dm-0-8 runs at 80 - 99 % continuously but the throughput is quite ...
0
votes
2answers
72 views
SQL install in Debian Jessie 8.0 failling: “Unable to locate package mysql” but sourcers.list is already configured.
I'm using Debian 8.0 Jessie and trying to install mysql.
My /etc/apt/sources.list is ok but I don't have enough reputation points to post the configurations once only two links are allowed, but with ...
1
vote
0answers
186 views
Problems with upgrading MySQL
In a bit of a mess here. I tried without success to upgrade my MySQL from 5.5 to 5.7. I am running a Mint 17.2 spin. The apt-get failed due to a network error and none of the usual apt "fix" routines ...
1
vote
1answer
59 views
How to setup MySQL with cloud-init?
How can I do this?
#cloud-config
users:
- name: dev
ssh-authorized-keys:
- ssh-rsa AB3NzaC1yc...
sudo: ['ALL=(ALL) NOPASSWD:ALL']
groups: sudo
shell: /bin/bash
packages:
- ...
0
votes
0answers
24 views
mysql.so: undefined symbol: vio_blocking
I'm trying to set up a Rails 2.2.2 installation (for an old app that I maintain) in a new Linux Mint 18 install.
I've installed mysql (5.7.16-0ubuntu0.16.04.1 (Ubuntu)) and, using RVM, have installed ...
0
votes
1answer
73 views
upgrade mariadb 10.0.29+maria-1~jessie failed
using debian 8 with mariadb repository, apt-get dist-upgrade command failed for Mariadb Packages.
Lecture des listes de paquets... Fait
Construction de l'arbre des dépendances
Lecture des ...
1
vote
2answers
78 views
How can I make apache to start up automatically on linux mint?
I have installed Linux Mint 18.1 Serena and I have XAMPP 5.6.28-1 on my computer. After I turn on my computer, I must run the XAMPP control panel and I must start Apache and MySQL manually.
Does ...
2
votes
0answers
34 views
AWS EC2 infrastructure
I was on a job interview today and one question I faced was:
I have my application running within a docker container on an EC2 instance (AWS Linux 64bit). The docker containers we use for the ...
0
votes
0answers
8 views
I have 3 node galeracluster in which out of 3 nodes in 2 nodes mysql services status is Active(running) and in one node it is Active(exited)
I have 3 node galeracluster in which out of 3 nodes in 2 nodes mysql services status is Active(running) and in one node it is Active(exited). And when I
execute
SHOW GLOBAL STATUS LIKE '...
3
votes
2answers
892 views
Is it possible to install mysql 5.7 on Amazon Linux AMI?
I tried installing and I am seeing the error
Error: Package: mysql-community-server-5.7.17-1.el7.x86_64 (mysql57-community)
Requires: systemd
You could try using --skip-broken to work around ...
1
vote
1answer
60 views
EasyApache 4 Migration Issue
One of server is hosting several domains with their wepages mostly in php. Server was running eayapache3 with php5.5. One of the domain asked to enable php5.6 recently. So we migrated the server from ...
0
votes
2answers
55 views
password is always passw0rd? Why?
Per telecomworld:
FreePBX Operator Panel (FOP)
The secret code for performing transfers and hangups in the Flash
Operator Panel is passw0rd (zero not the letter O)
I'm on Elastix 2.5 and am ...
0
votes
2answers
31 views
How to view only the first row or a table in MySQL?
I want to view one row of a table in a MySQL database to see what kind of information is stored in the table. What is the MySQL command and syntax to accomplish this, after > use [database_name] ...
4
votes
2answers
313 views
MySQL root account without password?
I've just installed MySQL server with no password on root account. I was prompted to enter root password 3 times and I left it blank all three times because I don't want to use password. But now it ...
0
votes
0answers
45 views
Move mysql/postgresql from /var/lib using systemd on CentOS 7.2
What's the proper way to move /var/lib/mysql and /var/lib/postgresql using systemd and symlinks on CentOS 7.2, ideally without editing conf files?
I found a way to start both that doesn't use systemd,...
0
votes
1answer
54 views
MySQL install aborts with error
I'm trying to install MySQL on Raspbian Jessie. This has worked smoothly on another machine with an identical setup; however, on the second one, I can't get it to work.
During package configuration, ...
0
votes
0answers
67 views
How to create new MySQL database with encoding via BASH script
I have one bash script for installing wordpress and want to add also mysql installer to easly can install database
#!/bin/bash
dr=$1
db=$2
zDir="latest.zip"
wpInstall="https://wordpress.org/"$zDir
...
0
votes
1answer
104 views
Problems with MySQL 5.7 and reset root password when use mysql_config_editor
I am using MySQL 5.7.17 on Debian Jessie and wanted to dump the database using mysqldump with mysql_config_editor.
The steps I did for the mysql_config_editor. They are:
mysql_config_editor set --...
0
votes
0answers
14 views
Can't configure the 'wsrep' in MariaDB/MySQL?
When I try to set wsrep in "/etc/mysql/mysql.conf.d/mysqld.cnf " like this:
[mysqld]
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_provider_options="gcache.size=256M; gcache.page_size=128M"
...
0
votes
2answers
35 views
Download / Compile local version of mysqldump
I am using a webserver that is administered by someone else. The version of mysqldump on this server is from 2011:
$ mysqldump --help
mysqldump Ver 10.13 Distrib 5.1.63, for debian-linux-gnu (x86_64)...
2
votes
1answer
187 views
MySQL dependencies conflicts
I have installed Cloudera Server and Agent successfully, but I am facing issues installing MySQL.
I have setup a local repository for this installation as I require offline installation.
How do I ...
0
votes
0answers
21 views
Is there an easy way to know what mysql commands are taking so much time?
It looks like I have tons of mysql commands. That increases my disk utilization to 100%
I want to know what the commands are or track things down. I have so many users on my server hosting so many ...
