Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

Filter by
Sorted by
Tagged with
0
votes
0answers
7 views

Instalation incomplete of mysql-server-8.0 in Kubuntu 20.04

I'm unable to start my MySQL server on Kubuntu 20.04. I've tried many times to install and to remove the installed packages, and I've followed this thread Can't get MYSQL8 to work on Ubuntu 20.04. ...
0
votes
0answers
17 views

copied mysql table doesn't allow to edit

I created (copied) a table through mysql. "CREATE TABLE bal0321 AS SELECT * FROM balance". But the new table doesn't allow to edit records. Why ?
0
votes
1answer
55 views

Configuring phpMyAdmin - ERROR 1045 (28000): Access denied for user debian-sys-maint'@'localhost'

I know that this question has already been asked but the answers do not solve my problem. MySQL-Server version: 8.0.23-0ubuntu0.20.04.1 (Ubuntu) OS: Kubuntu 20.04 amd64 I have now uninstalled and ...
1
vote
1answer
15 views

how to completely remove mysql community workbench from my system

I installed an old version of mysql workbench which was not compactible two years ago.Recently, I decided to install mysql server 8.0.24 using apt but I could not connect to mysql workbench community ...
0
votes
1answer
18 views

MYSQL Workbanch (snap) show permission denied error when i importing files

MYSQL Workbench (snap) shows a permission denied error when I importing files. place help
0
votes
1answer
13 views

Where to place temporary cvs bulkload file for mysql

I have a small mysql database and I want to use a cvs file to load the data. Currently the data is in /downloads and this is not accessible to mysql. I want to put it someplace where I do not need to ...
0
votes
1answer
22 views

Where to make configuration changes to MySQL in Ubuntu 20.04?

I have a couple of Ubuntu 20.04 servers running on AWS, using MySQL 5.7 rather than 8.0. When I set up the server I did some modifications to /etc/mysql/mysql.conf.d/mysqld.cnf and everything worked ...
0
votes
0answers
18 views

AWS ARM EC2 Not able to access apache after installation

So, I pull up my favorite instructions to install LAMP. https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-20-04 AWS only has instructions for ...
0
votes
0answers
33 views

Ubuntu Focal Fossa Installed but some leftover Eoan Ermine exists

A while back I had considerable difficulty upgrading my system from 19.04 to 20.04 and after it updated itself to 19.10 Eoan the lingering affects of multiple errors seem to keep it from updating so ...
0
votes
0answers
16 views

recover mysql databases from physical files in ubuntu

Is there any way to restore mysql databases from physical files? It's in case at some point the system crashes and I can't back up the databases. My version of mysql is 8.0.23. I have to point out ...
0
votes
0answers
21 views

Issues with MariaDB 10.3 development libraries and Ubuntu 20.04

Trying to install any of the MariaDB 10.3 development library packages for the version that comes with Ubuntu 20.04 seems to result in circular or unmet dependencies. I ran into this when trying to ...
0
votes
0answers
24 views

cannot install mysql server

Shows this error: Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an ...
0
votes
0answers
19 views

Raspberry Pi - Ubuntu will not boot

I am running apache2 and a MYSQL database on a Raspberry Pi 4 with a 32 GB SD card. Ubuntu version is 20.10. This Pi is used to host a local database, that is frequently updated via a python program. ...
-2
votes
0answers
21 views

Use a search word to retrieve database records and display in Python GUI [closed]

[enter image description here] 1 Hello from the other side. A true programmer doesn't run away from challenges but would make every attempt to provide a solution. smiles I'm having a little challenge ...
0
votes
1answer
55 views

phpmyadmin “503 service not available”: Unbuntu 20.04, MySQL 8.0

I'm having a major problem getting phpmyadmin working again (it used to work on 16.04). I upgraded Ubuntu 16.04 to 20.04 yesterday and got the following versions of stuff: MySQL 8.0.23-0ubuntu0.20.04....
0
votes
1answer
223 views

Can't install mysql-server with 'sudo apt install mysql-server' [closed]

i'm new in linux and i got a problem: can't install mysql after downloading mysql-apt-config_0.8.17-1_all.deb from mysql official page and configuring it using: sudo dpkg -i mysql-apt-config_0.8.17-...
0
votes
0answers
31 views

Mysql logrotation doesn't work

I'm having trouble making Mysql log rotation working. I don't know why this is so complicated , even though I followed documentation and internet advice, still cannot make it work. I have enabled all ...
0
votes
1answer
38 views

