Questions tagged [mysql]

MySQL is an open-source database owned by Oracle.

Filter by
Sorted by
Tagged with
0
votes
0answers
16 views

Mysql 5.7 keeps shutting itself off randomly in a day or two?

I have a DigitalOcean Ubuntu 16.4 machine with Nginx installed. Maybe it's related to Wordpress installation, maybe not. MySQL shuts itself down randomly. It has a 1GB swap file created. 1GB RAM. ...
0
votes
0answers
9 views

How to run a specific migration of an accidentally dropped table?

I accidentally dropped a table using the mysql command line (the table was empty btw). But I need this table. So I would like to re-run only the migration for that table, and not for other tables ...
-1
votes
1answer
16 views

Laravel - Server stack (RAM or CPU)

I've been asking myself a question for a week but I can't decide. I have to choose between two server stack for my application but opinions differ on blogs. Server 1 : 4 vCore(s) From 3 GHz 8 GB of ...
0
votes
0answers
17 views

AWS RDS Downsize mysql database without losing users and their passwords

AWS doesnt let you shrink DB storage. If this is required, they suggest to either user their Migration Service or use mysqldump. See https://aws.amazon.com/premiumsupport/knowledge-center/rds-db-...
0
votes
0answers
17 views

Having troubles to connect to AWS RDS MySQL Instance from my laptop

I created an instance for MySQL. I've already allowed ALL ip's in the security group for inbound and outbound. Now I'm doing mysql -h xx.xx.us-east-1.rds.amazonaws.com -u admin -P 3306 -p and after I ...
0
votes
1answer
29 views

mariadb 5.5 innodb keeps opening files up to 200k until system hangs completely

Mariadb 5.5 is installed on CentOS and serves a database in the total volume of around 40GBs (as measured per database files on a disk) and 506 tables. This database is being queried by php-fpm, and ...
0
votes
0answers
32 views

MySQL server has gone away

MySQL is running on Ubuntu 18.04. We have many databases running on this single server and many sites running from those databases. All sites working fine except one site. That site frequently goes ...
0
votes
0answers
15 views

Connecting to remote MYSQL database using FireDac and Delphi 10.3

When I attempt to connect to a remote mysql database server using the "remote IP address" using the Delphi 10.3 Firedac component I get an error message "Access denied for user 'myuser'@'local IP ...
0
votes
0answers
12 views

MySQL stopped on its own. Restarted service succefully

I'm not sure what the fuss is with MySQL, because out of the blue it just stopped the service when I tried to access the site this morning. I checked the mysql error log, here is what it says "...
1
vote
0answers
64 views

Convenient monitoring of database under Django

I am developing a web app under Linux and use Django for its back-end along with MySQL database (via DBeaver). Everything is awesome, but I was not yet able to find a convenient way to monitor the ...
0
votes
1answer
28 views

Changing Innodb_buffer_pool_instances

Using mysql 5.6 innodb size is 512M default is Innodb_buffer_pool_instances=8 Trying to add in my.cnf Innodb_buffer_pool_instances=1 getting error /usr/sbin/mysqld: unknown variable '...
1
vote
0answers
62 views

how to use old MySQL data directory for a new MySQL installation

I have my Mysql data in a EBS volume in aws, I need to point my Mysql to point to that directory instead of /var/lib/mysql. These steps i followed by this doesnot change the datadir sudo systemctl ...
0
votes
1answer
29 views

How to check the existing MySQL server if Strong Password Encryption is enabled?

Around half a year ago I have installed the latest MySQL 8 on Ubuntu 18.04. wget -c https://dev.mysql.com/get/${MYSQL_8_file} dpkg -i ${MYSQL_8_file} apt update apt install -y mysql-server I tried ...
0
votes
1answer
116 views

Apache connections stuck on “sending reply” and high mysql load

Apache on my dedicated server constantly hangs due to connections being stuck in a state of "sending reply": Apache status: connections stuck in "Sending Reply" This happens at least several times a ...
0
votes
0answers
33 views

Deleted Apache OpenMeetings default user group

I was experimenting with Apache OpenMeetings on a test server and did something goofy--I deleted the default user group. Now I am unable to log in with any pre-existing user account and create any new ...
0
votes
0answers
20 views

Where is the configuration file for MySQL 8 on Debian 10?

I'm trying to resolve a slow connection issue, and everything I find suggests that I modify my.cnf, but this file does not exist anywhere I have looked at. Running the command # mysqld --verbose --...
-1
votes
3answers
83 views

mysqltuner wants me to set join_buffer_size > 256.0M?

I have a 16GB dedicated server running 1 wordpress and 1 magento site! For the last month I have been trying to get mysql optimized! [root@server ~]# ./mysqltuner.pl MySQLTuner 1.7.19 - ...
0
votes
1answer
51 views

Can undefined variables and notices cause a cpu spike?

We're running centos 6.7, PHP 5 and MySQL 5.5 and Apache 2.2.15. Sometimes we see high CPU usage, mainly caused by MySQL so we take all the logs we can get. We're addressing MySQL optimization ...
0
votes
0answers
63 views

Mysql will not start - “cant change permissions of ca-key.pem”?

Trying to start our mysql service but getting an error: Nov 19 09:15:57 MIDBSQLMASTER mysqld[11497]: mysqld: Can't change permissions of the file 'ca-key.pem' (Errcode: 1 - Operation not permitted) ...
0
votes
0answers
21 views

How to migrate a D8 mysql site to D8 postgresql (drupal)

For reasons that are not relevant to the question we are moving our future apps to postgresql and want to convert our older apps also. I have used https://www.drupal.org/project/dbtng_migrator/...
1
vote
1answer
108 views

Docker / mySQL / MailCow [2002: Connection refused]

I am confronted with the following problem: 2002: Connection refused (mysql) Information about my cloudserver: 1 vCPU / 2 GB RAM / 20 GB NVMe SSD NO SWAP in standard-image from Hetzner (Provider) ...
0
votes
2answers
89 views

Fastest possible configuration for a local MySQL database, no security needed?

We have a local Optiplex PC setup to run our shared MySQL MariaDB database with no way to access it from the outside world. It doesn't have any critical data that needs to be protected. Basically, no ...
0
votes
1answer
53 views

MariaDB in docker - setting up grants to limit access by container hostname

I have a MariaDB container running on my swarm cluster that services several applications, each running in their own container and connected to the database with a dedicated network (internal and ...
0
votes
0answers
41 views

Mysql database been hacked. What to do now? [duplicate]

My testing database has been hacked. I am pretty sure it's hacked by an easily guessed test use admin credential. After reading How do I deal with a compromised server? I've got an idea of what to ...
2
votes
1answer
166 views

Was I using MariaDB or MySQL?

An Ubuntu upgrade (to 19.10) messed up my database server. After the upgrade, the sql server would not start. So I installed MySQL but later realized that I may have been using MariaDB. Is there a ...
0
votes
0answers
20 views

why innodb use gen_clust_index instead of table lock when table have no any index?

My mysql version is 5.7. I try to test some case about innodb lock.I know: a. query using table lock when table have no any index. b. table have no any index, innodb will auto create gen_clust_index. ...
0
votes
0answers
50 views

How does AWS RDS come up with the max_connections formula?

The following formula is used in my RDS parameter group for the max_connections property: {DBInstanceClassMemory/12582880} I have a relative understanding of the DBInstanceClassMemory per their ...
0
votes
1answer
33 views

How to set `max_prepared_stmt_count` **permanently** on mysql server?

I need to increase max_prepared_stmt_count, and I can do that easily by running set global max_prepared_stmt_count=50000; The problem, though, is that number gets reset to the default everytime ...
0
votes
0answers
13 views

MySQL least privileges to get database/tables size

I'm using centreon_plugins to monitor some mysql databases. As a best practice I create a dedicated user for monitoring and I give it the least possible privileges. For simple monitoring I usually ...
0
votes
0answers
45 views

Can't run “mysqld_safe --skip-grant-tables &” socket file at /run/mysqld/ dissapears when I stop mysql service, there for mysqld_safe can't find it

Trying to reset root password following different tutorials. First I stop the service, then I get stuck here: mysqld_safe --skip-grant-tables & returns 2019-11-03T00:29:07.330005Z mysqld_safe ...
0
votes
1answer
40 views

MySQL Can't set password requirement for root user? [duplicate]

I have just setup a new vps with Ubuntu 18, I did a fresh installation of mysql-server: sudo apt-get update sudo apt-get install mysql-server sudo mysql_secure_installation In this menu, I typed in ...
0
votes
0answers
394 views

mysqlimport — stack smashing detected and segmentation fault

We are importing a large batch of records with mysqlimport tool. We have ~800 files prepared for importing all in one directory with names such as: mytable.2019-10-31_17-37-1501 mytable.2019-10-...
0
votes
0answers
489 views

postfix+saslauthd+pam_mysql adds EOL to passwords, thus breaks

I'm trying to use the pam_mysql module in conjunction with postfix and saslauthd. Everything appears to be working, except the actual password comparison is failing. Note: the case being tested is ...
1
vote
0answers
27 views

mysql root has password set but it allows blank password [duplicate]

Its a new installation. I ran mysql_secure_installation and set a password. But I can still login with blank password. If I set -p it accepts my new password but also accepts blank password. root@...
0
votes
1answer
61 views

ETL to bigquery using airflow without have permission cloud storage/ cloud sql

i have done ETL from MySql to bigQuery with python, but because i haven't permission to connect google cloud storage/ cloud sql, i must dump data and partition that by last date, this way easy but ...
0
votes
1answer
27 views

1364 - Field 'aim' doesn't have a default value

1364 - Field 'aim' doesn't have a default value Query: INSERT INTO mybb_users (`username`,`password`,`salt`,`loginkey`,`email`,`postnum`,`threadnum`,`avatar`,`avatartype`,`usergroup`,`...
1
vote
1answer
37 views

Errors while restoring mariadb/mysql dump in docker

I'm running mariadb in a docker container. I want to backup and restore using a sql dump. I created the database for use with wordpress, and created just one test page. I installed phpmyadmin to the ...
0
votes
1answer
15 views

How to set-up Syslog-NG with MonitorWare schema?

we are setting up a centralized logging server which receives logs from many devices and servers and stored them into a database. The syslog on the central server is syslog-ng. It is chosen because ...
0
votes
0answers
17 views

MySQL: how can i track down cause of rising Open_tables?

Under MySQL 5.7.28 running under Debian Stretch SHOW STATUS LIKE 'Open_tables'; gives me an increasing number reaching 1500 soon after database restart. how can i track the root cause of it? SHOW ...
0
votes
0answers
69 views

Snipe-IT: MySQL hostname is being ignored

I have an installation of Snipe-IT on FreeBSD 11.3 with MySQL 5.7.27, PHP 7.3.7, and Apache 2.4.39_1. I'm encountering this error in ~snipe-it/storage/logs/laravel.log: [2019-10-25 13:13:24] ...
0
votes
1answer
61 views

MySQL (MariaDB) is running at 100% CPU utilization after adding an index

I attempted to add an index to a date field in a table (MyISAM) having about 4,000 rows, using PHPMyAdmin. PHPMyadmin froze, finally timed out. Now, even after rebooting the server, the MySQL (...
0
votes
0answers
22 views

Server response take time when same User open 2 same links

I am providing API service, My Site response is Fast, but when user open 2 same links at same time, then the server open the request and holds it from 20-50 seconds... Using WHM-Apache, mySQL. ...
0
votes
1answer
61 views

My server is returning an Internal Server Error during a long PHP request

I'm having a situation when running a long PHP request on my server. I configured my php.ini setting values as post_max_size to 32M and memory_limit to 512MB The server returns this error however: ...
0
votes
1answer
75 views

Update Your Amazon RDS SSL/TLS Certificates by October 31, 2019

We recently received an email from AWS called "Update Your Amazon RDS SSL/TLS Certificates by October 31, 2019" We have tried to follow the guidelines to get ready for the deadline in March 2020, ...
0
votes
1answer
52 views

Freeradius 3.0.12 doesn't send any data through mysql

After upgrading from v 2.x, freeradius stopped working for me. I have done multiple tshooting steps which led me to believe that the application is not sending any data through MySQL, even though it ...
1
vote
1answer
32 views

Can't access phpmyadmin, because of a faulty DNS entry [closed]

I've crashed my domain's DNS trying to enter a DKIM entry to my control panel, now I can't access my domain, my control panel or PHPMyAdmin because they all reside on my domain. Is there a way I can ...
0
votes
0answers
8 views

mysql active faild after update DirectAdmin

Yesterday I updated my DirectAdmin and today noticed all my website on the server has been down because mysql connection failed, for example: Warning: mysqli::__construct(): (HY000/2002): No such ...
1
vote
1answer
32 views

mysqldump extremely slow when using a private ip

I am facing a very strange issue with Mysql. I have two cloud server and they are in the same region and VPC network so the internal connection speed is quite fast. Both servers are running CentOS 7....
0
votes
1answer
35 views

Can't connect to MySQL server, “Unknown error”

I'm running a series of server programs on Windows Server 2016 that are using a MySQL server (MariaDB 10.0.27). At first everything is fine, the servers connect to the database, clients can connect to ...
0
votes
0answers
25 views

Force php mysqli_connect() to use TCP

Background: I'm migrating to php-fpm with chroot. Before I used socket for connecting to mysql. However it's quite a work to deliver mysql socket to all vhosts. Either I have to mount -o bind or I ...