Ask Ubuntu
Ask Ubuntu

Questions tagged [mysql]

Questions regarding the MySQL database server, client and tools.

MySQL is a fast, stable and true multi-user, multi-threaded SQL database server. SQL (Structured Query Language) is the most popular database query language in the world.

Source: Ubuntu package description

Links:

2991 questions
278
votes
11 answers

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 account while logged in Ubuntu as normal user account I…
codescope
  • 2,881
270
votes
11 answers

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 command: /etc/init.d/mysql start but I see this error…
user471011
  • 3,569
  • 8
  • 25
  • 19
260
votes
9 answers

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
  • 8,071
134
votes
10 answers

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 trying to install/reinstall it: Setting up…
TheGremlyn
  • 2,774
120
votes
12 answers

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 which is a windows port and runs under wine, but none…
richzilla
  • 12,185
113
votes
14 answers

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 here. If you need anymore information, please contact…
matthapkidokarate
  • 1,257
104
votes
3 answers

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 to the server. I'm getting         Cannot…
parv desai
  • 1,259
94
votes
9 answers

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?
Иван Бишевац
  • 2,041
84
votes
9 answers

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 searched a lot for it. I have found many sources…
Mostafa Ahangarha
  • 4,687
84
votes
4 answers

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
  • 4,310
  • 2
  • 19
  • 24
71
votes
7 answers

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 mysql_secure_installation threw the same error. I…
spqa
  • 823
69
votes
4 answers

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 install mysql-client-core-5.5 I get: Reading…
batman
  • 8,071
66
votes
2 answers

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.
Mangesh Jogade
  • 783
63
votes
7 answers

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 location of datadir in my.cnf mysql will not start up…
Jonny Flowers
  • 961
59
votes
12 answers

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 it -- I tried going to…
Mark
  • 591
1
2 3
…
99 100