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:

2993 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…
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 ERROR…
user471011
  • 3,569
261
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,101
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…
richzilla
  • 12,205
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 Connect to…
parv desai
  • 1,259
95
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,051
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,697
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
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 package…
batman
  • 8,101
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…
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