Questions tagged [mysql]
An open-source, relational database management system.
0
votes
0answers
11 views
Save Data From NCAT and update Database
I have a raspberry pi Device in two of my shops which will send data using ncat to my Linux machine at my home via the internet. I need to continuously listen to the TCP port 7070 and update my SQL ...
-2
votes
1answer
17 views
Suppress NULL field from printing anything in mySQL [on hold]
I have a table in mySQL created from phpmyAdmin of type blob.
The fields that are NULL have "Image" being displayed. How do I get rid of this, so it prints nothing? Just a blank cell for place where ...
0
votes
0answers
19 views
LAMP DB-agnostic way to create a DB stack
Is there a LAMP-MySQL (or equivalent) agnostic way to create a DB stack that includes:
DB-user and a relative password
DB with the same name as of the user
Setting a host for the DB (say, localhost)
...
-1
votes
0answers
14 views
Displaying image from MySQL [on hold]
So I am using phpMyAdmin and have created a dummy table with one column of type blob. I have imported on 26kB png file into this.
What I am trying to figure out is how to display my table data which ...
-2
votes
0answers
18 views
How can i change phpmyadmin password. I tried it. But not work.?
First i login to my server using putty.
and this is my server data
uname -or
2.6.32-754.6.3.el6.x86_64 GNU/Linux
.
uname -a
Linux vps-xxx-xxx.example.com 2.6.32-754.6.3.el6.x86_64 #1 SMP Tue Oct 9 ...
0
votes
0answers
28 views
How can i change mysql password. I tried it. But not work.?
First i login to my server using putty.
and this is my server data
uname -or
2.6.32-754.6.3.el6.x86_64 GNU/Linux
uname -a
Linux vps-xxx-xxx.example.com 2.6.32-754.6.3.el6.x86_64 #1 SMP Tue Oct 9 ...
0
votes
0answers
6 views
a lack of DTrace probes of mysql@5.6 installed via brew under macOS
I installed mysql@5.6 via brew (brew install mysql@5.6) under my macOS, but when I run sudo dtrace -ln 'mysql*:::', comparing to Table 5.6 MySQL DTrace Probes there are only a few probes listed,
sudo ...
0
votes
2answers
36 views
I use `ps -ef` find a `mysqld` progress, but how can I know which conf file it using?
I use ps -ef find a mysqld progress, but how can I know which conf file it using?
[root@controller data]# ps -ef | grep mysql
mysql 8901 1 0 15:15 ? 00:00:00 /usr/sbin/mysqld
root ...
0
votes
1answer
23 views
Service mysqld 5.6 keeps starting and stopping on CentOS 6.9
On my VPS, mysqld starts and right after that, it automatically stops and then starts again automatically.
I tried sudo service mysqld stop and it succeeded. After I started it manually and succeeded....
0
votes
0answers
27 views
Bash Parallel MySQL Dump
I have a project on AWS which will eventually have over 100 client databases each estimated in the 1~2GB size. I need to do daily backups of each database via mysqldump not the standard AWS RDS daily ...
0
votes
0answers
13 views
ionice vs nice for mysqlimport
I am trying to import a huge .sql file into a mysql server.
What (if any) is a best option to speed up the process (all other parameters being equal)
reducing the process niceness to -20?
setting ...
0
votes
0answers
16 views
ownCloud with mariadb under docker-not avalable connection
I tried to use official documentation https://github.com/owncloud-docker/serverwith docker-compose. My .env file:
OWNCLOUD_VERSION=10.0
OWNCLOUD_DOMAIN=localhost
ADMIN_USERNAME=admin
ADMIN_PASSWORD=...
3
votes
1answer
446 views
Installing mysql with mysql-apt-config: missing keys
I'm trying to update mysql on my Debian server with mysq-apt-config, but whenever I try to update it with dpkg -i mysql-apt-config_0.8.11-1_all.deb I get a missing keys error.
> dpkg -i /tmp/mysql-...
0
votes
1answer
32 views
htop - why does cpu% much higher than cpu core %?
So I have htop running on my RHEL 7.5 64-bit and noticed something I've not seen before.
I have 4-core and it shows that the % used fluctuates but never over 95% for each one.
However, when I look ...
0
votes
0answers
16 views
shell - mysqldump works with echo but not directly
Im preparing a shell script which will take mysql table dump with where clause.
Im passing table name and where condition from a parameter.
Backup command:
mysqldump -u root-p'pass' db ...
-1
votes
1answer
92 views
RHEL: syntax errors with bash script
I was tasked to do a bash script that can audit logins in mysql.
If you activate the general_log option in /etc/my.cnf, you can register all the activity that mysql does and it get write (in my case) ...
0
votes
0answers
20 views
redhat linux verlihub installation
I tried to install verlihub in my VM but I am facing a problem in Mysql database creation.
1
vote
0answers
19 views
MySQL - query to show guests with same last_name + booking_date [closed]
I have a guest table and a booking table and I am attempting to query how to find guests who share the same last names with the same booking date.
The result should output their last_name and ...
0
votes
1answer
22 views
Is there a maintainable way to install a recent version of phpMyAdmin on Ubuntu 18.04 [closed]
We use phpMyAdmin on a couple of servers running Ubuntu 18.04. Ubuntu ships with PHP 7.2, the latest phpMyAdmin version from the official repositories is 4.6.6, which is not compatible with PHP 7.2.
...
0
votes
0answers
21 views
macOS - MySQLWorkbench “cannot start SSH tunnel manager” only when opened via command line
I'm trying to get two instances of MySQLWorkbench running simultaneously but I'm running into this issue. If I navigate to my applications and double click the application everything works fine and I ...
0
votes
0answers
79 views
face error in installing mysql on AMI linux centos 2017-09
how to fix "Error: Package: mysql-community-server-5.6.42-2.el7.x86_64 (mysql56-community) Requires: systemd You could try using --skip-broken to work around the problem You could try running: rpm -Va ...
1
vote
1answer
121 views
Install MYSQL 5.7 using bash script with Centos
I'm using Centos 7 and trying to write a script that will install mysql 5.7 during a vagrant setup. I know how to change the root password manually, but how do you write this in a script?
I have this ...
1
vote
1answer
26 views
mysqldump on mariadb 10 extremely slow [closed]
I'm running a MariaDB 10.1.34 instance on AWS RDS. Instance specs are as follows:
Instance Class: db.t2.large
Storage: 100GiB gp2
DB Size: 1.2 GiB
I'm trying to create a mysqdump from an EC2 ...
0
votes
1answer
17 views
LOAD INFILE REPLACE Not working as expected
I am trying to import a txt file using LOAD INFILE like below.
LOAD DATA LOCAL INFILE '/home/xxxx/cloud_20181003.txt' INTO TABLE cloud_log_test FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (...
0
votes
2answers
102 views
How to update in mysql database from linux using awk/sed/linux-shell script for?
I have a data file called 'frequency.txt' in two columns, column 1 is 'frequency' it is a number showing a repetition of corresponding column 2 which has ids .
Example:-
Data
frequency, id
32 ...
1
vote
3answers
198 views
How to install php + mysql on Fedora?
I'm trying to install wordpress locally. I've installed mysql (MariaDB) and php-mysqli. I have user created and database from mysql console and I have this 3 files:
$ cd /etc/php.d/
$ cat 30-mysqli....
0
votes
2answers
458 views
error while loading shared libraries: libmysqlclient.so.20: cannot open shared object file: No such file or directory
So I'm running a program a college wrote on debian. When I do, the following error arises:
error while loading shared libraries: libmysqlclient.so.20: cannot open shared object file: No such file or ...
1
vote
2answers
484 views
Error installing mysql-server on Debian 9 Stretch (dependency problems)
Using Debian 9.5, fresh install. I want to install mysql-server, but I run into dependency problems.
sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading ...
1
vote
1answer
50 views
sh script for executing mysql script with entering pass [closed]
I'd like to execute a mysql script where user is asked to enter the password dynamically from the command line.
If possible with a message Enter your $root password
However it doesn't work as expected ...
0
votes
0answers
43 views
installing mysql on ubuntu 18.04, what is root password
I installed MySQL on ubunto 18.04 and it is asking me to root password, but I don't have it.
Mysql version is:
mysql Ver 14.14 Distrib 5.7.23, for Linux (x86_64) using EditLine wrapper
what I ...
1
vote
0answers
105 views
Damaged repomd.xml for mysql56-community when installing mysql
I am getting an error when I try to install mysql. This error says:
http://repo.mysql.com/yum/mysql-5.6-community/el/7/x86_64/repodata/repomd.xml: [Errno -1] Error importing repomd.xml for mysql56-...
2
votes
1answer
31 views
How can I monitor, record and check about the ports on my LUbuntu having been scanned or connected to by other computers?
I have installed some servers on LUbuntu 18.04, such as postgresql server, mysql server, vino server, and I may have installed and run some servers without knowing it. I rarely intend them to be ...
0
votes
1answer
262 views
Cannot access MySQL Database - PID file could not be found
I am using a Linux Server from GoDaddy, and without any known reason, PID file could not be found! These are the errors I got:
# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through ...
0
votes
3answers
50 views
How does a (mysql) process know “its” terminal if not from stdio?
One thing with the mysql program caught my attention. It can be told to ask for password interactively with the -p flag, in which case, as you would expect, a prompt appears in your terminal and ...
0
votes
1answer
21 views
MySQL - OS tied users
So, I'm trying to find this option and I can't find it in the docs. I need to know if there is a way in MySQL in which every user on the OS is also a User on the dB.
Just to clarify, when using ...
0
votes
1answer
11 views
Database Directory storage is full need to change link it to new Partition
My mysql Database Directory size is full. So I want to change it to another partition where there is large amount of space. The database version am using is MySQL 5.7.23 and OS is CentOS 7.
After ...
0
votes
1answer
116 views
Missing mysqld.sock file on linux server
I have this error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
Anyone know what is wrong? It seems it isn't ...
0
votes
1answer
34 views
ERROR 1071 (42000)
I am trying to do this:
CREATE UNIQUE INDEX name_index ON domains(name);
But when I do, I get the error below.
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
I tried ...
0
votes
1answer
121 views
Can access /var/lib/mysql-files but not /home/username/Desktop/temp?
I'm using mysql workbench to export my mysql database table to a .csv file using the statement.
SELECT * INTO OUTFILE '/var/lib/mysql-files/temporary2.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ...
0
votes
0answers
27 views
Migrating a Mysql 5.1 db on Centos6 to a Mariadb 5.5 on Centos7
I have a huge application that I need to migrate. It is currently running on an old Centos6, with MySQL 5.1. The next version of Centos use MariaDB 5.5, and according to the documentation, I should ...
0
votes
0answers
34 views
MariaDB Galera Cluster on Ubuntu 16.04 does not start after rebooting
I've installed a MariaDB Galera Cluster on Ubuntu 16.04 in 2 nodes.
Here the info from node1:
root@localhost:~# sudo more /etc/mysql/conf.d/galera.cnf
[mysqld]
binlog_format=ROW
default-storage-...
1
vote
1answer
30 views
How to DROP database with different case in the name
I tried to drop this kind of database name in MariaDB :
MariaDB [(none)]> DROP DATABASE `db_IRP_rec` ;
ERROR 1008 (HY000): Can't drop database 'db_irp_rec'; database doesn't exist
It seems mysql ...
1
vote
2answers
24 views
How to drop a database with metacharacters in the name
How to drop database with metacharacters in the name. The database name is #mysql50#lost+found.
I'm connecting in mysql as root user. I tried to put backslashes like in a shell command:
MariaDB [(...
1
vote
0answers
135 views
debconf-set-selections does not work in Dockerfile
I'm trying to set a root password for a mysql database in a Dockerfile like this:
(short version)
ENV DEBIAN_FRONTEND noninteractive
RUN echo mysql-community-server mysql-community-server/root-pass ...
0
votes
3answers
100 views
Have two lists, want to exclude list2 from list1
List1:
1,name1
2,name2
3,name3
4,name4
5,name5
6,name6
7,name7 ...
0
votes
2answers
350 views
Error upgrading MySQL 5.5 to 5.6 CentOS 6.6
I wish to upgrade MySQL 5.5 to 5.6 on my CentOS 6.6 server and I am receiving an error after command yum update mysql as per the below output.
I am following the guide here. I have also tried to ...
1
vote
1answer
51 views
Cron Daemon - LibClamAV errors
I have been receiving since a long time following mails:
From: Cron Daemon <root@autisticstory.net>
Subject: Cron <root@cloud-vps> test -x /usr/sbin/anacron || ( cd / &&
run-parts ...
-2
votes
1answer
349 views
Installing MySQL without Root Access on CentOS
I'm trying to follow the instructions here.
1) I can't find CentOS listed as an operating system on the MySQL website. So I downloaded the mysql-8.0.11.tar.gz from the MySQL website:
MySQL Community ...
0
votes
0answers
24 views
How to insert myhostname in postfix virtual via mysql
I'm searching for a way to insert the content of the postfix configuration variable "myhostname" (dynamically) into a mysql query.
See http://www.postfix.org/mysql_table.5.html
Currently I have
...
1
vote
2answers
51 views
Why can't I connect to mysql via the browser but via the terminal with php?
I would like to display a MySQL table in the browser with PHP and created the file demo-db.php
<!DOCTYPE html>
<html>
<body>
<?php
$servername = "localhost";
$username = "...
