Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

Filter by
Sorted by
Tagged with
0
votes
1answer
6 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....
0
votes
1answer
14 views

Problems with mysql-workbench for Ubuntu 20.04

Got an Ubuntu 20.04 VirtualBox VM and after installing MySQL server, wanted to install MySQL Workbench. 1st Approach If I run sudo apt install mysql-workbench or if I run sudo apt install mysql-...
0
votes
0answers
9 views

Phpmyadmin access denied every time ubuntu restarts [duplicate]

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::...
0
votes
1answer
10 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::...
0
votes
1answer
31 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
0answers
42 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
1answer
24 views

Connection to MYSQL with command line using the password in qoutes

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 ...
0
votes
0answers
16 views

Ubuntu 16.04 - Apt-get is broken - after a fresh Mysql installation [duplicate]

I'm getting dpkg: error processing package mysql-server-5.7 but mysql-server-5.7 package is working and I am able to login to the DB and chagned the password. But every time I run apt-get I am getting ...
0
votes
1answer
87 views

mysql-server-8.0 conflict, unable to install due to a conflict with “itself”

---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, ...
0
votes
0answers
34 views

14.04 How to update to the latest version of PHP inorder to run WordPress 5.4.1 [closed]

I'm currently running Ubuntu 14.04 and trying to use the latest version of WordPress v5.4.1. When trying to run my WordPress site, I'm receiving the error: Your server is running PHP version 5.5.9-...
0
votes
0answers
23 views

Cannot connect to mysql Local database after upgrade from 18.04 to 20.04 LTS

I cannot connect to MYSQL db and it is a root process: I have tried the solution: https://dba.stackexchange.com/questions/11027/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-...
0
votes
1answer
73 views

Remove mysql Completely error

I am on Focal Fossa and i have mysql installed . I was trying to remove it and install mariadb . I tried sudo apt-get remove mysql but when i do mysql -V i am getting mysql Ver 8.0.20-0ubuntu0.20.04....
1
vote
0answers
32 views

Ubuntu PHPMYADMIN ''No such file or directory &mdash" error

