I cannot start MySQL Server from command line on windows
Whenever I write the command "C: \ Program Files \ MySQL \ MySQL Server 5.0 \ bin \ mysqld" the command line comes back with something like this:
C:\>"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld"
141110 3:12:58 [Warning] Unable to create test file C: \ Program Files \ MySQL \ MySQL Server 5.5 \ data \ Dutta.lower-test
141110 3:12:58 [Warning] Unable to 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: InnoDB memory heap is disabled
141110 3:12:58 InnoDB: Mutexes and rw_locks use Windows locking 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: Buffer pool initialization completed
141110 3:12:58 InnoDB: Operating system error number 5 in a file operation.
InnoDB: error means mysqld does not have permission to access InnoDB: directory. You may have created an
InnoDB: subdirectory with the same name as the data file.
InnoDB: filename. \ Ibdata1
InnoDB: call file operation: "create".
InnoDB: Unable to continue.
I'm just a beginner. Maybe a stupid mistake. Sorry in advance!
source to share
The context and privileges of the current user will be affected when you manually launch the executable in this way.
You also need to make sure:
- The current user has the correct permissions for all required files and directories.
- You are raising command line permissions to run as administrator
If you have MySQL service installed, you can also use net start MySQL
.
This MySQL man page contains useful information for installing and running MySQL server on windows.
Remember that after you "start" the MySQL service (or service), you will not actually see anything, you will need to use the MySQL client application to connect to the server and communicate.
source to share