Questions tagged as ['mysql']
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 ...
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 ...
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.
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
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 ...
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.
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 ...
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..
Jul 31 11:59:15 mail postfix/submission/smtpd: connect from unknown[188.8.131.52] Jul 31 12:01:03 mail postfix/posts ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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: Starting MySQL Community Server... -- Subject: ...
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).
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: ...
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
127.0.0.1 it was working again, but my php app could not connect to the database ...
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 ...
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.
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 ...
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 ...
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 ...
My MySQL has a limited number of concurrent connections defined by the
max_connections variable by my cloud provider. Currently limited to
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'; +--- ...
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 ...
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 ...
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 ...
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 ...
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 ...