Hello.
The entity of the user in MySQL consists of two parts: the user name
and the host from which user connects to MySQL server (can be a '%
- it means any host). Look like your user table doesn't have an entry
for user 'root'@'host_from_you_are_connecting'. You should manually add the
Hello.
mysql stop automatically, and in process tab on task
manager there is no any process name mysqld*.
You may find errors in the error log. See:
http://dev.mysql.com/doc/mysql/en/error-log.html
my next question is can we address this problem by
installing 4.1.9. and/or delete
yeah, after long time,
thanks for answering.
at least i can reset password.
1. i continue what i did but set password to ''(it
doestn work if you set to other password). and restart
server normally(not with skip-grant-tables).
i can login to server. and set root password.
thanks
fred.
---
hi all,
i need to reset the root password. i have done 2
things.
but not worked.
i read
http://dev.mysql.com/doc/mysql/en/resetting-permissions.html
and do ..
a). i changed my.ini, add a line like
skip-grant-tables
and started mysql. then issue command ..
mysqladmin -u root
in addition :
when issue :
mysqld-nt --skip-grant-tables
mysql stop automatically, and in process tab on task
manager there is no any process name mysqld*.
thats why i just added a line skip-grant-tables on
my.ini.
my next question is can we address this problem by
installing 4.1.9. and/or