• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Solved Unable to connect to mysql server

Ezzz

Developer of Nostalrius and The Violet Project
Joined
Feb 26, 2010
Messages
1,889
Solutions
3
Reaction score
795
Location
Spain, Europe
Hello guys,

Well i uploaded my website "nicaw" to a free and great website hosting, however it always says me that it's

Unable to connect to mysql server

However, i tryed in my localhost, in the config.php.inc withdrawing the "localhost" and putting there my IP Adress, and it stills gives me "Unable to connect to mysql server"

On my localhost!!!
Code:
# MySQL server settings
$cfg['SQL_Server'] = 'myIPHere';
$cfg['SQL_User'] = 'root';
$cfg['SQL_Password'] = 'mypass';
$cfg['SQL_Database'] = 'mydatabase';
So i dont get it! It has to be something with my PC?, or do i still need to do something else!¿? Help will be appreciated by hand really.
 
Last edited:
Solved.

In the MySQL console, i forgot to add my privileges:

GRANT ALL PRIVILEGES ON database.* TO root@myip identified by 'password';
 
Back
Top