Hello Everyone!

Today we will show you how to allow remote access for MySQL.By default, MySQL is not available for remote access. On this tutorial, we will show how to activate the remote access on Windows and Linux.

Windows

 1. Open the MySQL command prompt

 2. In the MySQL prompt , enter the following command line that grants all users and all IPs:

      GRANT ALL ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘password root’;

img01

 

 

– Note it is possible to give privileges to other users (modifying ‘root’) in a IP (modifying @’%’).

3. Now run the command FLUSH PRIVILEGES;

img02

 

4. Allow MySQL port (ex: 3306) on your Firewall.

Linux

1. Open your terminal and login as root then run this command: nano etc/mysql/my.cnf

img03

 

2. Alter the line bind-address = 127.0.0.1to bind-address = 0.0.0.0

img04

img05

3. Restart MySQL Service, using /etc/init.d/mysql restart

img06

4. Enter this command line mysql –u root –p

img07

5. In the MySQL prompt , enter the following command line that grants all users and all IPs:

    GRANT ALL ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘password root’;

img08

– Note it is possible to give privileges to other users (modifying ‘root’) in a IP (modifying @’%’).

6. Allow MySQL port (ex: 3306) in your Firewall.

Ok, now you have granted permission for Scriptcase to be accessed with MySQL, and this might give you more flexibility to develop you’r projects with all the features that only Scriptcase offers you!

Check our website and download it for free, test it for 20 days with full access to our Support Department and take advantage of the most powerfull RAD tool.

 

 

By , The most efficient web development environment. Create your web solutions in a fast and innovative way, reducing the development time in up to 80%. Access http://scriptcase.net and learn more.

August 7, 2014

a

You might also like…

“Scriptcase is the best IDE we have used!” (SUITE TECHNOLOGY)

See how Suite Technology used Scriptcase to develop their projects. OVERVIEW Suite Technolog...

Exceptional Services Bestowed by Scriptcase Gets Recognized at GoodFirms

When it comes to Web hosting services Scriptcase is a choice. If you ask why? It’s becaus...

IaaS, PaaS and SaaS: understanding Cloud Computing types.

Cloud Computing is a factor that has been responsible for causing several important transformations...

You might also like…

Get new posts, resources, offers and more each week.

We will use the information you provide to update you about our Newsletter and Special Offers. You can unsubscribe any time you want by clinck in a link in the footer of any email you receive from us, or by contacting us at sales@scriptcase.net. Learn more about our Privacy Police.