Bsrgvty

Boot directly into another kernel from running Linux without bootloader

Rule of thumb: how far before changing my chain to prevent cassette wear

Paper status "Accept with Shepherd". What does it really mean?

Why are KDFs slow? Is using a KDF more secure than using the original secret?

33 Months on Death Row

What is this game with a red cricket pushing a ball?

Exists infinitely many as a numerical-quantifier

Is there a historical explanation as to why the USA people are so litigious compared to France?

Electrophilic substitution of benzene with conc. HNO₃ and HNO₂

Is it reasonable to ask candidates to create a profile on Google Scholar?

Why does b+=(4,) work and b = b + (4,) doesn't work when b is a list?

My Villain scrys on the party, but I forgot about the sensor!

Is it plausible that an interrupted Windows update can cause the motherboard to fail?

Is a light year a different distance if measured from a moving object?

"Table" method for expanding brackets vs "each term in the first bracket gets multiplied by each term in the second bracket"

What is this white sheet behind the insulation?

How is Smough's name pronounced?

How to give a rationality-inducing drug to an entire software company?

Is there any restriction in entering the South American countries multiple times in one year?

Novel set in the future, children cannot change the class they are born into, one class is made uneducated by associating books with pain

How should I tell a professor the answer to something he doesn't know?

Trying to add electrical outlets off of a junction box but the junction box has a lot more wires than Ive been shown so which ones to run it off?

Where is the 'zone of reversed commands...'?

A fast aquatic predator with multiple eyes and pupils. Would these eyes be possible?

Resetting forgotten phpmyadmin password

Where do I find the random generated password after the phpmyadmin installation?Change of Root Password for PHPMyAdmin Renders Unexpected Output on CLIReset password for mysql in ubuntu:Ubuntu PhpMyAdmin not able to find mysql passwordHow to completely remove lamp server and phpmyadminlocalhost/phpmyadmin root password recovery in ubuntuI forgot my Phpmyadmin username and password?phpmyadmin whitescreenphpmyadmin uninstalled, but account user still remainphpMyAdmin not loading correctlyUbuntu 18.04 LTS after fresh install of MySQL / PHPMyadmin; no root password; unable to login with PHPmyadminResetting MySQL root password

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;

23

12

I recently installed LAMP on Ubuntu 13.04(32-bit) but forgot my phpMyAdmin password. How can I reset its password without re-installing it?

lamp phpmyadmin password-recovery

share|improve this question

edited Dec 6 '15 at 17:17

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

asked Jul 19 '13 at 14:23

tHe_VaGaBonDtHe_VaGaBonD

24822 gold badges44 silver badges1111 bronze badges

add a comment
 | 

23

12

I recently installed LAMP on Ubuntu 13.04(32-bit) but forgot my phpMyAdmin password. How can I reset its password without re-installing it?

lamp phpmyadmin password-recovery

share|improve this question

edited Dec 6 '15 at 17:17

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

asked Jul 19 '13 at 14:23

tHe_VaGaBonDtHe_VaGaBonD

24822 gold badges44 silver badges1111 bronze badges

add a comment
 | 

I recently installed LAMP on Ubuntu 13.04(32-bit) but forgot my phpMyAdmin password. How can I reset its password without re-installing it?

lamp phpmyadmin password-recovery

share|improve this question

edited Dec 6 '15 at 17:17

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

asked Jul 19 '13 at 14:23

tHe_VaGaBonDtHe_VaGaBonD

24822 gold badges44 silver badges1111 bronze badges

share|improve this question

edited Dec 6 '15 at 17:17

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

asked Jul 19 '13 at 14:23

tHe_VaGaBonDtHe_VaGaBonD

24822 gold badges44 silver badges1111 bronze badges

share|improve this question

edited Dec 6 '15 at 17:17

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

asked Jul 19 '13 at 14:23

tHe_VaGaBonDtHe_VaGaBonD

24822 gold badges44 silver badges1111 bronze badges

edited Dec 6 '15 at 17:17

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

edited Dec 6 '15 at 17:17

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

