I use Adminer and can not connect to the database.
Where can I see or where I asked, or how can I change my password to enter?
Venzell
18.5k 5 gold signs 30 silver marks 55 bronze marks
darkwoolf darkwoolf
629 2 gold marks 9 silver marks 22 bronze marks
Closed due to the fact that the essence of the question is not clear to the participants of VenZell , Dmitriy Simushev , cheops , user194374, aleksandr barakin 9 Jun '16 at 13:34 .
Try to write more detailed questions. To get an answer, explain what exactly you see the problem, how to reproduce it, what you want to get as a result, etc. Give an example that clearly demonstrates the problem. If the question can be reformulated according to the rules set out in the certificate , edit it .
- Password to database or Adminer? And what are we talking about? About this: adminer.org/en/extension ? - VenZell
- the password to be entered into the admin at the entrance - darkwoolf
- take a screenshot of the tool you are working with and its login form without the entered data - VenZell
- added screenshot - darkwoolf
- Possible duplicate question: How to find out the root user password for the MySQL database in Ubuntu? - aleksandr barakin
|
2 answers
Explanation
You need not change (or enter) the password for the Adminer, but change (or enter) the password of the MySQL user.
How to change password
In the terminal, execute the command
sudo dpkg-reconfigure mysql-server-5.0 (Where mysql-server-5.0 is your version of the MySQL server)
Click "Enter" and enter the new password.
(Works only in Ubuntu)
How to find out the version of MySQL
In the terminal, execute the command
mysql --version There will be something like this:
mysql Ver 14.14 Distrib 5.1.66, for pc-linux-gnu (x86_64) using readline Whence information
How to recover password Mysql (Ubuntu)? (there is another way to recover the password in the article)
How to find out the version of MySQL server
VenZell VenZell
18.5k 5 gold signs 30 silver marks 55 bronze marks
- writes this when trying to find out the version of ERROR 2002 (HY000): Can't connect to mySQL server through socket '/var/run/mysqld/mysqld.sock' - darkwoolf
- @darkwoolf, look at this article softodom.com/516/… and try to solve this problem using the method described in it. Then go back to my answer. - VenZell
- krch, decided ... instead of localhost scored IP 127.0.0.1 - darkwoolf
|
instead of localhost, dial 127.0.0.1
darkwoolf darkwoolf
629 2 gold marks 9 silver marks 22 bronze marks
- And it solved the problem with a forgotten password without recovering it? - VenZell
- if you carefully read the question, I pointed out where I pointed it out, because I did not know why it didn’t go in ... But how it happened it was necessary to write exactly that ... I myself was surprised ... I just could not figure out how to come in later I was looking for a solution, I just wrote to php and all that and at 5 am I somehow came in after a hundred and second attempts, and then I forgot how I entered, but now I will know - darkwoolf
|