MySQL not connecting

[EK.IceFlake]

Hi guyz! I tried to connect a MySQL database with

Code Select Expand

db <- mysql_connect( "localhost", "YG", "<CENSORED>", "YGData", 7732);but it say connection details are wrong. But look at this (taken from MySQL console)
mysql> CREATE USER 'YG' IDENTIFIED BY '<CENSORED>'; CREATE DATABASE YGData
Query OK, 0 rows affected (0.00 sec)

    -> ;
Query OK, 1 row affected (0.03 sec)

mysql>
NOTE: <CENSORED> is replaced with a secret password consisting of letters and numbers
Any help appreciated

[vcmptr]

Are you sure port is correct?

[Thijn]

Can you login using the mysql client?
I'm not a 100% sure this will cause this error, but did you actually gave usage rights to that new user?

[EK.IceFlake]

Are you sure port is correct?

Yeah

Can you login using the mysql client?
I'm not a 100% sure this will cause this error, but did you actually gave usage rights to that new user?

Well, this is the query I executed to made that user... Didnt do anything about rights, these are only query I execute