asked Jul 19 '13 at 14:23

tHe_VaGaBonDtHe_VaGaBonD

24822 gold badges44 silver badges1111 bronze badges

asked Jul 19 '13 at 14:23

tHe_VaGaBonDtHe_VaGaBonD

24822 gold badges44 silver badges1111 bronze badges

3 Answers
3

active

oldest

votes

40

Simply change or reset your MySQL root password by doing the following:

1. 
   

   Stop the MySQL server

   
   
   

   sudo service mysql stop
   

   
   


2. 
   

   Start mysqld

   
   
   

   sudo mysqld --skip-grant-tables &
   

   
   


3. 
   

   Login to MySQL as root

   
   
   

   mysql -u root mysql
   

   
   


4. 
   

   Change MYSECRET with your new root password

   
   
   

   UPDATE user SET Password=PASSWORD('MYSECRET') WHERE User='root'; FLUSH PRIVILEGES; exit;
   

   
   


5. 
   

   Kill mysqld

   
   
   

   sudo pkill mysqld
   

   
   


6. 
   

   Start mysql

   
   
   

   sudo service mysql start
   

   
   



7. Login to phpmyadmin as root with your new password

share|improve this answer

edited Dec 6 '15 at 17:16

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

answered Jul 19 '13 at 17:35

jctoledojctoledo

1,4411212 silver badges88 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you please explain the use of #2 Start mysqld? Also, how will I be able to execute #3 since I don't remember my MySQL password anymore?
  
  – tHe_VaGaBonD
  Jul 22 '13 at 16:40
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The idea for #2 is that you are spawning a version of the MySQL daemon without a password. This allows you to reset it on step 4.
  
  – jctoledo
  Aug 6 '13 at 15:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Using Ubuntu 16 I was not able to run mysqld manually - trying to create socket and socket lock file in a dir that didn't even exist! But if you look at the very NEXT answer (which is not the accepted answer) that is what I needed - I stupidly forgot the password for the phpmyadmin user, and there it is, in plain text, in the phpmyadmin.conf folder!
  
  – Brian B
  Sep 6 '17 at 18:09
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ERROR 1054 (42S22): Unknown column 'Password' in 'field list'
  
  – Tiago Gouvêa
  Dec 26 '18 at 17:04
  

  
  
  
  

add a comment
 | 

28

You don't actually need to reset your username and password, if you can see them.

In your terminal window, type:

sudo -H gedit /etc/dbconfig-common/phpmyadmin.conf

This will open your phpmyadmin configurations.

There, you will see your username under dbc_dbuser='your_username' and password under dbc_dbpass='your_password'.

share|improve this answer

edited Feb 19 '16 at 8:21

muru

1

answered Feb 19 '16 at 7:12

thephoenix01thephoenix01

49877 silver badges1919 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I could not able to find **/etc/dbconfig-common/ ** path. Both "MySQL Database" & "Apache Web Server" running successfully. Any suggestion !! This I'm trying to work on Wordpress.
  
  – CoDe
  Aug 1 '16 at 9:41
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Don't forget to restart mysql " sudo service mysql restart "
  
  – alnassre
  Aug 24 '16 at 15:15
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I found a user called phpmyadmin, but not my main root user. That user also did not have permissions to add new users or databases!
  
  – Yahya Uddin
  Aug 24 '16 at 22:57
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Nice solution !
  
  – mistery_girl
  Feb 26 '18 at 17:14
  

  
  
  
  

add a comment
 | 

6

There is a workaround on Debian (Ubuntu, Mint, etc.) where there is a second admin account automatically generated by the system called

debian-sys-maint

You can see (and should not change) its password via

sudo nano /etc/mysql/debian.cnf

It is possible (sure on Ubuntu 16.04) to use that account both in phpMyAdmin as well as in the command line

mysql -u debian-sys-maint -p

The account has exactly the same privileges as phpMyAdmin's / MySQL's root.

share|improve this answer

edited May 3 at 16:26

Kulfy

8,1401010 gold badges3232 silver badges6060 bronze badges

