Questions tagged [mysql]
Questions regarding the MySQL database server, client and tools.
2,948
questions
0
votes
0
answers
67
views
How to recover user access to Mysql database?
I am working in LAMP(Mysql), I wanted to allow an external ip to connect to the database but it was not possible because Mysql was using MyISAM storage engine, so I tried to change it to InooDB adding ...
1
vote
0
answers
78
views
Missing Text in MySQL Workbench Performance Dashboard
I've installed MySQL Workbench on Ubuntu 22.04 following the directions here. I'm able to connect to my database server and run queries just fine. However, when I access the Performance Dashboard, ...
- 11
0
votes
2
answers
210
views
How to troubleshoot extremely high load averge (over 550)?
I am Ubuntu 18.04 user, running in OVHCloud Datacenter for 3 years with PHP Application and Mysql server on it. For 2.5 years, everything was ok, but in last 6 months i have strange issuee:
Every 4th ...
- 1
0
votes
1
answer
42
views
Uninstall MySQL and perform first time setup
I know this seems like a repeated question but I've tried every other answer and none of them worked.
I'm trying to follow this guide in order to create a database for my Minecraft server but before ...
0
votes
1
answer
49
views
MySQL remote setup
I'll be honest I know nothing about Linux, but for a few weeks I've been setting up my Minecraft server on a virtual machine on the cloud because it's way better than hosting companies, of course you ...
0
votes
0
answers
131
views
Problem while installing MySQL
Ubuntu 22.04
While installing MySQL this information come up
luis@l-System-luisj:~$ sudo apt-get install mysql-server
[sudo] password for luis:
Reading package lists... Done
Building dependency tree.....
- 31
0
votes
2
answers
554
views
Sqlyog not connected to ubuntu 22.04
Trying connect to mysql database with SQLYOG latest version but got this error message
"SSH ERROR: Fatal error network error : connection timed out"
0
votes
1
answer
458
views
when i am upgrading from Ubuntu 20.04 LTS to Ubuntu 22.04 LTS. The terminal is showing this error. Please resolve this
You might want to run 'apt --fix-broken install' to correct these.
The following packages have unmet dependencies:
libmysqlclient21 : Depends: mysql-common (>= 8.0.32-1ubuntu20.04) but 5.8+1.0....
2
votes
1
answer
1k
views
Install mysql 8 along with mysql 5.7 on Ubuntu 22.04
Is there any way to install MySQL 8 along with the already installed MySQL 5.7? I want to run two instances, one for version 8 and one for version 5.7. I have tried this on Windows, it's effortless, ...
- 41
1
vote
0
answers
470
views
Issue installing mysql in Ubuntu 22.04 LTS
I am new to Ubuntu and I have been trying to install mysql on Ubuntu 22.04 LTS -hosted on a virtualbox but I keep on getting the same message regardless of what I try. I have tried to uninstall mysql ...
- 11
0
votes
0
answers
709
views
apache2 oom_killer killed mariadb
Discovered mariadb was down and found this logging in syslog.
Apache is running mediawiki and wordpress. Could it be a rogue Wordpress plugin?
It looks like apache told linux to kill mariadb - is that ...
- 1,101
0
votes
0
answers
537
views
How to install mysql5 client in ubuntu 22.04?
I have ubuntu 22.04 and my current mysql client is at version: Ver 8.0.31-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu)) located at: /usr/bin/mysql. However when I try to connect to a database server ...
- 195
2
votes
1
answer
1k
views
Configuring MySQL for SLURM
I'm having problems getting SLURM (for job scheduling) to work with a MySQL database. I was using this as a reference, but perhaps I misunderstood something in it. If someone can let me know what I'...
- 2,071
0
votes
1
answer
5k
views
Mysql error "'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13)'" and I can't reset root password either
I'm getting the following error for a couple of commands I'm trying to run AND I don't know the password whenever I'm prompted for that. (note: I just updated my ubuntu distribution to 22.04, but I ...
- 103
0
votes
0
answers
287
views
What is the user/password for `sudo mysql` on Ubuntu 20.04?
When I installed mysql, I didn't write down the mysql root user password. I can get to the mysql prompt with just sudo mysql. However, mysql -u root -p does not work with the system's root password. I ...
- 111
0
votes
1
answer
310
views
mediawiki does not find mysql
After a reinstall of Ubuntu 22.10 and copy of backup to /var/www/html/ of mediawiki-1.38.4, reinstall of PHP8 and enabling of mbstring, intl and xml
in a webbrowser to localhost/mediawiki-1.38.4 the ...
- 1,069
0
votes
2
answers
923
views
docker mysql 5.7 on ubuntu 22.04
I'm used to using Ubuntu 20.04 and docker mysql created like this:
sudo docker run --name mysql-57-container -p 127.0.0.1:3310:3306 -e MYSQL_ROOT_PASSWORD=. -d --volume=/usr/share/docker/mysql57/conf....
- 21
0
votes
2
answers
214
views
Mythtv backend install problems
I am trying to install mythtv on Proxmox as Ubuntu 22.04 container. I had fallowed instructions on web and video on youtube
I ended with command:
sudo apt-get install mysql-server mythtv-backend ...
- 21
1
vote
0
answers
172
views
MySQL does not create socket when launched at boot
After a reboot, mysqld is running, but no socket gets created and you cannot connect to the MySQL server:
# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/...
- 175
1
vote
1
answer
5k
views
Mysql database root access denied
I cannot access my sql database on my server 22.04 LTS as root from localhost with and without password after just installing mysql-server-8.0 via apt I have tried to alter the password via the ...
2
votes
0
answers
46
views
Is there an easy way to find all files on an ubuntu server and load them along with path information into mysql?
I am using Ubuntu server 20.04 for OwnCloud and backups of multiple networked computers. I know I have many duplicate files on the server and would like to have one database of all files so I can ...
- 21
0
votes
0
answers
435
views
MySql workbench 8.0.31 on Ubuntu 22.04 looks like gibberish
I just installed and reinstalled MySQL Workbench Community 8.0.31-1 on Ubuntu 22.04 but when I open it through the icon or the terminal window it looks like gibberish. I'm running Ubuntu through ...
- 21
1
vote
0
answers
171
views
MySQL error while create databaseon mariadb
Trying new adventures, been set up cacti on my VirtualBox Machine, sticking to vary instructions, exploring my problem I stuck in, but can't go further.
I'm doing alright till I'm creating database on ...
- 11
0
votes
1
answer
436
views
MySQL Workbench and snap - how to change code_editor.xml
I have MySQL Workbench Community ver 8.0.29 installed as snap.
I would like to change some settings in code_editor.xml file.
The full path is /snap/mysql-workbench-community/10/usr/share/mysql-...
- 1
0
votes
1
answer
482
views
after a reinstall I'm having issues with OPcache Memcache Redis when Nextcloud tries to run cron
I had issues with mysql not being able to be updated. I ended up having to uninstalling it, which uninstalled a lot of other files and unfortunately I did autoremove. Anyways I did save a copy of what ...
- 2,801
0
votes
0
answers
416
views
ModuleNotFoundError: No module named 'mysql'
I need to run a python script when server start .
I add in rc.local /usr/bin/python3 /usr/bin/test.py , for this I have error
import mysql.connector as mysql
ModuleNotFoundError: No module named '...
0
votes
0
answers
584
views
MySQL suddenly fails to start
MySQL suddenly shuts down and fails at start. Problem in InnoDB that can't access directory.
I tried to set excuse me access to MySQL but still can't.
The log is:
2022-12-16T05:16:36.560556Z 0 [ERROR] ...
0
votes
1
answer
888
views
Set MySQL default-time-zone to Europe/Berlin results to MySQL crash
I'm running a VPS with Ubuntu 18.04.6 LTS (GNU/Linux 4.15.0 x86_64) and MySQL 5.7.40.
Until now I always took the following steps to setup the right time zone for MySQL on a new server:
First: sudo ...
- 153
0
votes
0
answers
143
views
Installing LAMP stack without MySQL on AWS
I want to host basic websites on AWS. I got my head around creating an instance, choosing a distro (Ubuntu) and installing Apache. I want to install PHP, but these basic websites don't require a ...
- 101
0
votes
0
answers
130
views
mariadb earlier versions
So I'm using zabbix 6 which does not actually support mariadb above 10.08
I manage to install mariadb 10.08 but today I see a log message that says:
the repository ( meaning mariadb 10.08) no longer ...
- 19
0
votes
0
answers
167
views
Cannot upgrade, uninstall, reinstall, install, remove or remove purge MySQL or MariaDB in Ubuntu 20.04
I'm trying to upgrade MySQL, but can't because of this kind of message:
The following packages have unmet dependencies:
mysql-server-8.0 : Depends: mysql-server-core-8.0 (= 8.0.31-0ubuntu0.20.04.1) ...
- 1,596
0
votes
0
answers
23
views
Connect new mysql installation to legacy DBs
I created a collection of DBs housed on an external HD using MySQL on a Ubuntu partion (v 18.04).
I ended up needing to reinstall Ubuntu, so lost the original mysql installation; having reinstalled on ...
- 163
0
votes
0
answers
254
views
How can I move MySQL's default storage location?
Background info:
The default installation of MySQL server 8.0 from APT was filling my root partition.
So I recently installed a new drive on my system intended to hold large datasets, including a ...
- 1
0
votes
0
answers
591
views
zabbix installation with the MySQL support
I'm trying to install zabbix on my ubuntu 22.04 server.
I installed the zabbix 6.1 repository on my system.
when I try to install zabbix server with mysql support it returns the following:
$ sudo apt ...
- 19
0
votes
1
answer
110
views
Default mySQL user behavior not matching online guides
My issue resembles this one, this, and this but is not the same. It includes this problem.
I am installing mySQL on a fresh Ubuntu 22.04 per this guide from DigitalOcean.
It is very straightforward, ...
- 105
-1
votes
1
answer
1k
views
Automatic backups of MySQL database with Cronjob
I would like to backup my MySQL database with a cron job, but I cannot make it work.
This is the code that I am using:
0 2 * * * mysqldump -u root toko_db | gzip > /var/backup/toko_db_`date '+%Y-%m-...
- 3
0
votes
0
answers
1k
views
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) after mysql -u root -p
I am on Ubuntu 22.04 and MySQL version 8.0.30. I start mysql using the command:
systemctl start mysql.service
When I run systemctl status mysql.service I get this output:
mysql.service - MySQL ...
- 147
0
votes
0
answers
64
views
Can't connect to local MySQL server through socker
I am using Ubuntu 20.4. LTS version.
I sucessfully installed mysql server with
sudo apt install mysql-server
Than I checked
mysql --version
and it says: mysql Ver 8.0.31 for Linux on x86_64 (MySQL ...
- 101
0
votes
0
answers
693
views
Permissions problem in Ubuntu when accessing airflow webserver as root and non-root user
I have followed this guide to install MySQL for aiflow on Ubuntu 22.04.
https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-22-04
I have created a non-root administrative ...
- 101
0
votes
0
answers
440
views
Installing MySQL as database for airflow - password issue
I have Ubuntu 20.04.4 LTS (GNU/Linux 5.10.102.1-microsoft-standard-WSL2 x86_64) on WSL2.
I'm following this guide to install Mysql and have reached step 4 where I have chosen MEDIUM and was prompted ...
- 101
0
votes
0
answers
1k
views
how to start mysql server on Ubuntu 20.04
I have Ubuntu installed via WSL 2 like so:
Ubuntu 20.04.4 LTS (GNU/Linux 5.10.102.1-microsoft-standard-WSL2 x86_64)
I'm trying to install mysql-server with this command, 'sudo apt install mysql-server'...
- 101
0
votes
1
answer
729
views
installing libmysqlclient21 gives error
I am trying to install libmysqlclient21 on databricks as shown below
%sh
sudo apt-get update
sudo apt-get update -y --fix-missing
sudo apt-get install -y libmysqlclient21
But I get the below error:
- 101
0
votes
2
answers
2k
views
MySQL - Cannot update to 8.0.31 from 8.0.30 at Ubuntu 22.04.1
I have 2 updates that could not be installed automatically.
When I try to upgrade with: sudo apt upgrade then I got this message:
The following packages have been kept back: mysql-client mysql-server
...
- 103
0
votes
1
answer
31
views
Track Incomming Traffic
I am using a local server and I am using a puclic static IP to access my software. My question is, is there any way to track which IP or which device is trying to access my software or hitting my ip? ...
0
votes
1
answer
351
views
Increase Mysql row size
When I run a laravel migration i get an error complaining about row size how can i solve i have run a couple of commands but not changed anything
SQLSTATE[42000]: Syntax error or access violation: ...
0
votes
1
answer
240
views
apt-get upgrade fails on mysql 5.7.40-0ubuntu0.16.04.1+esm1-log
On Ubuntu 16.04 ESM, upgrades went fine for a while. When it initially upgraded MySQL to 5.7.40, it ran the post-install script successfuly - so all the tables are in good shape and everything works, ...
- 387
0
votes
0
answers
6k
views
Unable to start MySQL Server. Failed to set datadir to '/var/lib/mysql/'
I have installed MySQL 8.0.31-1 Ubuntu 22.04 from the MySQL APT repository on a freshly installed Xubuntu 22.04. I am not able to launch MySQL Server. I got the following warnings and errors:
[Warning]...
- 1
0
votes
0
answers
1k
views
server timeout when install xtream ui
when i try to install xtream on my ubuntu server 18.04.6 with this lines
apt-get update && apt-get upgrade -y && sudo apt-get install mysql-server && sudo apt-get install ...
- 1
0
votes
1
answer
778
views
phpMyAdmin installation/config
I'm a noob to Linux and packages, not to mention websites and databases, however, I've followed this guide and completed all steps successfully and have a working wordpress site that I can access via ...
- 603
1
vote
0
answers
440
views
Access denied with MySQL root password
I installed MySQL on Ubuntu 22.04 and made a mistake.
When I do su - mysql -u root or su - mysql -u root I get Access denied for user 'root'@'localhost' How can I get this to work again?
[1]+ Stopped ...
