Hi,
I try to access the MySQL with ODBC connection from the internal LAN but I get the message that it is in the photo....
I also saw the topic http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid,12/func,view/id,9403/#9414
but there is no description on how to do that.....
I have port 3306 opened OK in the firewall.....
Any suggestion please
Thank you
I try to access the MySQL with ODBC connection from the internal LAN but I get the message that it is in the photo....
I also saw the topic http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid,12/func,view/id,9403/#9414
but there is no description on how to do that.....
I have port 3306 opened OK in the firewall.....
Any suggestion please
Thank you
In Database
Share this post:
Responses (1)
-
Accepted Answer
It looks like the host you are trying to connect from does not have access. Access to MySQL is not connected to the users on the Clear box (someone correct me if I'm wrong here and there is a connection) but is managed separately.
You can specify which host's can connect, and whether they are allowed to connect from the network, or only from localhost.
I take it you have set a password for your database from the ClearOS web interface. Once you have done that, there will appear a line above:
You can manage your MySQL database through another web interface. -- Go
Click on Go to get to phpmyadmin. Log on as root, with your password. From here in the privileges tab, you can add new users. They are not the same as ClearOS users!
From here you can add users. Remember to give them access from the network.
To test your connection before you add any new users, you could try connecting as root, with your password. It should connect, because root has network connection privileges. Once you can connect, create your user(s) and set the access right you want.

Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »