Mysql permissions 1

[rninja]

I would like to access my mysql database using a hostname other than localhost. Here is the example scenario I would like to have work:

mysql -u martin -h 192.168.0.100 -D coorpp -p

The reason I am trying to use another hostname is to use a program called mysqlfront, so I can edit the database visually, form a win box. No mater what I have tried so far, I cannot get acces I always get a 1045 error access denied.

Thanks in advance! Rninja

http://www.rninja.com

 

[devnull22]

You need to add the user to the mysql database with the host.
ie.

shell> mysql -u root -p mysql
shell> INSERT INTO mysql (user,host,password)
values ('martin','192.168.0.100',PASSWORD('blaa'));
shell>flush privileges

or you can use the GRANT funtions.

note : the user martin loging in from localhost is different
from martin loging in from 192.168.0.100

cheers devnull22

http://www.photoflux.com

http://www.clickEval.com

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !

 

[rninja]

Thanks Much Devnull22 Rninja

http://www.rninja.com