Hi Guys,
When I want to create a back-up I get this error:
Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: YES)
<b>Repair guide: <a target=_blank href='http://help.directadmin.com/item.php?id=45'>http://help.directadmin.com/item.php?id=45</a></b>
If I follow the tutorial then I execute this commando's:
Then I get this error:
Maybe it has something to do with this tutorial I followed:
https://help.directadmin.com/item.php?id=140
And executed this command exactly like this:
Mysql is running fine. Firewall is not running.
And when I edit:
/var/www/html/phpMyAdmin/config.inc.php
$cfg['Servers'][$i]['host'] = remote_server_address
I still can't connect..
Can you guys please help me out?
When I want to create a back-up I get this error:
Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: YES)
<b>Repair guide: <a target=_blank href='http://help.directadmin.com/item.php?id=45'>http://help.directadmin.com/item.php?id=45</a></b>
If I follow the tutorial then I execute this commando's:
Code:
systemctl stop mysqld
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
systemctl start mysqld
mysql mysql -e "UPDATE mysql.user SET authentication_string=PASSWORD('****') WHERE user='root'; FLUSH PRIVILEGES;"
systemctl unset-environment MYSQLD_OPTS
systemctl stop mysqld
systemctl start mysqld
mysql -uroot -p'*****' -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '*****';"
Then I get this error:
Code:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Maybe it has something to do with this tutorial I followed:
https://help.directadmin.com/item.php?id=140
And executed this command exactly like this:
Code:
mysql -uda_admin -p --host=4.3.2.1
Mysql is running fine. Firewall is not running.
And when I edit:
/var/www/html/phpMyAdmin/config.inc.php
$cfg['Servers'][$i]['host'] = remote_server_address
I still can't connect..
Can you guys please help me out?