Questions tagged as ['mysql']

MySQL is an open-source database owned by Oracle. ServerFault topics include how to run the server. For more MySQL specific questions like backup/restore/recovery/configuration, dba.stackexchange.com is probably a better home.
Score: 0
Roger Creasy avatar
Why are MySQL system user passwords incorrect?
sd flag

I was adding a user to my server via MySQL Workbench. Something went awry; the addition failed. Afterwards my root account could no longer access the DB via Workbench. (access denied)
I was able to connect as root from the command line mysql -uroot -p but root has no privileges.
This system has been in place and working, until now, for over a year

The log shows:
Found invalid password for user: 'mysql.in ...

Score: 0
NET-WATCH avatar
MariaDB 10.3 Randomly crash
lb flag

I'm facing a very weird issue with a mariadb database, randomly it crash with this error:

free(): corrupted unsorted chunks
210804 20:05:16 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To r ...
Score: 0
Can a replica to an RDS MySQL instance be setup outside RDS?
ca flag

I have a running RDS Mysql 5.7 instance that I would like to replicate to a MySQL 8 instance running on a Linux server (not on RDS).

Is this possible? I cannot find an option to do this from the dashboard.

Score: 0
Christopher Martinez avatar
Change bin-address on mysql ubuntu 18.04
sk flag

I'm trying to change the bin-address of my localhost database instance on a ubuntu 18.04 computer

i went to /etc/mysql/mysql.conf.d and then modified the file mysqld.cnf to assign the ip address i want 192.168.0.100.

From bind-address = 127.0.0.1 to bind-address = 192.168.0.100

When i try telnet 192.168.1.100 3306 after a while is see this message

telnet: Unable to connect to remote host: Connection re ...
Score: 1
TELA avatar
Alternate method for caching mysql query (query_cache) on version above 8.0
fm flag

On mysql version 8+ the query_cache support was removed.

I know why it is not a friendly thing with InnoDB when considering the CPU.

But I've some databases which really need this support where user repeat the same query in most cases.

Is it possible to restore query_cache or to achieve the caching via some other means.

Score: 0
MySQL 8.0.26 doesn't start after saving my.ini
ch flag

This is a fresh install of the latest version of MySQL at the time of writing (8.0.26) on a fresh install of a Windows 2019 Server Std, on a new HP ProLiant DL360 G10.

After installation and some configuration, I found that the MySQL80 service would not start back up if I stopped it. After a lot of reinstallations, I found that just saving the my.ini file was causing that. And by saving, I don't  ...

Score: 0
carlitobrigante avatar
Postfix doesn't send mail
cn flag

I am trying to learn about mail servers and am quite daunted by all of the moving pieces in the setup..

Currently I am unable to send via from my smtp server. I can receive mails fine from various domains.

In my logs I see the below entries when trying to send mail..

  • mail.log
Jul 31 11:59:15 mail postfix/submission/smtpd[1290]: connect from unknown[78.136.22.232]
Jul 31 12:01:03 mail postfix/posts ...
Score: 1
aimee avatar
MySQL / Web Server Bottleneck
jp flag

I’m trying to determine a MySQL / Web server bottleneck.

I have three servers. A Web server running Nginx, a remote MySQL server with my Wordpress DB and another remote MySQL server storing our data.

The bottleneck I’m trying to find is between my second MySQL server storing our data and my Web server. We have a page that has three DataTables on it (three separate queries). It’s loading very s ...

Score: 1
Hamza AZIZ avatar
high CPU usage of MySQL and recommendation from Mysqltunner
sn flag

we have noticed that our database server is getting so high CPU (more than 90 % used by mysqld process), the output of mysqltunner is shown below, can you help me please,

i'm okay about the innodb_buffer_pool_instances(=7), but is there some other suggestions ? enter image description here

enter image description here

enter image description here

Score: 0
noszone avatar
MySQL 8 - connecting to server with different port
cn flag

I have MySQL 8 on Debian 9 vps, and my problem that I can connect to server from php Adminer (web) with any port I've chosen:

localhost:3307, 33650, any port.

And php Adminer showing - MySQL » localhost:33899. And I can manage databases, but this instance is from 3306, which is default. Why such thing is happen? Am I miss something? This question was born due of other question on DBA - https://db ...

Score: 2
Gediminas avatar
How to stop unstoppable mysql-server package on Ubuntu 20.04
ua flag

So I purged and then tried to install mysql-server package on Ubuntu 20.04, it doesn't let for some configure problem. I found out that it doesn't even stopped and it seems that it automatically runs itself up again, I can't stop it no matter what

gediminas@ubuntu-g:~$ sudo ps aux | grep mysql
systemd+    9177  5.5  2.2 2123136 364052 ?      Ssl  21:21   0:00 mysqld
gedimin+    9354  0.0  0.0  2020 ...
Score: 0
user14850280 avatar
How do I run Laravel App with mysql using only Dockerfile?
us flag

I want to be able to enable my visitors to upload their laravel app to my server, and I want to run each app in a docker container. And I also want them to be able to have database access. My current Dockerfile is as such, but when I run docker exec -i myContainer echo "create database laravel3" | mysql, and then docker exec -i test30f php artisan migrate, I get an error Connection refused.

My Do ...

Score: 2
rai avatar
Mysql consume lots of space in ubuntu 20.4
us flag
rai

I need help regarding my application deployed in ec2 instance using T3 medium and Ubuntu 20. My problem is, I encountered a server error twice, it happens 3 months after each error. Prior to server error, I noticed I am greeted this message 99.5% of **GB once I log into the terminal console. The first server error happened three months ago I used a t2 tier, so without hesitation, I upgraded it to m ...

Score: 2
Jetto Martínez avatar
Tomcat redeployment and MySQL abandoned (sleep) connections
fr flag

TL;DR: Redeploy by restarting the server (Check final update).

This is an old question, but haven't found a solution just yet and at this point I don't know where to look.

