quote:
Originally posted by 1QuickSI:
restart MySql server with --skip-grant-tables
Login to mysql --user=root
select * from mysql.user
check that 'admin' is there with a correct password set AND FOR Host='localhost'
if yes, then you mistyped your 'admin' password. Change it."
- Can I know where should I key the above commands, in command line?
mysql> --user=root
or
e:mysqlbin> --user=root
or
e:mysqlbin> mysqld-nt --user=root
-------------------------------------------------
quote:
[qb]Originally posted by 1QuickSI:
update mysql.user set Host='localhost',Password=PASSWORD('youradminpassword') WHERE User='admin';
flush privileges;
exit;[/qb]