Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 30th, 2012  |  syntax: None  |  size: 11.33 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Last login: Wed Mar 16 23:45:09 on console
  2. Bens-MacBook:~ Ben$ mysql
  3. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  4. Bens-MacBook:~ Ben$ sql
  5. -bash: sql: command not found
  6. Bens-MacBook:~ Ben$ mysql
  7. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  8. Bens-MacBook:~ Ben$ /etc/init.d/mysqld start
  9. -bash: /etc/init.d/mysqld: No such file or directory
  10. Bens-MacBook:~ Ben$ telnet localhost 3306
  11. Trying ::1...
  12. telnet: connect to address ::1: Connection refused
  13. Trying fe80::1...
  14. telnet: connect to address fe80::1: Connection refused
  15. Trying 127.0.0.1...
  16. telnet: connect to address 127.0.0.1: Connection refused
  17. telnet: Unable to connect to remote host
  18. Bens-MacBook:~ Ben$ mysql -h 127.0.0.1 -u root -p
  19. Enter password:
  20. ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
  21. Bens-MacBook:~ Ben$ mysql
  22. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  23. Bens-MacBook:~ Ben$ sudo chown root /Library/LaunchDaemons/com.mysql.mysqld.plist
  24. Password:
  25. Bens-MacBook:~ Ben$
  26. Bens-MacBook:~ Ben$ mysql
  27. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  28. Bens-MacBook:~ Ben$ clear
  29.  
  30. Bens-MacBook:~ Ben$ mysql
  31. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  32. Bens-MacBook:~ Ben$ mysql -u root -p
  33. Enter password:
  34. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  35. Bens-MacBook:~ Ben$ mysql -u root -p
  36. Enter password:
  37. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  38. Bens-MacBook:~ Ben$ mysql -u root -p
  39. Enter password:
  40. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  41. Bens-MacBook:~ Ben$ mysqld
  42. 110317 17:22:04 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-file' instead.
  43. 110317 17:22:04 [ERROR] Can't find messagefile '/share/mysql/english/errmsg.sys'
  44. 110317 17:22:04 [Warning] Setting lower_case_table_names=2 because file system for /var/db/mysql/ is case insensitive
  45. 110317 17:22:04 [Warning] One can only use the --user switch if running as root
  46.  
  47. 110317 17:22:04 [Note] Plugin 'FEDERATED' is disabled.
  48. 110317 17:22:04 [Note] Plugin 'InnoDB' is disabled.
  49. mysqld: Unknown error 1146
  50. 110317 17:22:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  51. 110317 17:22:04 [ERROR] mysqld: unknown option '--skip-locking'
  52. 110317 17:22:04 [ERROR] Aborting
  53.  
  54. 110317 17:22:04 [Note]
  55. Bens-MacBook:~ Ben$ mysqld --skip-locking
  56. 110317 17:22:48 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-file' instead.
  57. 110317 17:22:48 [ERROR] Can't find messagefile '/share/mysql/english/errmsg.sys'
  58. 110317 17:22:48 [Warning] Setting lower_case_table_names=2 because file system for /var/db/mysql/ is case insensitive
  59. 110317 17:22:48 [Warning] One can only use the --user switch if running as root
  60.  
  61. 110317 17:22:48 [Note] Plugin 'FEDERATED' is disabled.
  62. 110317 17:22:48 [Note] Plugin 'InnoDB' is disabled.
  63. mysqld: Unknown error 1146
  64. 110317 17:22:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  65. 110317 17:22:48 [ERROR] mysqld: unknown option '--skip-locking'
  66. 110317 17:22:48 [ERROR] Aborting
  67.  
  68. 110317 17:22:48 [Note]
  69. Bens-MacBook:~ Ben$ mysql_upgrade
  70. Looking for 'mysql' as: mysql
  71. Looking for 'mysqlcheck' as: mysqlcheck
  72. Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
  73. mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
  74. FATAL ERROR: Upgrade failed
  75. Bens-MacBook:~ Ben$ /usr/local/mysql/bin/mysql -u root -p
  76. Enter password:
  77. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  78. Bens-MacBook:~ Ben$ mysqld start
  79. 110317 17:24:33 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-file' instead.
  80. 110317 17:24:33 [ERROR] Can't find messagefile '/share/mysql/english/errmsg.sys'
  81. 110317 17:24:33 [Warning] Setting lower_case_table_names=2 because file system for /var/db/mysql/ is case insensitive
  82. 110317 17:24:33 [Warning] One can only use the --user switch if running as root
  83.  
  84. 110317 17:24:33 [Note] Plugin 'FEDERATED' is disabled.
  85. 110317 17:24:33 [Note] Plugin 'InnoDB' is disabled.
  86. mysqld: Unknown error 1146
  87. 110317 17:24:33 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  88. 110317 17:24:33 [ERROR] mysqld: unknown option '--skip-locking'
  89. 110317 17:24:33 [ERROR] Aborting
  90.  
  91. 110317 17:24:33 [Note]
  92. Bens-MacBook:~ Ben$ cd /etc/init.d
  93. -bash: cd: /etc/init.d: No such file or directory
  94. Bens-MacBook:~ Ben$
  95. Bens-MacBook:~ Ben$ mysql --user=username --password=password
  96. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  97. Bens-MacBook:~ Ben$ shell> ./mysqld --basedir=/usr/local --verbose --help
  98. -bash: shell: command not found
  99. Bens-MacBook:~ Ben$ ./mysqld --basedir=/usr/local --verbose --help
  100. -bash: ./mysqld: Permission denied
  101. Bens-MacBook:~ Ben$ sudo ./mysqld --basedir=/usr/local --verbose --help
  102. Password:
  103. sudo: ./mysqld: command not found
  104. Bens-MacBook:~ Ben$ cd /usr/local/mysql
  105. Bens-MacBook:mysql Ben$ ./bin/mysql_safe --user=mysql &
  106. [1] 9152
  107. Bens-MacBook:mysql Ben$ -bash: ./bin/mysql_safe: No such file or directory
  108. ./bin/mysql_safe --user=mysql &
  109. [2] 10677
  110. [1]   Exit 127                ./bin/mysql_safe --user=mysql
  111. Bens-MacBook:mysql Ben$ -bash: ./bin/mysql_safe: No such file or directory
  112.  
  113. [2]+  Exit 127                ./bin/mysql_safe --user=mysql
  114. Bens-MacBook:mysql Ben$
  115. Bens-MacBook:mysql Ben$
  116. Bens-MacBook:mysql Ben$ mysql
  117. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  118. Bens-MacBook:mysql Ben$ clear
  119.  
  120. Bens-MacBook:mysql Ben$ mysqld_safe
  121. 110317 17:32:46 mysqld_safe Logging to '/var/db/mysql/Bens-MacBook.local.err'.
  122. 110317 17:32:46 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
  123. /usr/local/mysql/bin/mysqld_safe: line 107: /var/db/mysql/Bens-MacBook.local.err: Permission denied
  124. /usr/local/mysql/bin/mysqld_safe: line 144: /var/db/mysql/Bens-MacBook.local.err: Permission denied
  125. 110317 17:32:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  126. /usr/local/mysql/bin/mysqld_safe: line 107: /var/db/mysql/Bens-MacBook.local.err: Permission denied
  127. Bens-MacBook:mysql Ben$ sudo mysqld_safe
  128. Password:
  129. Sorry, try again.
  130. Password:
  131. 110317 17:34:48 mysqld_safe Logging to '/var/db/mysql/Bens-MacBook.local.err'.
  132. 110317 17:34:48 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
  133. 110317 17:34:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  134. Bens-MacBook:mysql Ben$ cd /usr/local/mysql
  135. Bens-MacBook:mysql Ben$ sudo chown -R mysql data
  136. Bens-MacBook:mysql Ben$ sudo chgrp -R mysql data
  137. Bens-MacBook:mysql Ben$ sudo scripts/mysql_install_db --user=mysql
  138. Installing MySQL system tables...
  139. 110317 17:36:08 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-file' instead.
  140. 110317 17:36:08 [ERROR] Can't find messagefile '/share/mysql/english/errmsg.sys'
  141. 110317 17:36:08 [ERROR] ./bin/mysqld: unknown option '--skip-locking'
  142. 110317 17:36:08 [ERROR] Aborting
  143.  
  144. 110317 17:36:08 [Note]
  145.  
  146. Installation of system tables failed!  Examine the logs in
  147. /var/db/mysql for more information.
  148.  
  149. You can try to start the mysqld daemon with:
  150.  
  151.     shell> ./bin/mysqld --skip-grant &
  152.  
  153. and use the command line tool ./bin/mysql
  154. to connect to the mysql database and look at the grant tables:
  155.  
  156.     shell> ./bin/mysql -u root mysql
  157.     mysql> show tables
  158.  
  159. Try 'mysqld --help' if you have problems with paths.  Using --log
  160. gives you a log in /var/db/mysql that may be helpful.
  161.  
  162. Please consult the MySQL manual section
  163. 'Problems running mysql_install_db', and the manual section that
  164. describes problems on your OS.  Another information source are the
  165. MySQL email archives available at http://lists.mysql.com/.
  166.  
  167. Please check all of the above before mailing us!  And remember, if
  168. you do mail us, you MUST use the ./bin/mysqlbug script!
  169.  
  170. Bens-MacBook:mysql Ben$ /bin/mysqld --skip-grant &
  171. [1] 22447
  172. Bens-MacBook:mysql Ben$ -bash: /bin/mysqld: No such file or directory
  173.  
  174. [1]+  Exit 127                /bin/mysqld --skip-grant
  175. Bens-MacBook:mysql Ben$ sudo chown -R mysql data
  176. Bens-MacBook:mysql Ben$ sudo chgrp -R mysql data
  177. Bens-MacBook:mysql Ben$ sudo scripts/mysql_install_db --user=mysql
  178. Installing MySQL system tables...
  179. 110317 17:37:21 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-file' instead.
  180. 110317 17:37:21 [ERROR] Can't find messagefile '/share/mysql/english/errmsg.sys'
  181. 110317 17:37:21 [ERROR] ./bin/mysqld: unknown option '--skip-locking'
  182. 110317 17:37:21 [ERROR] Aborting
  183.  
  184. 110317 17:37:21 [Note]
  185.  
  186. Installation of system tables failed!  Examine the logs in
  187. /var/db/mysql for more information.
  188.  
  189. You can try to start the mysqld daemon with:
  190.  
  191.     shell> ./bin/mysqld --skip-grant &
  192.  
  193. and use the command line tool ./bin/mysql
  194. to connect to the mysql database and look at the grant tables:
  195.  
  196.     shell> ./bin/mysql -u root mysql
  197.     mysql> show tables
  198.  
  199. Try 'mysqld --help' if you have problems with paths.  Using --log
  200. gives you a log in /var/db/mysql that may be helpful.
  201.  
  202. Please consult the MySQL manual section
  203. 'Problems running mysql_install_db', and the manual section that
  204. describes problems on your OS.  Another information source are the
  205. MySQL email archives available at http://lists.mysql.com/.
  206.  
  207. Please check all of the above before mailing us!  And remember, if
  208. you do mail us, you MUST use the ./bin/mysqlbug script!
  209.  
  210. Bens-MacBook:mysql Ben$
  211. Bens-MacBook:mysql Ben$
  212. Bens-MacBook:mysql Ben$
  213. Bens-MacBook:mysql Ben$ clear
  214.  
  215. Bens-MacBook:mysql Ben$ sudo scripts/mysql_install_db --user=mysql
  216. Installing MySQL system tables...
  217. 110317 17:37:33 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-file' instead.
  218. 110317 17:37:33 [ERROR] Can't find messagefile '/share/mysql/english/errmsg.sys'
  219. 110317 17:37:33 [ERROR] ./bin/mysqld: unknown option '--skip-locking'
  220. 110317 17:37:33 [ERROR] Aborting
  221.  
  222. 110317 17:37:33 [Note]
  223.  
  224. Installation of system tables failed!  Examine the logs in
  225. /var/db/mysql for more information.
  226.  
  227. You can try to start the mysqld daemon with:
  228.  
  229.     shell> ./bin/mysqld --skip-grant &
  230.  
  231. and use the command line tool ./bin/mysql
  232. to connect to the mysql database and look at the grant tables:
  233.  
  234.     shell> ./bin/mysql -u root mysql
  235.     mysql> show tables
  236.  
  237. Try 'mysqld --help' if you have problems with paths.  Using --log
  238. gives you a log in /var/db/mysql that may be helpful.
  239.  
  240. Please consult the MySQL manual section
  241. 'Problems running mysql_install_db', and the manual section that
  242. describes problems on your OS.  Another information source are the
  243. MySQL email archives available at http://lists.mysql.com/.
  244.  
  245. Please check all of the above before mailing us!  And remember, if
  246. you do mail us, you MUST use the ./bin/mysqlbug script!
  247.  
  248. Bens-MacBook:mysql Ben$
create a new version of this paste RAW Paste Data