My phpmyadmin with mysql worked perfectly for 2 months, and now I am getting this problem (i did absolutely nothing, I'm not sure why I get it). No such file or directory — The server is ...
2
votes
2answers
126 views

Can't Install MySQL after stupid clash with mariaDB

It completely slipped my mind that MySQL was already installed on this particular computer and I installed MariaDB, I was also unaware of the consequences of having both packages on the same computer, ...
2
votes
1answer
37 views

Error installing libmysqlclient-dev on Ubuntu 20.04

Trying to install mysqlclient on Ubuntu 20.04 to use in Django project sudo apt-get install python3.7-dev libmysqlclient-dev But get the following error python3.7-dev is already the newest version (...
0
votes
0answers
24 views

Ubuntu Memory is consumed

I have an Ubuntu 18.04 virtual server hosted on DigitalOcean, it is updated with all the latest updates and fixes, I started recently to notice that the memory on the server is being consumed rapidly, ...
0
votes
0answers
44 views

MySQL localhost connection refused

When I try to connect to localhost I get this error message [08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up. java.net.ConnectException: Connection ...
0
votes
0answers
13 views

Mysqld Service Suddenly Down, Ubuntu 16.04

My mysqld service just crashed and I have no idea how to fix it. I checked for syslog and this is what I got May 23 00:15:38 www mysqld: 2020-05-23 0:15:38 0 [ERROR] Aborting May 23 00:15:38 www ...
2
votes
0answers
39 views

Mysql can' t install on ubuntu 18.04 “ Specified filename /var/lib/mysql/ibdata1 does not exist.”

I new i 've since few days a mysql error when i install myql-server on ubuntu 18.04 i read many solution but the probleme is not solve yet please anynone can help me thank Setting up mysql-server-5.7 ...
0
votes
0answers
7 views

lampp php version change

I have changed php version from terminal and now from terminal if i check php -v its displaying my version 7.4 I changed php version on terminal using this command sudo update-alternatives --config ...
1
vote
2answers
53 views

Mysql install ERROR: Database files are locked. Daemon already running? Warning: Unable to start the server

At first I removed previous MySQL installation apt autoremove mysql-server-8.0 MySQL has been removed from services. Then I tried to install new MySQL apt install mysql-server which throws me an ...
1
vote
1answer
91 views

Cannot connect MySQL Workbench to MySQL server

Using Ubuntu 20.04. MySQL version: 8.0.20 I have installed MySQL workbench from snapstore. Installed MySQL server from apt. Server is running good. I can access MySQL shell from terminal. But i am ...
0
votes
0answers
57 views

Run init script when Docker with MySQL is ready

I am trying to run a script for initialization of MySQL within a Docker container. I just want to run it once, as it creates the default user for MySQL. /root/mysql-init.sh: #!/bin/bash mysql -u ...
0
votes
0answers
136 views

Internal Server Error when running a shellscript to database

For an assignment I'm supposed to take data in from a shellscript and push that data into a database. I have MySQL setup and listening on Port 3000, but when I run the script it keeps repeating ...
1
vote
0answers
17 views

apt install lamp-server - MySQL password

I have installed lamp-server via command apt install lamp-server and it works, as I see in the web browser. But I am not able to log in to mysql as root user. If I try to run mysql -u root -p ...
2
votes
1answer
186 views

Cannot increase MySQL table_open_cache in Ubuntu 20.04

I've read both of these related questions and still stuck: https://dba.stackexchange.com/questions/86987/mysql-open-files-limit-cannot-change-this-variable/86988#86988?newreg=...
0
votes
1answer
39 views

How can I reset mysql-server-8.0 root password on Ubuntu 20.04?

I've just installed Ubuntu 20.04 and messed something up with MySQL. I don't know how to login: $ mysql -u root -p Enter password: ERROR 1698 (28000): Access denied for user '...
0
votes
1answer
88 views

Cannot run mysql after update to 20.04

I've just upgraded from 19.10 to 20.04. All went fine, but I have problem with mysql. Here the currently installed packages: $ dpkg -l | grep mysql ii libmysqlclient21:amd64 ...
0
votes
0answers
12 views

Scuffed table in Mysql searchnig for debian-sys-maint's authentication_string

so I am new to Ubuntu (20.04 LTS) and I was trying to install apache2 and test a website locally on my device. Anyhow, I was following instructions found on: https://www.digitalocean.com/community/...
1
vote
0answers
26 views

Ubuntu 19.10 Update deleted the whole MySQL and the records

I have a serious problem with my Ubuntu Server, I updated today from 19.09 to 19.10 but during the install procedure, the system kept throwing messages that MySQL failed to update and the server want ...
0
votes
0answers
77 views

Cannot update: “Query against mysql.user table failed when checking the mysql.session.”

I have installed Ubuntu 18.04 in VirtualBox. I used the Software Updater to update Ubuntu, but my PC shut down, and when I came back and tried to update Ubuntu, it was not updating either in Software ...
-1
votes
0answers
23 views

Mysql command is not working

mysql command is not working in the Ubuntu terminal. I installed MySQL and removed it nearly about 50 times but MySQL command is not working. I am facing this problem from the time when I deleted ...
1
vote
1answer
40 views

Access denied for user root@localhost

I installed phpMyAdmin on Ubuntu LAMP 18.04. Now, when I visit /phpmyadmin/ and try to login with username root and the password that I set up when installing phpMyAdmin, I get the following error ...
0
votes
0answers
42 views

How can I reinstall mysql after deleting it?

I have been having lots of issues with mysql. In hindsight I have a feeling it has someting to do with App Armor. But now when I run sudo apt-get install mysql-serverI end up getting errors. Is this ...
0
votes
1answer
24 views

After wake up the authentication dialog freezes

Yesterday I updated my computer from Ubuntu 19.10 to 20.04. Normally the mysql server on my computer was not starting on boot. I was launching it myself when I need it. With yesterday's update, the ...
2
votes
1answer
187 views

mysql-server-8.0 installation problem on Ubuntu 20.04

I have installed mysql-server-8.0 on Ubuntu 20.04 and the install has not created /etc/mysql/ ... I have tried removing and re-installation but it does the same thing every time error : alternative ...
0
votes
2answers
34 views

Reset password for phpmyadmin on raspberry pi

I’ve got a raspberry pi with a phpmyadmin database. However I can not remember the password. I may not even have a password. I have tried various method of resetting the password but when I try ...
-2
votes
2answers
55 views

MySQL can't start and sudo mysql doesn't work

mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Sun 2020-05-10 19:27:59 CEST; ...
2
votes
1answer
97 views

MariaDB: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Main purpose I am trying to install a local version of Prestashop on my ubuntu server 20.04 following those steps. Issue I am currently trying to install MariaDB (Step 5 of the guide) and after ...
0
votes
0answers
18 views

phpmyadmin issue regarding Undefined index: dbi. Backtrace

I have installed Xampp in Ubuntu 20.04. I am having an issue in phpmyadmin, Though I was facing problem to access localhost/phpmyadmin initially after installtion, I was able to resolve the previous ...
0
votes
0answers
17 views

Ubuntu 18.04.4 // mysql 5.7 post installation // 'root'@'localhost' // ubuntu root account // solution(s)?

Post installation login to myql from shell: mysql -u root -p Generates a common error, unable to login as 'root' @ 'localhost' Searched googsta & read lots of responses/possible solutions. ...
1
vote
1answer
21 views

Fail to start apache2 and mysql server on startup

I'm using Ubuntu 16.04 LTS On every boot mysql-server and apache2 fail to start and when i try to start manually it breaks and shows following error: After re-installation it works but again in ...
0
votes
2answers
38 views

Connect to mysql database from a PHP file

I have created a form which takes input from user and will feed it to MYSQL database. I have used the following command $servername = 'localhost'; $username = 'root'; $password = ''; ...
0
votes
0answers
96 views

Help installing mysql v5.7 in ubuntu-server 20.04 LTS [duplicate]

I noticed mysql is version 8 only. Could someone point me in the right direction on how to install mysql 5?
0
votes
1answer
22 views

login phpMyAdmin to MySql getting error in Ubuntu 18.04 kubernetes nodes

i am trying to install phpMyAdmin and Mysql as pods in my Kubernetes cluster. everything is okay but when i try to log in into mysql by browser from phpMyAdmin interface i failed the error massages ...
0
votes
0answers
16 views

I tried sudo apt-get install mysql-server but got this error .mysql installation error: dpkg: error processing package mysql-server-5.5 (--configure):

I tried sudo apt-get install mysql-server but got this error .mysql installation error: dpkg: error processing package mysql-server-5.5 (--configure):
1
vote
2answers
22 views

Cannot login to phpmyadmin with root, there is two root users and can login to mysql without password

Following this tutorial, everything works fine, till the moment when I tried to login to my phpmyadmin with root and password: Problem 1 (cannot login to phpmyadmin): mysqli_real_connect(): (HY000/...
0
votes
0answers
78 views

mysql.service: Main process exited, code=exited, status=1/FAILURE

i cannot start my mysql server, it crashed all a sudden and i can not find any useful log to say why. my disk has still some space left, several Gigabytes. last logs from journalctl -feu mysql are ...
0
votes
1answer
451 views

Can't get MYSQL8 to work on Ubuntu 20.04

I have purged and re-installed mysql-client and server a few times, I have rebooted my system and yet I cannot get mysql to work on my computer. I ran these commands according to another askubuntu ...
1
vote
1answer
70 views

Is it possible to downgrade from php 7.4.5 to php 7.4.3

yesterday I downloaded the new ubuntu 20 version and long story short it blew up my mysql and php installation; I have managed to fix some of the errors already but it looks like ubuntu upgraded me ...

1
2 3 4 5
50