Advertisement
Guest User

Untitled

a guest
Nov 10th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. [mysqld_multi]
  2. mysqld = /usr/bin/mysqld_safe
  3. mysqladmin = /usr/bin/mysqladmin
  4. user = multi_admin
  5. password = multipass
  6.  
  7. [mysqld1]
  8. user = mysql1
  9. pid-file = /var/run/mysqld/mysqld1.pid
  10. socket = /var/run/mysqld/mysqld1.sock
  11. port=3307
  12. datadir=/var/lib/mysqld1
  13. server_id=4
  14. log-bin=mysql-bin
  15. binlog_format=mixed
  16.  
  17. [mysqld2]
  18. user = mysql2
  19. pid-file = /var/run/mysqld/mysqld2.pid
  20. socket = /var/run/mysqld/mysqld2.sock
  21. port=3308
  22. datadir=/var/lib/mysqld2
  23. server_id=3
  24. skip-log-bin
  25.  
  26. Reporting MySQL servers
  27. MySQL server from group: mysqld1 is running
  28. MySQL server from group: mysqld2 is running
  29.  
  30. $ mysql -u root --socket=/var/run/mysqld/mysqld2.sock -p
  31. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement