Blog

Jueves, 30 Mayo 2019 21:40

Habilitar acceso remoto a MYSQL desde Plesk

Written by 
Rate this item
(0 votes)

El artículo está en inglés, pero es de fácil comprensión. 

MySQL is in the view of many people one of the most common database management systems in use on a day to day basis. You can run MySQL on just about any platform including Microsoft Windows and server UNIX varieties, like Linux, with many platforms also supporting MySQL remote access.

 

What is MySQL?

It’s often the engine that holds the data for  programs, including online publishing. Backed by Oracle, MySQL is an open source (everyone has access to the code) database that fits into the RDBMS (Relational database management system) paradigm.

 

MySQL has shifted hands a few times. It was first designed and developed by a company located in Sweden called MySQL AB, but was then bought out by Sun Microsystems in 2018. Though MySQL is owned by a commercial enterprise, developers may use it under the GNU GPL (or General Public License). However, enterprises must get a specific license from Oracle if they want to use MySQL in their applications.

 

How MySQL fits into Plesk Onyx

Plesk Onyx is database-driven and needs a database server to facilitate the various database services that Plesk components use. For example, there are databases involved in hosting Plesk Webmail. Each customer website will also use a database to store content while APS application databases are also required.

 

Every Plesk installation ships with a number of database management tools and Plesk supports a range of databases including MySQL. Plesk can interact with database servers located on the machine running Plesk. But Plesk can also link to a database server on a remote machine. You can also facilitate remote MySQL access via Plesk, should you have an external application that requires access to your MySQL databases.

 

Plesk MySQL Remote Access

In many instances, a user needs to facilitate a connection to a database from a third-party software tool that isn’t running on the same server as the database. You can enable Plesk MySQL remote access so that remote servers and hosts can access the MySQL databases in your Plesk account.

 

Activating MySQL Remote Access Under Plesk

For security reasons, Plesk doesn’t automatically make it possible to get remote MySQL access. We recommend that you create a new, separate user to use for remote MySQL connections. Nonetheless, if you prefer to do so, you can use the admin user account to facilitate remote MySQL access.

 

To enable MySQL remote access you must connect to your server with SSH/RDP and carefully follow the steps we list below:

 

Login to Plesk and make sure the option Allow remote connections from any host is enabled at Tools & Settings > Database Servers > Settings.

Connect to a Plesk server via SSH/RDP and open the MySQL configuration file in any text editor. Location of this file is:

For Linux:

  • for CentOS/RHEL-based distributions:/etc/my.cnf
  • for Debian/Ubuntu-based distributions:/etc/mysql/my.cnf

For Windows:

  • %plesk_dir%Databases\MySQL\my.ini

Change bind-address parameter to:

bind-address = 0.0.0.0

Note: 0.0.0.0 means every IP address on the server. If it is required to bind to specific IP address, specify this particular IP instead of 0.0.0.0

Also, make sure that skip-networking parameter is not defined.

After that, restart MySQL server:

For Linux:

  • for MariaDB database server:# service mariadb restart
  • for MySQL database server:# service mysql restart.

For Windows:

  • Go to Plesk > Tools & Settings > Services Management > Restart MySQL Server

 

Read 4320 times Last modified on Jueves, 21 Noviembre 2019 12:26

54 comments

  • Comment Link hi Martes, 17 Mayo 2022 01:05 posted by hi

    No matter if some one searches for his essential thing, therefore he/she wishes to be available that in detail, so that thing is maintained over here.|

  • Comment Link hot shot bald cop Sábado, 07 Mayo 2022 23:20 posted by hot shot bald cop

    I was just telling my friend about that.

  • Comment Link Landon Jueves, 05 Mayo 2022 05:57 posted by Landon

    Today, while I was at work, my cousin stole my iphone and tested to see if it can survive a 40 foot drop, just so
    she can be a youtube sensation. My apple ipad is now destroyed and she has 83 views.

    I know this is totally off topic but I had to share it with someone!

  • Comment Link Randi Jueves, 05 Mayo 2022 03:37 posted by Randi

    Someone essentially assist to make seriously articles I would state.
    That is the very first time I frequented your web page and so far?
    I amazed with the research you made to make this particular publish
    extraordinary. Magnificent task!

  • Comment Link Sallie Miércoles, 04 Mayo 2022 10:52 posted by Sallie

    Howdy just wanted to give you a brief heads up and let you
    know a few of the pictures aren't loading correctly. I'm not sure why but I think
    its a linking issue. I've tried it in two different browsers and
    both show the same outcome.

  • Comment Link Violette Miércoles, 04 Mayo 2022 03:58 posted by Violette

    Thank you for another great article. Where else may just anybody get
    that kind of info in such an ideal means of writing?
    I have a presentation next week, and I'm at the search for such info.

  • Comment Link Stepanie Miércoles, 04 Mayo 2022 03:24 posted by Stepanie

    I was suggested this blog by my cousin.
    I'm not sure whether this post is written by him as no one else know such detailed about my trouble.
    You are wonderful! Thanks!

  • Comment Link Andy Miércoles, 04 Mayo 2022 00:19 posted by Andy

    It is truly a nice and helpful piece of information. I'm glad that you shared this helpful info with us.

    Please keep us up to date like this. Thanks
    for sharing.

  • Comment Link Jeannie Martes, 03 Mayo 2022 14:37 posted by Jeannie

    I think the admin of this site is really working hard for his website,
    as here every data is quality based information.

  • Comment Link Mohamed Lunes, 02 Mayo 2022 14:31 posted by Mohamed

    Hi! Quick question that's completely off topic. Do you know how to make your site mobile friendly?
    My weblog looks weird when viewing from my iphone 4.

    I'm trying to find a theme or plugin that might be able to correct
    this issue. If you have any suggestions,
    please share. Many thanks!

Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.