Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

1,088 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
13 votes
2 answers
6k views

Error during mysql-server installation

I was trying re-installing mysql-server, but I am getting some sort of warning during installation. It got installed but it's not working. Setting up mysql-client-core-5.7 (5.7.23-0ubuntu0.18.04.1) .....
Amit Singh Gaur's user avatar
4 votes
0 answers
877 views

Mysql doesn't start in Ubuntu 20.04

After making some system updates, my mysql server doesn't start after PC reboot. Output of Mysql -V: mysql Ver 14.14 Distrib 5.7.31, for Linux (x86_64) using EditLine wrapper Output of mysql -u ...
Lukáš Pop's user avatar
4 votes
1 answer
11k views

Ubuntu 19.10 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

First I did debian@osboxes:~/Desktop$ mysql -u root -p Command 'mysql' not found, but can be installed with: sudo apt install mysql-client-core-8.0 # version 8.0.18-0ubuntu0.19.10.1, or sudo ...
political science's user avatar
4 votes
0 answers
1k views

MySQL Server 8.0.13 won't start: unrecognized service

I just installed MySQL Server 8.0.13 on Ubuntu 18.04 and everything seemed to go fine until I tried to start the server. I have an identical installation that is working fine, and I followed the exact ...
Megunticook's user avatar
4 votes
1 answer
8k views

Mysql 5.7 cannot start again

For the first time in my life, I have Ubuntu, so I do not know much how to manage and what should I be looking for; I'm using version 18.04. I installed MySQL 5.7, it worked great for a couple of days ...
Simon's user avatar
  • 113
4 votes
1 answer
607 views

what to do when mysql command tool does not allow to enter Cyrillic alphabet?

After upgrading Ubuntu from 16.10 to 17.10 I have a problem. Now the mysql command-line tool does not allow to enter Cyrillic alphabet. When you start the mysql command tool, you can write SQL ...
vstas78's user avatar
  • 61
4 votes
0 answers
4k views

How do I restore innodb-files into an sql file and that's it?

I am trying to restore innodb databases from files. I followed Stop your mysql daemon/service (# services stop mysql) on mine services.msc and made sure MySql service is not running. Replace the new “...
Vitalis Hommel's user avatar
4 votes
1 answer
623 views

Where is the configuration data actually stored for Mysql 5.7.13 in Ubuntu 16.04 and what are best practices for managing it?

The following command gives the location of the files read in order of precedence for a default Mysql install on Ubuntu 16: mysqld --verbose --help | grep -A 1 "Default options" Default options are ...
user658182's user avatar
4 votes
0 answers
9k views

Mariadb Plugin 'unix socket' is not loaded

After installing Mariadb on Ubuntu 15.10 I was unable to use mysql. The following error was reported: Plugin 'unix socket' is not loaded. It seems that plugin table in the mysql db was empty. Why ...
iainH's user avatar
  • 798
4 votes
0 answers
8k views

MySQL not starting because "mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)"

I am setting up a new LAMP server with Ubuntu Server 13.10 and MySQL 5.5 and was in the middle of migrating mysql databases to new server when I realized mysql server is not running. All was fine last ...
AlanK's user avatar
  • 141
3 votes
0 answers
1k 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 ...
Eurythmax's user avatar
3 votes
0 answers
5k views

Ubuntu server not allowing shutdown

I attempted to shut down my Ubuntu 20.04.1 LTS server earlier today. On doing so, I got the following message: Operation inhibited by "APT" (PID 729631 "unattended-upgr", user root)...
FlammableD's user avatar
3 votes
0 answers
782 views

MySQL started performing ~2 times slower after upgrading Ubuntu from 19.04 to 20.04

I have an Ubuntu Server where the main app running is MySQL Server v8 About a week ago I upgraded Ubuntu from 19.04 to 20.04 and since then the performance of my database has drastically fallen. ...
Stalinko's user avatar
  • 263
3 votes
0 answers
935 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 ...
MOUTAIROU Bastou Abdel's user avatar
3 votes
1 answer
14k 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 trying ...
Alessandro Candeloro's user avatar
3 votes
0 answers
812 views

Non-interactive MySQL 8 installation on Ubuntu 18.04

I am looking for a MySQL 8 installation using a script without any user action. I see that it's going to UI where I need to give password. I tried: wget -c https://dev.mysql.com/get/mysql-apt-...
ML Learner's user avatar
3 votes
2 answers
196 views

Is it necessary to change the governor in Ubuntu Server 16.04?

I manage a dedicated remote SuperMicro SYS-2028TP-HC1R server with two Octa-Core E5-2620 V4 2.1GHz processors (HT, 32 threads), 32 GB RAM, 2 SDD of 480GB in RAID 1, running Ubuntu Server 16.04, and do ...
Jesus RC's user avatar
3 votes
0 answers
2k views

Cannot start mysql server: "Unit mysqld.service could not be found" "Job for mysql.service failed"

I have a problem starting MySQL server when I type this command service mysqld status I get this output: Unit mysqld.service could not be found also: $ sudo service mysql start Job for mysql....
yeslem's user avatar
  • 31
3 votes
0 answers
1k views

MySQL Workbench 'Error calling StartServiceByName for org.freedesktop.secrets: Timeout was reached'

Since I've updated MySQL Workbench to version 8.0.18 I can no longer connect to my Local instance. I am able to use MySQL via the command line. I have tried everything from changing passwords and ...
LDR's user avatar
  • 61
3 votes
1 answer
1k views

Mysql down after restarting server

I have an Ubuntu 16.04 server with ISPConfig 3.1. For some reason the server was working too much on a process with high load, so I powered off and restarted the machine. After that, Mysql stopped ...
DavidM's user avatar
  • 131
3 votes
0 answers
4k views

Upgrading to PHP 7.2 (from 7.0) broke MySQLi functions on NGINX server

EDIT - fixed with complete purge and reinstallation of PHP (see bottom) I'm hosting a web server (using NGINX) with a MySQL database backend. It was working previously with PHP 7.0, but when I ...
scattanach1's user avatar
3 votes
0 answers
2k views

mysql: unrecognized service

I installed MySQL on Ubuntu 16.04 server by running: sudo apt-get install mysql-server However when I run: sudo service mysql status I get the error: mysql: unrecognized service Thanks for help
Nadeem Mehraj's user avatar
3 votes
1 answer
5k views

Job for mysql.service failed because the control process exited with error code

MySQL server was running fine last night, but this morning, when I tried to hit the Bugzilla server, I found it down. I tried to start it, but I get: Job for mysql.service failed because the control ...
jicman's user avatar
  • 81
3 votes
0 answers
3k views

libmysqlclient.so.16

I have a program I'm trying to get running on an Ubuntu machine (I've previously run it only on CentOS), and when executing it I get: error while loading shared libraries: libmysqlclient.so.16: ...
Steven Linden's user avatar
3 votes
1 answer
84 views

