Package: mysql-server<br><br>eth0: static: <a href="http://172.16.200.1/24">172.16.200.1/24</a><br> netmask 255.255.255.0<br> gateway 192.168.1.254<br>eth1: dhcp: <a href="http://192.168.176.137/24">192.168.176.137/24</a><br>
Hostname: debian<br><br>apt-get install dnsmasq<br> modify /etc/dnsmasq.conf uncomment local=/localnet/<br> modify /etc/resolv.conf: nameserver 172.16.200.1<br><br>/etc/hosts<br> 127.0.0.1 debian -> 172.16.200.1 debian<br>
ping debian<br>ping debian.localnet<br>dig debian.localnet<br>dig debian<br>ALL WORKS<br><br>apt-get install mysql-server #set mysql root password to 123<br>sed -i -e 's/<a href="http://127.0.0.1/0.0.0.0/">127.0.0.1/0.0.0.0/</a>' /etc/mysql/my.cnf<br>
service mysql restart<br>mysql -uroot -p123 <br> CREATE DATABASE keystone;<br> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' IDENTIFIED BY 'password';<br> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'172.16.200.%' IDENTIFIED BY 'password';<br>
FLUSH PRIVILEGES;<br> user mysql;<br> select * from user where User='keystone';<br>+--------------+----------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+<br>
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string |<br>
+--------------+----------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+<br>
| localhost | keystone | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | | NULL |<br>
| 172.16.200.% | keystone | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | | NULL |<br>
+--------------+----------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+<br>
2 rows in set (0.00 sec)<br><br><br><br>mysql -ukeystone -ppassword<br>mysql> <br>mysql -ukeystone -ppassword -hdebian<br>ERROR 1045 (28000): Access denied for user 'keystone'@'debian' (using password: YES)<br>
mysql -ukeystone -ppassword -h172.16.200.1<br>ERROR 1045 (28000): Access denied for user 'keystone'@'debian' (using password: YES) <br>mysql -ukeystone -ppassword -hdebian.localnet<br>ERROR 1045 (28000): Access denied for user 'keystone'@'debian' (using password: YES)<br>
<br>$ dig debian<br>; <<>> DiG 9.8.1-P1 <<>> debian<br>;; global options: +cmd<br>;; Got answer:<br>;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 10416<br>;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0<br>
<br>;; QUESTION SECTION:<br>;debian. IN A<br><br>;; ANSWER SECTION:<br>debian. 0 IN A 172.16.200.1<br><br>;; Query time: 4 msec<br>;; SERVER: 172.16.200.1#53(172.16.200.1)<br>;; WHEN: Mon Dec 3 23:58:44 2012<br>
;; MSG SIZE rcvd: 40<br><br>$ host debian<br>debian has address 172.16.200.1<br>Host debian not found: 5(REFUSED)<br>Host debian not found: 5(REFUSED)<br><br>$nsloopup<br><br><br>wordaround:<br>1. add 'skip-name-resolve' to <a href="http://my.cf">my.cf</a><br>
2. add '172.16.200.1 debian.localnet' to hosts and must be put before '172.16.200.1 debian'<br clear="all"><br>-- <br>YunQiang Su <br>