![]() It is now located in the directory \Xampp\phpmyadmin\. ![]() I copied it from the template file and altered its contents. It is like the file contents are ignored. What should I do? I'm really confused and I need your help. I put in the password and it gives me another login box. I want to assign another random password to this user, and I want to access my database via PHPMyAdmin, as I did within the fresh Xampp installation before. I reset the mySQL password using the downloaded reset files from then I followed the instructions from Now I'm locked out of phpMyadmin - it brings up the login box and that's it. enter the following 2 commands at the mysql> command prompt, each with a semi colon at the end of a line, and press ENTER after each line to issue the command to mysql.- For MySQL versions prior 5.7. The relevant lines in that file are now: $cfg = 'root' Ĭurrently, it is strange but, I can connect with the password I deleted, but I cannot connect with empty password: C:\Users\hkBattousai>mysql.exe -user=root -password=rCZ4Xnz78zbLY2Vh // ConnectsĬ:\Users\hkBattousai>mysql.exe -user=root -password= // Error given Now we are going to reset the password for the root user, of course this could be used to reset any users password. Then I removed the password via the command line interface: Type '\c' to clear the current input statement. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Server version: 5.5.27 MySQL Community Server (GPL)Ĭopyright (c) 2000, 2011, Oracle and/or its affiliates. Mysql.exe: Switching to the default character set 'latin1'. Mysql.exe: Unknown OS character set 'cp857'. ![]() ![]() C:\Users\hkBattousai>mysql.exe -user=root -password=rCZ4Xnz78zbLY2Vh Then I edited the `" file of PHPMyAdmin, and made its contents exactly as below: īut I was able to connect to the MySql servier via command line by the same password. They correspond to the information given by the administrator of the MySQL server. You should check the host, username and password in your configuration and make sure that PhpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. It started to give the following error message, and it is the same ever since: Error I set a randomly generated password (rCZ4Xnz78zbLY2Vh). I was happily using it with its all features. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |