MySQL on FreeBSD, connecting with root user remotely?!?

I've just installed MySQL 3.23.49 on my FreeBSD 4.5 box and it's going ok so far except for one thing. First i've changed the root password, and I can login no problem. I even created a new user by name 'digitalsy' and gave him full privileges, even from a remote machine (on my LAN) so I can use MySQL-Front from windows. The thing is, I cannot give permission to my root user to connect remotely. Is there some sort of built in security feature that doesn't allow root to connect remotely? I haven't heard of one, and if not how can I fix this prob?

Here's the command I used:
mysql> GRANT ...
-> ON *.*
-> TO root@"remotemachine.mydomainname.com"
-> IDENTIFIED BY 'mypassword';

This returned an error something along the lines of cannot find row in table or something. But i created a new user as i said with this syntax:

GRANT ALL PRIVILEGES ON *.* TO digitalsy@localhost
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO digitalsy@"%"
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

and then i repeated the previous command for adding them remotely, and it worked, i could use mysql-front, no prob.

any ideas?

Thanks,

digitalsy

Hi,
Im not too sure, but that does sound very logical. YOu might wanna checkout http://www.mysql.com/doc/G/R/GRANT.html, it might have some info.

Actually i figured out why the other day, it was simply that the user URL was another user as opposed to root@localhost.

Doing the following worked:

GRANT ALL PRIVILEGES ON *.* TO URL
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;


Then i was able to connect with mysql front


-digitalsy

I am going to through some suggestions your way...first you might want to get out of the habit or not start to use root to connect to mysql. I suggest using a user that you have created. Sometimes you can forget to change the password and then you get hacked.

Also if you have to use root, try and encrypt the connect so that people do not get your password by sniffing the line. I understand that you are on you own LAN, however, what we do at home we are very likely to do at work...

Just my .02 worth...