I tried to start the newly installed MySQL server (V 5.5.15 on Windows Vista) using the mysqld command in the command prompt, but resulted the following error:
When I use mysqld command:
C:UsersPanora>mysqld
110914 16:23:02 [Warning] Can't create test file C:Program FilesMySQLMySQL Server 5.5dataPanora-PC.lower-test
110914 16:23:02 [Warning] Can't create test file C:Program FilesMySQLMySQL Server 5.5dataPanora-PC.lower-test
mysqld: File '.mysql-bin.index' not found (Errcode: 13)
110914 16:23:02 [ERROR] Aborting
110914 16:23:02 [Note] mysqld: Shutdown complete
C:UsersPanora>
When I use NET START command:
C:UsersPanora>NET START MySQL55
System error 5 has occurred.
Access is denied.
C:UsersPanora>
Additional notes:
(1) I’m able to start and stop the server using the MySQLWorkbench visual UI without any problems
(2) I’m able to stop the server using the command line without any problem using this command mysqladmin -u root -p shutdown
I’ve installed a MySQL server onto my computer and when I first installed it, it ran automatically. Now I’ve restarted my computer it is no longer running. What file do I need to run to get it back up and running again?
I’ve tried running MySQL 5.6 Command Line Client and mysqld.exe from the Program Files/MySQL/MySQLServer/bin directory, and I’ve had no luck.
Upon running mysqld.exe, I get the following error:
2013-10-28 18:52:12 4788 [ERROR] InnoDB: .ibdata1 can't be opened in read-write mode
2013-10-28 18:52:12 4788 [ERROR] InnoDB: The system tablespace must be writable!
2013-10-28 18:52:12 4788 [ERROR] Plugin 'InnoDB' init function returned error.
2013-10-28 18:52:12 4788 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2013-10-28 18:52:12 4788 [ERROR] Unknown/unsupported storage engine: InnoDB
2013-10-28 18:52:12 4788 [ERROR] Aborting`
Naturally, I tried running it as administrator, and I got this:
C:Windowssystem32>"C:Program FilesMySQLMySQL Server 5.6binmysqld.exe"
2013-10-28 19:24:30 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).
asked Oct 28, 2013 at 18:56
2
Make sure the mysqld.exe is ticked under the Startup tab when you go to run and type msconfig. Also, same goes for Services, look for the MySQL services there, right click > properties and make sure the startup types are selected as automatic.
answered Oct 28, 2013 at 19:02
RudolphRudolph
2,7023 gold badges26 silver badges31 bronze badges
4
If you installed MySQL using the MSI installer, it should be set up as a service.
You can open the service in two ways
METHOD #1: Access the Installed Service
- Open up the Services icon in the Control Panel
- Scroll alphabetically to the MySQL service
- Right click the service
- Click Start Service
METHOD #2: Command Line Execution
- Open DOS Window
- From the C: Prompt, run this:
net start mysqlor ‘net start mysql57’. The right name may vary on your system
If you get this error
C:Windowssystem32>net start mysql
System error 5 has occurred.
Access is denied.
C:Windowssystem32>
then you didn’t run the DOS Window as Administrator. Try again as administrator. You should see:
C:Windowssystem32>net start mysql
The MySQL service is starting..
The MySQL service was started successfully.
C:Windowssystem32>
Give it a try!!!
answered Oct 28, 2013 at 20:04
RolandoMySQLDBARolandoMySQLDBA
3,0551 gold badge20 silver badges25 bronze badges
1
I had the similar issue and found later that the encoding of my.ini file changes if you open that from notepad. Open the file from Notepad++ and make sure to take a note of the .ini file encoding (mostly it is UTF-8). If the file encoding changes SQL service will not start. Make sure that the new directory in which the data path is set has permissions for the account that runs the mySQLd service in windows (mostly it is network service).
answered Mar 19, 2020 at 20:28
1
The can’t read/write permission problem could be because mysqld.exe is already running. Consider terminating those processes via the task manager and then run your normal startup routine!
answered Jan 26 at 1:09
If you are using wamp on windows, you can start mysql from command line by :
cd wamp64
cd bin
cd mysql
dir
[check the version no of mysql]
cd mysql<version no>
mysql.exe -u root
This assumes that you have installed wamp at the root
answered Sep 2, 2016 at 1:05
KawaiKxKawaiKx
1,1132 gold badges9 silver badges15 bronze badges
1
In order to start manually the mysql serve you must run the mysqld executable. Open the command prompt and type:
shell> "C:Program FilesMySQLMySQLServerbinmysqld"
If mysqld doesn’t start, check the error log. The error log is located in the C:Program FilesMySQLMySQLServerdata. It is the file with a suffix of .err. You can also try to start the server as mysqld —console; in this case, you may get some useful information on the screen that may help solve the problem.
The last option is to start mysqld with the —standalone and —debug options. In this case, mysqld writes a log file C:mysqld.trace that should contain the reason why mysqld doesn’t start.
answered Oct 28, 2013 at 19:05
enryenry
1921 bronze badge
6
Problem Description:
I tried to start the newly installed MySQL server (V 5.5.15 on Windows Vista) using the mysqld command in the command prompt, but resulted the following error:
When I use mysqld command:
C:UsersPanora>mysqld
110914 16:23:02 [Warning] Can't create test file C:Program FilesMySQLMySQL Server 5.5dataPanora-PC.lower-test
110914 16:23:02 [Warning] Can't create test file C:Program FilesMySQLMySQL Server 5.5dataPanora-PC.lower-test
mysqld: File '.mysql-bin.index' not found (Errcode: 13)
110914 16:23:02 [ERROR] Aborting
110914 16:23:02 [Note] mysqld: Shutdown complete
C:UsersPanora>
When I use NET START command:
C:UsersPanora>NET START MySQL55
System error 5 has occurred.
Access is denied.
C:UsersPanora>
Additional notes:
(1) I’m able to start and stop the server using the MySQLWorkbench visual UI without any problems
(2) I’m able to stop the server using the command line without any problem using this command mysqladmin -u root -p shutdown
Solution – 1
This error is because of wrong permissions (denied). Check the user under which mysql is supposed to start and the permissions of the data directory.
Solution – 2
As the previous answer. This problem is because Windows Vista is restricting write to Program Files. And if you write it will only write to temporary files. You could try to turn off UAC but I would recommend to move the data folder to an other location. Not under program files.
Solution – 3
Open Command Prompt as administrator:
Then, you can start MySQL as shown below:
C:WindowsSystem32>net start MySQL80
The MYSQL80 service is starting.
The MYSQL80 service was started successfully.
In addition, you can stop MySQL as well:
C:WindowsSystem32>net stop MySQL80
The MYSQL80 service is stopping.
The MYSQL80 service was stopped successfully.
1. Причина проблемы: авторитет текущего операционного пользователя слишком низка, и операционный орган CMD должен быть изменен в качестве администратора!
1.1 Ошибка появилась ниже, показанная на рисунке ниже. Бедный я пробовал несколько раз. Сущность Сущность Сущность
2 Решение: изменить разрешения на работу CMD. Здесь есть два метода.
2.1 Метод 1: Сначала нажмите поиск в левом нижнем углу компьютера, введите CMD, а затем нажмите, чтобы запустить в качестве администратора, а затем напрямую введите сетевую остановку MySQL или NET Start MySQL в командной строке, чтобы открыть или остановить вашу базу данных.
2.2 Метод 2:
1. Все еще нажмите, чтобы сначала найти CMD, а затем нажмите, чтобы открыть позицию файла.
2. Справа -Нажмите командную строку, щелкните атрибут, нажмите «Дополнительно».
3. Проверьте как администратор, нажмите OK
4. Нажмите на приложение и, наконец, нажмите OK
5. (Обычно, если есть больше командных подсказок, вы можете исправить его на панели задач.) После нажатия командной строки вы можете запустить CMD в качестве администратора! В настоящее время введите сеть, запустите MySQL в командной строке, чтобы открыть ваш MySQL. Наконец, я желаю вам счастливого MySQL и надеюсь, что мы сможем расти вместе!
System error 5 occurred and access was denied when MySQL was restarted in CMD, as shown below:
This error is caused by insufficient permissions to operate CMD. The solution is as follows:
Enter CMD in the search bar of the start menu, right-click the search results, and select run as administrator!
If the frequency of CMD use is high, the following is a once-and-for-all method:
1. Right click on Cmd and select “Attend to Start Menu (U)” to find Cmd in Start Menu.
2. Right-click to select properties, select shortcut, then select advanced, select to run as administrator, and then click OK!
Just open the Start menu and click the shortcut above to run CMD as an administrator!
Net start mysql = net start mysql = net start mysql
In addition, some prompt that the server name is invalid
Different MySQL may have different names
Therefore, it needs to be modified to
Net start MySQL56