Public Pastes
daily pastebin goal
52%
SHARE
TWEET

Untitled

a guest Nov 28th, 2016 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
Top