Reply to thread

Message

<blockquote data-quote="Wiedmann" data-source="post: 183815" data-attributes="member: 52725">In other words:- you have not set &quot;bind-address&quot;- you have not set &quot;skip-networking&quot;in your &quot;my.cfg&quot; (btw. in normal case this should be &quot;my.cnf&quot;?)You can verify that MySQL is listening on all interfaces with &quot;netstat -a -n&quot;.You need only one user: &quot;root@%&quot; (Name: &quot;root&quot;; Host: &quot;%&quot;)If you have this user, you can/should delete all other users. (Don't edit the user table directly!. Use GRANT for adding users and DROP for deleting, or use the the MySQL Administrator tool)If you don't have this user, you can add this user with:[CODE]GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;[/CODE](change 'secret' to your password)Make sure a local firewall allows access to port 3306.</blockquote>

[QUOTE="Wiedmann, post: 183815, member: 52725"] In other words: - you have not set "bind-address" - you have not set "skip-networking" in your "my.cfg" (btw. in normal case this should be "my.cnf"?) You can verify that MySQL is listening on all interfaces with "netstat -a -n". You need only one user: "root@%" (Name: "root"; Host: "%") If you have this user, you can/should delete all other users. (Don't edit the user table directly!. Use GRANT for adding users and DROP for deleting, or use the the MySQL Administrator tool) If you don't have this user, you can add this user with: [CODE]GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;[/CODE] (change 'secret' to your password) Make sure a local firewall allows access to port 3306. [/QUOTE]

Verification