answered Aug 2 '18 at 14:49

Petr KosvanecPetr Kosvanec

6311 silver badge55 bronze badges

add a comment
 | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "89"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f321903%2fresetting-forgotten-phpmyadmin-password%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

40

Simply change or reset your MySQL root password by doing the following:

1. 
   

   Stop the MySQL server

   
   
   

   sudo service mysql stop
   

   
   


2. 
   

   Start mysqld

   
   
   

   sudo mysqld --skip-grant-tables &
   

   
   


3. 
   

   Login to MySQL as root

   
   
   

   mysql -u root mysql
   

   
   


4. 
   

   Change MYSECRET with your new root password

   
   
   

   UPDATE user SET Password=PASSWORD('MYSECRET') WHERE User='root'; FLUSH PRIVILEGES; exit;
   

   
   


5. 
   

   Kill mysqld

   
   
   

   sudo pkill mysqld
   

   
   


6. 
   

   Start mysql

   
   
   

   sudo service mysql start
   

   
   



7. Login to phpmyadmin as root with your new password

share|improve this answer

edited Dec 6 '15 at 17:16

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

answered Jul 19 '13 at 17:35

jctoledojctoledo

1,4411212 silver badges88 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you please explain the use of #2 Start mysqld? Also, how will I be able to execute #3 since I don't remember my MySQL password anymore?
  
  – tHe_VaGaBonD
  Jul 22 '13 at 16:40
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The idea for #2 is that you are spawning a version of the MySQL daemon without a password. This allows you to reset it on step 4.
  
  – jctoledo
  Aug 6 '13 at 15:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Using Ubuntu 16 I was not able to run mysqld manually - trying to create socket and socket lock file in a dir that didn't even exist! But if you look at the very NEXT answer (which is not the accepted answer) that is what I needed - I stupidly forgot the password for the phpmyadmin user, and there it is, in plain text, in the phpmyadmin.conf folder!
  
  – Brian B
  Sep 6 '17 at 18:09
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ERROR 1054 (42S22): Unknown column 'Password' in 'field list'
  
  – Tiago Gouvêa
  Dec 26 '18 at 17:04
  

  
  
  
  

add a comment
 | 

40

Simply change or reset your MySQL root password by doing the following:

1. 
   

   Stop the MySQL server

   
   
   

   sudo service mysql stop
   

   
   


2. 
   

   Start mysqld

   
   
   

   sudo mysqld --skip-grant-tables &
   

   
   


3. 
   

   Login to MySQL as root

   
   
   

   mysql -u root mysql
   

   
   


4. 
   

   Change MYSECRET with your new root password

   
   
   

   UPDATE user SET Password=PASSWORD('MYSECRET') WHERE User='root'; FLUSH PRIVILEGES; exit;
   

   
   


5. 
   

   Kill mysqld

   
   
   

   sudo pkill mysqld
   

   
   


6. 
   

   Start mysql

   
   
   

   sudo service mysql start
   

   
   



7. Login to phpmyadmin as root with your new password

share|improve this answer

edited Dec 6 '15 at 17:16

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

answered Jul 19 '13 at 17:35

jctoledojctoledo

1,4411212 silver badges88 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you please explain the use of #2 Start mysqld? Also, how will I be able to execute #3 since I don't remember my MySQL password anymore?
  
  – tHe_VaGaBonD
  Jul 22 '13 at 16:40
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  The idea for #2 is that you are spawning a version of the MySQL daemon without a password. This allows you to reset it on step 4.
  
  – jctoledo
  Aug 6 '13 at 15:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Using Ubuntu 16 I was not able to run mysqld manually - trying to create socket and socket lock file in a dir that didn't even exist! But if you look at the very NEXT answer (which is not the accepted answer) that is what I needed - I stupidly forgot the password for the phpmyadmin user, and there it is, in plain text, in the phpmyadmin.conf folder!
  
  – Brian B
  Sep 6 '17 at 18:09
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ERROR 1054 (42S22): Unknown column 'Password' in 'field list'
  
  – Tiago Gouvêa
  Dec 26 '18 at 17:04
  

  
  
  
  

add a comment
 | 

Simply change or reset your MySQL root password by doing the following:

1. 
   

   Stop the MySQL server

   
   
   

   sudo service mysql stop
   

   
   


2. 
   

   Start mysqld

   
   
   

   sudo mysqld --skip-grant-tables &
   

   
   


3. 
   

   Login to MySQL as root

   
   
   

   mysql -u root mysql
   

   
   


4. 
   

   Change MYSECRET with your new root password

   
   
   

   UPDATE user SET Password=PASSWORD('MYSECRET') WHERE User='root'; FLUSH PRIVILEGES; exit;
   

   
   


5. 
   

   Kill mysqld

   
   
   

   sudo pkill mysqld
   

   
   


6. 
   

   Start mysql

   
   
   

   sudo service mysql start
   

   
   



7. Login to phpmyadmin as root with your new password

share|improve this answer

edited Dec 6 '15 at 17:16

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

answered Jul 19 '13 at 17:35

jctoledojctoledo

1,4411212 silver badges88 bronze badges

share|improve this answer

edited Dec 6 '15 at 17:16

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

answered Jul 19 '13 at 17:35

jctoledojctoledo

1,4411212 silver badges88 bronze badges

edited Dec 6 '15 at 17:16

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

edited Dec 6 '15 at 17:16

Seth♦

37.8k2828 gold badges121121 silver badges179179 bronze badges

answered Jul 19 '13 at 17:35

jctoledojctoledo

1,4411212 silver badges88 bronze badges

answered Jul 19 '13 at 17:35

jctoledojctoledo

1,4411212 silver badges88 bronze badges

28

You don't actually need to reset your username and password, if you can see them.

In your terminal window, type:

sudo -H gedit /etc/dbconfig-common/phpmyadmin.conf

This will open your phpmyadmin configurations.

There, you will see your username under dbc_dbuser='your_username' and password under dbc_dbpass='your_password'.

share|improve this answer

edited Feb 19 '16 at 8:21

muru

1

answered Feb 19 '16 at 7:12

thephoenix01thephoenix01

49877 silver badges1919 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I could not able to find **/etc/dbconfig-common/ ** path. Both "MySQL Database" & "Apache Web Server" running successfully. Any suggestion !! This I'm trying to work on Wordpress.
  
  – CoDe
  Aug 1 '16 at 9:41
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Don't forget to restart mysql " sudo service mysql restart "
  
  – alnassre
  Aug 24 '16 at 15:15
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I found a user called phpmyadmin, but not my main root user. That user also did not have permissions to add new users or databases!
  
  – Yahya Uddin
  Aug 24 '16 at 22:57
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Nice solution !
  
  – mistery_girl
  Feb 26 '18 at 17:14
  

  
  
  
  

add a comment
 | 

28

You don't actually need to reset your username and password, if you can see them.

In your terminal window, type:

sudo -H gedit /etc/dbconfig-common/phpmyadmin.conf

This will open your phpmyadmin configurations.

There, you will see your username under dbc_dbuser='your_username' and password under dbc_dbpass='your_password'.

share|improve this answer

edited Feb 19 '16 at 8:21

muru

1

answered Feb 19 '16 at 7:12

thephoenix01thephoenix01

49877 silver badges1919 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I could not able to find **/etc/dbconfig-common/ ** path. Both "MySQL Database" & "Apache Web Server" running successfully. Any suggestion !! This I'm trying to work on Wordpress.
  
  – CoDe
  Aug 1 '16 at 9:41
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Don't forget to restart mysql " sudo service mysql restart "
  
  – alnassre
  Aug 24 '16 at 15:15
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I found a user called phpmyadmin, but not my main root user. That user also did not have permissions to add new users or databases!
  
  – Yahya Uddin
  Aug 24 '16 at 22:57
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Nice solution !
  
  – mistery_girl
  Feb 26 '18 at 17:14
  

  
  
  
  

add a comment
 | 

You don't actually need to reset your username and password, if you can see them.

In your terminal window, type:

sudo -H gedit /etc/dbconfig-common/phpmyadmin.conf

This will open your phpmyadmin configurations.

There, you will see your username under dbc_dbuser='your_username' and password under dbc_dbpass='your_password'.

share|improve this answer

edited Feb 19 '16 at 8:21

muru

1

answered Feb 19 '16 at 7:12

thephoenix01thephoenix01

49877 silver badges1919 bronze badges

sudo -H gedit /etc/dbconfig-common/phpmyadmin.conf

share|improve this answer

edited Feb 19 '16 at 8:21

muru

1

answered Feb 19 '16 at 7:12

thephoenix01thephoenix01

49877 silver badges1919 bronze badges

edited Feb 19 '16 at 8:21

muru

1

edited Feb 19 '16 at 8:21

muru

1

answered Feb 19 '16 at 7:12

thephoenix01thephoenix01

49877 silver badges1919 bronze badges

answered Feb 19 '16 at 7:12

thephoenix01thephoenix01

49877 silver badges1919 bronze badges

6

There is a workaround on Debian (Ubuntu, Mint, etc.) where there is a second admin account automatically generated by the system called

debian-sys-maint

You can see (and should not change) its password via

sudo nano /etc/mysql/debian.cnf

It is possible (sure on Ubuntu 16.04) to use that account both in phpMyAdmin as well as in the command line

mysql -u debian-sys-maint -p

The account has exactly the same privileges as phpMyAdmin's / MySQL's root.

share|improve this answer

edited May 3 at 16:26

Kulfy

8,1401010 gold badges3232 silver badges6060 bronze badges

answered Aug 2 '18 at 14:49

Petr KosvanecPetr Kosvanec

6311 silver badge55 bronze badges

add a comment
 | 

6

There is a workaround on Debian (Ubuntu, Mint, etc.) where there is a second admin account automatically generated by the system called

debian-sys-maint

You can see (and should not change) its password via

sudo nano /etc/mysql/debian.cnf

It is possible (sure on Ubuntu 16.04) to use that account both in phpMyAdmin as well as in the command line

mysql -u debian-sys-maint -p

The account has exactly the same privileges as phpMyAdmin's / MySQL's root.

share|improve this answer

edited May 3 at 16:26

Kulfy

8,1401010 gold badges3232 silver badges6060 bronze badges

answered Aug 2 '18 at 14:49

Petr KosvanecPetr Kosvanec

6311 silver badge55 bronze badges

add a comment
 | 

There is a workaround on Debian (Ubuntu, Mint, etc.) where there is a second admin account automatically generated by the system called

debian-sys-maint

You can see (and should not change) its password via

sudo nano /etc/mysql/debian.cnf

It is possible (sure on Ubuntu 16.04) to use that account both in phpMyAdmin as well as in the command line

mysql -u debian-sys-maint -p

The account has exactly the same privileges as phpMyAdmin's / MySQL's root.

share|improve this answer

edited May 3 at 16:26

Kulfy

8,1401010 gold badges3232 silver badges6060 bronze badges

answered Aug 2 '18 at 14:49

Petr KosvanecPetr Kosvanec

6311 silver badge55 bronze badges

debian-sys-maint

sudo nano /etc/mysql/debian.cnf

mysql -u debian-sys-maint -p

share|improve this answer

edited May 3 at 16:26

Kulfy

8,1401010 gold badges3232 silver badges6060 bronze badges

answered Aug 2 '18 at 14:49

Petr KosvanecPetr Kosvanec

6311 silver badge55 bronze badges

edited May 3 at 16:26

Kulfy

8,1401010 gold badges3232 silver badges6060 bronze badges

edited May 3 at 16:26

Kulfy

8,1401010 gold badges3232 silver badges6060 bronze badges

answered Aug 2 '18 at 14:49

Petr KosvanecPetr Kosvanec

6311 silver badge55 bronze badges

answered Aug 2 '18 at 14:49

Petr KosvanecPetr Kosvanec

6311 silver badge55 bronze badges