downloading mysql-server and now my terminal is red

When I start downloading MySQL from my terminal using the command sudo apt-get install mysql-server my terminal goes all red, and I don't know what to do. I answered yes and then the screen goes ...
Juan Carlos's user avatar
3 votes
1 answer
1k views

Can't connect MySQL and Web

I do some coding to connect MySQL and webserver. This is my coding $dbusername = "root"; // enter database username, I used "arduino" in step 2.2 $dbpassword = "qonita84"; // enter database ...
Qonita Salimah's user avatar
3 votes
0 answers
72 views

How does one know which versions of which packages go together in a LAMP Stack in Ubuntu?

I'm trying to install a specific version of MySQL to match a host and I'd like to install the corresponding working versions of some other packages for PHP and Apache2. I know you can check the ...
leeand00's user avatar
  • 786
3 votes
2 answers
330 views

How is MySQL upgrade happening in the LTS 14.04 -> 16.04 upgrade?

When doing the LTS upgrade from 14.04 to 16.04, how is MySQL updated, is a it just an in-place upgrade from Mysql 5.5 to 5.7? Or is there something fancier going on behind the scenes, like a logical ...
Mohamed Hafez's user avatar
3 votes
0 answers
79 views

replacement for `mk-table-checksum --scheme`

After upgrading to LTS 16.04.1, the mk-table-checksum --scheme generates errors, so tried to find a newer version, but can only find pt-table-checksum, and it doesn't have a --scheme-option. Also ...
Puggan Se's user avatar
  • 948
3 votes
2 answers
7k views

XAMPP: Starting MySQL...already running?

When I start XAMPP it shows this Starting XAMPP for Linux 7.0.8-0... XAMPP: Starting Apache...ok. XAMPP: Starting MySQL...already running. XAMPP: Starting ProFTPD...ok. when i open localhost/...
Bahaa's user avatar
  • 31
3 votes
1 answer
8k views

MySQL problem on Ubuntu 16.04

It randomly broke yesterday(not starting up any more) and I don't know how to fix it. When I run: sudo service mysql start It gives this error: Job for mysql.service failed because the control ...
Bijleveldje's user avatar
3 votes
1 answer
4k views

mariadb-server-10.0 mariadb-server installation error. How do I fix?

For some reasons I am unable to install maria db. I did try the following procure but I did not manage to install. I keep getting: Errors were encountered while processing: mariadb-server-10.0 ...
Qwerty's user avatar
  • 109
3 votes
1 answer
356 views

phpMyAdmin and Drupal sites don't render after 14.04 LTS to 16.04 LTS upgrade

