Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,944
questions
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;
+---------------------------------------------------------------...
- 111
-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
57
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....
- 281
0
votes
1
answer
124
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
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 ...
- 319
0
votes
0
answers
144
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 ...
- 1
0
votes
0
answers
131
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 ...
- 383
1
vote
1
answer
270
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 '...
- 383
2
votes
2
answers
138
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
177
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 ...
- 586
0
votes
1
answer
713
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 ...
- 56k
0
votes
0
answers
44
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 ...
- 101
1
vote
1
answer
65
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 ...
- 1,029
2
votes
0
answers
103
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 ...
- 188