Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sudo lsof -Pni :3306
- COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
- mysqld 1646 mysql 19u IPv4 20618 0t0 TCP 127.0.0.1:3306 (LISTEN)
- /etc/mysql/mariadb.conf.d/99-openstack.conf
- [mysqld]
- bind-address = 10.0.0.11
- default-storage-engine = innodb
- innodb_file_per_table
- max_connections = 4096
- collation-server = utf8_general_ci
- character-set-server = utf8
- /etc/mysql/mariadb.conf.d/50-server.cnf
- [server]
- # this is only for the mysqld standalone daemon
- [mysqld]
- #
- # * Basic Settings
- #
- user = mysql
- pid-file = /var/run/mysqld/mysqld.pid
- socket = /var/run/mysqld/mysqld.sock
- port = 3306
- basedir = /usr
- datadir = /var/lib/mysql
- tmpdir = /tmp
- lc-messages-dir = /usr/share/mysql
- skip-external-locking
- # Instead of skip-networking the default is now to listen only on
- # localhost which is more compatible and is not less secure.
- bind-address = 10.0.0.11
- #
- # * Fine Tuning
- #
- key_buffer_size = 16M
- max_allowed_packet = 16M
- thread_stack = 192K
- ....
- mysql -u keystone -p works
- mysql -u keystone -p -h 10.0.0.11 does not work
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement