MySQL not localhost

[MaRiOs]

How do I remove the localhost thing from mysql so me and my clients can connect from their home's using progs like MySQL administrator etc ?

 

[MaRiOs]

I have found this :

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dmysql -e "insert into user values ('111.111.111.111', 'databaseusernamehere', password('databasepasswordhere'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N')"


and then run:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e "flush privileges;"
(Note:_ The Y's and N's above indicate permissions)


But this is on a certain db,
i want this for all the dbs.

 

[MaRiOs]

Ok I just saw this post :


use mysql;
UPDATE db SET Host='%' WHERE Db="YOURDBNAME";
UPDATE user SET Host='%' WHERE User="YOURUSER";
FLUSH PRIVILEGES

This will then open your server to external connections for that particular database.

But i want to do it for all databases,how can I do that ?

 

[DjFarout]

you have to create a user for non local permissions....

ie
CREATE USER 'john'@'%' IDENTIFIED BY 'doe';

you need to create one of these for every user that wants to access their db out side your machine.

 

[MaRiOs]

thank you! It works fine!