Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

Filter by
Sorted by
Tagged with
134 votes
10 answers
213k views

16.04 upgrade broke mysql-server

My overall upgrade went well, but I am left with a critically lingering issue of mysql-server not being able to install itself, and nothing I am trying gets it to work. This is the error I see when ...
TheGremlyn's user avatar
  • 2,774
9 votes
1 answer
10k views

WordPress Installation Failed

I am trying to install Wordpress on Lubuntu. I followed the instructions here. Including PHP Apache and MySQL setups. Apache and MySQL appear to be running fine. However, when I go to http://...
TeKola's user avatar
  • 91
71 votes
7 answers
145k views

mysql doesn't ask for root password when installing

I used apt install mysql-server to install MySQL on Ubuntu 16.04 but during the installation, it did not ask for root password. After installation I got ERROR 1045 when I tried to login as root and ...
spqa's user avatar
  • 823
278 votes
11 answers
396k views

can't login as mysql user root from normal user account in ubuntu 16.04

I just installed Ubuntu 16.04 LTS along with the packages php, mariadb and nginx. I ran mysql_secure_installation and changed the root password. Now when I try to login to mysql using the root ...
codescope's user avatar
  • 2,881
82 votes
4 answers
425k views

How do I uninstall MySQL completely?

The answers to related questions forget to: remove the MySQL databases remove the mysql user remove the logs in /var/log How do I uninstall MySQL completely?
Olathe's user avatar
  • 4,240
48 votes
3 answers
761k views

How to change root password for mysql and phpmyadmin

I've set up mysql and phpmyadmin and chose not to set a password when installing hoping that once set up i could login with root and no password but i get the following error from phpmyadmin: Login ...
Jon's user avatar
  • 585
12 votes
7 answers
36k views

How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get?

How would I go about upgrading MySQL to version 5.5 on Ubuntu Server 9.10? Would I be better off waiting for it to be an easy $ sudo apt-get install mysql-server job? I'm also unsure as to which ...
bcmcfc's user avatar
  • 838
254 votes
9 answers
1.1m views

How do I uninstall MySQL?

I installed MySQL using sudo apt-get. Now I need to remove it from my system. How can I do that?
batman's user avatar
  • 7,961
39 votes
7 answers
274k views

MySQL Access denied for user 'root'@'localhost'

In my server, everytime I try to access MySQL I get the error: Access denied for user 'root'@'localhost' (using password: NO) when I try mysqladmin -u root -p password I get Access denied ...
user253867's user avatar
29 votes
6 answers
80k views

unable to reset root password of mysql

I need to reset the root password of my local mysql installation but it woudln't let me. I've tried this: $ sudo /etc/init.d/mysql stop * Stopping MySQL database server mysqld ...
stdcerr's user avatar
  • 1,080
13 votes
2 answers
49k views

Can't install mysql-server/client on ubuntu 16

I'm having a problem with mysql installation which I can't resolve alone. First I tried to remove and purge old files with this command sudo apt-get remove --purge mysql Tried also sudo apt-get ...
S.I.'s user avatar
  • 403
44 votes
5 answers
75k views

MySQL won't start because of AppArmor?

I'm trying to install mysql-server-5.7 on Kubuntu 16.04, but I'm having trouble. sudo apt install mysql-server gives the following output. Setting up mysql-server-5.7 (5.7.18-0ubuntu0.16.04.1) ... ...
Supernormal's user avatar
100 votes
3 answers
127k views

Cannot connect MySQL Workbench to MySQL server

I have installed MySQL workbench from Snap Store and MySQL server 8.0 using apt. The server is running fine and I can access MySQL shell from terminal. But I am having issues connecting the Workbench ...
parv desai's user avatar
  • 1,221
24 votes
5 answers
111k views

My MySQL installation is broken. How to completely reconfigure it?

Here are the following commands I have done. $ sudo service mysql start mysql start/running $ mysql -u root ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/...
alm's user avatar
  • 261
11 votes
4 answers
13k views

Install Apache, Php, Mysql latest versions not available via apt

I need to install the latest versions of apache, php and mysql that are available on their websites, but the problem is that apt repositories don't have these updates versions yet. Versions that I ...
Tarun's user avatar
  • 4,245
57 votes
14 answers
134k views

"Failed to spawn mysql main process: unable to execute: No such file or directory"

I'm a newbie on MySQL ground so bear with me. I've just finished upgrading 11.10 to 12.04. Everything seemed to work without any hiccups and all my software and settings are working fine. Apart from ...
radek's user avatar
  • 1,222
46 votes
6 answers
207k views

Install MySql 5.6 on Ubuntu 16.04

It seems that Ubuntu 16.04 is coming with MySQL 5.7, however I need to install 5.6. When I try to install it explicitly sudo apt-get install mysql-server-5.6 I get the following error: Package mysql-...
Tarlog's user avatar
  • 669
37 votes
7 answers
46k views

how to stop apache2, mysql from starting automatically as computer starts?

My os is 11.04. I have apache2 & mysql installed. How to stop apache2, mysql from starting automatically as computer starts?
Rahul Prasad's user avatar
36 votes
8 answers
93k views

How to install MySQL 5.6?

I just installed Ubuntu 12.10 (amd64), and want to install a recent version of MySQL 5.6. If possible, I would like to install (not upgrade) it the "Debian Way' (i.e., using apt-get or dpkg).
Ross Smith II's user avatar
29 votes
6 answers
110k views

Cannot reinstall mysql-server after its purge

I recently did a fresh install of Ubuntu 16.04. I also installed mysql-server and mysql-client (their default version 5.7.12) via apt-get install. Because 5.7.12 was showing some issues, I decided to ...
Harry's user avatar
  • 441
120 votes
12 answers
280k views

MySQL GUI Tools

Does anyone have any good ideas as to native MySQL GUI clients for Ubuntu? So far I've tried MySQL Workbench, which never seemed to work properly, phpMyAdmin which I found a bit slow, and Navicat ...
richzilla's user avatar
  • 12k
94 votes
9 answers
120k views

How to stop mysql from running at boot time?

Currently, my MySQL server starts on every server boot. For a couple reasons, this is undesirable behavior. Is there a way to disable this behavior?
Иван Бишевац's user avatar
84 votes
9 answers
430k views

Cannot enter phpmyadmin as root (MySQL 5.7)

I'm using Ubuntu desktop 16.04 (upgraded from 15.10). I had installed phpmyadmin from by apt-get install phpmyadmin. It works if I go to localhost/phpmyadmin but I cannot log into it as root. I have ...
Mostafa Ahangarha's user avatar
63 votes
7 answers
134k views

How do I move the MySQL data directory?

I am trying to move the data directory of my MySQL database to a second disk array that I have as a mount point /array2/. The problem I am having is I have tried everything and after I modify the ...
Jonny Flowers's user avatar
55 votes
2 answers
520k views

E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing? [duplicate]

I am using ubuntu 13.10 on evaluation board and my internet is not working. Also i need to install softwares and apt-get install is also not working. Terminal says : E: Unable to fetch some archives,...
mong cape's user avatar
  • 559
8 votes
2 answers
23k views

How to upgrade to MySQL 8.0?

I have a Drupal site 8.6.10 on an Ubuntu server 18.04 with MySQL 5.7.25 I want to update MySQL to version 8.0 Here are the steps I followed : I backed up my database. I uninstalled MySQL from my ...
fgtr's user avatar
  • 83
6 votes
3 answers
3k views

Can't install MySQL 8 on Ubuntu 19.04

I'm using Ubuntu 19.04 and downloaded version 8.13 of MySQL APT config and ran these commands wget https://dev.mysql.com/get/mysql-apt-config_0.8.13-1_all.deb dpkg -i mysql-apt-config_0.8.13-1_all....
Jerry Skidmore's user avatar
3 votes
1 answer
11k views

Package mysql-server-5.5 is not configured yet

Question I am installing a LEMP stack on a fresh minimal install of Ubuntu 14.04 LTS. When I tried to install MySql sudo apt-get install mysql-server it returned an error with the following ...
Suragch's user avatar
  • 165
113 votes
14 answers
354k views

Mcrypt extension is missing in 14.04 server for mysql

The php mcrypt extension on ubuntu 14.04 shows that it is installed properly, but phpmyadmin says: The mcrypt extension is missing. Please check your PHP configuration. My current php config is ...
matthapkidokarate's user avatar
56 votes
8 answers
249k views

How to install MySQL workbench?

Installing MySQL workbench on 10.04 or 10.10 is not a problem, as the deb packages are available on MySQL's website. But there is no 11.04 deb package available. So, how do I install MySQL workbench ...
oshirowanen's user avatar
  • 3,977
41 votes
9 answers
72k views

Having trouble installing and removing MySQL in Ubuntu

I have trouble in installing or removing the partly installed mysql-server-5.6 in ubuntu15.04. The error I am getting was $ sudo apt-get -f install Reading package lists... Done Building ...
Shameerariff's user avatar
39 votes
2 answers
167k views

ERROR 1698 (28000): Access denied for user 'root'@'localhost' at Ubuntu 18.04

I have followed this tutorial to install MySQL but after successfully installed MySQL, I could not access database. ERROR 1698 (28000): Access denied for user 'root'@'localhost'
Ashrafuzzaman Sujan's user avatar
27 votes
4 answers
37k views

How do I install MySQL without a password prompt?

I'm trying to install MySQL on Ubuntu Natty without the password prompt. However, I keep getting prompted for a password at some stage after the main installation. Also, when I do enter what I ...
ObiHill's user avatar
  • 439
14 votes
4 answers
58k views

Is it possible to install MySQL 5.5 or 5.6 on Ubuntu 16.04?

