Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,945
questions
0
votes
0
answers
6
views
Initializing database using mysql-operator
I have a rather complex application, with several applicative components and a MySQL database. I am using kubernetes and Helm manage it. I would like to clusterize the database using mysql-operator, ...
0
votes
0
answers
6
views
Combining Tables in MySQL [migrated]
I am in need of some help
I have a Database that hold product records as well as sale location data and I need to have a data set returned with data from different tables
So far I have tried the ...
0
votes
0
answers
13
views
mysql - show all users/hosts with privileges to access a certain database [migrated]
Is there a way to list all users/hosts that have been granted access to a database? I know I can do this:
> show grants for someuser;
+---------------------------------------------------------------...
-2
votes
0
answers
16
views
there's packet loss in my .pcap file and i want to find the cause for it [closed]
[enter image description here][1]
https://i.sstatic.net/fzMo9dj6.png
1
vote
0
answers
58
views
systemd: ensure, service is started after mysql
I have a systemd path unit, which watches a config file to apply db changes if the config file changes. To ensure the path unit runs after mysql, I added these lines:
Wants=mysqld.service
After=mysqld....
0
votes
1
answer
127
views
keep getting mysqli_real_connect(): (HY000/1045): Access denied for user 'testing'@'localhost' (using password: YES) for non-root users
I have a linux web server as a part of a college course (i.e, all of my applications and setting are done according to my teacher instructions, and I get the needed files from his ftp server). I'm ...
3
votes
2
answers
741
views
How to Import MySQL 4.1.14 data into MySQL 5.7.44?
I have a fresh install of WordPress 6.5.3 on MySQL 5.7.44-1.el7 up and running via Docker, accessible via my web browser.
I also have old data from WordPress 2.0.2 on MySQL 4.1.14 saved into a ...
0
votes
0
answers
145
views
I am experiencing ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
I am using MAC apple silicon, on Sonama 14.4.1
I came across this error while following a tutorial installing MySQL server. I searched around for solutions but none of them seem to work. I get this ...
0
votes
0
answers
137
views
Why does WSL recognize the host as <PC_NAME>.mshome.net?
I was having trouble connecting to my Ubuntu OS running in WSL2
But then when I changed the bind-address of the config file at /etc/mysql/mysql.conf.d/mysqld.cnf to 0.0.0.0 instead of 127.0.0.1.
Then ...
1
vote
1
answer
279
views
How to connect to MySQL on WSL Ubuntu from the Windows host?
I am trying to connect to the MySQL server on my WSL2 Ubuntu 24.04.
I created a user in the following way inside Ubuntu:
CREATE USER 'myuser'@'localhost' IDENTIFIED WITH mysql_native_password BY '...
2
votes
2
answers
140
views
Permissions error in directories used by Docker and application I am developing
I have run a docker container mysql from my own application development on C#, and configured data persistence to this path:
C:\ProgramData\Persistence\data\mysql
When i start everything goes well ...
0
votes
1
answer
179
views
Waiting for a MySQL or MariaDB server to become ready to perform updates
Is there an universal command/query to issue at the mysql client program to wait for the server to become ready for processing queries and updates, independent of whether the server is MySQL or ...
0
votes
1
answer
743
views
How can I reset my MySQL root password in MySQL 8.0.36 on Red Hat 8 if ‘mysqld_safe’ is gone?
For years I have been using mysqld_safe (like this) with --skip-grant-tables so I can safely reset my MySQL root password:
sudo mysqld_safe --skip-grant-tables &
But recently, while attempting ...
0
votes
0
answers
45
views
MariaDB - database folder changed?
I have MariaDB installed via Homebrew on MacOS.
I have local databases in /usr/local/var/mysql but a day or two ago, my local MariaDB now points to /opt/homebrew/var/mysql and does not find any of my ...
1
vote
1
answer
66
views
MySQL: Converting Row to Columns Based on Field Values
I am using MySQL Workbench 8.0.
I will break my question into two parts as I believe the first part will be straightforward (but is slightly beyond my current SQL knowledge level) but the second part ...
2
votes
0
answers
104
views
Why my terminal throws control characters while using arrows in mysql-client?
I have a situation with remote servers (all Debians) where I get control chars into mysql-client command line when I try to search in history (CTR+R) and try to make the first move:
mysql> update ...
0
votes
1
answer
219
views
Why is MariaDB refusing to start?
MariaDB refused to start with this error:
Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13 "Permission denied")
I think it may be a permissions error somewhere,. How ...
0
votes
0
answers
143
views
How to use multithread option on single table backup using mydumper
I'm trying to use mydumper and myloader to perform a backup and restore activity of the MySQL database. Below is the use case
We have 1 database, around 2 TB, out of which 1 table is around 1.3 TB. ...
0
votes
0
answers
41
views
Can't bring back old mysql on mac
Initial problem is when I try to run mysql on terminal it outputs something like this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
I was triying to ...
3
votes
1
answer
130
views
Unable to install MariaDB after deleting /var/lib/mysql, because mysql.user exists
I tried to install MariaDB on my system (Manjaro) and after install with mariadb-install-db I couldn't get the service running. I figured this was because I run the command without root (I was ...
0
votes
1
answer
124
views
How to grep on mysql CLI command output?
mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for source to send event
Master_Host: xx.xx.xx.xx
...
0
votes
1
answer
125
views
MySQL server won't connect after Docker container
Working on a Ubuntu 22.04 system with MySQL 8. I have a legacy collection of MySQL data/dbs on an external harddrive that I used a Docker container and MySQL image to connect to and export. This ...
0
votes
0
answers
145
views
MySQL is not connecting with server
I am currently using MySQL 8.0.36 on Windows 10. Today, when I started my computer to work on SQL, I encountered an issue where it displayed 'No connection established.' Subsequently, I attempted to ...
0
votes
0
answers
298
views
How to install MySQL 8.1 in Debian 11
I need MySQL 8.1 for Magento, but I am unable to install it from the given repository.
After some research, I found that the MySQL package has been removed from the default repository and updated with ...
0
votes
0
answers
56
views
How to access Datasources and Drivers in Wildfly 27 on Linux CentOS 8
I installed Wildfly 27 on Linux CentOS 8, apparently the installation was successful, my objective is the MySQL database, so following Red Hat Administration and Configuration Guide I created the ...
0
votes
1
answer
429
views
(FATAL): The background process “SQL Databases and dependent apps” failed with a fatal error: The subprocess reported error number 127 when it ended
I am installing CPanel in ubuntu 20.04.
But getting MySQL related error.
(FATAL): The background process “SQL Databases and dependent apps” failed with a fatal error: The subprocess reported error ...
2
votes
1
answer
677
views
Cannot install mariadb-server on Debian "There is a MariaDB/MySQL server running" (because of Akonadi?)
Preamble, I've done some research and as usual we have a cornucopia of similar questions but not exactly covering the described title:
https://askubuntu.com/questions/1407756/akonadi-on-kde-cant-...
1
vote
0
answers
141
views
Are there no error logs for MySQL on Plesk server (Ubuntu)?
I have installed a Plesk server with version 18.0.57 on an Ubuntu 22.04.3 LTS. I am looking for the error logs for MySQL accesses or MariaDB accesses. But I can't find them via SSH.
Where could they ...
0
votes
0
answers
248
views
Cannot connect to a fresh brew install of mysql from a client on the same host
I just did a fresh install of mysql on a mac using brew.
brew install mysql
We've installed your MySQL database without a root password. To secure it run:
mysql_secure_installation
MySQL is configured ...
0
votes
0
answers
197
views
Accessing MySQL database through SSH tunnel
At the moment I can access a MySQL database by SSHing in terminal.
This prompts me for a passphrase for a key
ssh test-db01.somedomain.com
Enter passphrase for key '/Users/yourname/.ssh/path/to/key':
...