Please note, I already posted this on the MySQL official forum, but received
no response. I thought I'd try again in another location. My apologies to
anyone reading this twice...
Despite everything I've tried, I cannot get MySQL to start as a Windows
service. However, I AM able to get it started via the mysqld-nt --console
command.
Here is my (funky) setup:
- MySQL 5.0 on Windows XP SP2 development server
- datadir in my.ini file set to network path Z:/path/to/mysql/ (note the
forward slashes)
- This network drive is actually an external hard drive (via firewire) on my
workstation PC
Permissions are set accordingly:
- User "MyUserAcco unt" exists on BOTH server and workstation (with identical
passwords)
- MySQL service is set to run as "MyUserAcco unt"
- "MyUserAcco unt" has FULL permissions to access the local MySQL basedir and
the network datadir path
In short, I can execute:
mysqld-nt --console (with or without --standalone)
.... to get the server started. I enter the mysql command line and can see
all my databases from my network share. I then can verify through Task
Manager that the mysqld-nt service is running under the "MyUserAcco unt" user
(this is the default Windows user for my server).
I shutdown with:
mysqladmin -u root -p shutdown
Now I try to start the service using:
- net start mysql or...
- Windows Services console
.... and receive the following error:
"Could not start the MySQL service on Local Computer.
Error 1067: The process terminated unexpectedly."
Checking Windows Event Viewer gives me foggy error messages such as:
"Aborting" and...
"The MySQL service terminated unexpectedly. It has done this x time(s)."
I will gladly provide more information if needed, but I am completely
stumped at this point. Many thanks to any who can help me out with this.
- Kevin
no response. I thought I'd try again in another location. My apologies to
anyone reading this twice...
Despite everything I've tried, I cannot get MySQL to start as a Windows
service. However, I AM able to get it started via the mysqld-nt --console
command.
Here is my (funky) setup:
- MySQL 5.0 on Windows XP SP2 development server
- datadir in my.ini file set to network path Z:/path/to/mysql/ (note the
forward slashes)
- This network drive is actually an external hard drive (via firewire) on my
workstation PC
Permissions are set accordingly:
- User "MyUserAcco unt" exists on BOTH server and workstation (with identical
passwords)
- MySQL service is set to run as "MyUserAcco unt"
- "MyUserAcco unt" has FULL permissions to access the local MySQL basedir and
the network datadir path
In short, I can execute:
mysqld-nt --console (with or without --standalone)
.... to get the server started. I enter the mysql command line and can see
all my databases from my network share. I then can verify through Task
Manager that the mysqld-nt service is running under the "MyUserAcco unt" user
(this is the default Windows user for my server).
I shutdown with:
mysqladmin -u root -p shutdown
Now I try to start the service using:
- net start mysql or...
- Windows Services console
.... and receive the following error:
"Could not start the MySQL service on Local Computer.
Error 1067: The process terminated unexpectedly."
Checking Windows Event Viewer gives me foggy error messages such as:
"Aborting" and...
"The MySQL service terminated unexpectedly. It has done this x time(s)."
I will gladly provide more information if needed, but I am completely
stumped at this point. Many thanks to any who can help me out with this.
- Kevin
Comment