Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,947
questions
0
votes
0
answers
17
views
How to import JSON in MySQL on Windows
I want to import some objects with selected label:value pairs from a JSON (placed locally on a Windows machine) into MySQL (runs on the same Windows machine). MySQL is prepared for import - table with ...
- 216
0
votes
0
answers
34
views
"Signing" Error on Debian 11 when I try to install MySQL Server
For adding a repository on apt in Debian 11, I did this,
wget https://dev.mysql.com/get/mysql-apt-config_0.8.22-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.22-1_all.deb
But, when I continue, doing ...
0
votes
0
answers
60
views
I'm trying to get my RHEL 9 server to run postfix and use MySQL as the client
I'm trying to migrate my email server from an old RHEL 6 virtual image to a new RHEL 9 server. I went through the standard install with some minor SELinux issue that have been fixed. I installed the ...
0
votes
1
answer
34
views
Authentication in MySQL from other docker containers
I have one docker container running docker with MySQL image. Say it's called sql.
This container has 2 databases: database1 and database2
I have created specific users for each database, say user1 ...
- 95
0
votes
1
answer
33
views
.mysql_history: how to persist it with the official MariaDB Docker image?
How does it work the MariaDB .mysql_history file from the official MariaDB Docker image?
It's not really something I want in production. But it might be handy in a developer setup. Also, although it ...
- 228
0
votes
0
answers
61
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, ...
- 163
1
vote
1
answer
89
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....
- 291
0
votes
1
answer
487
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
760
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
214
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
312
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
453
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
237
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
279
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 ...
- 616
0
votes
1
answer
2k
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 ...
- 55.9k
0
votes
0
answers
72
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
87
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,089
2
votes
0
answers
145
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
0
votes
1
answer
325
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
211
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. ...
- 11
0
votes
0
answers
77
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
194
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 ...
- 347
0
votes
1
answer
161
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
...
- 103
0
votes
1
answer
143
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 ...
- 181
0
votes
0
answers
249
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
391
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
66
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 ...
Cezar Apulchro
0
votes
1
answer
515
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
891
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-...
- 228
1
vote
0
answers
166
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 ...
- 11
0
votes
0
answers
388
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
234
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':
...
- 187
0
votes
1
answer
371
views
Ubuntu 22.10 not able install mysql
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 22.10
Release: 22.10
Codename: kinetic
I trying
sudo apt-get install mysql-server
Reading package lists... Done
...
- 1
0
votes
1
answer
159
views
How to move MySQL 8 files to external drive on Mac
I just installed MySQL 8.2 on my Mac. It stores data in /usr/local/mysql/data/ by default, where _mysql user and _mysql group owns the directory. I created a new data directory in the root of the ...
- 293
0
votes
0
answers
105
views
Warning with NO consequences: postfix/trivial-rewrite[]: warning: relay_domains lookup failure
I get the below warning in the mail log file.
postfix/trivial-rewrite[]: warning: relay_domains lookup failure
The mail server is working well without any issues. What can this error mean?
Running ...
- 519
0
votes
0
answers
138
views
Can't stop MySQL service (running but not found)
I have MySQL server running in docker FROM ubuntu/mysql:8.0-22.04_beta
I am trying to stop the service
$> /etc/init.d/mysql stop
bash: /etc/init.d/mysql: No such file or directory
$> service ...
- 2,248
0
votes
0
answers
267
views
MySQL workbench permission denied for files in media drives under "Other Locations" of Ubuntu 22.04 LTS
I've freshly installed MySQL workbench in a new Ubuntu system (Ubuntu 22.04 LTS) through Ubuntu Software center and all installations and database connections are configured smoothly.
But when I try ...
- 101
0
votes
0
answers
163
views
Is it possible to use codespaces + local mysql server?
I'm using a local mysql server alongside a spring boot application, it's easy to configure the MySQL server in the application properties file:
spring.datasource.username=blablabla
spring.datasource....
- 3
0
votes
0
answers
53
views
SSL Connection to mysql database using OCI Data integration REQUIRE X509 flag
I have a data integration requirement to connect and retrieve data from mysql database using SSL,the user am using to connect is created is with REQUIRE X509 flag so in the connection i need to ...
1
vote
1
answer
489
views
MySQL Docker container on Plesk isn't accesible from the exterior
I'm trying to set up a MySQL database to use it externally. I have a Ubuntu server with Plesk and Docker.
The main problem is that when logged in the server the port seems to be used/open, but ...
- 13
1
vote
0
answers
216
views
Unable to upgrade MySQL to version 8.0.34 under Windows 11
I tried to upgrade MySQL from version 8.0.32 to 8.034 under Windows 11 and I had a strange problem while doing that. Take a look at this picture:
As you can see, the Next button is not highlighted, ...
0
votes
0
answers
39
views
Xampp error for blocked port
I am unable to start mysql xampp. it is not working . I have attached screenshot. Please provide me solution.it is showing about to port blocked or missing dependencies.
0
votes
0
answers
71
views
Unable to connect to my remote desktop
I want to remotely access my desktop PC (server) that has a static IP, from my laptop. Both are running Linux Mint 21.2.
I have opened the port 3306 on my router settings because I want to access a ...
- 11
0
votes
0
answers
118
views
How is Windows 11 Apache php 8 Apache manual setup different from the php 7 on windows 10
I have read previous post on the setup of Apache php MySQL manual installation and the all seems to follow the same steps. Please what would be the constant k in all the different different versions ...
- 1
1
vote
0
answers
501
views
How can I share my local mysql server/database to the cloud using cloudflare, so that, I can use that connection to connect to other applications?
I have created a tunnel in Cloudflare and connected it to my local pc. I can access my localhost via port 3508. Now, I want to make this database accessible over the internet as my accounting desktop ...
- 11
1
vote
1
answer
119
views
How to define command line options in my sql systemctl service
I have a mysql install on Digital ocean cloud.
And by default it's working with system ctl service.
I need to run the server with those options :
That have taken from here.
So I've tried to edit this ...
- 121
1
vote
0
answers
338
views
Configuration for IIS Server not working on some browsers. (REDCap)
So we are configuring a server site with REDCap to put up surveys and I am able to load it using localhost or the IP address through internet explorer. However, trying google chrome or edge browsers ...
- 11
2
votes
0
answers
49
views
SFTP user login details real-time filtering
I have enabled the SFTP login log into the default logfile /var/log/syslog and tried to filter the login time of each user and insert it into the database.
But the filtering is not worked as I ...
- 121
0
votes
0
answers
368
views
Windows 10: Connecto to pc with static IP address
Due to business, we need a special computer that will be a server. That computer will have a MySQL database installed, to which we will connect from other remote computers via a static IP address.
We ...
- 141
0
votes
0
answers
221
views
My package manager doesn't work after I upgrade
I don't know why my package manager is not fully working.
halil@ubuntu:Downloads$ sudo apt upgrade
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
...
- 1