Questions tagged [mysql]

An open-source, relational database management system.

0
votes
1answer
33 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
63 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
99 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
702 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
62 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
20 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
263 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
1k 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
3k 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
1k 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
239 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
69 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
164 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
40 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 ...
1
vote
1answer
2k 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
53 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
27 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
14 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
265 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
52 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
269 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 ...
1
vote
1answer
37 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
105 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
261 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
196 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
480 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
97 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
645 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
27 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
60 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 = "...
0
votes
1answer
51 views

Which program creates the /etc/mysql directory and its contents?

I was trying to install mysql-server and while trying to set a password I messed up the debian.cnf file and then deleted /etc/mysql hoping that dpkg-reconfigure would recreate it. Now dpkg-...
1
vote
1answer
304 views

mysqld not start after upgrading 5.1 to 5.7 in centos 6.9

I have upgrade mysql 5.1 to mysql 5.7 in CentOS6.9. But now when I try to start mysql, mysql not start File permissions: [root@Intern mysql]# ll /var/lib/mysql total 174104 -rw-r----- 1 mysql ...
1
vote
1answer
75 views

Why give mysql group the same GID as sudo group?

I'm following installation/setup instructions in the MySQL Secure Deployment Guide, which say to create the mysql group with: groupadd -g 27 -o -r mysql The -o permits adding a group with a non-...
-1
votes
1answer
49 views

Risk of keep mysql data folder into linux cache

Is there a risk of doing: vmtouch -dl /mysql-data-folder On a production server with 192GB RAM and mysql data folder of 50GB. What is vmtouch? man vmtouch vmtouch opens every file provided ...
0
votes
1answer
71 views

Download of mysql rpm unauthorized

I've been using this website: https://opensourcedbms.com/dbms/installing-mysql-5-7-on-centosredhatfedora/ as a basis for executing the following command: wget http://dev.mysql.com/get/mysql57-...
1
vote
0answers
1k views

Mysql yum install how to get right dependencies Centos 6.9

I'm trying to get MySql 5.7 installed on a Centos 6.9 system. I've been following instructions here: I've downloaded this rpm: mysql57-community-release-el6.rpm and installed it with this command: ...
0
votes
0answers
82 views

Setting MySQL/MariaDB data directory to a directory in `home`, how can I make sure the `/home` is mounted before mysql daemon starts at boot time

On openSUSE Leap 15, I install MariaDB by: > sudo zypper in mariadb Right after installing MariaDB and right before starting it, I add this line to /etc/my.cnf, to set the MariaDB data directory ...
0
votes
1answer
1k views

Install MySQL Server with prompt for initial password

On Linux Mint, I installed MySQL Server and opted to use a blank password. This means I can't login to phpMyAdmin, as blank passwords are not accepted. I can't reset the root MySQL password either, ...
0
votes
1answer
1k views

Problem installing mariadb

I want install mariadb but i get this error [root@wslb_206]# cat /etc/redhat-release CentOS Linux release 7.3.1611 (Core) [root@wslb_206]# yum install mariadb-server mariadb --> Finished ...
1
vote
0answers
272 views

mysql after sudo su works; mysql or sudo mysql fails

I was visiting a mysql installation (don't know the details) [user@host ~]$ mysql -u kco -p Enter password: ERROR 1045 (28000): Access denied for user 'kco'@'localhost' (using password: YES) ...
6
votes
3answers
9k views

How do I capture a MySQL result set in a bash array?

I'm using bash shell on CentOS 7. I want to run a MySQL query from a shell script and iterate over each row of results. If there were 4 rows returned, I thought I could capture the four rows in an ...
1
vote
1answer
4k views

Requires: libc.so.6(GLIBC_2.17)(64bit) MySql Failure

I am trying to install MySql 5.6 on my Centos 2.6.32-220.17.1.el6.x86_64 but i get this error message. [root@Confluence-Host ~]# yum install mysql-server Loaded plugins: fastestmirror, security ...
1
vote
0answers
181 views

Changing MySQL Temporary File - Permissions Error

At the moment, MySQL Server is using /tmp as it's temporary directory, and I'd like to change that, because it's running into storage issues. Following this post: https://encylia.com/2015/02/06/how-...
0
votes
1answer
4k views

MySQL dump, access denied 1045 with correct username and password

I have created a user callsed "backup" for my MySQL Database, and given it a specific password. and I'm now trying to execute this command: sudo mysqldump --user=backup -password=SuperS3f@kePass --...
0
votes
1answer
27 views

Problem while installing LEMP on Linux Mint

I have been trying to install the LEMP stack on Linux Mint following these instructions: https://www.digitalocean.com/community/tutorials/how-to-install-linux-nginx-mysql-php-lemp-stack-in-ubuntu-16-...
2
votes
0answers
231 views

High Memory and Swap Usage but server running fast

Running a high traffic lemp web server on Centos 7 platform using nginx and mariadb. The server is running very nicely and load avg and cup usage is acceptable but from what I know it should not be. ...
0
votes
1answer
230 views

Why can't I connect to mysql remotely?

I need to configure mysql so I can connect to it remotely. Here is part of /etc/mysql/my.cnf file: [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket ...
0
votes
0answers
239 views

MySQL Bash for loops

I have a bunch of directories created as per "lesson column" example: /tmp/Caldera/ /tmp/Basic Navigation/ /tmp/Signs and Symbols/ I have a bunch of json files example: 0e689686-4f5a-4800-90ac-...
0
votes
0answers
70 views

Do something if mysql command fails

I'm trying to get the below command to do something if sql is not true for filename in test.txt do mysql -N -e "SELECT ROLE FROM SENTRY WHERE ROLE = '$filename';" exitcode=$? if [ $exitcode -ne 0 ]; ...
1
vote
1answer
285 views

MySQL SystemD Logfile Permission Denied

I've installed MySQL 5.6 on a CentOS 7 server and I'm trying to change the error log location from the default /var/log/mysql.log to /var/log/mysqld.err. MySQL is running properly when I use the ...