Mysql mysql -e 'UPDATE er SET authentication_string=null WHERE user='root' FLUSH PRIVILEGES 'For all the other versions of MySQL/MariaDB: Type the following to reset the password now for MySQL 5.7 and higher: That should start up mysql without the need for a root password. Systemctl set-environment MYSQLD_OPTS='-skip-grant-tables' SET password=PASSWORD(' rootpass') and skip to step #2, below. If it cannot be found, then mysqld we need to reset it, and may need to restarted with the -skip-grant-tables option depending on server version. The mysql root password can be found in the /usr/local/directadmin/scripts/setup.txt if it has not been deleted.
Make sure the root mysql password works.When connecting to the MySQL screens in DirectAdmin, if this error appears, that would indicated that the 'da_admin' user has not been setup correctly. Use '%' for wildcards and quotes for 'exact phrases'
Error connecting to MySQL: Access denied for user: (Using password: YES)
