Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [mysql]

An open-source, relational database management system.

Filter by
Sorted by
Tagged with
3
votes
1answer
2k 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-...
1
vote
2answers
2k views

Cannot login root user after upgrading MySQL from 5.6 to 5.7

After upgrading MySQL from 5.6 to 5.7, I am not able to log in as root: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I found the following in the log: 2016-10-...
1
vote
0answers
58 views

After rebooting server, service start without special chars

I wrote a simple Java server. This service (java server) connects with a mySQL database. I am connecting to this service with a socket connection. Everything works well when I start my service by ...
0
votes
0answers
70 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
108 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) ...
3
votes
2answers
232 views

How to make Cron run

I am trying to set up cron to run the mysqlauditgrep command (its the MySQL 5.6 Utilities package). The mysqlauditgrep command is in bash. The command I am looking to run is: mysqlauditgrep --format=...
1
vote
1answer
268 views

How to set up Cron to run mysqlauditgrep command for 11AM on Friday

I am trying to set up cron to run the mysqlauditgrep command (its the MySQL 5.6 Utilities package). The mysqlauditgrep command is in bash. The command I am looking to run is: mysqlauditgrep --format=...
1
vote
1answer
2k views

Install MySQL workbench on ubuntu

I am using Ubuntu 9.10 - the Karmic Koala - released in October 2009 I downloaded mysql-workbench-gpl-5.2.33b-1ubu1004-i386.deb from here But when I run this package it show me following error: ...
0
votes
2answers
2k views

Php 5.6 and Mysql 5.6.x on Debian 8.10

Is it possible to run Php 5.6 and Mysql 5.6.x on Debian 8.10?
1
vote
3answers
15k 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....
0
votes
3answers
1k views

Running a web server/database server, need to connect to my servers- how?

I have a database server and web server both running CentOS. My database server will host MySQL and my web server will host Apache. How do I connect to my Linux-based servers? Is there something ...
6
votes
3answers
9k views

Using `nohup` to Import MySQL Dump on Debian Server

I am trying to import a mysqldump file into my mysql database, but my (putty) connection to the server keeps timing out halfway through. I tried to use nohup . . . . & but this doesn't appear to ...
0
votes
1answer
37 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
87 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 ...
7
votes
7answers
21k views

How to install MySQL Workbench on Fedora 21

Is there an easy way to install MySQL Workbench on Fedora 21? I could not find a RPM package and failed at compiling it from source because I am using MariaDB and therefore was unable to install ...
1
vote
1answer
799 views

Yum skip-broken problem

I'm trying to install mysql-connector-odbc using yum. It gives me this error. Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered to Red ...
12
votes
4answers
63k views

Turn off --skip-grant-tables in MySQL

I'm pretty new to using Linux but am setting up my MySQL databases on an Amazon ec2 instance. I followed some directions I found about resetting the user login pass by using the --skip-grant-tables ...
0
votes
2answers
1k views

Cannot Access LAMP Web Server on Ubuntu Server 14.04

UPDATE: So it seems that I can access the website from computers outside of the LAN, it's when I try to pull up from any computer on the same LAN as the server that I get an issue. From what I've read ...
1
vote
1answer
1k 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 ...
0
votes
3answers
2k views

Installation of MySQL 5.7 on Debian 8 fails [closed]

I have a problem installing MySQL 5.7. I downloaded the file here with Windows and put it with ftp in the temp directory of my server, because wget always timed out. Then I executed sudo dpkg -i /...
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
222 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
256 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
33 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
387 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
6k 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....
1
vote
2answers
6k 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
104 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
52 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
5k 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
315 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
383 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
57 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
16 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
3k 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
238 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
467 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 ...
3
votes
3answers
9k views

After fresh install of mysql-server, can't log in with `mysql root -u`

EDIT: I believe this is actually a duplicate of https://askubuntu.com/questions/766334/cant-login-as-mysql-user-root-from-normal-user-account-in-ubuntu-16-04 I used the top answer from that page and ...
0
votes
1answer
325 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
58 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
334 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
623 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
65 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
259 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
14k 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
118 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 ...
1
vote
0answers
354 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
866 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 ...