Hi Manfred, > Have anybody a step by step example to use mySQL Administrator on Windows to > connect to mySQl on a OpenSolaris install > I have set OpenSolaris to an static IP (192.168.10.211) > I have set the grant to the user: grant all on mysql.* to root at > 192.168.10.211 identified by "myPassword"
You are granting access to all the tables in the mysql database to the root user on the OpenSolaris host. You should be granting access for the Windows client you want to connect from. I.e.: grant all on mysql.* to root at winHOST identified by "myPassword" Where winHOST is the name or IP address of your Windows client. > I can ping the server from the login Window on mySQLAdministrator > In the /etc/my.cnf file is no bind-address=192.168.10.211 !!!! Is it > necessary? > No, if you don't specify a bind-address, it should try and bind to all IPs on all interfaces. MC -- Martin 'MC' Brown, mc at mcslp.com and mc.brown at sun.com Technical Writer, Database Group, Sun Microsystems Everything MCslp: http://planet.mcslp.com
