Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,945
questions
2
votes
0
answers
48
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 ...
0
votes
0
answers
345
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 ...
0
votes
0
answers
205
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
...
0
votes
0
answers
879
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 ...
1
vote
0
answers
203
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 ...
-1
votes
1
answer
357
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.
...
1
vote
0
answers
100
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 ...
0
votes
1
answer
877
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 ...
1
vote
1
answer
196
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 ...
1
vote
1
answer
7k
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
243
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
vote
0
answers
1k
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.
0
votes
0
answers
307
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'...
1
vote
1
answer
609
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 ...