abiliazione user esterne a mysqlserver

7 views
Skip to first unread message

ugobale

unread,
Oct 5, 2012, 6:15:10 AM10/5/12
to mod-...@googlegroups.com
Ciao

Mi ricordo di un commando che abilitava con % tutte le user, che mi avevi suggerito ai tempi, ma nei miei appunti non lo trovo.
Penso sia possibile abilitare solo alcune user all’accesso di mysql server, ecco a che punto siamo :

ni253149,root,root # uname -a
Linux ni253149 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
ni253149,root,root # mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.1.61 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| itest              |
| mysql              |
| test               |
+--------------------+
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SELECT USER() ;
+----------------+
| USER()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'binlog_format';
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| binlog_format | STATEMENT |
+---------------+-----------+
1 row in set (0.00 sec)
ni253149,root,root # cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
bind-address=151.98.253.149


# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


per favore potresti aiutarmi ?

grazie
Ugo

Reply all
Reply to author
Forward
0 new messages