Advertisement
Guest User

Untitled

a guest
May 22nd, 2017
558
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.72 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement