This is about resetting the MySQL 5.7 root password in Ubuntu 16.04 LTS
You probably tried something like this:
sudo service mysql stop mysqld_safe --skip-grant-tables &
And then got something like this (stangely, exists is misspelled in the output):
[1] 5599 2018-03-02T21:36:41.292413Z mysqld_safe Logging to syslog. 2018-03-02T21:36:41.294798Z mysqld_safe Logging to '/var/log/mysql/error.log'. 2018-03-02T21:36:41.296902Z mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
Then you tried to find the socket (takes a while):
sudo find / -type s
And /var/run/mysqld does not exist.
So you start mysql again and search and now it does exist!
sudo service mysql start sudo find / -type s [output:] /run/mysqld/mysqld.sock /run/dbus/system_bus_socket /run/acpid.socket /run/snapd-snap.socket ...
My guess is that mysql_safe can’t create the directory (which appears to be dynamically created when mysql starts). Solution:
sudo mkdir /var/run/mysqld sudo chown mysql:mysql /var/run/mysqld
Now run:
sudo service mysql stop mysqld_safe --skip-grant-tables & mysql -uroot mysql
When you get to the mysql prompt (don’t forget to change your pw before copy/pasting!!!):
UPDATE mysql.user SET authentication_string=PASSWORD('YOURNEWPASSWORD'), plugin='mysql_native_password' WHERE User='root' AND Host='%';
exit;
then
sudo mysqladmin -S /var/run/mysqld/mysqld.sock shutdown sudo service mysql start
OTHER SOLUTION (means restarting MySQL a couple times!):
Note: in MySQL 5.7 you may find that my.cnf actually references config files elsewhere:
!includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/
So in my case:
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
Under [mysqld] add:
skip-grant-tables
Close the file and restart mysql, then…
sudo service mysql restart sudo mysql -uroot mysql (use query above...)
Edit mysqld.conf again, remove the line, then restart MySQL
sudo service mysql restart
Good luck!
Thanks a ton. It worked like charm !!
I don’t know where I’m going wrong. I installed mysql and was a little surprised that I wasn’t prompted to set a root password, and then I had awful memories of this happening in the past and having a devil of a job to get things running properly again.
Anyway, my system seems to have accepted that /var/run/mysqld needed to be created, but the next bit just presents me with the following output:
$ mysqld_safe –skip-grant-tables &
[1] 3268
padi@Efnisien:~$ 2019-09-28T18:52:57.702623Z mysqld_safe Logging to syslog.
2019-09-28T18:52:57.707595Z mysqld_safe Logging to ‘/var/log/mysql/error.log’.
/usr/bin/mysqld_safe: 152: /usr/bin/mysqld_safe: cannot create /var/log/mysql/error.log: Permission denied
2019-09-28T18:52:57.711485Z mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists.
/usr/bin/mysqld_safe: 152: /usr/bin/mysqld_safe: cannot create /var/log/mysql/error.log: Permission denied
Which just brings me back to the original issue, I still can’t set up a password that I know rather than the one used by the system that it won’t tell anyone what it is.
Maybe I should just have installed mariaDB?
After installing MySQL/MariaDB you should run:
mysql_secure_installationThis will set the root password, get rid of anonymous users and a test db.
When it asks you for the initial password just hit enter. You will then set a password later.
p.s. I often forget to add sudo to my references, so make sure to do that (or just do
sudo -iand then you don’t have to type it in all the time)worked for me!
Worked for me. Thanks
mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld
Thanks – can you provide more context to your posts and explain what/where this belongs in the process?
This worked for me thank you so much!!