Mysql crashing

[BeHappy4Ever 386]

When i logged in in my game i got a crash in my mysql..

Here are the error logs:

http://pastebin.com/bK3Lf9tK

PS I can't login to my database i get "Uknown Error"

[MichaelM 51]

Try to reinstall mysql server.

[BeHappy4Ever 386]

5 hours ago, MichaelM said:

Try to reinstall mysql server.

This is the second time that i get the crashing betwwen these 4 days so i want to know what exactly is going on..Do you know?

Also thanks a lot for your reply!

[iltizio 286]

How did you install your database? With datafiles or with mysql import/export (dump or trasfer)?

With this error seems you have install your databases with copy and paste MySQL directory, that is the wrong way, specially if you have innodb tables like you. 

To recover:

- create dumps from the original MySQL server

- stop mysql-server on your broken server (service mysql-server stop)

- remove you entire MySQL data directory (rm -rf /var/db/mysql)

- start mysql-server on your broken server (service mysql-server start)

- restore your game databases from dumps.

[BeHappy4Ever 386]

On 11/7/2016 at 10:39 AM, iltizio said:

How did you install your database? With datafiles or with mysql import/export (dump or trasfer)?

With this error seems you have install your databases with copy and paste MySQL directory, that is the wrong way, specially if you have innodb tables like you. 

To recover:

- create dumps from the original MySQL server

- stop mysql-server on your broken server (service mysql-server stop)

- remove you entire MySQL data directory (rm -rf /var/db/mysql)

- start mysql-server on your broken server (service mysql-server start)

- restore your game databases from dumps.

Via package if  i remember good

I tried to put password with this method but i still cant connect via navicat

Spoiler

 

/usr/local/etc/rc.d/mysql-server stop

mysqld_safe --skip-grant-tables &

mysql -u root

use mysql

update user set password=PASSWORD('desiredpassword') where user='root';

flush privileges;

quit

service mysql-server restart

 

 

 

Can you help me to can connect via navicat?

also why had i this error?
 

[iltizio 286]

If you have mysql 5.7

CREATE USER 'root'@'%' IDENTIFIED BY 'yourpassword';
GRANT ALL ON *.* TO 'root'@'%' WITH GRANT OPTION;

flush privileges;

 

If you have mysql <5.7

GRANT ALL PRIVILEGES ON *.* TO root@"%"
IDENTIFIED BY 'yourpassword'
WITH GRANT OPTION;

flush privileges;