Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,943
questions
0
votes
0
answers
9
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
33
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 ...
- 576
0
votes
0
answers
26
views
How can I build data a warehouse using a PostgreSQL database? [closed]
My company is in traditional manufacturing business. Which uses a very old ERP system that was programed specifically for the company using BASIC 30 years ago. Its a flat file system and its able to ...
0
votes
1
answer
71
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.6k
-5
votes
0
answers
46
views
Kindly help in merging two number fileds
mariadb database
sno
Cr
Dr
Combined output should be
1
0
100
100
2
100
0
100
3
Null
100
100
4
100
Null
100
The merged or combined output field should ignore 0 or null and output only positive ...
-1
votes
0
answers
21
views
Why is installation of MySQL on my mac is always halted [closed]
I've been trying to install MySQL on my mac and an issue kept happening. I downloaded macOS 14 (x86, 64-bit), DMG Archive. Everything seemed fine until the final step. It says "the software was ...
Greta Lee
0
votes
0
answers
18
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
0
votes
0
answers
43
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,019
2
votes
0
answers
48
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
80
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
55
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. ...
- 1
0
votes
0
answers
21
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 ...
2
votes
1
answer
75
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 ...
- 337
0
votes
1
answer
90
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
71
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
54
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
140
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
45
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
306
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
368
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-...
- 192
1
vote
0
answers
105
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 ...
- 21
0
votes
0
answers
183
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
163
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
181
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
99
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
60
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 ...
- 499
0
votes
0
answers
95
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,148
0
votes
0
answers
142
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
112
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
44
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
315
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
177
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
33
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
64
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
99
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
418
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
73
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
257
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
45
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
307
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
52
views
Query for Employees with Laptops Only
I'm using a MySQL database and trying to figure a query upon 2 tables:
Employee table where the status needs to be active
Asset table where the status needs to also be active
The asset table ...
- 201
0
votes
0
answers
62
views
Orangescrum says "Wrong database information. Please try with correct information." even though I've provided correct credentials
I'm entering correct database credentials. I've seen similar post in stackoverflow, which was left unanswered. Hoping for replies here.
- 123
0
votes
0
answers
193
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
0
votes
0
answers
747
views
How to use mysql commands in lando environment?
I tried to test some different mysql commands in a script running in a lando container dedicated to a drupal installation. I run the setup as described in the getting started guide. Everything is ...
- 13
1
vote
0
answers
186
views
'2003 (HY000): Can't connect to MySQL server' from browser
I have created a CentOS 9 droplet on DigitalOcean and a separate MySQL 8 Database. I can connect to this database from the droplet's console as well as from the terminal on my Mac. I can also run a ...
- 165
0
votes
0
answers
53
views
Virtualmin configuration error after updates
I updated my VPS which I administer with Virtualmin, it runs Ubuntu 20.0.4.6
When rechecking the configuration, it stops at:
A problem was found with your Postfix virtual maps :
The map source mysql:/...
- 1
-1
votes
1
answer
288
views
How to fix MySQL installation in Ubuntu:20.04 Docker container
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of start.
...
Cannot stat file /proc/3352/fd/0: Permission denied
Cannot stat file /proc/3352/fd/1: ...
0
votes
2
answers
2k
views
Can't copy paste between windows 10 to centos 7 in VMware workstation, how to fix this issue?
I've windows 10 installed as primary Operating System. Inside it, using vmware workstation 17, I've installed centos 7.
Now, for eg: I want to copy the command to download mysql workbench in centos 7.
...
- 123
1
vote
0
answers
91
views
I need help doing a bash shell script to index .inf files by hardware ID
I'm working on a new system to automate drivers installation in Windows 10/11. Some time ago, I downloaded a drivers collection from driverpack (the drivers collection is fine, but the software to ...
- 41
0
votes
1
answer
590
views
how to stop apache2 via kill -9
I know the normal method to start or stop apache2 on linux is:
sudo /etc/init.d/apache2 start|stop
Or…
sudo service apache2 start|stop
Or…
sudo systemctl start|stop apache2
But, in an emergency, I ...
- 785