Loading

MYSQL Connection string

Abdu Rafeeq

How to write connectionstring for mysql externel server(hosted server)

I put given connection string but error arise

Authentication to host '208.000.000(sample)' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'bba403225.alshamil.net.ae' (using password: YES) ..

any help

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bharathi Raja8y ago
mysql -u root -p
UPDATE mysql.user SET Password=PASSWORD('mypass') WHERE User='root';
Flush the privileges: FLUSH PRIVILEGES;
Exit by typing: Exit
Edited line in the file config.inc.php with the new root password: $cfg['Servers'][$i]['password'] = 'mypass'
Bryian Tan8y ago
did you check with the hosting company?