Can't create a user on MySQL?

Asked Oct 31 '15 at 04:27

Active Nov 01 '15 at 02:00

Viewed 48 times

I am typing the following into the command prompt:

GRANT ALL ON publications.* TO 'jim'@'localhost'
IDENTIFIED BY 'mypasswd';

I keep getting

ERROR 126: Incorrect key file for table. .\mysql\dbi.MYI': try to repair it.

How do I repair dbi.MYI? I read somewhere that my tmp folder might be too small? If that's the case how do I increase the size?

edited Nov 01 '15 at 02:00

jpmc26

asked Oct 31 '15 at 04:27

123undo

Have you tried running repair table? [REPAIR TABLE](https://dev.mysql.com/doc/refman/5.7/en/repair-table.html) – JRD Oct 31 '15 at 04:31
I tried REPAIR TABLE db.myi, and it said '"db.myi' doesn't exist. – 123undo Oct 31 '15 at 04:37
1

Possible duplicate of [MySQL: #126 - Incorrect key file for table](http://stackoverflow.com/questions/2011050/mysql-126-incorrect-key-file-for-table) – e4c5 Oct 31 '15 at 04:39
You ran `repair table db;`? – JRD Oct 31 '15 at 04:47
Just tried that, and I got 'publications.db' doesn't exist. – 123undo Oct 31 '15 at 04:56
You may need to log in as root and then `use mysql;` first. – JRD Oct 31 '15 at 06:20
Still not working =( – 123undo Oct 31 '15 at 14:01

0 Answers0