[[SOLVED] MySql доступ по сети]

права смотреть из терминала, локально?
или туту?

к какому порту коннектится? который в LISTEN находится?

server ~ # mysql_setpermission
Password for user  to connect to MySQL: 
******
######################################################################
## Welcome to the permission setter 1.4 for MySQL.
## made by Luuk de Boer
######################################################################
What would you like to do:
  1. Set password for an existing user.
  2. Create a database + user privilege for that database
     and host combination (user can only do SELECT)
  3. Create/append user privilege for an existing database
     and host combination (user can only do SELECT)
  4. Create/append broader user privileges for an existing
     database and host combination
     (user can do SELECT,INSERT,UPDATE,DELETE)
  5. Create/append quite extended user privileges for an
     existing database and host combination (user can do
     SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,
     LOCK TABLES,CREATE TEMPORARY TABLES)
  6. Create/append full privileges for an existing database
     and host combination (user has FULL privilege)
  7. Remove all privileges for for an existing database and
     host combination.
     (user will have all permission fields set to N)
  0. exit this program

Make your choice [1,2,3,4,5,6,7,0]: 6


Which database from existing databases would you like to select:
You can choose from:
  - information_schema
  - adsa
  - mailsql
  - mysql
Which database will it be (case sensitive). Type * for any:
*
OK, the user entry will NOT be limited to any database
What username is to be created: newuser
Username = newuser
Would you like to set a password for newuser [y/n]: y
What password do you want to specify for newuser:
Type the password again:
We now need to know from what host(s) the user will connect.
Keep in mind that % means 'from any host' ...
The host please: 192.168.1.4
Would you like to add another host [yes/no]: y
Okay, give us the host please: *
Would you like to add another host [yes/no]: n
Okay we keep it with this ...
The following host(s) will be used: 192.168.1.4,*.
######################################################################

That was it ... here is an overview of what you gave to me:
The database name       : *
The username            : newuser
The host(s)             : 192.168.1.4,*
######################################################################

Are you pretty sure you would like to implement this [yes/no]: y
Okay ... let's go then ...

Everything is inserted and mysql privileges have been reloaded.

ну и еще раз повтарюсь поставл bind-adress 192.168.1.1

в моем случае 192,168,1,1 - Гентоо
192,168,1,4 - Клиент который заходит через мускул клиент на гентоо используя созданный только что логин NEWUSER