problem pri sprembi root gesla v MySQL v Ubuntu

Želim spremeniti root geslo v MySQL-u, ker sem ga pozabil.
Sledil sem tem navodilom.
link

Ta ukaz iz navodil mi uspšno izvede

sudo /etc/init.d/mysql stop

Tudi tega:

sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &

Pri tem ukazu pa dobim sledeči error:

mysql -u root

Error:

mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[1]+  Exit 1                  sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking

Kako naj spremenim geslo?

Problem je, da ti mysql umre preden se sploh uspes skonektat nanj. Probaj ga pognat v locenem tabu, brez da ga posljes v background (&).

še vedno dobim isti error

sem ga pognal v ločenem tabu in brez '&' in ne dobim nobenega errorja.
Če poženem htop ne vidim nobenega mysql* procesa.

ne vem kaj je ta pastebin ampak tu je printscreen
https://postimg.org/image/8ritjrzqh/

http://pastebin.com/raw/zh3CafAv

Poskusi k mysqld dodati še to:

--socket=/var/run/mysqld/mysqld.sock

, ostalo naredi kot si že poskušal ...

S tem serverju poveš kje naj posluša. Na to vtičnico se potem povezuješ s klientom ...

Kaj pa pravi error log?

tail /var/log/mysql/error.log

Hmm .. nič uporabnega

Tu imaš opisano še eno malo drugačno metodo (pod B.5.3.2.2 Resetting the Root Password: Unix and Unix-Like Systems) ...

Sem se lotil predlagane metode ampak nenajdem .pid file-a.

It dokumentacije:

Stop the MySQL server if it is running. Locate the .pid file that contains the server's process ID. The exact location and name of this file depend on your distribution, host name, and configuration. Common locations are /var/lib/mysql/, /var/run/mysqld/, and /usr/local/mysql/data/. Generally, the file name has an extension of .pid and begins with either mysqld or your system's host name.

Sem pogledal vse 3 lokacije vendar ga ni v nobeni mapi omenjeni??

kako nej ustavim service če nimam .pid file-a?

oz. kako nej vem če je že ustavljen?

seba@seba-H81-D3:~$ sudo kill 11273
seba@seba-H81-D3:~$ mysqld_safe --init-file=/home/seba/mysql-init
/usr/bin/mysqld_safe: 548: /usr/bin/mysqld_safe: cannot create /var/lib/mysql/mysqld_safe.pid: Permission denied
awk: close failed on file /dev/stdout (Broken pipe)
2016-11-04T20:48:38.263752Z mysqld_safe Logging to syslog.
2016-11-04T20:48:38.265684Z mysqld_safe Logging to '/var/log/mysql/error.log'.
mkdir: cannot create directory ‘/var/run/mysqld’: Permission denied
chown: cannot access '/var/run/mysqld': No such file or directory
chmod: cannot access '/var/run/mysqld': No such file or directory
2016-11-04T20:48:38.278275Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/bin/mysqld_safe: 137: /usr/bin/mysqld_safe: cannot create /var/log/mysql/error.log: Permission denied
/usr/bin/mysqld_safe: 1: eval: cannot create /var/log/mysql/error.log: Permission denied
2016-11-04T20:48:38.282365Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
/usr/bin/mysqld_safe: 137: /usr/bin/mysqld_safe: cannot create /var/log/mysql/error.log: Permission denied
rm: cannot remove '/var/lib/mysql/mysqld_safe.pid': Permission denied

če poženem s sudo dobim pa naslednje:

seba@seba-H81-D3:~$ sudo mysqld_safe --init-file=/home/seba/mysql-init
2016-11-04T21:32:55.563890Z mysqld_safe Logging to syslog.
2016-11-04T21:32:55.566176Z mysqld_safe Logging to '/var/log/mysql/error.log'.
2016-11-04T21:32:55.582220Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-11-04T21:32:57.979161Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
seba@seba-H81-D3:~$ 

v htop vidim da se je mysql pognal vendar tudi ugasne tako da nima smisla pisat:

mysql -u root -p

Mogoče bi bilo pametno da bi zbrisal program in ga ponovno naložil?

Sem pogruntal v čem je bil problem, če bo kdo rabil:

1 Potrebno je imeti inštaliran MySQL Server + Client
2 Treba je bilo ustaviti service z:

sudo /etc/init.d/mysql stop

3 Pognati

mysqld_safe --skip-grant-tables &

4 Odpreti novo terminal okno in vanj vpisati:

mysql -u root

Sedaj bi moral biti v programu.
5 Zatem

mysql>use mysql;

6 in potem

update user set authentication_string=password('1111') where user='root';

Namest 1111 uporabi svoje novo geslo.
7 exit all windows