![]() ![]() For example, if it’s required to allow access to the database called database for user user with password password and remote IP address 203.0.113.2: GRANT ALL ON database.* TO '203.0.113. Grant access to remote IP address and login to MySQL. ![]() Note: For the access to client’s MySQL server on Windows, use PHPMyAdmin: Plesk > Tools & Settings > Database Servers – MySQL DB Admin. Step -5: The mysqliconnect () function opens a new connection to the MySQL server. Step -4: Here we define our database name. Start Plesk Services Monitor > select MySQLX or MariaDBX (where X is a version) > click Restart. But you can create db user name whatever you want. ![]() If it is required to bind to specific IP address, specify this particular IP instead of 0.0.0.0Īlso, make sure that skip-networking parameter is not defined. It is available under the GPL license and is supported by a huge and active community of open source developers. Note: 0.0.0.0 means every IP address on the server. MySQL Community Edition is the freely downloadable version of the world's most popular open source database. Location of this file is:Ĭhange bind-address parameter to: bind-address = 0.0.0.0 Following are best affordable Web Hosting Provider: DomainRacer: Affordable, SSD hosting with 21x Faster Server GoDaddy: Largest Domain Registrar and Web. Log in to Plesk and make sure the option Allow remote connections from any host is enabled at Tools & Settings > Database Servers > Settings.Ĭonnect to a Plesk server via SSH/ RDP and open the MySQL configuration file in any text editor. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |