SHARE
TWEET

Untitled

a guest May 22nd, 2017 529 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # If the root user has a password you have to create a
  2. # /root/.my.cnf configuration file with the following
  3. # content:
  4. #
  5. # [mysqladmin]
  6. # password = <secret>
  7. # user= root
  8. #
  9. # where "<secret>" is the password.
  10. #
  11. # ATTENTION: This /root/.my.cnf should be readable ONLY
  12. # for root !
  13.  
  14.  
  15. [root@db1.cm.tor.fmpub.net ~]# ll .my.cnf
  16. -r-------- 1 root root 74 Jan 27 04:07 .my.cnf
  17.  
  18. Contents of file.
  19.  
  20. [mysqladmin]
  21. password = STRIPPEDOUT
  22. user = root
  23.  
  24.  
  25. /etc/my.cnf
  26.  
  27. [mysqld]
  28. log_error
  29. log-bin=mysql-bin
  30. slow-query-log=1
  31. slow-query-log-file=db1.cm.tor-slow.log
  32. slow_launch_time=1
  33. long_query_time=2
  34. expire_logs_days = 3
  35.  
  36. [mysqld_safe]
  37. log-error=/var/lib/mysql/mysqld.log
  38. pid-file=/var/run/mysqld/mysqld.pid
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top