Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

Filter by
Sorted by
Tagged with
0 votes
1 answer
16 views

mysql problem connecting

I want to open mysql and I cant. I write this command in terminal: mysql -uroot -p and the it says: Enter password but I don't remember what the password is,so what can I do now? Thanks.
user avatar
2 votes
0 answers
89 views

Unable to start mariadb service on WSL2 (Win10) Ubuntu 22.04

I'm trying to run the mariadb service on Ubuntu 22.04 on WSL2 but with no success. The MariaDB service could not be started. Environment: Microsoft Windows [Version 10.0.19044.1645] WSL2 with Ubuntu-...
user avatar
  • 121
0 votes
1 answer
24 views

Akonadi on KDE can't start due to "Unknown error" and I can't update MariaDB

Konact / KMail does not want to start anymore, because Akonadi fails. I am not able to start akonadi ~$ akonadictl --verbose start Connecting to deprecated signal QDBusConnectionInterface::...
user avatar
  • 379
2 votes
0 answers
87 views

Ubuntu 22.04 Unable to run database via docker

Since I updated my Ubuntu version my Docker container mysql:8.0.23 is not able to successfully run anymore. My Docker version is: 20.10.12 Docker Compose version is: v2.4.1 The problem itself is that ...
user avatar
0 votes
2 answers
178 views

Ubuntu 20.04 - Can't update mysql-client and mysql-server packages

Before updating to Ubuntu 20.04 from 18.04, I decided to first update MySQL from 5.5 to 8.0. I then updated to Ubuntu 20.04 and all was well, until some updates for mysql-client and mysql-server came ...
user avatar
  • 1
0 votes
0 answers
94 views

Cannot log in through phpmyadmin to mysql in my container

I'm trying to have one docker container with: ubuntu 20.04, on top of which I add apache, php, mysql and phpmyadmin (all on the same container) What's installed: mysql Ver 8.0.29-0ubuntu0.20.04.2 ...
user avatar
  • 101
0 votes
0 answers
122 views

Ubuntu 22.04 Multiple Issues

Have done six installations on different hardware. Installing from two different iso images downloaded from the Ubuntu.com download page and using both dvd and flash drive installation media produces ...
user avatar
0 votes
0 answers
19 views

Init Script is failing?

I am using a init script for databricks cluster and the below is the script: #!/bin/bash apt-get -y update && apt-get install -y libudunits2-dev libgdal-dev libgeos-dev libproj-dev This ...
user avatar
  • 1
5 votes
2 answers
9k views

MySQL root password setup error

I am working on a project and I have been trying to use MySQL instead of SQLite. So I downloaded MySQL and I am trying to set the root password with mysql_secure_installation, but when I submit both ...
user avatar
  • 51
1 vote
0 answers
60 views

Why can't my mysql start after modification datadir?

question os:ubuntu 20.04/22.04(have tried) mysql: mysql8 disk: mechanical hard drive Modifying the storage path mysql will not start. I have followed the instructions on the internet countless times, ...
user avatar
  • 11
0 votes
0 answers
29 views

'package is in a very bad inconsistent state' when installing mysql-server-8.0 on my VPS

I got an error after trying to install `mysql-server-8.0 on Ubuntu 20.04 on my VPS. I tried to purge it, and this Reading package lists... Done Building dependency tree Reading state ...
user avatar
  • 1
0 votes
0 answers
13 views

MYSQL error while trying to connect wordpress database

When I connect to my WordPress site in a browser, I see this: When I check on the status of MySQL in Terminal, I see this: sudo systemctl status mysql ● mysql.service - MySQL Community Server ...
user avatar
2 votes
0 answers
270 views

Unable to install mysql-server on ubuntu 22.04 LTS

I am trying to install mysql-server on ubuntu 22.04 LTS but I am getting the following dpkg error message. How can I fix this issue ? Reading package lists... Done Building dependency tree... Done ...
user avatar
  • 43
0 votes
0 answers
142 views

Installation of MySQL 8.0 with Ubuntu 22.04 (jammy)

I was building a docker container with Ubuntu 22.04 including MySQL 8.0 yesterday. At first everything was fine, the containers bash shell runs as root and I could connect to the database via the ...
user avatar
0 votes
0 answers
15 views

Mysql refusing to start

Good day , I have upgarded to ubuntu 20.04 from 16.04 but now MSQL is failling to start . When i try to restart MySQL it says -> Job for mysql.service failed because a fatal signal was delivered to ...
user avatar
  • 1
0 votes
1 answer
40 views

20.04.04 libmysqlclient21 breaks wine

Due to unknown reason the upgrading of libmysqlclient21 from focal-proposed started to require to remove libsnmp:386,libsane:386 and wine-stable:386, thus removing the entire wine installaion (wine, ...
user avatar
0 votes
0 answers
152 views

MySQL Access denied for user 'xxx'@'localhost' while create connection in Java

There are user 'pawa' on my Ubuntu. When I try create Connection object with code: Properties properties = new Properties(); properties.put("user", "root"); properties.put("...
user avatar
0 votes
1 answer
90 views

MySQL server not starting Ubuntu 20.04.3

I have been trying to install the mysql-server on my ubuntu server, but it just gives me this error when I type: mysql This is what I get: ERROR 2002 (HY000): Can't connect to local MySQL server ...
user avatar
1 vote
0 answers
29 views

Unable to purge MySQL

I am using an Ubuntu 20.04 VPS. I've recently been having some issues with MySQL, so I decided the best way to fix it would be to reinstall it. So I made a backup of all my DB's and wanted to purge it....
user avatar
  • 11
0 votes
0 answers
41 views

Tussling with upgrade to mysql-8.0 on 20.04

I recently upgraded to 20.04 and discovered that mysql was borked. It was suggested that I purge mysql entirely and restart from scratch. Prior to doing this, I downgraded to 5.7 using these ...
user avatar
1 vote
0 answers
131 views

Problem with mysql-8.0 when upgrading to 20.04

I'm updating to Ubuntu 20.04, but mysql is hitting problems. I don't know much, so any help is appreciated. Here's the output of apt install mysql-server: jesse@nietzsche:~$ sudo apt install mysql-...
user avatar
0 votes
1 answer
43 views

Cant start mysql

When i try to run sudo service mysql start it just kinda "loads" no output or nothing. nothing is shown in the error logs. sudo service mysql status mariadb.service - MariaDB 10.3.32 ...
user avatar
  • 1
0 votes
1 answer
89 views

MySQL not starting in Xampp? [duplicate]

I'm using Ubuntu 21.10 & Xammp 8.1.4. Apache web server & ProFTPD servers are running well. I have problems with MySQL server that is not running: root@user-Inspiron-7386:~# /opt/lampp/lampp ...
user avatar
0 votes
1 answer
37 views

Mysql directory path in ubuntu 20.04 tls

I have a backup of a database that is more than 500MB and I need to restore on a server, but every time phpMyAdmin give me error. I want to restore it by uploading the file in my server then from ...
user avatar
0 votes
1 answer
112 views

How work Phpmyadmin for php 5.6 on Ubuntu 20.04?

I have a problem with the installation of phpMyAdmin in my server Ubuntu 20.04. My version of php is 5.6 but when I install phpMyAdmin and open url /phpmyadmin in my browser, I get the error HTTP ...
user avatar
  • 1
1 vote
0 answers
44 views

Ubuntu 20.04.3 LTS on Raspberry PI - MySQL was working and then stopped

I have been using MySQL with Ubuntu 20.04.3 on Raspberry PI for about 3 months with absolutely no problem but earlier this week I discovered mysql.service was no longer running. As this is definitely ...
user avatar
  • 11
0 votes
0 answers
24 views

Without any reason MySQL usage goes down

Without any reason, my MySQL server hangs. For example, when I start my ubuntu server it works properly for the first 3hours then MySQL server usage goes down. After that, I restart my server it will ...
user avatar
1 vote
0 answers
51 views

Logrotate syslog and mysql error

OS version: 20.04 When trying to manually logrotate, there are errors rotating syslog and mysql. ~$ sudo logrotate -f /etc/logrotate.conf error: rsyslog:4 unknown unit 'e' error: found error in /var/...
user avatar
0 votes
0 answers
123 views

MySQL remote connection timeout and port 3306 close

I've been searching through the whole a fix but nothing worked. I'm trying to allow remote access to my MySQL db. I've been editing my /etc/mysql/mysql.conf.d/mysqld.cnf to modify bind address to set ...
user avatar
0 votes
0 answers
145 views

Ubuntu 20 stopping MySQL for automatic update

I have Dovecot server with MySQL. Ubuntu is stopping MySQL automatically which causes problems in Dovecot. Why does this happen? How to disable auto update on MySQL or Ubuntu server? Logs: Mar 8 06:...
user avatar
2 votes
0 answers
79 views

I can't fix broken packages

I can't fix this problem. I don't know how. I followed a tutorial on youtube and I downloaded the deb package on this site dev.mysql.com/downloads/mysql and I tried installing it. It didn't work and ...
user avatar
0 votes
1 answer
59 views

Server migration: mysql

What is the best and fastest way to move mysql when changing servers? Currently I do it through phpmyadmin, I backup the db in the old server, open a new user in the new server, create a new database ...
user avatar
  • 425
0 votes
0 answers
40 views

MySQL access denied error keeps coming back

About every month, I get the following error: MySQL Error: : 'Access denied for user 'root'@'localhost' I navigate to this StackOverflow question on how to deal with the error, and then I get back ...
user avatar
1 vote
1 answer
51 views

LAMP Installation on Ubuntu 20.04 LTS - issue with phpmyadmin installation

I get below error when installing phpmyadmin Depends: php7.4-common (= 7.4.3-4ubuntu2.8) but 7.4.28-1+ubuntu20.04.1+deb.sury.org+1 is to be installed E: Unable to correct problems, you have held ...
user avatar
  • 11
2 votes
0 answers
110 views

Mysql 8.0 with Letsencrypt SSL on Ubuntu 20.4

I installed a Letsencrypt SSL certificate on my Ubuntu 20.4 VPN server and it works. Now, I am trying to configure mysql on this server for SSL. I read many relating posts that deal with the same ...
user avatar
  • 31
0 votes
1 answer
98 views

uninstalled and reinstalled mysql on ubuntiu 18.04: mysqld not found

I uninstall and then reintall mysql on ubuntu 18.04, and after that I tried the following: $ sudo service mysql start ~$ sudo /etc/init.d/mysql start [ ok ] Starting mysql (via systemctl): mysql....
user avatar
0 votes
0 answers
27 views

Eror message task hung block 120 seccond

I get an error message on my Ubuntu server 18.04.5 and 20.04.1 and can't run my system. How can I solve this?
user avatar
0 votes
0 answers
32 views

Q.How to Retrieve File/Image from Database And Display in JSP web page using Hibernate , MySQL Database?

I need a code that can help me to retrieve my image/file from Mysql database and also display it on the webpage(.jsp) by using HIbernate and Servlet JSP. Q.How to Retrieve File/Image from Database And ...
user avatar
1 vote
0 answers
87 views

NextCloud - MySQL Broken Packages Error

I'm still pretty new to the Linux/Terminal world, but I've really fallen in love with all the neat tools and doors open to this OS. I am trying to set up NextCloud on Ubuntu Server 20.04.3, following ...
user avatar
0 votes
0 answers
142 views

mysql installation on Ubuntu 18.04, E: Sub-process /usr/bin/dpkg returned an error code (1)

I tried to install mysql on ubuntu 18.04 using: $ sudo apt install mysql-server I got the message: dpkg: error processing package mysql-server (dependency problems) I followed the steps at: dpkg: ...
user avatar
2 votes
1 answer
808 views

Cannot remove mysql-server-8.0 on Ubuntu 20.04

after dist upgrading Ubuntu to Ubuntu 20.04 mysql does not work. I tried to remove it and my goal is to reinstall it. The problem is that I can not remove mysql-server-8.0: sudo dpkg -r --force-all ...
user avatar
  • 131
0 votes
0 answers
15 views

Everything I tried to update I received this message [duplicate]

$ sudo apt -f install Reading package lists... Done Building dependency tree Reading state information... Done Correcting dependencies... Done The following packages were automatically ...
user avatar
0 votes
0 answers
78 views

new install of ubuntu 20.04.03, mysql 8.0.28, and zoneminder 1.34 from ppa:iconnor/zoneminder-master: mysql won't start

#mysql gets ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) no /var/run/mysqld directory no mysqld.socket listed under find / -type s But ...
user avatar
  • 11
-1 votes
1 answer
146 views

Can't remove mysql completely

I tried many times to completely remove MySQL from my system without success. I get these errors: I also tried other commands without success. What should I do? Here is the output of apt list --...
user avatar
0 votes
1 answer
386 views

Unable to install MySQL

I am totally new to using Ubuntu. I don't even know a single command to run. I'm trying to install MySQL but an error is always there. I ran this command: sudo apt-get install mysql-community-client-...
user avatar
0 votes
0 answers
13 views

Showing characters on website for data saved in database

I have upgraded database to version mysql-8.0 8.0.28-0ubuntu0.20.04.3. But its starting showing the invalid characters from database on website. Can you please tell how can we resolve this. I have ...
user avatar
0 votes
0 answers
90 views

MySQL upgrade from 5.7 to 8.0, run the process automatically

I would like to upgrade MySQL from 5.7 to 8.0 on my Ubuntu 18.04 I installed the package with the command : $ sudo dpkg -i mysql-apt-config_0.8.22-1_all.deb After I done with this step, I have to run:...
user avatar
  • 137
1 vote
1 answer
228 views

Install python-mysqldb for Python 2.7 in Ubuntu 20.04 - unmet dependencies

I am trying to install python-mysqldb for Python 2.7 in Ubuntu 20.04: $ sudo add-apt-repository 'deb http://archive.ubuntu.com/ubuntu bionic main' $ sudo apt update $ sudo apt install -y python-...
user avatar
  • 2,333
3 votes
1 answer
3k views

MySQL: An error occurred during the signature verification [duplicate]

Through VirtualBox, even in different machines, I have 2 Ubuntu Server 20.04 instances running with the following info: lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: ...
user avatar
1 vote
1 answer
355 views

Installing 8.0.28 mysql on Ubuntu 20.04?

8.0.28 As its release date was only few days ago,I cannot install it because it is not in the official ubuntu repo yet. I cannot work out how to actually manually install it either. I have tried ...
user avatar

1
2 3 4 5
56