I recently upgraded to Ubuntu 16.04. Unfortunately I need to work MySQL 5.5 or 5.6. I tried many solutions to have MySQL 5.5 or 5.6 run on Ubuntu 16.04 like this Install MySql 5.6 on Ubuntu 16.04 . ...
idris's user avatar
  • 161
11 votes
4 answers
57k 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 ...
CodeConnoisseur's user avatar
9 votes
2 answers
15k views

MySQL Automatic backup tools

I use back-in-time for backuping up my projects. but my Database's are not included. I'd like to backup all database's scheduling by day or hours. Is there any tool to backup MySQL automatically?
Achu's user avatar
  • 21.2k
69 votes
4 answers
184k views

How to install MySQL?

I tried running mysql in my terminal and I got: The program 'mysql' is currently not installed. You can install it by typing: sudo apt-get install mysql-client-core-5.5 But when I do: sudo apt-get ...
batman's user avatar
  • 7,961
59 votes
12 answers
243k views

Where is my phpMyAdmin installation?

I just finished installing mysql-server, and then installed phpmyadmin which came with Apache and PHP. It set it up alright and made a phpMyAdmin database, but I can't seem to find the URL to get to ...
Mark's user avatar
  • 591
56 votes
2 answers
92k views

Ubuntu 15.10 mysql error 1524 - unix_socket

On Ubuntu 15.10, at a point (maybe after an install & remove of mariadb) mysql was unable to operate. Tasks are up, but the server is down. At the command: mysql -u root -p the system reply ...
Hydra Starmaster's user avatar
56 votes
7 answers
249k views

how to reinstall mysql?

A software upgrade broke, among other things, mysql and I have not been able to get it back up yet. Suspected cause: I had a near-full boot disk; the upgrade filled up the disk before completing and ...
st01's user avatar
  • 1,083
42 votes
5 answers
70k views

mysql PPA - invalid signature

I already have mysql-server package installed!!! I want to make sure I have the most recent MySQL in my Ubuntu. So (long time ago) I added repo.mysql.com/apt/ubuntu PPA. Recently I noticed errors ...
naXa stands with Ukraine's user avatar
39 votes
2 answers
198k views

Uninstall MySQL from Ubuntu 16.04 [duplicate]

I am trying to uninstall MySQL completely from Ubuntu 16.04 LTS,but I am facing an issue saying: The following packages have unmet dependencies: mariadb-client-10.0 : Depends: libdbd-mysql-perl (...
SK7's user avatar
  • 999
30 votes
7 answers
48k views

Why did installation of MySQL 5.6 on Ubuntu 14.04 fail?

I wanted to get a look at MySQL 5.6 on Ubuntu 14.04 just out of curiosity. And based on this article it certainly looked like installation should be simple and straightforward. So I fired up an AWS ...
WebLearner's user avatar
26 votes
3 answers
109k views

Cannot install mysql-server-5.5/the following packages have unmet dependicies

I'm a newbie here so please bear with me. I'm using ubuntu 14.04. I tried entering mysql with the following command: mysql -u root -p and I got the following message: The program mysql can be ...
Amuna's user avatar
  • 263
22 votes
7 answers
144k views

How do I start the MySQL console in XAMPP?

The XAMPP installation is done. XAMPP is up and running. What about the MySQL console? How is possible to start the MySQL console to run some special SQL statements?
Claus Kaldeich's user avatar
20 votes
7 answers
52k views

dpkg: invoke-rc.d: initscript mysql, action "start" failed

I have read a number of the posts here and they all state to run the following commands: Apt-get -f remove ** apt-get update apt-get upgrade apt-get -f install ** I have seen these in various order ...
Titanicx's user avatar
  • 201
16 votes
6 answers
28k views

Systemd Mysql won't stop

After upgrading to 15.04, I have had lots of fun getting to know systemd. I think I have everything working except I am unable to stop mysql.service; the systemctl command just hangs and mysql just ...
Craig Dunford's user avatar
8 votes
6 answers
4k views

Which is the easiest way to reset the mysql root password?

In the past there has been sudo /etc/init.d/mysql reset-password, (1) is manually restarting and setting the password with an sql command again required? (2) (1) http://www.ubuntugeek.com/reset-the-...
WhiteZebra's user avatar
7 votes
3 answers
24k views

Is it possible to install MySQL Server 5.7 on Ubuntu 19.10?

Is it possible to install MySQL Server 5.7 on Ubuntu 19.10? If yes, how?
Mohamed Aslam's user avatar
6 votes
2 answers
61k views

How to downgrade PHP from 5.5.9 to 5.4 in Ubuntu 14.04 (Installed with LAMP)

I need to downgrade my PHP version from 5.5.9 to 5.4 (using Ubuntu 14.04), because I have a code that's using mySQL (which is deprecated in 5.5.9), and I cannot change that code. Is there a way to do ...
Hagaymosko's user avatar

1
2 3 4 5 6