Hi guyz! I tried to connect a MySQL database with
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
Are you sure port is correct?
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?
Quote from: vcmptr on Jul 02, 2015, 04:54 PMAre you sure port is correct?
Yeah
Quote from: Thijn on Jul 02, 2015, 05:38 PMCan 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