Advertisement
Guest User

Untitled

a guest
Oct 20th, 2014
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.78 KB | None | 0 0
  1. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
  2.  
  3. user = mysql
  4. pid-file = /var/run/mysqld/mysqld.pid
  5. socket = /var/run/mysqld/mysqld.sock
  6. port = 3306
  7. basedir = /usr
  8. datadir = /media/db2/mysql
  9. tmpdir = /tmp
  10. lc-messages-dir = /usr/share/mysql
  11. skip-external-locking
  12.  
  13. # /var/lib/mysql/ r,
  14. # /var/lib/mysql/** rwk,
  15. /media/db2/mysql/ r,
  16. /media/db2/mysql/** rwk,
  17.  
  18. sudo service mysql restart
  19.  
  20. mysql -u root -p
  21.  
  22. 130125 12:35:41 InnoDB: Waiting for the background threads to start
  23. 130125 12:35:42 InnoDB: 1.1.8 started; log sequence number 1595675
  24. 130125 12:35:42 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
  25. 130125 12:35:42 [Note] - '127.0.0.1' resolves to '127.0.0.1';
  26. 130125 12:35:42 [Note] Server socket created on IP: '127.0.0.1'.
  27. 130125 12:35:42 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
  28. 130125 12:35:42 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
  29. 130125 12:35:43 [Note] Plugin 'FEDERATED' is disabled.
  30. /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
  31. 130125 12:35:43 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  32. 130125 12:35:43 InnoDB: The InnoDB memory heap is disabled
  33. 130125 12:35:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  34. 130125 12:35:43 InnoDB: Compressed tables use zlib 1.2.7
  35. 130125 12:35:43 InnoDB: Using Linux native AIO
  36. 130125 12:35:43 InnoDB: Initializing buffer pool, size = 128.0M
  37. 130125 12:35:43 InnoDB: Completed initialization of buffer pool
  38. 130125 12:35:43 InnoDB: highest supported file format is Barracuda.
  39. InnoDB: Log scan progressed past the checkpoint lsn 49439
  40. 130125 12:35:43 InnoDB: Database was not shut down normally!
  41. InnoDB: Starting crash recovery.
  42. InnoDB: Reading tablespace information from the .ibd files...
  43. InnoDB: Restoring possible half-written data pages from the doublewrite
  44. InnoDB: buffer...
  45. InnoDB: Doing recovery: scanned up to log sequence number 1595675
  46. 130125 12:35:45 InnoDB: Starting an apply batch of log records to the database...
  47. InnoDB: Progress in percents: 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
  48. InnoDB: Apply batch completed
  49.  
  50. $ ls /media/db2/mysql -al
  51. total 28732
  52. drwxrwxrwx 3 mysql root 4096 Jan 25 12:39 .
  53. drwxr-xr-x 4 root root 4096 Jan 25 2013 ..
  54. -rw-rw---- 1 mysql mysql 18874368 Jan 25 2013 ibdata1
  55. -rw-rw---- 1 mysql mysql 5242880 Jan 25 12:39 ib_logfile0
  56. -rw-rw---- 1 mysql mysql 5242880 Jan 25 2013 ib_logfile1
  57. drwx------ 2 root root 4096 Jan 25 2013 mysql
  58.  
  59. sudo chown mysql:mysql /mysql/data/dir
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement