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]

MySQL is an open-source database owned by Oracle.

0
votes
0answers
10 views

WAMP Server: Apache PHPMyAdmin login screen not showing

I have recently setup a WAMP server (Windows, Apache, MySQL, PHP) and i'm having trouble setting up PHPMyAdmin. I didnt use XAMPP for any of this, i installed the services directly onto the server. ...
0
votes
1answer
10 views

Fastest way to move Innodb database from one server to another

I understand I can use mysqldump or xtrabackup to move InnoDB from one db to another. Considering I am okay with server down time, are there better way to move InnoDB database? I have tried copying ...
0
votes
0answers
11 views

Zabbix Performance (history syncer 100%)

Since November 2018 we have performance problems with Zabbix 3.4.10. Since this time, we made tuning for tcp connections, tuning in the OS (CentOS 6.9), tuning in the MariaDB conf, tuning in the ...
0
votes
1answer
26 views

mysqldump cron job runs in terminal but not cron tab

I have this cron job, /usr/bin/mysqldump -u username -p'password' MyDatabase > /backup/CronBackup/MyDatabaseBackup.sql &>/backup/CronBackup/cronBackupLog.log I have been through this page: ...
0
votes
0answers
12 views

Mysql corruption on MacBook Pro [on hold]

The last few days I am experiencing constant mysql crashes looks like the database corrupts ant than mysql constantly restarts but is unable to be stable. I have checked the disk but looks ok. I would ...
1
vote
1answer
33 views

How to Solve unknown_ca error on WSO2IS-5.7 when using MySQL RDS as backstore?

I've tried to install an instance on AWS using aws RDS as my datasource through the mysql-connector-java-5.1.45-bin.jar with jdbc url jdbc:mysql://< instance>.< zone>.rds.amazonaws.com:...
0
votes
1answer
32 views

Unable to run mysqldbexport with --export=both on windows 10 My SQL 8.0.16

I am trying to export data and ddl using the mysqldbexport using the following command mysqluc> mysqldbexport --server=user:passowrd@localhost:3306 --export=both --bulk-insert world --output-...
-1
votes
2answers
59 views

Can not import table to MySQL database on linux

I am trying to install cacti. When I want to import mysql_test_data_timezone.sql to MySQL database on Linux CentOS, I get an error. My command is mysql -u root -p mysql < /usr/share/mysql/...
1
vote
1answer
50 views

Connection conrol MySQL on RDS

I am trying to implement a connecton control/login failure audit on MySQL RDS instance but my MySQL CONNECTION_CONTROL PLUGIN isn't capturing and storing the attempted login failures. I installed the ...
0
votes
1answer
28 views

Prevent MYSQL users reading status of global variables

Is it possible to prevent a user from reading status or global variables via SHOW VARIABLES; or SHOW STATUS; the same way it is possible to restrict privileges on reading or acting on a table or ...
-1
votes
0answers
17 views

Mysql high ram usage [closed]

I try to optimization Mysql. There is no problem, but high ram usage. Plesk panel shows high ram usage warning. Where am I making a mistake? Do you have any suggestions about optimization? For both ...
1
vote
1answer
62 views

Should I use public IP or private IP for connecting servers within the same VPC?

I have 2 Linux servers on AWS. Both servers are in the default vpc (aws default vpc). Both of these servers have their own Elastic IP. I also have a webServer which is inside the same vpc. I want to ...
-1
votes
1answer
49 views

mariadb service fail to start after reboot

I'm trying to get mariadb 10.2/10.3 to work on a fresh installation of ubuntu server 6.04 which comes with mysql 5.7. The installation process goes fine and everything works fine untill I reboot the ...
1
vote
0answers
19 views

AWS : Replicate Amazon Elastic search and RDS

We are working on an AWS system where we are using Amazon RDS for database purposes and ElasticSearch for indexing. We have a requirement that we require weekly backup of both the services along with ...
0
votes
0answers
10 views

sqlcounter expire_on_login mysql freeradius

sqlcounter expire_on_login mysql freeradius rlm_sqlcounter I'm trying to set access period time by first login of client first I enable sqlcounter module in mode-enable folder OS version: Ubuntu 18....
1
vote
1answer
91 views

AWS RDS DB Connections 90+

I have a single db.m5.large RDS instance running in my aws setup. When I check for max connection from mysql console, with bellow query. mysql> show variables like 'max_connections'; ...
1
vote
0answers
62 views

