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.

0
votes
0answers
24 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
15 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 ...
0
votes
0answers
20 views

mysqli_real_connect(): (HY000/2002): No such file or directory

Well i'm facing this issue which happened after i installed httpd-mpm-itk and i tried googling and i couldn't find a similar issue as my problem. Here is my config.inc.php: $cfg['Servers'][$i]['...
2
votes
1answer
48 views

Mariadb 1000% CPU [on hold]

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
0answers
19 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 ...
0
votes
0answers
28 views

MySQL unable to start

I am using Ubuntu on VPS hosting and my website (wordpress) was working perfectly couple of days. Now when I checked mysql is creating problem and its service is unable to start. Job for mysql....
-1
votes
0answers
20 views

connecting to MySQL over ssh in javafx android [on hold]

I want to connect mysql database located at hosting server using ssh technique in android javafx (using javafxmobile-plugin) project. I scussfully connected to mysql database using javafx android ...
-1
votes
0answers
11 views

Issues with MySQL cpu usage [closed]

MySQL CPU usage is above 100% and the server services are stopping intermittently. Please see my.cnf file details. The server is a 4GB, 60GB HD VPS. performance-schema=0 default-storage-engine=...
1
vote
0answers
28 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
13 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
20 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" ...
0
votes
0answers
22 views

squid3.5 - cannot authenticate username/password with Mysql 8

I configured squid 3.5 and mysql 8 in (centos 7.5)same vm(NAT) in vmware workstation. This is my configuration: Mysql configuration wget https://repo.mysql.com//mysql80-community-release-el7-1....
0
votes
1answer
21 views

ERROR 2003 (HY000): Can't connect to MySQL server on 'XXX.XXX.XXX.XXX' (111)

I'm running the following mysql command: mysql -h 10.8.0.16 -u username -p after typing the password, I receive the following error: ERROR 2003 (HY000): Can't connect to MySQL server on 'XXX.XXX....
1
vote
0answers
12 views

mariadb-libs is needed by turnserver

I am trying to install TURN server on centOS7 for one of my webrtc application. This TURN server would be used in a video calling application. I had followed below steps: yum install -y make gcc cc ...
0
votes
0answers
19 views

MySQL and Postgres replication to the same slave

I need to set up multi-source replication from several different servers to one slave so that I can mine data from the slave without increasing load on the masters. This is my first time setting up ...
0
votes
0answers
18 views

Google Cloud SQL update broke itself on Table Views?

There was an update (initiated by Google) on Oct 17, 2018 on our cloud SQL Server. I think it broke itself and it particularly removed some of the important table views. made the exporting job based ...
-2
votes
0answers
77 views

Tomcat server is unresponsive after some hours of load [on hold]

I am having four Ubuntu version 16 servers on AWS behind the LB, each server is having 4 cores and 8 GB RAM. Every server is having Tomcat 7.With following config in server.xml <Connector port="80"...
0
votes
1answer
45 views

Issues with Wordpress container configured for external database host

I am trying to run the Wordpress container, configured to use an external MySQL database server like so: docker run --name wordpress1 -p 801:80 -e WORDPRESS_DB_HOST=MYDBSERVERIPADDRESS:3306 -e ...
1
vote
1answer
43 views

How to clone my cloud server locally? [closed]

I'm working on an IoT project and have my backend running on cloud. Now, there are a few sites where the connection of the device is not being allowed to the cloud by the authorities but instead they ...
0
votes
0answers
24 views

Can't load /etc/my.cnf because of Apparmor

I installed MYSQL 5.7 and can't load data from /etc/my.cnf because of Apparmor. Tried this manual, but my.cnf still blocked by Apparmor. journalctl -xe output: Nov 24 11:12:21 JCSM002 audit[27912]: ...
0
votes
0answers
23 views

How to connect to mysql on host from docker?

I have mysql on my localhost and I am able to log in with root: [root@pocnnr1n1 etc]# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB ...
6
votes
2answers
221 views

Can I put the MySQL binlogs on a slow disk?

We have only 450 GB nvme space on our master server and the binlogs are using a lot of space, even if they are kept for only two days. Does writing the MySQL binlogs to a slower disk (like a remote ...
0
votes
1answer
19 views

Mysql generate multiples connections on multiple ports on windows server 2012

I have a detail in my server, if run a command netstat it show me this. Is normal? TCP 127.0.0.1:53898 127.0.0.1:3306 TIME_WAIT 0 TCP 127.0.0.1:53899 127.0.0.1:3306 ...
0
votes
1answer
19 views

OwnCloud error deploying to AWS: The username is already being used (not WebDAV related)

I have an instance of Owncloud running on AWS Elastic Beanstalk I’m just deploying it from the docker, so I have a very simple Dockerrun.aws.json { "AWSEBDockerrunVersion": "1", "Image": { "...
1
vote
0answers
20 views

innodb_buffer_pool_size, optimize and mysqltunner [migrated]

I'm trying to understand how to properly size innodb_buffer_pool_size and when to optimize my tables. Questions are: When sizing the innodb_buffer_pool_size, should I take into account the size of ...
0
votes
2answers
263 views

MySQL cli does not remember history of some commands

I use linux OS with mysql database. mysql CLI doesn't log some commands in ~/.mysql_history . For example can not log create user. How can force cli to store all commands in mysql_history ? How can ...
1
vote
0answers
64 views

What is a “normal” latency/performance of inserts on mariadb or mysql?

Hadn't used MySQL family for years. Now need to move from OracleDB to either MariaDB or PostgreSQL. So on a similar "hardware" (Openstack VM: RHEL 7.3, 4HT cores of 2.5GHz Xeon E312xx, "local" SAN &...
0
votes
0answers
35 views

Connection Failed: Unknown MySQL server host

I have encountered a following issue: I am trying to use MySQL ODBC 8.0 Connector (I have tested both 64bit and 32bit) to connect to Microsoft Azure MySQL server. Settings are: In Azure I have ...
0
votes
0answers
15 views

mysql router cannot connect to innodb-cluster

I have installed a docker based innodb-cluster on a centos machine composed of three mysql docker instances. The current cluster configuration is : { "clusterName": "devCluster", "...
0
votes
2answers
67 views

Should I create Mysql user `user@localhost` or `user@127.0.0.1`?

My server is centos 7.4, mysql 5.5. In my.cnf,I set skip-name-resolve = 0 and skip-networking= 1,which means mysql will use user@127.0.0.1 even I run user@localhost. Then, when I create a new user, ...
1
vote
0answers
22 views

I cannot remove instance from MySQL InnoDB Cluster, got error about get_string(7): field is NULL (LogicError)

I have a MySQL InnoDB Cluster(version 5.7). I just have two server, a master and a slave. I am try to remove master instance to let slave promote to master. When I execute command cluster....
1
vote
1answer
67 views

Why is no root pass needed to access MariaDB after upgrade to Ubuntu 16.04?

I've recently upgraded a system from Ubuntu 14.04 to 16.04 (mysql Ver 15.1 Distrib 10.0.36-MariaDB) and noticed root can get in without a password eg:mysql -u root is empty. Tried setting a new ...
0
votes
0answers
28 views

MySql - Lost Connection to server during query

I have this simple select statement with an empty database: SELECT s.id FROM status s WHERE s.days > ( SELECT -1 days UNION SELECT st.days days FROM process_status pst JOIN status st ON pst....
2
votes
2answers
80 views

Unknown Database when trying to connect to an AWS RDS instance

I created a MySQL RDS instance, however, when I try to connect without writing the database name, it connects but does not allow me to create any tables. When I do write the name, the connection fails ...
0
votes
0answers
31 views

MySQL server won't start - ERROR! The server quit without updating PID file

So I have a newer macOS - macOS Mojave 10.14.1. The mysql version I have installed is 5.6 - and I unfortunately cannot upgrade (trying to run our company app, and our files syntax is stuck in 5.6 and ...
0
votes
0answers
4 views

PHP - The server requested authentication method unknown to the client [migrated]

I want to connect to a MySQL database from PHP but I can't because "authentication method unknown", I found many solution but all of them about creating a new user with the old password type, but ...
0
votes
1answer
39 views

ODBC Item on MySQL query causes Zabbix server to stop

I'am new to Zabbix. Today I've tried to add a SQL item (Database monitoring) to a host without success. Without this SQL item, the Zabbix server runs fine. I check this with service zabbix-server ...
-2
votes
1answer
62 views

MySQL suddenly stopped to work - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

My website outputs the following error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) I tried many solutions I found online, none of them worked. # service ...
0
votes
0answers
60 views

Can't connect to mysql on remote server

I have several machines running CentOS, one of which is set up as the mysql server. I had been running this for a while, and was able to connect to mysql from the remote machines with no problem, but ...
1
vote
1answer
60 views

Amazon RDS mysql enable slow querry log

I am trying to enable the slow query log via RDS web console. We are using mysql 5.6 on RDS not aurora. I'm changing the Parameter groups values of slow_query_log to 1 long_query_time to 5 ...
0
votes
0answers
131 views

Access denied; you need (at least one of) the SUPER privilege(s) for this operation - Strange issue with MariaDB instance on shared server

I have local instances of MySQL 8.0.12 and MariaDB 10.1.31. Both have a database "ExampleDB" when I execute the script below there is no issue: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` ...
2
votes
1answer
51 views

What is the maximum number of words allowed in a MariaDB InnoDB Full Text Search query

I recieved this error when performing a search with 746 words (it wasn't intentional someone pasted text into the wrong box). HA_ERR_FTS_TOO_MANY_WORDS_IN_PHRASE: Too many words in a FTS phrase or ...
2
votes
1answer
52 views

What is the most straightforward way to migrate from dotdeb's MySQL package to Oracle's MySQL package?

I'm upgrading a Debian installation which has been running the dotdeb package for MySQL 5.6. Since dotdeb isn't supporting MySQL anymore, I'd like to migrate to the repo hosted directly by Oracle. ...
0
votes
0answers
42 views

Can Mysql read content under [mariadb] group?

I migarated from Mariadb to Mysql. As some setting are not compatible,I put those incompatible setting under [mariadb] of /etc/my.cnf. For example, [mysqld] myisam_recover_options=FORCE,BACKUP# ...
2
votes
2answers
117 views

Restoring deleted MySQL database from log file

Last Night I accidently deleted a production MySql database on a digital ocean droplet. I immediately shut down apache and MySql. I have the following ib* files: ib_buffer_pool ib_logfile0 ...
0
votes
1answer
55 views

Haproxy to redirect Mysql with ssl

Im looking If is possible to use haproxy to balance mysql servers with ssl. Only Im finding how to use with http but in this case we need to enable this option. For now specific config is listen ...
-1
votes
1answer
54 views

MYSQL is consuming 100% of CPU usage

Been monitoring WHM > Process Manager for a while now, and a particular process from MYSQL keep eating up CPU Usage playing from 30%-100% from time to time PID : 3618 owner : mysql CPU% : 100.60 ...
1
vote
0answers
38 views

Overloaded MySQL Connections & Not Respond Server

A few times a day, our database server does not shut down the processes in the sleep state and does not respond by slowing down access to the server. Here are two problems: server 32gb ram etc. ...
1
vote
1answer
123 views

libmysqlclient.so.18 is missing on centos 7.5

On centos 7.5 I have mysql 5.7.24 installed, with subsequent installation of mysql-devel. I'm trying to get the MySQLdb module of Python 3.7 working, however, on importing it with (in python) import ...
1
vote
1answer
112 views

Transaction check error when install mysql 8.0.13

I install mysql on Centos 7 by command yum localinstall https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm After that: yum install mysql-community-server And this is error after ...