Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

I can not start the MySQL Server from command line in windows

Tags:

mysql

Whenever I write the command "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" the command prompt hits back with something like this:

C:\>"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld"

141110 3:12:58 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.5\data\Dutta.lower-test
141110 3:12:58 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.5\data\Dutta.lower-test
141110 3:12:58 [Note] Plugin 'FEDERATED' is disabled.
141110 3:12:58 InnoDB: The InnoDB memory heap is disabled
141110 3:12:58 InnoDB: Mutexes and rw_locks use Windows interlocked functions
141110 3:12:58 InnoDB: Compressed tables use zlib 1.2.3
141110 3:12:58 InnoDB: Initializing buffer pool, size = 128.0M
141110 3:12:58 InnoDB: Completed initialization of buffer pool
141110 3:12:58 InnoDB: Operating system error number 5 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.

I'm just a beginner. May be a silly mistake. Sorry in advance !!

like image 736
Plabon Dutta Avatar asked Nov 09 '14 21:11

Plabon Dutta


1 Answers

I think I got it. I had the exact same problem and actually ended up uninstalling and reinstalling a couple of times; until...

start> CMD> c:\Program Files\MySQL Server 5.7\bin> mysql -u root -p

Hope its as simple for u too. I kinda laughed when I noticed.

like image 197
borregs Avatar answered Sep 20 '22 01:09

borregs