Questions tagged [mysql]

An open-source, relational database management system.

Filter by
Sorted by
Tagged with
1
vote
2answers
3k 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
0answers
259 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-...
1
vote
1answer
289 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
1answer
44 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
470 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
1answer
7k 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
3answers
2k 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....
2
votes
2answers
8k 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
2k views

Failed to open the bootstrap file in MySQL

After doing an installation of MySQL Ver. 5.7.10 for RH/Oracle Linux I get an error that during the initialization the bootstrap file was not found. I'm not sure where this may come from, as it is a ...
0
votes
0answers
113 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 ...
2
votes
1answer
55 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 ...
2
votes
2answers
6k 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
3answers
467 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
1answer
384 views

Debian Squeeze/MySQL error

I installed lighttpd and PHP on MySQL using the instructions in the accepted answer here: http://raspberrypi.stackexchange.com/questions/1164/how-to-install-lighttpd-with-php Then I tried to ...
0
votes
3answers
60 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
18 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 ...
2
votes
1answer
4k views

How do I troubleshoot these SELinux AVC errors?

Background: I have a CentOS 6 LAMP server. Recently the server has started to become unresponsive every few days. Originally, mysqld would throw a nagios alert and I would be unable to even ssh into ...
1
vote
1answer
249 views

MYSQL not starting

Here is a my error log file [localhost:local/mysql-5.5.15-osx10.6-x86_64/data] root# sudo localhost.err localhost1.err 130911 14:16:24 mysqld_safe Starting mysqld daemon with databases from /usr/...
1
vote
3answers
472 views

Upgrade MySQL 5.0.88 to 5.1.69

I am upgrading my MySQL installation on a Fedora 10 (and 14) box (in test first.) I have made a system image (it is a VM) and have downloaded MySQL Server Community 5.1.69-1 from the MySQL site. Once ...
0
votes
1answer
345 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
61 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
370 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
655 views

Fun with Ubuntu 16.04 and mysql [closed]

I want to thank you in advance if you manage to get all the way through this post and give me some ideas. It's a lot. I am on Ubuntu 16.04 on a 64bit Dell 1820. It is dual boot with Windows, and I'...
1
vote
1answer
94 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
348 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 [(...
4
votes
3answers
15k views

MySQL not getting started on linux

I need to run MySQL service for my linux 2.16 version with SUSE version 11 distribution. Downloaded the following files and installed all the rpms as under: MySQL-server-5.5.27-1.sles11.i586 MySQL-...
1
vote
1answer
131 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
0answers
399 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 ...
-2
votes
1answer
1k 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 ...
1
vote
1answer
393 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 ...
0
votes
1answer
177 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
175 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
75 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 ...
-2
votes
1answer
38 views

How can I get back to directory line from the MySQL line?

I’m not sure exactly what I did, but I entered into MySQL and now I cannot return to the directory line. How can I leave mysql> cd .. and return to debian@beaglebone:/home$ cd ..
0
votes
1answer
74 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
100 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 ...
9
votes
3answers
16k 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 ...
10
votes
2answers
19k views

High IO wait - How to determine the root cause?

I have a MySQL instance on two dedicated servers. One for the production, the other for the test platform. The 2 servers are pretty the same, the only difference is the RAID controller and the ...
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
2k views

Not able to install php5-mysql or php5-mysqlnd

I'm using Debian Jessie inside a docker container docker run --entrypoint /bin/bash -i -t php:5-apache. Unfortunately, I am not able to install php5-mysql or php5-mysqlnd . I did the following steps: ...
1
vote
0answers
417 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) ...
1
vote
1answer
1k 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
2answers
2k views

Use the output and exit code of a mysql command in an if statement

Early in this script users and their credentials are read into variables. The following code works as intended to check the credentials of a mysql user. lu="test" lp="test-password" ldb="local_db" ...
2
votes
2answers
918 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 needs to be done ...
0
votes
1answer
10k 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 --...
16
votes
8answers
14k views

Encrypt a password the same way mysql does

I've created a user ... but forgotten the password mysql> create user 'blayo'@'%' identified by 'right'; Which Linux command line tool can encrypt the password the same way mysql 5.5 does ? mysql> ...
0
votes
1answer
32 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
1answer
41 views

Mysql cannot make a user [duplicate]

So I am currently running kali linux 4.15.0 and I am trying to run DVWA ( Damn Vulnerable Web Application) I tried making the user as: MariaDB [(none)]> CREATE USER 'user'@'127.0.0.1' ...
0
votes
0answers
373 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-...

1 3 4 5 6 7 17