Bug #42853 Change wording of the 'disallow root access from remote machines' setup option
Submitted: 14 Feb 2009 4:14 Modified: 31 Mar 2014 8:29
Reporter: Roel Van de Paar (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Config Wizard Severity:S3 (Non-critical)
Version:5.0.72sp1 OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D4 (Minor)

[14 Feb 2009 4:14] Roel Van de Paar
Description:
The current enable/disable option in the 'MySQL Server Instance Config Wizard' says 'Enable root access from remote machines' (on the security options screen, below the password). 

The term 'remote' is incorrect, as it is not possible to connect even on the 'local' machine using the external IP, as can be seen from the below.

How to repeat:
o Run 'MySQL Server Instance Config Wizard' and note the current wording in the security options screen, below the password.

o Example:

192.168.0.50 is my IP, mysql is on this machine, and the option 'Enable root access from *remote* machines' is disabled (unticked).

C:\mysql5.1.31\bin>mysql -uroot -p -P5131
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.31-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye

C:\mysql5.1.31\bin>mysql -uroot -p -P5131 -h 192.168.0.50
Enter password: ******
ERROR 1130 (HY000): Host '192.168.0.50' is not allowed to connect to this MySQL
server

C:\mysql5.1.31\bin>ipconfig

Windows IP Configuration

Wireless LAN adapter Wireless Network Connection:

   IPv4 Address. . . . . . . . . . . : 192.168.0.50

Suggested fix:
Change this to ticked by default (reverse option) and maybe use wording like 'Disallow root access from any interface except for localhost' or similar.
[11 Jan 2010 21:55] Roel Van de Paar
See bug #50219
[15 Jan 2010 0:25] Roel Van de Paar
See bug #18555
[31 Mar 2014 8:28] Yngve Svendsen
Posted by developer:
 
Thank you for the bug report. We are closing this report now for two related reasons:

* MySQL Server 5.0 is an obsolete version of MySQL Server
* For recent MySQL Server versions, the config wizard is no longer available, and the MySQL Installer for Windows is the recommended way to install MySQL Server on Windows