Advertisement
Guest User

Untitled

a guest
Nov 28th, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. sudo lsof -Pni :3306
  2. COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
  3. mysqld 1646 mysql 19u IPv4 20618 0t0 TCP 127.0.0.1:3306 (LISTEN)
  4.  
  5.  
  6. /etc/mysql/mariadb.conf.d/99-openstack.conf
  7. [mysqld]
  8. bind-address = 10.0.0.11
  9.  
  10. default-storage-engine = innodb
  11. innodb_file_per_table
  12. max_connections = 4096
  13. collation-server = utf8_general_ci
  14. character-set-server = utf8
  15.  
  16. /etc/mysql/mariadb.conf.d/50-server.cnf
  17. [server]
  18.  
  19. # this is only for the mysqld standalone daemon
  20. [mysqld]
  21.  
  22. #
  23. # * Basic Settings
  24. #
  25. user = mysql
  26. pid-file = /var/run/mysqld/mysqld.pid
  27. socket = /var/run/mysqld/mysqld.sock
  28. port = 3306
  29. basedir = /usr
  30. datadir = /var/lib/mysql
  31. tmpdir = /tmp
  32. lc-messages-dir = /usr/share/mysql
  33. skip-external-locking
  34.  
  35. # Instead of skip-networking the default is now to listen only on
  36. # localhost which is more compatible and is not less secure.
  37. bind-address = 10.0.0.11
  38.  
  39. #
  40. # * Fine Tuning
  41. #
  42. key_buffer_size = 16M
  43. max_allowed_packet = 16M
  44. thread_stack = 192K
  45. ....
  46.  
  47. mysql -u keystone -p works
  48.  
  49. mysql -u keystone -p -h 10.0.0.11 does not work
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement