Problem connecting External MYSQL

Site Operators Tutor Help
1

I am trying to connect external MySQL database using tutor configuration. I set up database server with:

DROP USER IF EXISTS 'openedx'@'%';
CREATE USER 'openedx'@'%' IDENTIFIED BY 'yourpassword';
GRANT ALL PRIVILEGES ON openedx.* TO 'openedx'@'%';
FLUSH PRIVILEGES;
mysql> SELECT user, host FROM mysql.user WHERE user = 'openedx';
+---------+------+
| user    | host |
+---------+------+
| openedx | %    |
+---------+------+
1 row in set (0.00 sec)

Now i am getting the following error message:

mysql -u openedx --password="****" --host "mysql.internal.****.com" --port 3306 -e "GRANT ALL ON openedx.* TO '"'"'openedx'"'"'@'"'"'%'"'"';"'

Initialising MySQL...

mysql: [Warning] Using a password on the command line interface can be insecure.

ERROR 1045 (28000): Access denied for user 'openedx'@'ip-*****.internal' (using password: YES)

I really appreciate for any suggestions.

2

Hi @hkhanal01 could you provide more detail? What version of Tutor are you using? Is there any other details of your system or what docs you’ve looked at that aren’t helpful?

3

@sarina I resolved this issue. I made a mistake in creating the user in Mysql server. I messed up between “openedx” and root user. I had to crate the separate root user .