Advertisement
Guest User

Untitled

a guest
Jan 15th, 2013
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.55 KB | None | 0 0
  1. root@helium:~# /usr/sbin/mysqld
  2. 130115 21:12:06 [Note] Plugin 'FEDERATED' is disabled.
  3. /usr/sbin/mysqld: Incorrect file format 'plugin'
  4. 130115 21:12:06 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  5. 130115 21:12:06 InnoDB: The InnoDB memory heap is disabled
  6. 130115 21:12:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  7. 130115 21:12:06 InnoDB: Compressed tables use zlib 1.2.3.4
  8. 130115 21:12:06 InnoDB: Initializing buffer pool, size = 128.0M
  9. 130115 21:12:06 InnoDB: Completed initialization of buffer pool
  10. 130115 21:12:06 InnoDB: highest supported file format is Barracuda.
  11. InnoDB: The log sequence number in ibdata files does not match
  12. InnoDB: the log sequence number in the ib_logfiles!
  13. 130115 21:12:06 InnoDB: Database was not shut down normally!
  14. InnoDB: Starting crash recovery.
  15. InnoDB: Reading tablespace information from the .ibd files...
  16. InnoDB: Restoring possible half-written data pages from the doublewrite
  17. InnoDB: buffer...
  18. 130115 21:12:06 InnoDB: Waiting for the background threads to start
  19. 130115 21:12:07 InnoDB: 1.1.8 started; log sequence number 1595685
  20. 130115 21:12:07 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  21. 130115 21:12:07 [Note] - '127.0.0.1' resolves to '127.0.0.1';
  22. 130115 21:12:07 [Note] Server socket created on IP: '127.0.0.1'.
  23. 130115 21:12:07 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host'
  24.  
  25. root@helium:~# /usr/sbin/mysqld --skip-grant-tables &
  26. [1] 2030
  27. root@helium:~# 130115 21:13:28 [Note] Plugin 'FEDERATED' is disabled.
  28. 130115 21:13:28 InnoDB: The InnoDB memory heap is disabled
  29. 130115 21:13:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  30. 130115 21:13:28 InnoDB: Compressed tables use zlib 1.2.3.4
  31. 130115 21:13:28 InnoDB: Initializing buffer pool, size = 128.0M
  32. 130115 21:13:28 InnoDB: Completed initialization of buffer pool
  33. 130115 21:13:28 InnoDB: highest supported file format is Barracuda.
  34. InnoDB: The log sequence number in ibdata files does not match
  35. InnoDB: the log sequence number in the ib_logfiles!
  36. 130115 21:13:28 InnoDB: Database was not shut down normally!
  37. InnoDB: Starting crash recovery.
  38. InnoDB: Reading tablespace information from the .ibd files...
  39. InnoDB: Restoring possible half-written data pages from the doublewrite
  40. InnoDB: buffer...
  41. 130115 21:13:28 InnoDB: Waiting for the background threads to start
  42. 130115 21:13:29 InnoDB: 1.1.8 started; log sequence number 1595685
  43. 130115 21:13:29 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  44. 130115 21:13:29 [Note] - '127.0.0.1' resolves to '127.0.0.1';
  45. 130115 21:13:29 [Note] Server socket created on IP: '127.0.0.1'.
  46. 130115 21:13:29 [Note] /usr/sbin/mysqld: ready for connections.
  47. Version: '5.5.28-0ubuntu0.12.04.3' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
  48.  
  49. root@helium:~# mysql -u root -p
  50. Enter password:
  51. Welcome to the MySQL monitor. Commands end with ; or \g.
  52. Your MySQL connection id is 1
  53. Server version: 5.5.28-0ubuntu0.12.04.3 (Ubuntu)
  54.  
  55. Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
  56.  
  57. Oracle is a registered trademark of Oracle Corporation and/or its
  58. affiliates. Other names may be trademarks of their respective
  59. owners.
  60.  
  61. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  62.  
  63. mysql> use mysql;
  64. Reading table information for completion of table and column names
  65. You can turn off this feature to get a quicker startup with -A
  66.  
  67. Database changed
  68. mysql> select User, Password, Host from user;
  69. ERROR 130 (HY000): Incorrect file format 'user'
  70. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement