MySQL & Navicat [HELP]

[Menna]

I'm stuck on the 'New connection' in Navicat, I'm typing in a password that I made when installing MySQL as it tells me to but, it's not working.

I'm following this tut:

You must be registered for see links

Thank you,
Menna x

P.S. had to space it out or it would come up as ************.

 

[idfk]

You must of typed it wrong, or you did it on a whole different IP?

 

[Aaron]

If you are trying to access the SQL server remotely using navicat on your computer, you need to allow remote connections on your SQL command client.. open it up and run a query similar to..

GRANT USAGE ON *.* TO 'root'@'YOUR SERVER IP' IDENTIFIED BY 'passwordhere';
hit enter.
then type FLUSH PRIVILEGES; (to update the changes.. once that says OK).. it should be ok..

You may also need to add a firewall exception (3306) for it.. as well.

Hope this sorta helped!