MySQL passwordless access via SSH tunnel - Access denied for user 'root'@'localhost'

I have a new MySQL 8 server installed. Fresh, clean, straight from the package. Now I want to connect to it with DBeaver (a GUI tool). It has a secure feature as SSH tunnel. The tunnel works. I ...
0
votes
1answer
83 views

“Data Dictionary upgrade from MySQL 5.7 in progress” takes forever for some small databases

I made release update recently from 18.04 to 20.04. After update SQL doesn't work. After checking status with systemctl status mysql.service I get this: ● mysql.service - MySQL Community Server ...
0
votes
1answer
49 views

Cannot install / start mysql server: failed to start mysqld daemon error, ubuntu 20.04

I finally upgraded to the new ubuntu lts version, but had several problems before it finally worked (I removed python 2.7 for it to finally install - don't know if this is maybe relevant so just in ...
0
votes
0answers
51 views

Ubuntu 20.04 Mysql wont start

I am getting this error message: root@ubuntu:/# systemctl status mysql ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: loaded (/etc/init.d/mysql; generated) ...
0
votes
0answers
29 views

Mysql Failed to start MySQL Community Server on ubuntu 20.04

I have used various methods including changing mysql folder access permissions, etc. but it still doesn't work, when I change the folder access permissions nothing happens. mysql.service - MySQL ...
0
votes
1answer
41 views

Why can't I start mysql?

I am running on Ubuntu 20.04 with MySQL 8 and ever since I ran the command Sudo service mysql restart I receive this in terminal: Job for mysql.service failed because the control process exited with ...
0
votes
0answers
12 views

Ubuntu install and configure for OpenRealty script?

I'm trying to verify what version of Ubuntu server I should use and process for installing / configuring the following requirements. Assuming Ubuntu 16.x but with the PHP SuExec/SuPHP all the ...
0
votes
0answers
18 views

Script always running on ENTRYPOINT dockerfile but i only want him to run once

I tried to set up a Wordpress solution (installing by myself and not using an official image). I have one container with Apache, PHP and Mariadb-client (to interrogate Mariadb-server from another ...
0
votes
2answers
23 views

Separate LAMP in 2 servers

I wanna isntall apache + php in a server and my sql in another server How can they communicate ? What should i install in both servers and what should i do to let them communicate so the web ...
0
votes
0answers
15 views

Restore a MYSQL database from physical files

I know this question has been asked many times but it doesn't work for me. I saved the file /var/lib/mysql and when I replace it, I get an error message and MySQL doesn't want to start anymore: Can't ...
0
votes
0answers
20 views

Unable to reinstall mysql-server

Ok so i was getting some errors on mysql i was not able to fix after looking for hrs. So i decided to reinstall mysql-server on my ubuntu server, but after trying to uninstall and reinstall it for ...
1
vote
0answers
49 views

Release upgrading 18.04 LTS to 20.04 LTS breaks mysql-server 5.7?

L.s. I work for a managed hosting company and because of Ubuntu 16.04 has gone EOL we are pushing our clients to dist-upgrade their servers. Most clients preffer the least amount of downtime and want ...
0
votes
0answers
15 views

How can I install php5 and php5-mysql in Ubuntu 18.04?

I have an application that used php5 and php5-MySQL, I tried to use php5.6 and php5.6-mysql, but it doesn't work because of Grant Privileges. How can I install php5 in Ubuntu 18.04 ?! Note: I can't ...
1
vote
1answer
53 views

Why is 'my_global.h' from libmysqlclient-dev is missing in Ubuntu 20.04

There's package libmysqlclient-dev, providing MySQL API. In Ubuntu versions before 20.04 it contains header file '/usr/include/mysql/my_global.h', but in 20.04 there's no such file in package, as well ...
0
votes
1answer
18 views

C# + mysql + ubuntu server encoding issue

While working on project, which requires database (mysql) usage, I faced an interesting issue, touching cyrillic handling. Firstly, on the stage of developing everything was pretty nice and ...
1
vote
0answers
27 views

How to move MySQL data directory

I am trying to move the /var/lib/mysql data directory to a different drive. I have tried the solutions listed in https://www.digitalocean.com/community/tutorials/how-to-move-a-mysql-data-directory-to-...
-1
votes
1answer
74 views

MysqlDump problem on Ubuntu 20.04 - Error 2013

I would like to ask about problem with mysqldump on Ubuntu 20.04 (I'm using DBeaver, but same problem is in all apps and also in dumping from console). I found a few threads in discussions about this ...
0
votes
0answers
27 views

MySQL 5.7 ENCRYPT(str,salt) (Deprecated now) vs. MySQL 8.0 SHA2(str, hash_length)

I have got an Ubuntu Sever 18.04 running Postfix + Dovecot + ... MySQL 5.7 is installed to contain user password hashes by using strong salt. MySQL 5.7 ENCRYPT(str,salt) has been used to generate the ...
1
vote
0answers
84 views

Broken mysql v8.0 installation on wsl2 and Ubuntu 20.04

I am close to giving up on this having spent hours and hours working on it. I am also a newbie when working with mysql, as I usually work with Rails and Postgres, so bear with me. I am a wsl2 user, ...
1
vote
1answer
46 views

WGET image files from source server using CRON to run a SCRIPT using a PHP-mySQL-based generated list

I am trying to setup a process which would do the following : I have a folder where image files are stored (various resolutions : l/m/s/xs): WORKING ! each day, a mySQL table is updated/completed ...
0
votes
1answer
26 views

Should I stop services when performing release upgrade?

Should I stop services like mysql and postfix before performing release upgrade(from 18.04 to 20.04)? Is there a risk of data loss/corruption if I don't?
0
votes
0answers
86 views

E: Unable to correct problems, you have held broken packages while installing mysql on ubuntu 20.04

altius@altius-HP-ProBook-440-G5 ~ $ sudo apt install -f mysql-client=5.7.33-1ubuntu18.04 mysql-community-server=5.7.33-1ubuntu18.04 mysql-server=5.7.33-1ubuntu18.04 Reading package lists... Done ...
0
votes
0answers
59 views

How do I completely uninstall and reinstall MySql without removing packages listed as dependencies?

About a month ago MySql server 8 stopped working on my Ubuntu 20.10 machine. I don't know what caused the problem but I suspect this followed an update. Since then I've scoured the Web for solutions ...
1
vote
1answer
67 views

mysql-connector-java

I have put the mysql-connector-java-5.1.34-bin.jar in /usr/share/java directory. Added that path in my CLASS_PATH. But I get the error "java.lang.ClassNotFoundException: com.mysql.jdbc.Driver&...
0
votes
1answer
66 views

Installing mysql-server showing error. Unmet dependencies:

I am trying to install mysql-server on Ubuntu 20.04 LTS. But I get this error: Reading package lists... Done Building dependency tree Reading state information... Done You might want to run '...
1
vote
1answer
1k views

How can I fix: MySQL can't find mysqli.so or xml.so

I bought a new laptop and installed Ubu 20.04. I downloaded the latest apache2, php and mysql I got phpMyAdmin from their own webpage, because, previously, when I used the Ubuntu supplied version, I ...
1
vote
1answer
94 views

Impossible to install MySQL 5.7 on Ubuntu 20.04

This is what I've done so far on a fresh Ububntu 20.04 installation: wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb In the prompt, I ...
0
votes
0answers
34 views

Mysql Server Fails to Start

I am attempting to start mysql in Pop OS kernel 5.11 and I get this error message when I try to run sudo service mysql status : ● mysql.service - MySQL Community Server Loaded: loaded (/lib/...
0
votes
1answer
24 views

Why is MySQLd not loading the cnf file?

I recently installed a test mysql server instance on Ubuntu 18.04 with MySQL 5.7.33. When the server starts, it's using defaults and not the proper cnf file. root@host2:~# mysql --help | grep "...
2
votes
0answers
434 views

“pip install MySQL-python” not working on Ubuntu 20.04

When I try to install MySQL-python using pip for Python 2.7, it is not working anymore on Ubuntu 20.04 - on Ubuntu 18.04 it still works... Any idea of how I could make this run on Ubuntu 20.04? I know ...
0
votes
1answer
23 views

mysql server error ubuntu 20.04 [duplicate]

I accidentally stopped the installation of mysql while setting the root password and now I can't, neither open the application, nor uninstall it. sudo apt-get remove --purge mysql* returns E: Could ...
0
votes
0answers
44 views

phpmyadmin not found after install on VPS

Hello i installed phpmyadmin on ubuntu 20.04, i did all the updates, when i type on Google Chrome IP/phpmyadmin says Not Found The requested URL was not found on this server. Apache/2.4.41 (Ubuntu) ...
0
votes
1answer
43 views

Ubuntu 20.04 ownCloud error

I'm having some issues with a fresh installation of ownCloud on my Ubuntu 20.04 desktop. This is what i get after trying to login:

1
2 3 4 5
54