How do I access mysql over the network?

Question

I have a development window and a development server.

I have some development tools in my development area with which I want to access MySQL located on a development server.

The development server was configured using XAMPP.

How to make mysql available over the network? What am I using for the host name?

thank

Answer 1

comment out the line:

skip-networking -> #skip-networking

in file:

/Applications/XAMPP/xamppfiles/etc/my.cnf

Answer 2

Try the following: http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

Answer 3

mysql XAMPP :

-go xammp XAMPP\Apache\\\

-open httpd-xampp.conf

#
# New XAMPP security concept
#
<LocationMatch "^/(?i:(?:xampp|security|licenses|phpmyadmin|webalizer|server-status|server-info))">
        #Require local        
       
	ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
</LocationMatch>

Hide result

-create a database in mysql and create a new user with a username and password with the host:% (any host), which will allow you to connect the "username" @ "%" over the network

-search command line type ipconfig

now you can access mysql in your ipaddress: 3306 (3306 is the default port for mysql)