Posts for Tag: mysql

Mysql access denied for user root

Clean installation of mysql-server on Ubuntu (also happened to me on Debian), i can't connect with root and no password (even though on installation i set a blank password). This is not MariaDB, it's the proper 5.7 version installed via package repository after using the Mysql APT tool to set it up.

Here's the shit i had to do to make this work:

sudo emacs /lib/systemd/system/mysql.service

In this file, add --skip-grant-tables to the Exec command. After that run:

sudo systemctl daemon-reload
sudo service mysql restart

Now login into Mysql:

mysql -uroot

And run these commands to reset the root user's credentials:

use mysql;
update user set authentication_string=PASSWORD("") where User='root';
update user set plugin="mysql_native_password" where User='root';
flush privileges;
quit;

Now, just revert what you did to the startup script, don't forget to run systemctl reload and restart the service and logging in with root should work. 

I curse you, Oracle.

On using MySQL and working remotely

A couple of interesting articles this morning, one about [why you should not use MySQL](http://grimoire.ca/mysql/choose-something-else) (i particularly love the expression "Mysql development and administration causes brain damage, folks...") and a [rant about remote work](http://ericfarkas.com/posts/a-short-rant-about-working-remotely/) and why companies still can't see the value in it.