Host Options When Adding A User
Posted 11 May 2012 - 04:32 PM
i.e. using 'localhost' will allow the user to connect locally. If you want the user to be able to connect remotely should you use '%' ?.
Are there any other choices?
Posted 11 May 2012 - 06:58 PM
You may use SQL-wildcards ("%" and "_") in a user definition, so for example
'someuser'@'%' can connect from anywhere (as "%" is the SQL wildcard for any number of any characters)
'someuser'@'10.0.0._' can connect from the ip's 10.0.0.0, 10.0.0.1, 10.0.0.2, .. , 10.0.0.9 (but not 10.0.0.10 etc. as "_" is the SQL wildcard for a single character).
See more here: http://dev.mysql.com...ount-names.html
Posted 14 May 2012 - 03:46 PM
Note also that you must set the "bind-address" config to the network port(s) to be used (in /etc/mysql/my.cnf on Ubuntu).
See http://dev.mysql.com...n/security.html for security considerations...
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users