MySQL does not replicate, but it connects

I'm new to the subject. My problem is this: I am working with Bykom MySQL, on the one hand I have a working server and on the other hand I have an administrative server. In the administrative server I ...
0
votes
1answer
63 views

How to get MySQL resource usage per user

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 ...
1
vote
2answers
82 views

MySQL server sporadically runs rampage

I'm faced with a baffling problem where mysqld sporadically gets in an awkward state of very high CPU usage (several hundred threads, all fighting for CPU time) and quick memory accumulation (to not ...
0
votes
0answers
21 views

Azure mysql server portal shows 150 GB extra used space than actual db size

I'm using azure mysql database, Azure portal shows total of 350 GB of used space but when I analyzed using schema inspector the total size used is 205 GB. what might be cause of extra storage. My ...
1
vote
1answer
80 views

Amazon Aurora read-only slaves slowly increase to 100% CPU and die

We have a master database instance hosted on AWS Aurora (mysql) and have many read-only slaves being replicated from it. The master and the 4-12 autoscaling slaves are currently of db.r4.4xlarge size ...
0
votes
0answers
12 views

Mysqld stuck while changing root password

I'm trying to reset root user password of MySQL 8.0.16 in windows 10, but it stuck at middle. PS C:\tools\mysql\current\bin> mysqld --init-file=C:\\mysql-init.txt --console 2019-05-07T10:05:49....
0
votes
0answers
21 views

Liunx based Azure PHP App service is missing MYSQL Driver

I'm trying to host WordPress website on Azure Linux App service. I got this error: Your PHP installation appears to be missing the MySQL extension which is required by WordPress I searched ...
0
votes
0answers
20 views

How install Azure phpmyadmin on Linux App service

I have a Azure Database for MySQL resource. I want to use phpmyadmin while I'm using Linux App service which doesn't contain Extentions. How to install and use phpmyadmin without extra cost, Note ...
0
votes
1answer
31 views

Mikrotik + Freeradius + Mikrotik-Address-List

I have Mikrotik which works like PPTP server and Freeradius for authentication and authorization. How to assign PPTP user's IP or name in Freeradius (user1 = 10.11.1.145 in my case) with Mikrotik's ...
0
votes
1answer
31 views

AppArmor causing mysql to stop?

We have two Ubuntu instances both having MySQL server. MySQL in one gets shutdown everyday almost without any apparent reason. Ubuntu 18.04.1 LTS (GNU/Linux 4.15.0-1031-aws x86_64) Only thing I ...
0
votes
0answers
23 views

sudo dpkg --configure -a | MySQL error

I'm having trouble executing the command: sudo dpkg --configure -a I got a message telling me that I needed to run this command in order to correctly configure MySQL. After executing this command, I ...
0
votes
0answers
39 views

DBI connect('orthomcl:mysql_local_infile=1','root',…) failed

I have cat orthomcl/Dockerfile: FROM debian:stretch-backports RUN apt-get update && apt-get install -y --no-install-recommends \ wget \ cpanminus \ build-essential \ ...
0
votes
0answers
25 views

docker-compose up exited with code 1 because of few InnoDB errors

I have cat orthomcl/Dockerfile: FROM debian:stretch-backports RUN apt-get update && apt-get install -y --no-install-recommends \ wget \ cpanminus \ build-essential \ ...
-1
votes
2answers
158 views

Having Trouble Setting Subdomains On NGINX

I'm currently setting up OpenMediaVault on my Rock64 Single Board PC which is based off Debian and is configured through the web GUI running from NGINX on port 80. I'm currently trying to install ...
0
votes
2answers
51 views

Slow Queries WordPress Site (500k visitors a month and 150k posts)

I'm running a WordPress site with 500k visitors a month and 150k posts with in average 100 pageviews every second. I am trying to figure out if the load on the server is normal or if there is ...
1
vote
1answer
31 views

docker-compose up caused orthomcl_orthomcl_1 exited with code 0

I have cat orthomcl/Dockerfile: FROM debian:stretch-backports RUN apt-get update && apt-get install -y --no-install-recommends \ wget \ cpanminus \ build-essential \ ...
-3
votes
1answer
30 views

MYSQL just using 1GB [closed]

My System just uses 1GB of Ram but i get a lot of nginx 504 Errors and i guess mysql is the bottleneck any hints welcome htop output
-1
votes
0answers
14 views

Connecting webserver to local database server [duplicate]

I have a web server running PHP and another server for database in the same data center connecting on the same rack. What is the correct way to connect PHP to database server to reduce latency and ...
2
votes
3answers
47 views

Mysql runs out of memory during backup dumps (Docker container)

We have a container running MariaDB, and a few other small containers on the host. The Mysql container was allocated 21G of memory (out of 32G total), as well as a few other parameters, with the ...
0
votes
2answers
99 views

MySQL 8 on CentOS 7 - after update to 8.0.16-1, service won't start

This morning, I updated MySQL as there was an update available, but since then, the service won't start. Below is a screen grab from the output from systemctl status mysqld.service - the error seems ...
0
votes
2answers
43 views

ubuntu 18.04 ufw how to allow local 3306 connections to mysql?

If I run this command: mysql -u root -p -h 127.0.0.1 -P 3306 with the correct password (yes, I have the correct password) it says access denied I run the exact same thing, just disable ufw first ...
0
votes
0answers
14 views

jdbc connection to Mysql outside of VPN

This is a replica of my SO question I have a public accessible Mysql instance and i am trying to access it behind a clients VPN. So, on the VPN I was granted access to the DB, so by doing mysql -h ...
1
vote
1answer
34 views

MySQL PDO Too many connections

I have an application that is constantly inserting to a stats table. The average number of open connections is usually about 20 to 22. There is also a processing script in PHP run by a cron that runs ...
0
votes
1answer
60 views

Unable to Connect to AWS RDS using endpoint

We have two RDS running on AWS. On is a production database and the other is a development database. Both servers were working correctly until we decided to upgrade the production server from a db.t2....
0
votes
1answer
67 views

write master's slave thread lag flapping

if I have two mysql hosts pointed at each other: host A and host B: ------> hostA(write co-master) | | | -----> hostB (read-only co-master) why would hostA ever show replication delay when ...
0
votes
0answers
127 views

Receiving “Failed to store CSRF token in session! Probably sessions are not working properly” when trying to open phpMyAdmin on IIS

I'm trying to run phpMyAdmin for the first time on a sever running 2019 windows sever, however when I try to open localhost/phpMyAdmin I receive this error displayed on the web page "Failed to store ...
1
vote
2answers
81 views

MySQL and Apache are running out of memory

Can you help me how can I figure which SQL query makes my MySQL running out of memory? So, running dmesg command in console, I get following result: [root@dmzemf httpd]# dmesg -T | grep 'Out of ...
0
votes
0answers
9 views

(how do I)Azure data Factory to (on prem) mysql DB connection using cert

We need to pull data from a client on prem DB, they require us to use SSL + their cert when connecting. The only issue I'm having is: I have no idea where to "import" the PEM file for their certs in ...
5
votes
1answer
320 views

Can I add database to AWS RDS MySQL without creating new instance?

Just like a vps/server when I install mysql on it, it can be flexible to add/remove database in one server, but on aws rds mysql can I add database without create a new instance?
-1
votes
1answer
80 views

mariadb (“mysql”) bind not working, empty response

I am trying to connect to mysql on host from docker. (from devilbox php - it has socat even without it) in docker I had configured bridge network. started the docker container, and it works, i can ...
0
votes
1answer
136 views

MySQL Cluster -> Galera MariaDB Cluster Replication not working, but no errors

I am setting up a database migration between a 2-node master cluster running MySQL Cluster 7.2 (MySQL 5.5) and a 2-node slave cluster (plus arbitrator) running MariaDB 10.3 with Galera clustering. I ...
0
votes
1answer
38 views

Set MySQL connection flags from command line client

Is it possible to set MySQL client flags when using the command line client? I would like to set the CLIENT_FOUND_ROWS client flag, but the manpages of the mysql client do not mention the setting of ...
1
vote
2answers
43 views

Different password for Roundcube and external IMAP/SMTP

Is it possible to have the Roundcube password, and the password that's used for IMAP and SMTP connections (such as when using a mail app), be different? I would like to do this because I've set up 2 ...
0
votes
0answers
23 views

MariaDB 10.1.37 incorrectly reports zero Seconds_Behind_Master

I have a master MariaDB server and several replicas. All replicas report zero Seconds_Behind_Master. All but one replicas report Master_Log_File and Relay_Master_Log_File equal to that of the master. ...