Stack Exchange Network

Stack Exchange network consists of 174 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.

-1
votes
0answers
8 views

PHP-FPM can't connect to mysql through Localhost but can through 127.0.0.1

I have PHP 7 installed with php-fpm and am unable to connect to mysql with PDO or mysqli. Both give the same error: SQLSTATE[HY000] [2002] No such file or directory If I switch over to CLI it ...
0
votes
0answers
15 views

MySQL SSL error: wrong version number

I'm having difficulty with MySQL and OpenSSL. I'm running MySQL 5.7 and OpenSSL 1.1.0g on Ubuntu 16.04 Regardless of what certificates I load, MySQL starts up but does not establish a connection over ...
1
vote
1answer
16 views

MySQL 8 on Ubuntu: what's the difference between /etc/mysql/conf.d/ and /etc/mysql/mysql.conf.d/?

As per title. In /etc/mysql/my.cnf I see: !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/ .cnf files from both location are loaded: why having two? Which one is the "right one" ...
-4
votes
1answer
22 views

directory protection in Ubuntu 14.04 Server [on hold]

I want to run the following on a single ubuntu 14.04 server - Asterisk - PHP/Apache/ MySQL This server will be offline at customer's location. I want to protect these folders in a way that if my ...
0
votes
1answer
61 views

FreeBSD swap usage with mysql

For the past few months, on a few different servers with similar FreeBSD versions and specs, I've been experiencing high swap usage with MySQL while seemingly having plenty of free RAM. FreeBSD 11.2-...
0
votes
1answer
26 views

Postfix authentication using MySQL SHA512

In our postfix setup, we are using the pam_mysql module to authenticate the user from the MySQL database. ( similar to this link) Which is perfectly working fine. We are using SHA512_CRYPT() for ...
1
vote
1answer
60 views

how to access external mysql from docker

I have an springboot java app inside docker that needs to access an external mysql. How can I configure this? Is it possible to define it inside Dockerfile? I am now to docker so I assume this ...
0
votes
0answers
12 views

Error Code: 1728. Cannot load from mysql.db. The table is probably corrupted

Whenever I try to do a DB query with a particular DB user (myuser) I get the following error: Access denied for user 'myuser'@'localhost' to database 'mydatabase' [1044] I decided to check the ...
1
vote
2answers
23 views

Can I see the actual collation (of e. g. Latin1) as used in for instance MySQL or Windows? The order of characters, not the name

I searched, and all I find is descriptions of the names, and the selection of collations. For example: _Zulu 0Alpha Alpha alpha usually sorts this way (on US Windows, most SQL servers etc.), ...
-1
votes
1answer
37 views

MySQL 5.7 and GDPR [closed]

Hella ! I know how GDPR requires me to hide all personal data and make it impossible to get a match on any living person with any combination of the tables records. But any of you have experience ...
0
votes
1answer
19 views

Apache-PHP slow page in one virtual host causes performance degradation or timeout on other

I have multiple PHP applications running under different virtual host on an Apache server. Each application uses MySQL as backend. Each application uses different MySQL servers in the same data center....
2
votes
0answers
21 views

How would I Import Data Daily Into SQL Server RDS AWS from an external MYSQL database

Currently I have a job on SQL Server that uses a linkedserver to our MySQL database to import data. We now have an SQL Server RDS and so I need to have the data be imported into it from the MySQL db. ...
0
votes
0answers
21 views

Ubuntu new ssd provisioning / Mysql growing out of space

One of my weekend project is growing virally and its mysql database is growing and I am running out of space. Here's what df -h looks like at the moment. Filesystem Size Used Avail Use% Mounted ...
-1
votes
1answer
26 views

Starting mysql failed because the control process exited with error code [duplicate]

Ok. First. I tried to run a website on a server but it was too heavy for MySQL to handle. Apparently, it broke due to lack of RAM. So I changed the .cnf and .ini files for the server to lower the load,...
0
votes
0answers
14 views

Prevent a Tomcat web app from accessing the internet

I need to restore a backup of jamfPro (a tomcat webapp with mySQL database) to retrieve some data that no longer exists in my production instance. I can't have this restored backup reaching out to the ...
2
votes
0answers
23 views

CentOS phpMyAdmin connecting from external ip?

I'm trying to connect to phpMyAdmin which is running on my CentOS server from my pc with the following phpMyAdmin.conf: <Directory /usr/share/phpMyAdmin/> AddDefaultCharset UTF-8 <...
0
votes
0answers
8 views

Mariadb TLS does not enable

