Sign-up our Newsletter  Register on our LinkedIn  Follow us on Twitter  Check out our Facebook  Follow us on Google+
Follow

I can run XStudio only form the server hosting MySql!

It is a MySql configuration issue.
The reason for this is that you're probably using the root user to connect to MySQL (by default, MySQL does give permission to root to connect only locally). You should create a new dedicated user having the permissions to connect from anyremote location (and only to xstudio_db database).

  • Launch the MySQL Administrator tool on the system hosting the database server
  • Select the User Administration option
  • Right-click in the bottom left hand corner of the window and select Add new user
  • You can check that the temporary name of the user is "New user@any host"
  • Enter the credentials of this new user: name=xstudio and password=xstudiopwd
  • Select the Schema privilege tab
  • Click on the xstudio_db database item and grant all the rights to this user by pressing <<
  • Validate and exit the MySQL Administrator tool
  • Restart XStudio from the remote host and provide the new xstudio user credentials in the connection settings dialog



If you wish to keep on using the root user (it's not recommended), you can resolve the issue by executing the following actions:

  • Launch the MySQL Administrator tool on the system hosting the database server
  • Select the User Administration option
  • Right-click on the root user and select Add Host
  • Add the host name or IP address of the remote host to which you wish to allow connections
  • Validate and exit the MySQL Administrator tool

Once root has the appropriate privileges to connect from the specified host it should be possible to connect the MySQL Administrator client to the database server

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.