![]() ![]() 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 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. 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 Then, run the next command on Windows Command Line: C:\wamp64\bin\mysql\mysql5.7.21\bin\mysqld.exe wampmysqld -init-fileC:\\wamp64\\mysql-init. Then I removed the password via the command line interface: Try this: Create a file C:\wamp64\mysql-init.txt with this content: UPDATE er SET PasswordPASSWORD ('1234') WHERE User'root' FLUSH PRIVILEGES This will reset password to 1234 for user root. 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'. Under the Value field, enter your new password let’s say mikerotch. Look for the row named userpass (usually the 3 rd one) and make the following changes: Under the Function field, set it to MD5. ![]() Mysql.exe: Unknown OS character set 'cp857'. Click on the little yellow pencil icon located next to the admin entry that’s the edit icon. 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 |