We have three Java(Spring, non boot) webapps deployed on two servers: one app is on a GCP Compute Engine deployed on Tomcat9 (port 80) and the other two are in our in-house server on one instance of Tomcat8.5 (port 8080 redirected fr ...

Score: 0
Hafez Divandari avatar
mysqld: Unable to determine if daemon is running: No such file or directory
br flag

I was unable to re/start mysql on Ubuntu 18.04 using systemctl start mysql.service command. It suddenly happened after restarting the server.

I see this line on the log file:

mysqld: Unable to determine if daemon is running: No such file or directory

How to solve this?

The result of journalctl -xe -u mysql.service is:

Jul 14 16:36:49 cloud systemd[1]: Starting MySQL Community Server...
-- Subject: ...
Score: 1
How can I optimize the memory usage of mysql server on ubuntu?
br flag

I have an ubuntu server version 20.04.2 LTS. On it I have installed just mysql version 8.0.25-0ubuntu0.20.04.1

It's a dedicated server so I have my.cnf set up as this:

innodb_dedicated_server = 1
skip_name_resolve       = 1
key_buffer_size         = 16M
myisam-recover-options  = BACKUP
max_binlog_size         = 100M

The server is a vmware VM configured with 10GB RAM, 8 CPU (2 core, 4 sockets).

The ...

Score: 0
Error accessing MySQL endpoints through nginx ingress in eks
zm flag

I got 3 node on aws eks.

I want to use mysql client and access the database via Nginx Ingress.

this is my yaml.

apiVersion: networking.k8s.io/v1beta1
kind: Ingress
metadata:
  annotations:
    kubernetes.io/ingress.class: ext-nginx
    nginx.ingress.kubernetes.io/rewrite-target: /
  name: ext-nginx-ingress
  namespace: ext-nginx-ingress
spec:
  rules:
    - host: mysql.***********.com
      http:
        ...
Score: 0
sitemapxml avatar
Mysql server won't start after changing bind-address
cn flag

I have two dropplets at digitalocean, one is for http server and another is for database.

In mysql config /etc/mysql/mysql.conf.d/mysqld.cnf I have set bind-address to digitalocean private ip and everithing was working without the errors.

After server was rebooted, mysql failed to start. After I change bind-address to 127.0.0.1 it was working again, but my php app could not connect to the database ...

Score: 0
merlin avatar
mysqld_multi will not start as /var/run/mysqld' for UNIX socket file don't exists
in flag

I am trying to start 2 mysql instances on boot (ubuntu 20.04) by using mysqld_multi. The system complains that the directory /var/run/mysqld is missing and I can not figure out why?

content of /etc/mysql/my.cnf:

mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
#user       = multi_admin
#password   = multipass
log        = /var/log/mysql/error.log

[mysqld2]

# * Basic Settings
#
user ...
Score: 1
Ubuntu 20.04 Mysql8 keep accepting null/any password for root
mx flag

After installing "mysql-server" on ubuntu20 and running "mysql_secure_installation" and setting a password the system still not authenticating correctly and still accepting any/blank password for mysql root user via linux root user while from other linux users its not accepting any.

Score: 0
Kimberly avatar
Export SQL as CVS with Matching ID's
ug flag

I have an SQL database that I'm exporting as CVS sheets to import into a new WordPress website. CVS sheets to import into a new WordPress website. I downloaded the user.cvs which has the basic user information. I downloaded the user_information.cvs. I can't combine (or merge) the two CVS sheets because they have no common factors. Is there any way I can add a common value to both SQL tables so I can mer ...

Score: 1
Hamza AZIZ avatar
slow environment with high CPU usage
sn flag

I'm new to Linux metrics

in our test environment we experiment a slowness, after investigation we have found that the disk space used to store backup data is full, but what is wired for me is that the disk i/o is not high at all

we are working with MySQL server

here is the output of the top commandenter image description here

Score: 0
Sridharan Srinivasan avatar
MySQL - Select queries 10x slower on Azure VM vs on-prem VM
cn flag

We have been working on a project to migrate a MySQL database from an on-premise Linux server to a Windows VM on Azure (IaaS). (There's a specific reason because of which we have gone with the IaaS option instead of the Azure MySQL PaaS offering).

After the migration, we see that the queries on the MySQL database are significantly slower (about 10x) on the new server. The VM is configured with 64 ...

Score: 1
Why does MariaDB CHAR_LENGTH return NULL instead of 0 when a field is NULL?
gb flag
Tim

I am trying to calculate to total size of stored metadata in a table using CHAR_LENGTH to add up the size of the relevant fields in each row to get a rough idea of the storage size of a result set.

I don't want the size of all the data in the table, only the size of a set of results.

However, some fields in the table have NULL values and as soon as CHAR_LENGTH hits one of those the whole calculation ...

Score: 2
adamsfamily avatar
Can an unauthorized login attempt occupy a MySQL connection for a long time?
in flag

My MySQL has a limited number of concurrent connections defined by the max_connections variable by my cloud provider. Currently limited to 151 connections.

There is only one web server using this database therefore it should be more than enough. However, I was surprised to see that I currently have 30+ active connections to my server:

mysql> show status where `variable_name` = 'Threads_connected';
+--- ...
Score: 1
MediumMatrix avatar
Installed MySQL server but mysql command does not ask for password in the shell
in flag

I installed the following mysql client on my server 'mysql Ver 8.0.25-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))' and went through mysql_secure_installation steps and set the password as asked through this process. In the shell im logged in as root, I wonder if this has anything to do with mysql not asking for a pasword when I use put this command? Basically, i type mysql into my terminal, and I g ...

Score: 0
merlin avatar
How to backup large MySQL database with the help of LVM snapshots?
in flag

I am trying to find a backup/restore procedure for a MySQL 8 DB with 400M+ Rows in InnoDB tables. MySQLdump takes days and therefore I am trying this now:

  • Mount a LVM volume on the DB Folder
  • Create LVM snapshot
  • Restore on other server from Snapshot

The files are all there, but MySQL will not start:

2021-07-04T15:48:14.415660Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-07-04T ...
Score: 0
nurdglaw avatar
Restore MySQL database is very slow
ar flag

I've just bought a new home desktop. I have three MySQL databases that I want to move across. I dumped them all using mysqldump before removing the drive from the old machine.

Restoring the largest of the databases is taking ages (getting on for 24 hours so far). I'm restoring via:

mysql -uxxxx -p
Enter password: yyyy
mysql> create database foo;
mysql> use foo;
mysql> start transaction;
mysql ...
Score: 1
ycwong avatar
Docker compose simple routing for Mysql router
ng flag
    version: '3.1'
services:
  Mysql:
    image:
      mysql-router:latest
    hostname: mysql-router
    environment:
      MYSQL_PASSWORD: 123456
      MYSQL_HOST: 192.168.1.1
      MYSQL_PORT: xx
      MYSQL_USER: xxx

I would like to deploy a Mysql router with a docker-compose file on 192.168.1.2 and I will like to make it route to another MySQL router, the MYSQL_HOST is the destination (192.168 ...

Score: 0
Use snapshots to freeze a single database in MySQL
au flag

Various resources such as https://mariadb.com/kb/en/backup-and-restore-overview/ or https://www.thegeeksearch.com/how-to-backup-and-restore-mariadb-database/ describe how to backup the entire data of a MySQL instance. However, they all talk about the entire dataset across all databases.

I'd like to achive per-database snapshots (e.g. with LVM, KVM, qcow2 etc). However this may not be possible as it is my  ...