Forums

Christos
Christos
Offline
Resolved
0 votes
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
http://www.clearfoundation.com/media/kunena/attachments/legacy/images/problem-20100611.PNG
Friday, June 11 2010, 06:24 AM
Share this post:
Responses (1)
  • Accepted Answer

    AndyL
    AndyL
    Offline
    Friday, June 11 2010, 12:10 PM - #Permalink
    Resolved
    0 votes
    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.
    The reply is currently minimized Show
Your Reply