Hi Adrian,
On 8/25/06, Adrian Greeman <[EMAIL PROTECTED]> wrote:
"The security settings could not be applied to the database because the ......
I am pasting here the text of one of my earlier posts to this list:
--------------------------------------------
I got MySQL 5.0.22 running successfully on Win-XP-SP2 as follows:
1) Download the no-install zip package of MySQL-5.0.22 from the website.
2) Unpack it in the directory of your choice (C:\mysql5 - for example)
3) Create a top-level folder - C:\mysql5Data for the data directory.
4) Cut the contents of C:\mysql5\data directory and paste the same
into C:\mysql5Data.
5) Delete C:\mysql5\data directory.
6) Create a copy of an appropriate mysql-xxx.ini file and rename it to MY.INI.
7) Change the value of the data-dir variable to C:/mysql5Data - NOTE
FORWARD INSTEAD
OF BACK-SLASHES.
8) Create another top-level C:\InnoDBData folder.
9) Change appropriate InnoDB data-directory variables in C:\my.ini
(with forward slashes!)
10) Right-click MY COMPUTER icon on the desktop and select properties
from the shortcut
menu. Goto the Advanced tab and select Environment [Variables].
Select PATH in the \
system variables and add C:\mysql5\bin; at the beginning of it.
Apply and OK.
11) Select RUN from the start menu, type CMD and press ENTER.
12) Right click the C:\InnoDBData folder, select Properties from the
shortcut menu and
add "LOCAL SERVICE" user-account in the security tab and give it
"Full Control" access.
13) Do the same as in 12) with the C:/mysql5Data folder.
12) type mysqld-nt --install YourServiceName
--defaults-file=C:\mysql5\my.ini --local-service
and press ENTER.
13) type NET START YourServiceName AND PRESS ENTER.
Now you have MYSQL-5.0.22 installed on WinXP-Pro-SP2.
Forget about the automatic installer. I got similar errors like yours.
Additionally, I have found that the MySQL ODBC driver installs best
when you do it manually - that is, hand-copy files into the Windows
System32 directory. In addition, as I have found, it complains that
some MSVCR7.dll is missing. When I searched for the file on Google,
the search engine led me to some DllFiles.com (or some similar
webpage) where I got the file, downloaded the same to my computer and
everything worked like a cinch!
--
Asif
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
