Questions tagged [mysql]
Questions regarding the MySQL database server, client and tools.
2,948
questions
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 ...
269
votes
11
answers
1.9m
views
How do I start/stop mysql server?
I tried to find in some articles describing how to correctly start & stop mysql server.
I found this link: How to start/stop MySql server on Ubuntu 8.04 | Abhi's Blogging World
I ran this ...
255
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?
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 ...
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 ...
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 ...
100
votes
3
answers
128k
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 ...
94
votes
9
answers
121k
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 ...
82
votes
4
answers
426k
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?
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 ...
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 ...
64
votes
2
answers
162k
views
How can I install MySQL client on 10.04?
How can I install MySQL client in Ubuntu?
I have already installed MySQL 5.1 binary on server.
I am not able to find the right package for apt-get.
63
votes
7
answers
135k
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 ...
59
votes
12
answers
244k
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 ...
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 ...
56
votes
7
answers
250k
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 ...
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 ...
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
3
answers
516k
views
ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no )
I'm trying to install queXS cati app on my Ubuntu desktop and I installed MySQL server and PHP 5 and I cannot login into MySQL server as root without password:
mysql -u root
it says
ERROR 1045(...
55
votes
2
answers
522k
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,...
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 ...
46
votes
12
answers
88k
views
How to upgrade PHPmyAdmin [revisited]
This question was asked previously, How to upgrade PHPmyAdmin
The answer given was
sudo apt-get update
sudo apt-get install phpmyadmin
or
sudo apt-get update
sudo apt-get upgrade
The version of ...
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-...
45
votes
5
answers
250k
views
Port 3306 appears to be closed on my Ubuntu server
I have two VPS servers, and both have MySQL installed, one for testing and one for development. One of my servers won't let me connect from outside. With the user;
'mytestuser'@'%'
According to ...
44
votes
3
answers
61k
views
How to keep apache and mysql from starting automatically
Is there a way to make apache and mysql not run automatically on startup?
Currently, whenever I boot my machine, they start automatically and run in the background.
I am using Ubuntu 12.04.
44
votes
5
answers
76k
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) ...
...
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 ...
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
168k
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'
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 (...
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 ...
37
votes
1
answer
50k
views
Package 'libmysqlclient-dev' has no installation candidate
Facing
E: Package 'libmysqlclient-dev' has no installation candidate
I am using this blog for reference:
https://rehalcon.blogspot.com/2018/03/dockerize-your-django-app-for-local.html
Here is my ...
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).
35
votes
11
answers
407k
views
mysql server start failed
I am running ubuntu server.
When I tried to login to mysql(which was running),I got the following error
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/...
35
votes
4
answers
70k
views
Start MySQL on Startup
I installed MySQL, and changed the configuration so the databases are stored on a separate hard drive. In the process MySQL has stopped starting up automatically. When I start the computer, I need to ...
34
votes
7
answers
385k
views
How to run mysql command from terminal?
I have the following sql command which I usually run in phpmyadmin by selecting the database, then running it in the command window.
DELETE FROM `wp_posts` WHERE `post_type` = "attachment"
However ...
34
votes
2
answers
62k
views
"Rejected send message, 1 matched rules; type="method_call", sender=":1.5"" while starting MySQL
I have a mysql that has been working fine but now will not start. All I've been able to accomplish is using
sudo start mysql
which generates the following error:
start: Rejected send message, 1 ...
33
votes
18
answers
82k
views
Can't start mysql - mysql respawning too fast, stopped
Today I did a fresh install of ubuntu 12.04 and went about setting up my local development environment. I installed mysql and edited /etc/mysql/my.cnf to optimise InnoDB but when I try to restart ...
33
votes
6
answers
90k
views
Where are mysql-admin and query-browser?
In terminal I run next commands:
sudo apt-get install mysql-server
sudo apt-get install mysql-admin
sudo apt-get install mysql-query-browser
With first command - all ok.
But for latest two ...
31
votes
1
answer
104k
views
How do I enable the mod_rewrite Apache module for Ubuntu 11.04?
In other linux like CentOS, it works but i am not getting it running in Ubuntu 11.04.
/var/www/html/folder/public/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module ...
30
votes
3
answers
98k
views
MySQL 5.5 Update to MySQL 5.7
I searched a tutorial for dummies, about how to Update my MySQL 5.5 Server to MySQL 5.7 I'm Using ubuntu 14.04. I've already tried the tutorials on the MySQL Website. How can I upgrade my server?
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 ...
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 ...
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 ...
29
votes
4
answers
94k
views
MySQL root password setup error
I am working on a project and I have been trying to use MySQL instead of SQLite. So I downloaded MySQL and I am trying to set the root password with mysql_secure_installation, but when I submit both ...
28
votes
4
answers
38k
views
Why does mariadb keep dying? How do I stop it?
I am running MariaDB 10.0.23-0 on Ubuntu 15.10 as a LAMP server. Running sudo /etc/init.d/mysql start results in:
Job for mariadb.service failed because a timeout was exceeded. See "systemctl status ...
28
votes
7
answers
106k
views
Install MySQL 5.7 on Ubuntu 20.04
I am trying to install MySQL 5.7 on a fresh Ubuntu 20.04 installation. I followed Kulfy's steps in this post to install MySQL 5.7 on Ubuntu 20.04. I was able to install mysql-client, but not mysql-...
28
votes
5
answers
46k
views
How to I move MySQL data files onto different partition?
I have my hard drive partitioned with two partitions, so I can easily re-install Ubuntu and try out different versions without losing my home directory data.
It is setup like this:
20GB -> / (...