Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

Filter by
Sorted by
Tagged with
1 vote
0 answers
116 views

I broke MySQL and can't figure out what's wrong

Ubuntu Server 20.04 Somehow in the course of trying to install phpmyadmin, I broke MySQL and I can't figure out how to fix it. I originally installed the LAMP stack via tasksel. In the course of ...
Abdul-Hakeem's user avatar
2 votes
2 answers
15k views

How to install MySQL 8.0 with lower_case_table_names=1 on Ubuntu Server 20.04 LTS successfully?

It seems to be a lot of trouble to get MySQL running with lower_case_table_names=1 as can be seen in: lower_case_table_names=1 on Ubuntu 18.04 doesn't let mysql to start lower_case_table_names ...
stackprotector's user avatar
0 votes
1 answer
282 views

How can I install 2 mysql instances in ubuntu using the generic binaries?

I want to install 2 mysql versions, one on the default port (3306) and the other on the 3308 port, on ubuntu 18.04 using the tar.gz file for generic binary installation. I would really appreciate if ...
Nuzrah Nilamdeen's user avatar
0 votes
0 answers
399 views

Can't connect to local MySQL server through socket problem

Did anyone experience this issue? root@spmmktlxcrm002:~# tail -f /var/log/upstart/mysql.log Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! 200722 11:16:11 [...
Silver Dangeros's user avatar
3 votes
3 answers
1k views

Why do I have to use MySQL from terminal only? [duplicate]

I managed to install MySQL on Ubuntu 20.04 from the terminal. Everything went perfectly. But why can't I access MySQL like any normal application, i.e., from the menu? The only way I can use it is ...
miuuna11's user avatar
2 votes
1 answer
3k views

Mysql show error /etc/profile.d/wsl-integration.sh: cannot create //.cache/wslu/integration: DirectoryWSL: Ubuntu

I install mysql in WSL: Ubuntu 18.04 when I restart mysql sudo service mysql restart show error: No directory, logging in with HOME=/ mkdir: cannot create directory ‘//.cache’: Permission denied -su: ...
lili's user avatar
  • 21
2 votes
1 answer
2k views

Mysql database restoration from folder backup

I need to restore from folder backup my mysql databases. I have a complete /var/lib/mysql folder backed up with all the files. I have a fresh install of mysql. I copied back from the backup the ...
c001os's user avatar
  • 327
8 votes
4 answers
40k views

Unable to install mysql 5.7 on ubuntu 20.04

Can anyone help me in installing mysql 5.7. I tried following this answer, but when I run sudo apt-cache policy mysql-server It gives me: 8.0.20-0ubuntu0.20.04.1 500 500 http://pk.archive.ubuntu....
Maaz Anzar's user avatar
2 votes
2 answers
5k views

Error when installing mysql-server - now I cannot install any package

I have Ubuntu 20.04. mysql-server failed to install. Now, when I run sudo apt install -f I get $ sudo apt install -f Reading package lists... Done Building dependency tree Reading state ...
Jerguš's user avatar
  • 751
0 votes
1 answer
5k views

Access denied when using mysqli with php

I want to connect to my database on my Linux machine with PHP (PHP 7.2.24-0ubuntu0.18.04.6 (cli)) using mysqli(). But whenever I try to access it, I get this error: Warning: mysqli_connect(): (HY000/...
Netsu's user avatar
  • 11
0 votes
2 answers
193 views

MySQL active after every boot, but I only want it to start when I need it [duplicate]

Whenever I boot, when I type systemctl status mysql.service, I see MySQL is running. I want to manually activate MySQL whenever I need it. I forget to turn off every single time I don't need the ...
Hakan Demir's user avatar
2 votes
3 answers
4k views

Error installing MySQL

In Ubuntu 20.04, I try to install mysql server: sudo apt install mysql-server and get the following error: Setting up mysql-server-8.0 (8.0.20-0ubuntu0.20.04.1) ... Renaming removed key_buffer and ...
Erel Segal-Halevi's user avatar
0 votes
1 answer
1k views

After upgrading to 20.04, my PHP+MySQL website stopped working

I had Ubuntu 16.04 where I could run a local website with PHP and MySQL. I upgraded to 20.04 and installed PHP 5.6 and linked it to Apache2: sudo apt install php5.6 sudo apt install libapache2-mod-...
Erel Segal-Halevi's user avatar
0 votes
0 answers
351 views

CPU load average spikes every hour with CPU 55% and memory 82% only

Our Digital Ocean droplet's CPU load average spikes every 1-1.5 hour. Here is the the performance graph for the past 24 hours: Here are some MySQL error logs for 1.5 hours (one cycle) as well as ...
Tom Jansen's user avatar
2 votes
1 answer
1k views

Deleted /etc/mysql/... now unable to install or uninstall other software

I was messing around with my mysql install and was trying to replace it with a mariadb-server installation. After using the typical commands for completely removing mysql I was unable to delete an old ...
Manfredovik's user avatar
2 votes
1 answer
8k views

Ubuntu 20.04 can't start mysql server

I did release-upgrade and after this upgrade I have problems with my mysql server. My server looks on place and it is running, but actually is not: systemctl status mysql.service ● mysql.service - ...
topche's user avatar
  • 21
0 votes
1 answer
6k views

Broken package of Mariadb

I am stuck and I don't know what to do anymore. I am trying to install Mariadb and then for some kind of occassion these errors persist like glue. dpkg: regarding .../mariadb-client-core-10.3_1%3a10.3....
Sam's user avatar
  • 101
0 votes
2 answers
345 views

Unable to remove package from Ubuntu software

I'm very new to Linux. so that i try Ubuntu. I install MySQL server and works then i install MySQL it shows me some error. And I get rid by reference documentation https://www.digitalocean.com/...
muthu kamalan .m's user avatar
0 votes
1 answer
360 views

Reload all my MySQL tables

Trying to set up phpMyAdmin I seem to have deleted all tables in my database: allstudentsdb The database allstudentsdb is still there, but empty. Good news: the tables were all saved in /var/tmp/...
Pedroski's user avatar
  • 375
0 votes
0 answers
132 views

MySQL aes_decrypt on Ubuntu 20.04 returns hex data

I recently installed Ubuntu 20.04 LTS on my 64 bit laptop. I also installed MySQL. Until now everything on MySQL was working well. However I am having problems with AES_ENCRYPT and AES_DECRYPT. I am ...
perlmaster56's user avatar
1 vote
1 answer
7k views

PHPMyAdmin - How to fix #1006 - Can't create database 'database_name' (errno: 13 "permission denied") in Ubuntu 20.04?

In my Ubuntu 20.04 (Desktop/Laptop not server) OS based machine I recently install XAMPP (Version: 7.4.7). Now when I try to create a database it shows #1006 - Can't create database 'database_name' (...
Shimul's user avatar
  • 131
0 votes
2 answers
8k views

Docker MySQL error no 'mysql' table

When I'm trying to boot up containers it fails logs ➜ enigma git:(master) ✗ docker-compose up --build Starting db ... done Starting nginx ... done Starting pma ... done Attaching to db, nginx, ...
Dmytro Soltusyuk's user avatar
1 vote
1 answer
264 views

how to move maven,spring boot,sql projects from one drive to another

I have two disks on my laptop after a recent ROM upgrade. I have all my java projects(used maven, spring boot and MySql) running on 128g disk(Ubuntu 20.04) and I installed Ubuntu on the new disk too ...
sonu ishaq's user avatar
1 vote
3 answers
2k views

error running shared postrotate script for mysql

I installed a new Ubuntu 18.04 server with mysql, and I receive the following error by email daily: Cron <root@www> test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron....
Uri's user avatar
  • 145
0 votes
0 answers
1k views

Completely reset mysql [duplicate]

I am having a lot of problems with mysql server. First, I couldn't log into the database, couldn't log in as root. When I ran mysql_secure_installation, it seemed to accept the password reset but ...
3x5's user avatar
  • 545
1 vote
2 answers
16k views

mysqld: Can't read dir of '/etc/mysql/conf.d/' (OS errno 2 - No such file or directory)

I am trying to install mysql-server by using sudo apt-get install mysql-server but apt says this: dpkg: error processing package mysql-server (--configure): dependency problems - leaving unconfigured ...
Tomáš Sidorják's user avatar
2 votes
0 answers
642 views

Not able to stop mysql --skip-grant-tables --skip-networking?

I used "--skip-grant-tables --skip-networking" command for reset root password. But after that my database running on the same mode. I completely uninstall mysql from my Ubuntu 18.0 by below ...
Sunil Kothiyal's user avatar
3 votes
3 answers
6k views

mysqld out of memory: Kill process

I did read and followed these 2 posts: MySQL out of memory Optimising MySQL settings - mysqld running out of memory but I still get this error: Jun 18 06:06:32 hamid kernel: [42478.128706] Out of ...
user3636770's user avatar
2 votes
1 answer
3k views

How to connect Libreoffice Base with mysql on Ubuntu 20.04?

I have a virgin install of 20.04 (instead of upgrading from 18.04, and older versions). mysql works, but I cannot use LibreOffice Base to connect to my database in mysql. This worked well in 18.04. I ...
Janos's user avatar
  • 951
1 vote
1 answer
2k views

Can't install mysql-server on Ubuntu 18.04

I cannot install mysql-server on my Ubuntu 18.04 VPS. I have already done sudo apt-get update && sudo apt-get upgrade as well as purging all mysql packages multiple times. Running sudo apt-get ...
Bunsen Burner's user avatar
1 vote
0 answers
2k views

Why is /dev/vda1 getting 100%? Disk size is 960GB

My Wordpress site crashed and when I logged in to the server to check, i am unable to start mysql because for some strange reason 960GB is 100% full (which shouldn't be, I don't have that much ...
LittleLebowski's user avatar
0 votes
1 answer
3k views

Problems whit MySQL workbench in ubuntu 20.04 'cannot connect to database server'

i installed mysql like this sudo apt-get install mysql-server mysql-client and i installed mysql workbench, from ubuntu software app.. and when i try to connect to the workbench this happens image ...
Gian Luka's user avatar
0 votes
5 answers
9k views

Mysql won't install on Ubuntu Server 20.04

I have looked at all the similar posts I could find on AskUbuntu or outside but could not find any that solved my issue.. I'm simply trying to install mysql on my server but can't seem to get it ...
Buno's user avatar
  • 163
15 votes
3 answers
33k views

Connect MySQL Workbench to WSL2

I have a brand new WSL2, running on the latest Windows 10 (2004) with Ubuntu 20.04, MySQL installed, I can access it from Bash and get the status -- mysql> status -------------- mysql Ver 8.0.20-...
Jim Dunn's user avatar
  • 311
1 vote
1 answer
3k views

Can't login into MySQL when installing MediaWiki (HY000/1045)

Trying to bind MediaWiki to mysql-server while installing it (the second step of installation) but got an error message: Cannot access the database: :real_connect(): (HY000/1045): Access denied for ...
Ms.Simpson's user avatar
5 votes
2 answers
13k views

Ubuntu 20.04 MySQL Datadir Permissions (Errno 13)

askubuntu.com, I need some help debugging my MySQL setup! For the past couple years, I have been hosting my local development resources on Dropbox, and it's been working wonderfully. This past week, I ...
Kyle Niemiec's user avatar
1 vote
1 answer
438 views

How do I mirror every inserts or updates from a table to another in MySQL? [closed]

Is there a way to mirror every inserts or updates from a table to another? I have a database where entries are create and if they are no longer required, they will be delete. But I want to intercept ...
NETFLOX's user avatar
  • 125
1 vote
0 answers
247 views

LAMP Mysql PDO FETCH_ASSOC is not working

I have a PHP script and it works well on hosting or on WAMP (in Windows), but when I try to run it on LAMP (in Ubuntu), it gives me this error: Fatal error: Uncaught Error: Call to a member function ...
Cat2972's user avatar
  • 19
1 vote
1 answer
586 views

mysql service starts during boot before its file system is mounted

After every boot of Ubuntu 20.04, I find that the mysql.service has failed to start - but I can restart it manually successfully. Looking in syslog during the boot, I can see that the mysql.service ...
flymike's user avatar
  • 287
0 votes
2 answers
4k views

No MySQL Privileges For Any Usr

I have searched previous posts for days now... and no solution seems to work, I am risking a "duplicate post"... PROBLEM: PHPMYADMIN installs flawlessly, but none of my users have even basic ...
nightwatch's user avatar
4 votes
1 answer
3k views

Unable to install mysqldiff on ubuntu 20.04

Since I've upgraded my system to 20.04 mysqldiff is missing. I found this package: https://manpages.ubuntu.com/manpages/focal/en/man1/mysqldiff.1.html but if I try to install it with apt, but it can't ...
László Katona's user avatar
0 votes
1 answer
3k views

MySQL max_connections of Ubuntu 20.04 LTS

I updated the file /etc/mysql/mysql.conf.d/mysqld.cnf to include line max_connections = 65535. I restarted the MySQL server with sudo service mysql restart. Then in the MySQL client I entered ...
James Read's user avatar
0 votes
1 answer
323 views

mysql installation issue - Ubuntu 18.04 bionic

On logging in to MySQL, I get the warning: mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/...
Disha Shetty's user avatar
3 votes
2 answers
8k views

Python install mysqlclient keeps on giving error

From a list of the following dependencies present in a requirements.txt file asgiref==3.2.7 astroid==2.4.1 colorama==0.4.3 Django==3.0.6 djangorestframework==3.11.0 djangorestframework-simplejwt==4.4....
Tiago Martins Peres's user avatar
4 votes
2 answers
23k views

Problems with mysql-workbench for Ubuntu 20.04 [duplicate]

Got an Ubuntu 20.04 VirtualBox VM and after installing MySQL server, wanted to install MySQL Workbench. I tried installing MySQL Workbench with APT first and ran: sudo apt install mysql-workbench sudo ...
Tiago Martins Peres's user avatar
0 votes
1 answer
1k views

Phpmyadmin access denied every time ubuntu restarts

I have a xampp installation on my ubuntu machine. And I am trying to use phpmyadmin to access mysql. But every time I start xampp and try to open phpmyadmin I get an error that says mysqli::...
Abdulaziz Yesuf's user avatar
2 votes
1 answer
1k views

How to install phpmyadmin on apache2 ubuntu 20.04 server

I have installed php7, and mariadb. And I have done these steps that written in this document: https://websiteforstudents.com/install-phpmyadmin-on-ubuntu-20-04-18-04-with-apache/ But I couldn't run ...
user avatar
1 vote
0 answers
843 views

WSL for 20.04 Lost mysql? I lost my databases. I can't dump connect start mysql

I have lost about £300 today as UBUNTU WSL will not let me install/ reinstall mysql on WSL. After i did an upgrade first i had an innodb corruption. So i followed this guide and did a backup of ...
tim golding's user avatar
0 votes
1 answer
335 views

Connection to MYSQL with command line using the password in quotes

Im giving a command line as -p$3 which will take the password and if the password dosent have $ it is working but if the password has $ the -p$3 is not working. How can we prompt the password which ...
Keshav R's user avatar
1 vote
1 answer
6k views

mysql-server-8.0 conflict, unable to install due to a conflict with "itself" [duplicate]

---I have already tried (twice)--- Install of mysql-server after mariadb fails mariadb is not the issue because although it was installed on this computer, all dependencies have already been removed, ...
Mario's user avatar
  • 73

1
10 11
12
13 14
59