Questions tagged [mysql]
An open-source, relational database management system.
794
questions
1
vote
0answers
22 views
SSH Tunnel/Reverse Tunnel Question
I am attempting to daisy chain tunnels/ports to access mysql on a secured server. Without opening up iptables, I would like to, from my local machine:
mysql -uadmin_user -p -hlocalhost:8002
and ...
1
vote
0answers
19 views
Port not available on the same network(MySQL with docker)
I have two servers in one network.
192.168.202.5 netmask 255.255.255.0
192.168.202.32 netmask 255.255.255.0
On second server I start MySQL using Docker Compose.
docker ps
CONTAINER ID ...
0
votes
0answers
26 views
How to generate the conection string to mysql-server in linux
I have an asp.net core app with user authentification working fine in my windows machine (I've got MySQL server for windows). I want to deploy it on my Linux machine. Everything works fine except for ...
-1
votes
1answer
14 views
mysqldump have issue in cPanel cron job
To create auto backup of database, I am using this command in cPanel cron job
mysqldump --opt -Q -u {mysql_user_name} --password='{password}' {database} | gzip > /home/[account_name]/db_backup/...
0
votes
1answer
8 views
How to make a Mysql request to get GLPI data?
I have an ip of host where glpi database is installed. I have to make a mysql request to get data from glpi database.
I have also a login and a password.
The basic command like this
mysql -h 192....
0
votes
2answers
106 views
PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/www/html/
I am working with php(7.3) and mysql in linux machine. But I am getting PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/www/html/ error in apache2 log file (/var/log/error.log). I ...
0
votes
0answers
10 views
Error using mysqlfrm to restore database
Good afternoon.
I need to restore a base named "bignew", and I have .frm and .ibd files only. As my SGBD, I'm used XAMPP in a Linux Mint 19.
Reading many posts, I opted for install and try mysqlfrm. ...
0
votes
1answer
46 views
SElinux configuration of symlinked /etc/my.cnf -> /app/program/my.cnf
Please advise me of whether it is possible to configure SElinux context in a way that MariaDB would pick it up.
current configuration:
ls -lZ /etc/my.cnf
lrwxrwxrwx. root root system_u:object_r:...
0
votes
0answers
75 views
mysql taking 100% of CPU
I had a problem with my VPS like a week ago, and I had to completely reinstall it for it to work. It worked, but just for a while.
Everything was alright until now, I really don't know what the ...
0
votes
0answers
25 views
Mariadb running out of memory
I have an old web server that's been running for some time, with regular updates. For the last month it's been crashing every few days. I tracked it down to:
$ dmesg
Out of memory in UB 136: OOM ...
0
votes
0answers
9 views
MySQL Replication from older master to newer slave - Unknown system variable 'binlog_checksum', 'SERVER_UUID'
So, here is the master:
[04:18] [master ~] # mysql -V
mysql Ver 14.14 Distrib 5.5.62, for Linux (x86_64) using readline 5.1
And slaves:
[08:37] [slave1 ~] # mysql -V
mysql Ver 14.14 Distrib 5.7....
0
votes
0answers
26 views
Pacemaker cluster service can't start properly Couldn't mount filesystem
I have 3 nodes MySQL cluster on RHEL 7.5 with DRBD, Pacemaker and after start cluster getting following error. How can I overcome ?
[root@db1 ~]# pcs status
Cluster name: mysql_cluster
Stack: ...
0
votes
1answer
37 views
How to script SSH connection using keypair and password?
I managed to login to my hosting provider manually with this command:
ssh -i /path/to/key-ssh me@mydomain.com
The server then asks for a password, and login succeeds.
Now I want to automate a ...
1
vote
1answer
26 views
How to get CPU usage in MySQL per user? [closed]
I want to know is there anyway to get CPU usage per user in MySQL? for example I have 3 different users 'user1', 'user2' and 'user3'. I want to get the average/real time memory usage and CPU usage of ...
0
votes
1answer
61 views
nextcloud on docker - error initializing database
When starting my nextcloud container with docker-compose up I encounter the error:
db_1_7bb6e5f5b725 | Initializing database
db_1_7bb6e5f5b725 | mkdir: cannot create directory '/var/lib/mysql//mysql':...
1
vote
1answer
78 views
problem with apt upgrade when install MySQL in Ubuntu 19.4
i trying to install mysql in ubuntu 19.4 but i can't upgrade with sudo apt upgrade
this is the output ;
astrix@astrix:~/Downloads$ sudo apt upgrade
Reading package lists... Done
Building ...
0
votes
1answer
77 views
fetch dependencies while install deb with ansible
i'm trying to install mysql 8.0.15-1debian9 on a debian 9 server
the problem is that mysql only provides the latest version of mysql in their apt repository which is 8.0.16-1debian9
however 8.0.16-...
0
votes
0answers
27 views
How much space does it require to install php, mysql and phpmyadmin on CentOS 7? [duplicate]
I use ovh.com self managed VPS. The plan name is 'VPS 2018 SSD 1'. It offers 2 GB RAM and 20 GB disk space. I have only php 5.5 installed. When I try to install phpmyadmin, it throws an error saying '...
0
votes
0answers
15 views
Truncated incorrect DOUBLE value: 'null'
When I am running the query in MySQL from Linux server I got the error i.e Truncated incorrect DOUBLE value: 'null' Same query run in MySQL from Windows server it was working.
UPDATE ...
0
votes
1answer
45 views
sed: Match this comma or that, but not both
I have a huge mysql dump that I'm using sed to delete unneeded rows (very much faster than deleting from table) and each line of the dump is in the format
INSERT INTO table_name VALUES ("somevalue", ...
0
votes
0answers
170 views
Mysql failed because a configured resource limit was exceede CentOS 7
Mysql is down on my vps server and i tried to restart, stop then start, but nothing works.
The error i am seeing every time is this
[root@vps ~]# service mysqld restart
Redirecting to /bin/...
1
vote
0answers
26 views
Having trouble with connecting to MySQL server [closed]
I'm using a Dragino LG01 gateway which is running a Linux system. I want to connect the gateway to a MySQL database (using XAMPP). There is a tutorial for doing this but I am still having problems.
...
0
votes
1answer
11 views
remote mysql login using username / password not working when adding password to command line
I am running the following command to connect to a remove mysql server (it is part of a bash script that will connect automatically)
mysql -h slave1 -u monitor -pvP!KnK4*
And I receive the following ...
0
votes
0answers
1k views
Wordpress site hosted on Digital Ocean - 100% CPU usage
TL;DR - when there's traffic (around 900) our sites' CPU reaches 100%, slow down and crush.
INTRODUCTION
Our company holds more than 40 content websites, hosted on Digital Ocean, using Wordpress CMS....
1
vote
1answer
24 views
How do I capture this mysql output message in a variable?
I have this line in my script:
mysqlinsert=$(/Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot --password=notmyrealpassword << EOF
$mysqlrun)
Despite what it returns, the ...
1
vote
1answer
76 views
MySQL Java connector still using old java version?
Installing mysql-connector-java-8.0.15-1.el6.noarch.rpm (available here ) shows libgcj package as a dependency.
Installing libgcj creates below file:
/usr/bin/gij
$/usr/bin/gij -version
java version ...
1
vote
1answer
355 views
systemctl status mysqld.service shows activating
I have configured MySQL 5.7.25 instance using Linux Generic Binaries on a separate mount point (instead of default locations) on a test server (RHEL 7.4).
The systemd support, in this case, must be ...
1
vote
2answers
62 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
46 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 ...
0
votes
1answer
88 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 ...
2
votes
1answer
335 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
58 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
112 views
How to send data from Raspberry pi to Remote SQL DB without installing mysql or mysql Client
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 or sql client in Pi because the ...
0
votes
0answers
12 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
17 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
31 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).
0
votes
1answer
36 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
321 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
1answer
290 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
106 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
59 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
48 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
30 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
8 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
70 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
39 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....
1
vote
1answer
118 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
29 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
107 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
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-...