I am trying to enable MariaDB (10.3.12) tls with certificates but it stays Disabled. I am working under centos7. I have tried this with ubuntu 18.04 and mysql and it worked, so I wonder what is wrong ...
-1
votes
1answer
27 views

MySQL restart on the server the memory used by mySQL has increased from 1.8 GB to 9.2 GB This resulted in 97% of the Server memory being in used

MySQL restart on the server the memory used by mySQL has increased from 1.8 GB to 9.2 GB This resulted in 97% of the Server memory being in used Any tuning need to be set on my.cnf file. Every week ...
1
vote
0answers
13 views

Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade [migrated]

In mysqld.log I have thousands of lines like: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade So, according to virtually every post on the ...
0
votes
0answers
49 views

InnoDB Cluster - MySQL 8.0.13 upgrade to 8.0.14 on Ubuntu 18.04.1 LTS - Cluster creation fails

With the recent upgrade of MySQL from 8.0.13 to 8.0.14 on Ubuntu 18.04.1 LTS, I started getting an error by the time I issue the dba.createCluster('mycluster') after following the procedure to create ...
1
vote
1answer
58 views

MariaDB MySQL shows have_ssl disabled when certs are installled

Trying to enabled SSL on my mariadb-server. I have followed the official mariadb docs to generate a ca-key ca-cert server-key server-cert. My machine is a debian 9 kvm vps with mariadb 10.1.37 When I ...
0
votes
0answers
18 views

Fatal error 1236 when swapping in new master, “master has purged binary logs”

