Advertisement
Guest User

Untitled

a guest
Mar 5th, 2015
239
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.15 KB | None | 0 0
  1. [nlundsten@localhost lib]$ sudo rm /var/lib/mysql
  2. [sudo] password for nlundsten:
  3. rm: cannot remove ‘/var/lib/mysql’: Is a directory
  4. [nlundsten@localhost lib]$ sudo rm /var/lib/mysql -rf
  5. [nlundsten@localhost lib]$ sudo mysql_install_db --user mysql --datadir /var/lib/mysql
  6. Installing MySQL system tables...2015-03-04 22:24:34 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  7. 2015-03-04 22:24:34 25658 [Note] InnoDB: Using atomics to ref count buffer pool pages
  8. 2015-03-04 22:24:34 25658 [Note] InnoDB: The InnoDB memory heap is disabled
  9. 2015-03-04 22:24:34 25658 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  10. 2015-03-04 22:24:34 25658 [Note] InnoDB: Memory barrier is not used
  11. 2015-03-04 22:24:34 25658 [Note] InnoDB: Compressed tables use zlib 1.2.3
  12. 2015-03-04 22:24:34 25658 [Note] InnoDB: Using Linux native AIO
  13. 2015-03-04 22:24:34 25658 [Note] InnoDB: Using CPU crc32 instructions
  14. 2015-03-04 22:24:34 25658 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  15. 2015-03-04 22:24:34 25658 [Note] InnoDB: Completed initialization of buffer pool
  16. 2015-03-04 22:24:34 25658 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
  17. 2015-03-04 22:24:34 25658 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
  18. 2015-03-04 22:24:34 25658 [Note] InnoDB: Database physically writes the file full: wait...
  19. 2015-03-04 22:24:34 25658 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
  20. 2015-03-04 22:24:34 25658 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
  21. 2015-03-04 22:24:35 25658 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
  22. 2015-03-04 22:24:35 25658 [Warning] InnoDB: New log files created, LSN=45781
  23. 2015-03-04 22:24:35 25658 [Note] InnoDB: Doublewrite buffer not found: creating new
  24. 2015-03-04 22:24:35 25658 [Note] InnoDB: Doublewrite buffer created
  25. 2015-03-04 22:24:35 25658 [Note] InnoDB: 128 rollback segment(s) are active.
  26. 2015-03-04 22:24:35 25658 [Warning] InnoDB: Creating foreign key constraint system tables.
  27. 2015-03-04 22:24:35 25658 [Note] InnoDB: Foreign key constraint system tables created
  28. 2015-03-04 22:24:35 25658 [Note] InnoDB: Creating tablespace and datafile system tables.
  29. 2015-03-04 22:24:35 25658 [Note] InnoDB: Tablespace and datafile system tables created.
  30. 2015-03-04 22:24:35 25658 [Note] InnoDB: Waiting for purge to start
  31. 2015-03-04 22:24:35 25658 [Note] InnoDB: 5.6.23 started; log sequence number 0
  32. 2015-03-04 22:24:35 25658 [Note] Binlog end
  33. 2015-03-04 22:24:35 25658 [Note] InnoDB: FTS optimize thread exiting.
  34. 2015-03-04 22:24:35 25658 [Note] InnoDB: Starting shutdown...
  35. 2015-03-04 22:24:36 25658 [Note] InnoDB: Shutdown completed; log sequence number 1625977
  36. OK
  37.  
  38. Filling help tables...2015-03-04 22:24:37 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  39. 2015-03-04 22:24:37 25686 [Note] InnoDB: Using atomics to ref count buffer pool pages
  40. 2015-03-04 22:24:37 25686 [Note] InnoDB: The InnoDB memory heap is disabled
  41. 2015-03-04 22:24:37 25686 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  42. 2015-03-04 22:24:37 25686 [Note] InnoDB: Memory barrier is not used
  43. 2015-03-04 22:24:37 25686 [Note] InnoDB: Compressed tables use zlib 1.2.3
  44. 2015-03-04 22:24:37 25686 [Note] InnoDB: Using Linux native AIO
  45. 2015-03-04 22:24:37 25686 [Note] InnoDB: Using CPU crc32 instructions
  46. 2015-03-04 22:24:37 25686 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  47. 2015-03-04 22:24:37 25686 [Note] InnoDB: Completed initialization of buffer pool
  48. 2015-03-04 22:24:37 25686 [Note] InnoDB: Highest supported file format is Barracuda.
  49. 2015-03-04 22:24:37 25686 [Note] InnoDB: 128 rollback segment(s) are active.
  50. 2015-03-04 22:24:37 25686 [Note] InnoDB: Waiting for purge to start
  51. 2015-03-04 22:24:37 25686 [Note] InnoDB: 5.6.23 started; log sequence number 1625977
  52. 2015-03-04 22:24:37 25686 [Note] Binlog end
  53. 2015-03-04 22:24:37 25686 [Note] InnoDB: FTS optimize thread exiting.
  54. 2015-03-04 22:24:37 25686 [Note] InnoDB: Starting shutdown...
  55. 2015-03-04 22:24:38 25686 [Note] InnoDB: Shutdown completed; log sequence number 1625987
  56. OK
  57.  
  58. To start mysqld at boot time you have to copy
  59. support-files/mysql.server to the right place for your system
  60.  
  61. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
  62. To do so, start the server, then issue the following commands:
  63.  
  64. /usr/bin/mysqladmin -u root password 'new-password'
  65. /usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
  66.  
  67. Alternatively you can run:
  68.  
  69. /usr/bin/mysql_secure_installation
  70.  
  71. which will also give you the option of removing the test
  72. databases and anonymous user created by default. This is
  73. strongly recommended for production servers.
  74.  
  75. See the manual for more instructions.
  76.  
  77. You can start the MySQL daemon with:
  78.  
  79. cd /usr ; /usr/bin/mysqld_safe &
  80.  
  81. You can test the MySQL daemon with mysql-test-run.pl
  82.  
  83. cd mysql-test ; perl mysql-test-run.pl
  84.  
  85. Please report any problems at http://bugs.mysql.com/
  86.  
  87. The latest information about MySQL is available on the web at
  88.  
  89. http://www.mysql.com
  90.  
  91. Support MySQL by buying support/licenses at http://shop.mysql.com
  92.  
  93. WARNING: Found existing config file /usr/my.cnf on the system.
  94. Because this file might be in use, it was not replaced,
  95. but was used in bootstrap (unless you used --defaults-file)
  96. and when you later start the server.
  97. The new default config file was created as /usr/my-new.cnf,
  98. please compare it with your file and take the changes you need.
  99.  
  100. WARNING: Default config file /etc/my.cnf exists on the system
  101. This file will be read by default by the MySQL server
  102. If you do not want to use this, either remove it, or use the
  103. --defaults-file argument to mysqld_safe when starting the server
  104.  
  105. [nlundsten@localhost lib]$ sudo service mysql start
  106. Redirecting to /bin/systemctl start mysql.service
  107. ^C[nlundsten@localhost lib]$ sudo service mysql status
  108. Redirecting to /bin/systemctl status mysql.service
  109. ● mysqld.service - MySQL Community Server
  110. Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
  111. Active: activating (start-post) since Wed 2015-03-04 22:22:47 PST; 2min 14s ago
  112. Process: 25084 ExecStart=/usr/bin/mysqld_safe (code=exited, status=0/SUCCESS)
  113. Process: 25073 ExecStartPre=/usr/bin/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
  114. Main PID: 25084 (code=exited, status=0/SUCCESS); : 25085 (mysql-systemd-s)
  115. CGroup: /system.slice/mysqld.service
  116. └─control
  117. ├─25085 /bin/bash /usr/bin/mysql-systemd-start post
  118. └─25803 sleep 1
  119.  
  120. Mar 04 22:22:47 localhost.localdomain mysqld_safe[25084]: 150304 22:22:47 mysqld_safe Logging to '/var/log/mysqld.log'.
  121. Mar 04 22:22:47 localhost.localdomain mysqld_safe[25084]: 150304 22:22:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  122. Mar 04 22:22:48 localhost.localdomain mysqld_safe[25084]: 150304 22:22:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  123. [nlundsten@localhost lib]$ sudo tail -n50 /var/log/mysqld.log
  124. Warning: World-writable config file './auto.cnf' is ignored
  125. 2015-03-04 22:12:48 22982 [Warning] World-writable config file './auto.cnf' has been removed.
  126.  
  127. 2015-03-04 22:12:48 22982 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a5641d07-c2fe-11e4-bfb7-80193456190e.
  128. 2015-03-04 22:12:48 22982 [Note] Server hostname (bind-address): '*'; port: 3306
  129. 2015-03-04 22:12:48 22982 [Note] IPv6 is available.
  130. 2015-03-04 22:12:48 22982 [Note] - '::' resolves to '::';
  131. 2015-03-04 22:12:48 22982 [Note] Server socket created on IP: '::'.
  132. 2015-03-04 22:12:48 22982 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'user'
  133. 150304 22:12:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  134. 150304 22:22:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  135. 2015-03-04 22:22:48 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  136. 2015-03-04 22:22:48 25258 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
  137.  
  138. 2015-03-04 22:22:48 25258 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)
  139.  
  140. 2015-03-04 22:22:48 25258 [Note] Plugin 'FEDERATED' is disabled.
  141. /usr/sbin/mysqld: Incorrect file format 'plugin'
  142. 2015-03-04 22:22:48 25258 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  143. 2015-03-04 22:22:48 25258 [Note] InnoDB: Using atomics to ref count buffer pool pages
  144. 2015-03-04 22:22:48 25258 [Note] InnoDB: The InnoDB memory heap is disabled
  145. 2015-03-04 22:22:48 25258 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  146. 2015-03-04 22:22:48 25258 [Note] InnoDB: Memory barrier is not used
  147. 2015-03-04 22:22:48 25258 [Note] InnoDB: Compressed tables use zlib 1.2.3
  148. 2015-03-04 22:22:48 25258 [Note] InnoDB: Using Linux native AIO
  149. 2015-03-04 22:22:48 25258 [Note] InnoDB: Using CPU crc32 instructions
  150. 2015-03-04 22:22:48 25258 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  151. 2015-03-04 22:22:48 25258 [Note] InnoDB: Completed initialization of buffer pool
  152. 2015-03-04 22:22:48 25258 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
  153. 2015-03-04 22:22:48 25258 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
  154. 2015-03-04 22:22:48 25258 [Note] InnoDB: Database physically writes the file full: wait...
  155. 2015-03-04 22:22:48 25258 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
  156. 2015-03-04 22:22:48 25258 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
  157. 2015-03-04 22:22:48 25258 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
  158. 2015-03-04 22:22:48 25258 [Warning] InnoDB: New log files created, LSN=45781
  159. 2015-03-04 22:22:48 25258 [Note] InnoDB: Doublewrite buffer not found: creating new
  160. 2015-03-04 22:22:48 25258 [Note] InnoDB: Doublewrite buffer created
  161. 2015-03-04 22:22:48 25258 [Note] InnoDB: 128 rollback segment(s) are active.
  162. 2015-03-04 22:22:48 25258 [Warning] InnoDB: Creating foreign key constraint system tables.
  163. 2015-03-04 22:22:48 25258 [Note] InnoDB: Foreign key constraint system tables created
  164. 2015-03-04 22:22:48 25258 [Note] InnoDB: Creating tablespace and datafile system tables.
  165. 2015-03-04 22:22:48 25258 [Note] InnoDB: Tablespace and datafile system tables created.
  166. 2015-03-04 22:22:48 25258 [Note] InnoDB: Waiting for purge to start
  167. 2015-03-04 22:22:48 25258 [Note] InnoDB: 5.6.23 started; log sequence number 0
  168. 2015-03-04 22:22:48 25258 [Note] Server hostname (bind-address): '*'; port: 3306
  169. 2015-03-04 22:22:48 25258 [Note] IPv6 is available.
  170. 2015-03-04 22:22:48 25258 [Note] - '::' resolves to '::';
  171. 2015-03-04 22:22:48 25258 [Note] Server socket created on IP: '::'.
  172. 2015-03-04 22:22:48 25258 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'user'
  173. 150304 22:22:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  174. [nlundsten@localhost lib]$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement