You have to create a new MySQL User and assign the required privileges as below in the Query prompt via the phpMyAdmin or using the command prompt:
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Once completed with all these above four queries, it should be connecting with username / password
Hope this helps !
If you want to learn more about SQL, Check out this SQL Certification by Intellipaat.
For more information visit :