I updated from 14.04 LTS to 16.04 LTS yesterday. All seemed well until I tried to browse to localhost/phpmyadmin/ or any of my local Drupal sites. My Drupal sites don't render any content at all (no ...
Mike Steigerwald's user avatar
3 votes
0 answers
441 views

MySQL support not available. after upgrade to 16.04.1 from 14.04

When I visit the webpage, all I see on the screen is "MySQL support not available." I have checked to see if mysql was running, and it is, apache is running, and I can see my phpinfo.php test file. I'...
Gary's user avatar
  • 53
3 votes
0 answers
969 views

mysql-server-5.7 configure fails

mysql-server-5.7 doesn't want to configure. root@me-device:~# dpkg --configure mysql-server-5.7 Настраивается пакет mysql-server-5.7 (5.7.13-0ubuntu0.16.04.2) … Renaming removed key_buffer and myisam-...
Andrew McFinley's user avatar
3 votes
1 answer
2k views

Ubuntu xampp, mysql wont start at all

After changing whatever I saw and I found, unfortunately no success. When I installed xampp it ran successfully and both apache and mysql started. But surprisingly after restart below errors begin ...
Hossein Shahsahebi's user avatar
3 votes
0 answers
2k views

Error 500 on localhost/phpmyadmin

I recently installed apache2 and phpmyadmin on localhost, and everytime I try to connect to localhost/phpmyadmin I get prompted with an "Enter your username/password". I enter root as the username and ...
johm8's user avatar
  • 31
3 votes
0 answers
2k views

MySQL Workbench do not render Columns Tab at ER

I have a fresh install of Ubuntu 14.10, after installing all I need, I started MySQL Workbench (v.6.1.7 build 1788) and in it's ER modeling its not showing anything in Columns Tab when editing a table,...
Joao Evangelista's user avatar
3 votes
0 answers
890 views

Using gnome-keyring with svn via ssh and mysql-workbench

Problem: mysql-workbench fails to connect to the keyring to connect to mysql. I'm trying to get my svn command (which uses an svn+ssh uri) to prompt me to enter my password for my local rsa secrets. ...
Kieveli's user avatar
  • 91
3 votes
0 answers
541 views

Another apparmor / mysql wont install

I am trying to config another instance of mysql on my present but i can't mysql_install_db --user=mysql --datadir=/var/lib/mysql2 Installing MySQL system tables... ERROR: 1005 Can't create table '...
mY001's user avatar
  • 31
3 votes
2 answers
8k views

Why is the mysql-server package from mysql.com missing server files?

I'm usually not using Ubuntu, but decided to give it a try today because it's the preferred distro for Windows Subsystem for Linux, that I wanted to try today to see if/how it could replace my VMWare ...
BenMorel's user avatar
  • 161
3 votes
1 answer
38k views

The MySQL server fails to start: mysql.service failed because the control process exited with error code

The MySQL server quit working when I was installing Drupal, the last version. Then I reinstalled the MySQL server, but without success. It fails to start. Output of sudo service mysql start Job for ...
Andreiasi's user avatar
2 votes
1 answer
475 views

MySQL not allowing 'root@localhost' to access it

I'm trying to set up MySQL server as part of a LAMP stack on Ubuntu Server 22.04, I have installed MySQL and whenever I try to run the commands: ~$ sudo mysql or ~$ sudo mysql -u root -p It returns ...
Archvirus's user avatar
2 votes
0 answers
44 views

Is there an easy way to find all files on an ubuntu server and load them along with path information into mysql?

I am using Ubuntu server 20.04 for OwnCloud and backups of multiple networked computers. I know I have many duplicate files on the server and would like to have one database of all files so I can ...
CncJerry's user avatar
2 votes
0 answers
2k views

Can't start mysql server when installing it on Ubuntu 22.04

Just had a fresh install of ubuntu 22.04 and wanted to install mysql and this is what I get after running sudo apt install mysql-server Setting up mysql-server-8.0 (8.0.29-0ubuntu0.22.04.2) ... ...
mohmlll's user avatar
  • 21
2 votes
2 answers
4k 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 ...
MSwDE's user avatar
  • 21
2 votes
0 answers
130 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 ...
KesiScarlet's user avatar
2 votes
0 answers
700 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 ...
maraxai's user avatar
  • 31
2 votes
1 answer
248 views

Postfix MariaDB SSL Connection Error

I have two servers, both running Ubuntu 21.04. I have Postfix (v3.5.6) installed on one server and MariaDB (v10.5.12-MariaDB-0ubuntu0.21.04.1) installed on the other. When Postfix tries to connect ...
Schlameel's user avatar
  • 121
2 votes
0 answers
331 views

MYSQL 8 cannot connect from remote machine

I've setup a new 20.04.03 LTS Server. I can connect to MySQL locally, but can't connect from workbench on remote machine. I've created my user username@% and granted all permissions. I went an edited ...
Bradley Armstrong's user avatar

1
2 3 4 5
22