Questions tagged [mysql]

MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

Filter by
Sorted by
Tagged with
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, ...
José Carlos Santos's user avatar
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 ...
neubert's user avatar
  • 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.
Jatin Patel's user avatar
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 ...
Zep's user avatar
  • 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 ...
 C Okonta's user avatar
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 ...
user7870766's user avatar
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 ...
lingar's user avatar
  • 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 ...
Kyle Schuck's user avatar
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 ...
Amal P Ramesh's user avatar
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 ...
Ivan's user avatar
  • 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 ...
THE DOCTOR's user avatar
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.
achhainsan's user avatar
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 ...
FeXa's user avatar
  • 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 ...
xdobx's user avatar
  • 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 ...
erdomester's user avatar
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:/...
mr buffy's user avatar
-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: ...
ouya olivier's user avatar
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. ...
achhainsan's user avatar
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 ...
BorHacker's user avatar
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 ...
acgbox's user avatar
  • 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 ...
St. Jan's user avatar
  • 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 ...
Thilina Wimalapriya's user avatar
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 ...
ahinsa's user avatar
  • 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.
SHresTho12's user avatar
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'...
Jibun no Kage's user avatar
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 ...
Skye's user avatar
  • 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 ...
netrangermike's user avatar
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 ...
sam23's user avatar
  • 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 ...
gopikachuuuu's user avatar
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 ...
Mohd Farhan Bin Ramli's user avatar
-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 ...
phobic's user avatar
  • 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. ...
WesR's user avatar
  • 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 ...
Dom's user avatar
  • 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 ...
Kevin Matsubara's user avatar
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 ...
user10931326's user avatar
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->...
Swiss Frank's user avatar
-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....
guyaloni's user avatar
  • 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 ...
porg's user avatar
  • 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 ...
dab92's user avatar
  • 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 ...
techguy's user avatar
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 ...
patschiboy's user avatar
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 ...
John Neville's user avatar
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 ...
David Buik's user avatar
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 ...
LEO JARABA PEREZ's user avatar
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: ...
Kevin Matsubara's user avatar
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 ...
Khem17's user avatar
  • 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 /...
andriy kin's user avatar
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 ...
Rohit Gupta's user avatar
  • 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 ...
derhannes's user avatar
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 ...
Sunny's user avatar
  • 353

1
2 3 4 5
39