Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,923
questions
1
vote
0
answers
41
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
27
views
unable to connect to DB from inside WSL even tho i can connect to the same DB from outside VPN
I can connect to a particular DB, through OpenVPN, in Windows, however, when I try to connect to that same DB inside WSL I am unable to connect. To test the connection in both WSL and Windows I'm ...
- 6,919
0
votes
0
answers
10
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
40
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
26
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
141
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
20
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
73
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
28
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
46
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
32
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
52
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.
- 121
0
votes
0
answers
125
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
317
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
89
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
37
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
154
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
700
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.
...
- 121
1
vote
0
answers
54
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
194
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 ...
- 743
1
vote
1
answer
146
views
RDBMS user managment through Gitlab CI/CD
I'm setting up Gitlab CI/CD, to test and deploy a project that uses micro services. The service are build in Laravel and each runs in a Dockers container of their own. Each micro service has a ...
- 63
0
votes
1
answer
3k
views
Failed to start MySQL Community Server After Updating to Ubuntu 22.04.2
I have updated my Ubuntu server on DigitalOcean to version 22.04.2. Now I can't log in to the phpMyAdmin ( also my Flask website can't connect to the MYSQL ). When trying to login to the phpMyAdmin ...
0
votes
0
answers
78
views
Connect to local database (windows) from Ubuntu linux virtual machine
I'm trying to connect to my local windows database server from Ubuntu Linux Virtual machine.
I've created a user and grants in the database and flushed the privileges.
However when trying to connect ...
- 1
1
vote
0
answers
707
views
Sql Workbench does not work on macOs venture latest version
When ever I try to launch the MySql workbench it crashes and shows this error report.
I tried uninstalling and reinstalling different versions it shows same error.
- 11
0
votes
0
answers
116
views
MariaDB (mysql like) How to get the index value of a selected row in a sql table? This the unique index, not a row count
Say you have a table... Index is primary key...
Index Sensor
1 BME280
2 BMP280
And want to return the Index value only of a matching select query?
SELECT * FROM Sensor WHERE Sensor = 'BME280'...
0
votes
0
answers
60
views
Cannot connect to VPS
I have an application that connects to my VPS IP, SQL and such.
It is a server application so that people can connect to my game. Ive had it working on a Windows VPS before but it seems to not let ...
- 1
1
vote
0
answers
294
views
How can I add 2 missing nodes to a galera cluster that has one node that is accepting reads and writes?
I am running a galera cluster with 3 nodes, having 3TB of data.
Last night due to a short power cut and a faulty UPS I completely lost 2 of the nodes and everything in /var/lib/mysql folder.
At this ...
0
votes
0
answers
39
views
Cannot find upgrade path from 5.7.38 to 5.6 , GitLab CI Runners faild InvalidParameterCombination
GitLab CI Runners faild the jbo with the following error message
│ Error: Error modifying DB Instance legacy-dms: InvalidParameterCombination: Cannot find upgrade path from 5.7.38 to 5.6.
│ status ...
- 39
0
votes
0
answers
215
views
WSL MySQL fails to stop - requires kill -9 pid to stop it
I am having trouble getting MySQL to stop running without having to kill it using the process id. This can become a problem, especially if I update or upgrade my packages. MySQL is always a bit ...
0
votes
1
answer
526
views
Want to install MySQL 5.7 but apt-cache policy mysql-server not showing mysql 5.7 on Ubuntu 22.04
I have some trouble on installing mysql 5.7 on ubuntu 22.04
I follow this steps https://computingforgeeks.com/how-to-install-mysql-on-ubuntu-focal/
I checked that I have followed correctly, but on the ...
-1
votes
1
answer
487
views
mysql consistently loses connection on long running big select statements
When I run a select statement on a big table (8GB+) via the mysql client for a long time I get the following error:
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
ERROR ...
- 189
0
votes
0
answers
320
views
how do you install mysql client without mysql sever on wsl
I currently have MySQL v8 installed in W11 where the database itself runs as a Windows service.
I want to install the command line client on WSL but I don't want to create another database server.
...
- 111
1
vote
1
answer
397
views
Disable 2FA for phpMyAdmin through terminal
I set up 2FA for logging into phpMyAdmin but the token was deleted from my phone. Now I can't log into my database because it's requiring a code that I no longer have access to.
I've accessed mysql ...
- 11
1
vote
0
answers
358
views
Unable to get mariadb to get bound on localhost
On my remote Ubuntu 20.04 server I have an instance of mariadb running.
I can access this server through SSH with user myuser and open run the CLI-client on the server to open a prompt for the ...
2
votes
0
answers
23
views
Unsupported operation when trying to remotely create new MySQL user via HashiCorp Vault
I have deployed HashiCorp Vault in a Linux VM, and I want it to connect to an instance of MySQL database running on my host machine.
In my database (host machine IP 100.101.102.103), I have created a ...
- 121
0
votes
0
answers
92
views
"unable to upgrade to Fedora Linux 35": complaining about mysql cannot be verified and repo is GPG enabled?
My box was at Fedora31 for a long time, and as it can only upgrade two versions at once, I upgraded to 33 and would then go to 35 then the current (I think) 36.
Going from Settings->Fedora->...
- 333
-1
votes
1
answer
294
views
Install phpMyAdmin for remote access
I use Ubuntu 20.04, and using a remote MySql DB (which is installed on an external server).
I am looking for installing phpMyAdmin without installing a local MySql server, but cannot find how to do it....
- 121
0
votes
1
answer
291
views
Test that mysql shell with --ssl-mode=REQUIRED to given --host REALLY works without first providing username, password, database-name?
I'm looking for a possibility in the mysql client to only test whether the --ssl-mode=REQUIRED directive to a given --host is 100% ensured, without potentially spoiling username, password and database ...
- 359
0
votes
2
answers
1k
views
How to install MySQL 5.7 on CentOS 9?
I have an use case where I need to install MySQL 5.7 on CentOS 9. I found a guide which describes how to do this on CentOS 8, and it works perfectly. However, when I try the same steps on CentOS 9, it ...
- 3
0
votes
1
answer
2k
views
ERROR 2003: Can't connect to MySQL server on 'localhost:3306'(111 "Connection refused")
My laptop for database and raspberry pi 3b+ as remote computer:
I am trying to have a remote database from my laptop. I want my raspi 3b+ to connect to it but it seems I can't do it. Badly need your ...
- 1
2
votes
0
answers
703
views
SSH tunneling for MySQL/MariaDB not working anymore on MacOS Ventura, works in Monterey
I've been using a simple SSH tunnel to connect to remote database server from my local Mac. This worked fine in Monterey, but stopped working on Ventura.
I set up public keys, and I have verified that ...
- 121
0
votes
0
answers
40
views
I'm trying to install MariaDB but MySQL gets installed instead
[root@sweet91 playbook]# dnf install mariadb
Updating Subscription Management repositories.
Red Hat Enterprise Linux 9 for x86_64 - 22 kB/s | 2.4 kB 00:00
Red Hat Enterprise Linux 9 for ...
0
votes
0
answers
14
views
Recover accidentally formatted and deleted directory on CentOS [duplicate]
I accidentally mounted a new drive partition to two directories instead of one.
mount -t auto /dev/sdb2 /var/lib/mysql
mount -t auto /dev/sdb2 /var/lib/mysql_backup
After my first drive was full after ...
- 111
0
votes
0
answers
940
views
egrep warning: egrep is obsolescent; using egrep -E
could someone help me with the problem I had when installing and starting xampp, it shows me this error. (Arch-Linux)
sudo /opt/lampp/lampp start
XAMPP: Starting Apache...egrep: warning: egrep is ...
0
votes
1
answer
351
views
How to pipe stdin into mysql parameter
I want to try and import a database from an SQL file. I want to supply the argument for the --defaults-extra-file parameter by echoing a config file and pipe the output to the command.
This command:
...
0
votes
0
answers
356
views
Using my computer as MySQL database and access with Xamarin.forms app
I have developed an app from Xamarin. forms (C#) and I want to use my own computer to host a MySQL database. I have forwarded my port on my router as well but the database can only be accessed when my ...
- 1
0
votes
1
answer
93
views
Cannot install mysql
I can't install mysql to my vps server
I tried:
dpkg: error processing package mysql-server (dependency problems)?
https://askubuntu.com/questions/1068270/apparmor-parser-error-for-mysqld
cannot open /...
1
vote
1
answer
128
views
Is it possible to put database in the cnf file To secure mysqldump
I have a working cron job to backup the databases on a daily basis. I want to secure the authentication details in a mysql config file for mysqldump using --defaults-extra-file.
I know I can do the ...
- 2,789
1
vote
2
answers
674
views
MariaDB --tc-heuristic-recover in Docker container
I have a MariaDB database in a docker container for my home automation (homeassistant). For some reason it stopped working and I get this error in the docker system logs:
221001 12:27:03 mysqld_safe ...
- 21
0
votes
0
answers
84
views
MySql (Version 8.0.30) access as root user works when accessed with sudo (Ubuntu 22.04) but not otherwise
I am able to have access MySql when invoked with sudo, as in:
sudo mysql -u root -p
It prompts for a password, whether I enter an invalid password, a valid password or just plain enter, it accepts ...
- 353