mariadb remote access issues

Hello all my name is 0xNosaj I have a website I was given to control and move. It runs on PHP. I have only SSH access to it but I cannot seem to make the phpmyadmin site come up. How I've tried connecting are ssh -L 8080:1.2.3.4:80 user@1.2.3.4 and ssh -NL 3307:localhost:3306 root@REMOTE_HOST But when I try to connect with credentials I have I get an error when I open the phpmyadmin website on my laptop. >mysqli::real_connect(): (HY000/1045): Access denied for user 'nosaj'@'localhost' (using password: YES) I have done a GRANT ALL on [database] identified by 'PASS'; FLUSH PRIVILEGES; and restarted MariaDB. I do not have the root password for the MariaDB database but I do have root on the Linux server (Ubuntu 18. If this is the wrong forum, if someone could kindly guide me to the correct place I'd sure appreciate it.