Our situation: we have three MySQL 5.7.23 replica servers attached to a MySQL 5.7.23 master server running in EC2 instances in AWS. (Yes, one day we hope to be running in Amazon RDS or equivalent, but ...
0
votes
1answer
49 views

using mysql to send a database of log messages to syslog-ng?

I want to create a database of my proxy-server log messages and then modify and change them then finally send them to syslog-ng!! Is it possible?
2
votes
1answer
66 views

RDS Aurora Serverless “Parameter Groups”

I have an RDS Aurora Serverless MySQL cluster, and I am trying to change a MySQL setting (connect_timeout). Normally, you would use a Parameter Group to set the value on the DB instance. But, since ...
1
vote
0answers
14 views

MariaDB 10.2 crash on innodb table corruption

I'm running MariaDB 10.2 on Windows and had some hard drive corruption on my server that messed up some innodb tables. Unfortunately this also affected backups, so I'm trying to dump the tables and ...
1
vote
1answer
143 views

MySQL my.cnf config for dedicated server [duplicate]

we have a dedicated server hosting 1 website on it uses WordPress, CPU: Intel® Xeon® W-2145 Octa-Core (8-core) RAM: 128 GB DDR4 ECC RAM Connection: 1 Gbit/s-Port Traffic: Unlimited OS: CENTOS 7.6 ...
1
vote
0answers
73 views

MySQL, Sequel Pro via ssh, access denied error

Before I get into details, there are at least a couple of questions that seem to address the same problematic behavior, but the answers given to the questions don't apply in my situation, which I will ...
2
votes
1answer
37 views

Apache and MySQL processes running at 100% CPU

I have a production server that's usually very stable, and has been for a very long time. Last night, it suddenly started showing very high loads (150+). Deactivating Apache will decrease the load ...
-2
votes
1answer
37 views

LAMP stack with AWS performance [duplicate]

I am planning to move my LAMP stack to AWS as the number of users increases. Current estimations suggest, that the Server has to handle roughly 100.000 users accessing the static landing page, out of ...
0
votes
0answers
18 views

How to restore MariaDB Databases from files

After the whole server went FUBAR I managed to retrieve website files (php,html and such) and the DBs. Now I have these files: aria_log.00000001 aria_log_control ib_buffer_pool ib_logfile0 ...
0
votes
0answers
24 views

mysqld_safe --skip-grant-tables exits before i can type mysql-u root to rest root password

Made some simple mistakes--don't have backup for my server, and uninstalling/reinstalling in several different manners hasn't helped. I've attempted a few shell scripts to slow the processing of the "...
0
votes
1answer
73 views

PHP 5.6 with Debian 9 -> mysql connection

I created an debian 9 machine with ISPConfig - standard stuff (after this tut: https://www.howtoforge.com/tutorial/perfect-server-debian-9-stretch-apache-bind-dovecot-ispconfig-3-1/ ). Comes with PHP ...
0
votes
1answer
105 views

Ubuntu 18.04 server - can unattended-upgrades cause MySQL to crash?

Quick overview of the company product I'm working on before I ask my question: We have a server running a pretty much stock install of Ubuntu 18.04 and a vision app. The main purpose of the server ...
-1
votes
1answer
33 views

linux mysql convert .sql.tar.gz to csv

I have a .sql.tar.gz file tht ws generated by mysql export is there any command in linux to convert this sql.tar.gz file to csv? Thanks
0
votes
0answers
28 views

Multi-master PowerDNS setup

I'm trying to set up multiple PowerDNS hosts (masters), that will write to a Galera MariaDB backend. I provisioned a HAProxy loadbalancer in front of the Galera cluster nodes and all the PowerDNS ...
0
votes
1answer
120 views

phpmyadmin database getting deleted automatically [closed]

I am using aws ec2 t2 instance. Where I created few database as per my requirement. For last few day I noticed new databases which I create getting deleted automatically. Is there any possibility of ...
0
votes
1answer
81 views

mysql.service location on Ubuntu 18.04 server?

I need to edit the mysql.service file to make MySQL automatically restart when it crashes. I'm working with a pretty much stock Ubuntu 18.04 server install and followed these instructions https://www....
0
votes
0answers
66 views

Failed to create connection pool: Failed to initialize pool: Communications link failure

We are using mysql router service 8.0 with group replication 1 master and 2 slaves 5.7.24 and 2 application host. After initating the app services we got the error in the middle ware log. ERROR [xx....
0
votes
2answers
145 views

local mysql was hacked with ransomware hack. How to check if database data was downloaded?

I had a test mysql database running on Vagrant dev box. Turns out the network wasn't that secure. All of the databases were deleted (and replaced with a DB ransomware note) and in the logs I can see ...
0
votes
0answers
18 views

PDO to mysql socket connetion trouble

I try to connect to mysql (mariadb) via socket connetcion. I have created the mysql user via unix_socket identification. Also I have given some privileges to the test db. I wrote the conn.php file as:...
0
votes
1answer
292 views

How to install mysql server using ansible playbook?

I am trying to install mysql server on centos using ansible playbook. My yml file looks like above. --- - name: Install MySQL database server hosts: test become: yes become_method: sudo ...
2
votes
0answers
41 views

Mariadb over VPN from a sql-IDE times out, but works with mysql CLI client, why?

This is a situation where I don't have any clue on what's going on : I configured an OpenVPN using a PKI, everything seems to work, except this: Dbeaver and Mysql-Workbench hangs after a "succeed ...
1
vote
2answers
74 views

AWS transfer RDS mysql to another region without loosing data

I wanted to transfer my mysql databaes from us-east-1 (virginia) to eu-east-1 (ireland) without loosing any data. Also, I want to stop virginia after transfering database from one region to other ...
1
vote
0answers
88 views

MySQL 600-700% CPU after upgrade from 5.7 to 8.0.13

htop picture I have 0 slow queries in the log, tried with different my.cnf configurations. Can't see what's the problem. 8 cpu server, 32GB ram, ssd, dedicated mysql server. All cpus > 100%, it's ...
0
votes
1answer
30 views

How to setup a PHP API to work over HTTPS?

I use a simple API with PHP to get some values in JSON format, it is working fine in web browser over HTTP. I enabled SSL in mariadb with the certificates, but when I try my API using HTTPS, it says ...
2
votes
1answer
125 views

Mariadb 1000% CPU [closed]

I have a big problem with my site (Laravel based), I have from 1000 to 1500 contemporary visitors, and I have a problem with mariadb, practically when people use filters, and other options that ...
0
votes
1answer
218 views

Enabling mysql on boot error (Refusing to operate on linked unit file mysql.service)

I'm following instructions on vultr to install LAMP stack on VPS (https://www.vultr.com/docs/how-to-install-apache-mysql-and-php-on-ubuntu-16-04). When trying to enable mysql on boot I'm getting an ...
1
vote
1answer
67 views

MySQL not allowing remote connections using Python3 mysql.connector on Raspbian-Stretch

I am trying to allow connections using mysql.connector from a specific machine to a MariaDB server, within the local network. Ideally, I would like to create an account limited to a single IP and DB. ...
1
vote
0answers
53 views

mysql_secure_installation on Ubuntu 16.04 doesn't set the root pass

I'm upgrading a few mysql (MariaDB) hosts from Ubuntu 14.04 to 16.04 and noticed mysql_secure_installation doesn't seem to set a root password on the DB, even though it prompted me for it. I changed ...
0
votes
1answer
21 views

2 MySQL instances in the same cib.xml

I have a RHEL 7.3 cluster with 2 nodes, managed by Pacemaker. It's used for MySQL HA. I currently have one MySQL service added to the cluster (MySQL 5.2): <primitive class="ocf" id="mysqldb1" ...