0

I am using LAMP in Ubuntu 12.04. How to reset the phpMyAdmin password?

hypertext@hypertext-desktop:~$ sudo mysqld --skip-grant-tables &
[2] 7196
hypertext@hypertext-desktop:~$ sudo: /var/lib/sudo writable by non-owner (040777), should be mode 0700                                                         UPDATE user SET Password=admin WHERE User='root';
bash: syntax error near unexpected token `('

[2]+  Stopped                 sudo mysqld --skip-grant-tables
hypertext@hypertext-desktop:~$ sudo mysqld --skip-grant-tables &
[3] 7252
hypertext@hypertext-desktop:~$ sudo: /var/lib/sudo writable by non-owner (040777), should be mode 0700
mysql -u root mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[3]+  Stopped                 sudo mysqld --skip-grant-tables
hypertext@hypertext-desktop:~$ sudo mysqld --skip-grant-tables &
[4] 7259
hypertext@hypertext-desktop:~$ sudo: /var/lib/sudo writable by non-owner (040777), should be mode 0700
UPDATE user SET Password='admin' WHERE User='root';FLUSH PRIVILEGES; exit;
UPDATE: command not found

[4]+  Stopped                 sudo mysqld --skip-grant-tables

[4]+  Stopped                 sudo mysqld --skip-grant-tables
FLUSH: command not found
exit
There are stopped jobs.
hypertext@hypertext-desktop:~$ sudo pkill mysqld
sudo: /var/lib/sudo writable by non-owner (040777), should be mode 0700
[sudo] password for hypertext: 
hypertext@hypertext-desktop:~$ sudo service mysql start
sudo: /var/lib/sudo writable by non-owner (040777), should be mode 0700
[sudo] password for hypertext: 
mysql: unrecognized service
hypertext@hypertext-desktop:~$ ^C
hypertext@hypertext-desktop:~$
Kaushik Das
  • 101
  • 1
    You should try to get your MySQL service running properly, before you deal with stuff, that depends on it like PhpMyAdmin. – David Foerster Aug 24 '15 at 02:26
  • That is running smoothly – Kaushik Das Aug 24 '15 at 17:38
  • 1
    What are all these warnings and error messages in the above listing then? Why do you need to start the MySQL daemon multiple times over? Why is the service mysql unrecognised? – David Foerster Aug 24 '15 at 20:03
  • i have started it multiple time to reset root ppassword.. I have configureit a year later and forget it. Now I want: (1)to reset/Retrive password? OR (2)Uninstall the package and re install it(While uninstalling also need password that i don't know) – Kaushik Das Aug 25 '15 at 15:31

0 Answers0