1QuickSI
Thanks for your reply.
quote:
Originally posted by kenhk:
[QUOTE]Originally posted by 1QuickSI:
[qb]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."
-------------------------------------------------
quote:
[qb]Originally posted by 1QuickSI:
update mysql.user set Host='localhost',Password=PASSWORD('youradminpassword') WHERE User='admin';
flush privileges;
exit;[/qb]
I input the commands and the error 1044: Access denied for user: '@localhost' to database 'mysql'
-------------------------------------------------
quote:
Originally posted by 1QuickSI:
Try editing your hosts file with
127..0.1 localhost
- which file should I edit?
-------------------------------------------------
quote:
[qb]Originally posted by 1QuickSI:
mysql -h your.ip.address.here[/qb]
- after enter the command---1130 - Host 'kenkk' is not allowed to connect to this MySQL server
I tried on the same box as the install and from my workstation