Questions tagged [mysql]
Questions regarding the MySQL database server, client and tools.
2,943
questions
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 ...
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 ...
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 ...
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 [...
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 ...
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: ...
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 ...
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....
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 ...
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/...
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 ...
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 ...
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-...
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 ...
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 ...
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 - ...
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....
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/...
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/...
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 ...
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' (...
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, ...
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 ...
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....
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 ...
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
...
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 ...
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 ...
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 ...
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 ...
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 ...
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
...
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 ...
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-...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 '/...
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....
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 ...
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::...
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 ...
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 ...
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 ...
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, ...