1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MySql Remote Access - How To

Discussion in 'Plesk for Linux - 8.x and Older' started by glennj, May 23, 2006.

  1. glennj

    glennj Guest

    OK, this has been covered before, but I searched the forum and could only ever find part of the solution.

    This is how to do it!

    Firstly check your /etc/my.conf file to make sure "skip-networking" is not enabled. If it is, comment it out.

    # skip-networking

    and save the file.

    Now restart the MySql service

    service mysqld restart

    If you are using the Firewall component of Plesk make sure the MySql Server allows incoming requests (I limit this by my workstation's Internet IP address... don't like the idea of having it open to whole world).

    Now in an SSH shell you need to add a MySql user (or you could update an existing user).

    mysql -uadmin -pyourpasswd mysql

    the password will be the same as your Plesk Admin password.

    then use the following command to add your user

    GRANT ALL PRIVILEGES ON *.* TO 'your_username'@'%'

    Obviously using your preferred username and password.

    To allow connection from only a specific IP/Host change the % to that IP/Host.

    You should now be able to connect with something like SQLYog.

  2. poke

    poke Guest

    Thanks for the write up.