Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist



Threaded Mode | Print  

 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist, Please help! (0 Replies, Read 10722 times)
shayne
Group: Member
Post Group: Newbie
Posts: 1
Status:
Hey all,

I just recently installed Ampps onto my OSX machine. It worked perfectly the first time I set it up. My local site was great and no problems were found. However, when i stopped the servers and closed the program, and then later tried to reopen it; mySQL does not start. At all. It doesnt do anything. Amongst the error log, there was this:

[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist


I have no idea what to do. I have spent the last 4 hours looking online, and browsing this very forum and have found people with similar situations but nothing seems to be working on my end.

I am entirely new to this, so if you do have a suggestion, could you please try and explain it step by step?

Huge thank you to anyone who helps!!!

Shayne


FULL ERROR LOG:

2015-07-31 15:57:53 20941 [Warning] You need to use --log-bin to make --binlog-format work.
2015-07-31 15:57:53 20941 [Note] Plugin 'FEDERATED' is disabled.
/Applications/AMPPS/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
2015-07-31 15:57:53 20941 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-07-31 15:57:53 20941 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-07-31 15:57:53 20941 [Note] InnoDB: The InnoDB memory heap is disabled
2015-07-31 15:57:53 20941 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-07-31 15:57:53 20941 [Note] InnoDB: Memory barrier is not used
2015-07-31 15:57:53 20941 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-07-31 15:57:53 20941 [Note] InnoDB: Not using CPU crc32 instructions
2015-07-31 15:57:53 20941 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-07-31 15:57:53 20941 [Note] InnoDB: Completed initialization of buffer pool
2015-07-31 15:57:53 20941 [Note] InnoDB: Highest supported file format is Barracuda.
2015-07-31 15:57:53 20941 [Note] InnoDB: 128 rollback segment(s) are active.
2015-07-31 15:57:53 20941 [Note] InnoDB: Waiting for purge to start
2015-07-31 15:57:53 20941 [Note] InnoDB: 5.6.24 started; log sequence number 49180233
2015-07-31 15:57:53 20941 [Note] Server hostname (bind-address): '*'; port: 3306
2015-07-31 15:57:53 20941 [Note] IPv6 is available.
2015-07-31 15:57:53 20941 [Note]  - '::' resolves to '::';
2015-07-31 15:57:53 20941 [Note] Server socket created on IP: '::'.
2015-07-31 15:57:53 20941 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 28, 2024, 9:01 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.032