Cara Mengatasi MySQL Server Error #1045 #2002

By -
Bismillah... cmiw

Have you ever installed phpmyadmin and got these errors:
  • #2002 Cannot log in to the MySQL server
  • #1045 Cannot log in to the MySQL server
Here's the simple solution, but if you have another better than this, please write it in comment box :D
  1. Stop the mysql demon process using this command :
    sudo service mysql stop
  2. Start the mysqld demon process using the --skip-grant-tables option with this command:
    sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &
  3. Start the mysql client process using this command:
    mysql -u root
  4. From the mysql prompt execute this command to be able to change any password:
    FLUSH PRIVILEGES;
  5. Then reset/update your password and quit:
    SET PASSWORD FOR root@'localhost' = PASSWORD('password');
    quit
  6. Start the mysql demon process using this command :
    sudo service mysql start
Now, you can log in to MySQL as root user. Try to reopen from your browser!

Comments

Post a Comment

Populer Post

Extract Database With Sqlmap

By -
Bismlillah... Hello, buddy! have ever think why Oracle Corp will monopolize and commercialize Mysql? While many people already depended on it in their development. You do not need to answer it, seriously. Coz now we aren't going to talk about that, but we're gonna talk about how to use Sqlmap to extract database. Assumption: You have apache2, mysql, phpmyadmin instaled on your system. I use DVWA for victim site, click here  for more information and download link. You have found the vulnerable from DVWA site. Click here for tutorial. I use Mantra and Burp Suite for IG(Information Gathering). Click here for tutorial!. Important to find the cookie. Open your teminal and go to sqlmap directory " cd /pentest/database/sqlmap/ " or use gnome menu. So let's rock, here's the step: First read the manual by typing " ./sqlmap -h ". If you are already knew about the usage, let's continue. Here's the syntax " ./sqlmap.py -u victim_u...
Read more

How To Install Mutillidae And Try A Little Test

By -
Image
Bismillah... So, bofore we start sharing about Mutillidae. Better for us to know it's definition. Open the spoiler to read it, but if you aren't patient enough, just pass it by :D Open: Mutillidae is a free, open source web application provided to allow security enthusiest to pen-test and hack a web application. Mutillidae can be installed on Linux, Windows XP, and Windows 7 using XAMMP making it easy for users who do not want to install or administrate their own webserver. It is already installed on Samurai WTF. Simply replace existing version with latest on Samurai. Mutillidae contains dozens of vulnerabilities and hints to help the user exploit them; providing an easy-to-use web hacking environment deliberately designed to be used as a hack-lab for security enthusiast, classroom labs, and vulnerability assessment tool targets. Mutillidae has been used in graduate security courses, in corporate web sec training courses, and as an "assess the assessor" tar...
Read more