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