Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql]

An open-source, relational database management system.

1
vote
2answers
27 views

Why does mysql server not accept nonlocal connection request, but still listen on a tcp port?

A mysql server with default settings is listening on a port on a machine: $ nmap -p0-65535 192.168.1.97 Starting Nmap 7.60 ( https://nmap.org ) at 2019-03-20 14:34 EDT Nmap scan report for ocean....
1
vote
1answer
41 views

Why is mysql server accepting nonlocal request, while postgresql server is not?

By default configurations, why is mysql server accepting nonlocal request, while postgresql server is not? $ nmap -p0-65535 192.168.1.97 Starting Nmap 7.60 ( https://nmap.org ) at 2019-03-20 14:34 ...
-1
votes
1answer
16 views

What are the contents inside .frm,MYI,MYD files in mysql [closed]

What is inside .frm, MYI, MYD files in mysql
0
votes
1answer
27 views

Not able change MySQL password on the mac

I forget my MySQL password. and I followed almost all the ways on the Google. But I'm still not able to change MySQL password. and I correctly wrote commands. What's the wrong with this? I really ...
1
vote
1answer
75 views

Ubuntu 18.04 LTS: Problem with dependencies installing MySQL 8.0 server

I'm trying to install MySQL on Ubuntu 18.04. To do that, first I have donwload the package with the command: wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb And then, run the ...
2
votes
1answer
53 views

How can I find out information about a service?

$ nmap -p0-65535 192.168.0.142 Starting Nmap 7.60 ( https://nmap.org ) at 2019-03-10 17:53 EDT Nmap scan report for ocean (192.168.0.142) Host is up (0.000031s latency). Not shown: 65531 closed ports ...
0
votes
1answer
33 views

How to send data from Raspberry pi to Remote SQL DB without installing mysql or mysql Client

Hi I am new to Linux environment I would like send some port checking data and a timestamp ( both saved as a variable) to my remote Mysql DB running on a linux Node machine . I don't want install sql ...
0
votes
0answers
8 views

How to set up query-cache-type in Percona server 8.0

I installed Percona server 8.0 on Debian 9 with memory 1 G. When I set up these in my config file : query-cache-type = 0 query-cache-size = 0 I got this error: [Server] ...
0
votes
0answers
8 views

How to safely handle gtid_purged when adding replication channel, but len(GTID_PURGED) > 1024?

I'm adding a channel to a multi-master mysql slave. In the past, the procedure has been: import new db from a mysqldump, stop slave, record value of gtid_purged, reset master, manually set ...
0
votes
1answer
26 views

Is there a way to retrieve a root mysql password (no reset)

Is there a way to get back / retrieve a mysql root password. I mean get it back : not resetting it (I already know how to reset it and I use the reset method currently).
1
vote
1answer
21 views

Incorrect syntax near '@DB_DATABASE_NAME'

I'm trying to create a MySQL database and tables by sending commands to mysql(1) through a text file. The file is simple: $ cat test.sql SET @DB_DATABASE_NAME = "test_db"; SET @DB_TABLE_NUMBERS = "...
2
votes
0answers
92 views

MySQL Workbench and multi hop ssh tunnel

I have an issue with MySQL Workbench. This is how my connection looks like: laptop => bastion:22 => machineX:22 (10.10.10.10) => mysql:3306 So, I have two hops before I can reach the ...
2
votes
0answers
93 views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) but I have a password in place

I have been trying to install phpmyadmin on my Debian 9 (stretch) system, I already have apache, php and mysql installed and working. When I run sudo apt-get install phpmyadmin it downloads but the ...
1
vote
1answer
89 views

PhpMyadmin times out with small SQL file

I am trying to upload bump to phpmyadmin, which has has only 2MB but it has 12 thousand lines. I always get this error: Service Unavailable The server is temporarily unable to service your request ...
0
votes
0answers
29 views

mysqladmin generates “error” messages

Some time ago I installed NGINX, php7, mariaDB and Wordpress on my Raspberry Pi running Raspbian. I created a Wordpress database - which is working. Recently I installed ssmtp and mailutils on my ...
0
votes
1answer
45 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) ...
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
7 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
44 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
27 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
42 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
17 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
39 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
970 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
86 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
19 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
94 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) ...
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
29 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
37 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
91 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
329 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
42 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
172 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
507 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
1k 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
899 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
99 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
50 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
137 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
37 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
629 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
52 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
13 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
196 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
41 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
188 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
37 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 ...