The problem is that I could not remember the root password that I set on the XAMPP security page, and because I could not enter PHPmyAdmin and create the database, I assumed that I should reset the password for the root account. Any changes that I make on the PHPMyAdmin security page or on the command line have no positive results for me.
Although it seems that this problem has been solved many times already, I read numerous articles here and on different sites regarding this error, and yet I did not find a thread with an answer.
What I have done is to repeat a few examples below, many times to go. I still cannot get into phpMyAdmin or do anything on the command line with a root account.
I have:
reset my root passwords for Windows systems via a file (mysql-init.txt) containing the following commands:
UPDATE mysql.user SET Password = PASSWORD ('1234') WHERE User = 'root';
PRIVILEGES OF FLUSH;
after disabling MySql, the above commands were executed using the line command from my XAMPP shell (run as administrator), the syntax is:
msyqld --init-file: C: \ My site \ Xampp \ mysql \ mysql-init.txt Note: The file is located in the mysql folder. I posted it there.
I at points I changed my config.inc.php file, changing the password, but without a real Exodus.
$cfg ['] [$ i] [' host '] =' localhost ';
$ cfg ['Servers'] [$ i] ['auth_type'] = 'cookie';
$ cfg ['Servers'] [$ i] ['user'] = 'root';
$ cfg ['Servers'] [$ i] ['password'] = '';\ , Xampp sec
$ cfg ['Servers'] [$ i] ['extension'] = 'mysqli';
$ cfg ['Servers'] [$ i] ['AllowNoPassword'] = true;
$ cfg ['Lang'] = '';
- PHPMyadmin root,
get "# 1045 MySQL
"
mysql (
) :
mysql -u root -p
( )....
.
...
mysqladmin -u root 1234
: " " root "@" Localhost "( : )
:
root @localhost = PASSWORD ('1234');
, , ( 1045)
, , root. - , , ?
, - , - , root
. , root - . , , ( ... ). . , - . , , , .