i can't login phpmyadmin by any user and password. i try
http://help.directadmin.com/item.php?id=45
but
1) Make sure the root mysql password works. If you know it, skip to 2). The mysql root password can be found in the /usr/local/directadmin/scripts/setup.txt if it has not been deleted. It's under the header "mysql=". If it cannot be found, then mysqld will have to be restarted with the --skip-grant-tables option:
service mysqld stop (Redhat)
mysqld_safe --skip-grant-tables &
That should start up mysql without the need for a root password. Once in, type
use mysql
UPDATE user SET password=PASSWORD('newpass') WHERE user='root';
FLUSH PRIVILEGES;
quit
That will reset the root password for you.
Type "killall -9 mysqld_safe; killall -9 mysqld" to shut down mysqld.
Start it up again with
/sbin/service mysqld start
is ok
but when i type
mysql -uroot -pnewpass it error
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
please help to fix.
http://help.directadmin.com/item.php?id=45
but
1) Make sure the root mysql password works. If you know it, skip to 2). The mysql root password can be found in the /usr/local/directadmin/scripts/setup.txt if it has not been deleted. It's under the header "mysql=". If it cannot be found, then mysqld will have to be restarted with the --skip-grant-tables option:
service mysqld stop (Redhat)
mysqld_safe --skip-grant-tables &
That should start up mysql without the need for a root password. Once in, type
use mysql
UPDATE user SET password=PASSWORD('newpass') WHERE user='root';
FLUSH PRIVILEGES;
quit
That will reset the root password for you.
Type "killall -9 mysqld_safe; killall -9 mysqld" to shut down mysqld.
Start it up again with
/sbin/service mysqld start
is ok
but when i type
mysql -uroot -pnewpass it error
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
please help to fix.