Questions tagged [mysql]
Questions regarding the MySQL database server, client and tools.
1,088
questions with no upvoted or accepted answers
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) .....
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 ...
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 ...
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 ...
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 ...
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 ...
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 “...
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 ...
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 ...
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 ...
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 ...
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)...
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. ...
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 ...
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 ...
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-...
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 ...
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....
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 ...
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 ...
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 ...
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
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 ...
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: ...
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 ...
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 ...
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 ...
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 ...
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 ...
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/...
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 ...
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
...
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 ...
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'...
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-...
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 ...
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 ...
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,...
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. ...
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 '...
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 ...
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 ...
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 ...
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 ...
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) ...
...
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 ...
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 ...
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 ...
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 ...
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 ...