MySQL

[DaBeeeenster]

ok sorry, i understand you are trying to help me. i've installed MYSQL properly, as instructed, through tutorials etc. the service starts (mysqld-nt.exe), the mysql admin works ok, but when i first run it it DOESN'T ask for a username or password...so if i try and set a password for mysql by doing the following it brings up "mysql: ERROR: unknown variable 'mysql.allow_persistent=On'", and it brings it up if i run mysql.exe with or without a statement. thanks

Ok. Almost there. That's still not enough information though.

What EXACTLY do you type into the command line, and what EXACTLY do you get out>?

[XA04]

Ok. Almost there. That's still not enough information though.

What EXACTLY do you type into the command line, and what EXACTLY do you get out>?

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\XtR0n Ak3R>cd C:\mysql\bin

C:\mysql\bin>mysql
mysql: ERROR: unknown variable 'mysql.allow_persistent=On'

C:\mysql\bin>mysql -u root mysql
mysql: ERROR: unknown variable 'mysql.allow_persistent=On'

C:\mysql\bin>


thanks

[killgORE]

kkk, any chance you would reinstall everything ?

use any uninstallers that came with your downloads.. there is a lot of ways to get php. mysql and apache, and a lot of ways that they are installed/uninstalled. If u remove all traces of your current installs and then REBOOT <- to be sure things are stopped.

Download this.

http://sourceforge.net/project/showf...group_id=93507

That bad boy will setup apache in c:\Apache2 and mysql in c:\mysql... and php is somewhere that it knows about. Importantly it will ask to replace your hosts file and your mysql config file. Just let it do whatever it wants.

Then.
Go to control pane/administrative tools/services and start mysql <- make sure that the properties of this service are pointing to the correct i.e NEWLY installed mysql exe (*-nt.exe). Then try and run the command line client.

Apache2 Triad has a very cut down version of mysql so all the admin etc extra exe's are missing. It should be possible to replace mysql later after it gets its own version to work.

good luck.

[XA04]

sorry, i don't want to cheat my way through doing this i want to learn how to do it the hard way so that i know how to do it, then yes maybe i will cheat and use the quick way but i would like to know how to set it up manually at least first...ive tried re-installing about 5 times now and it still doesn't work...same error, could this be something to do with winxp sp2?

[DaBeeeenster]

Try uninstalling mysql and then reinstalling it.

[XA04]

Try uninstalling mysql and then reinstalling it.

i already have like 5 times

[DaBeeeenster]

What version of windows? Oh, and where is mysql installed? It can cause problems on the Win32 platform if it is not in c:\mysql

[XA04]

What version of windows? Oh, and where is mysql installed? It can cause problems on the Win32 platform if it is not in c:\mysql

no mean to be rude but are you actually reading my posts? i already said that i re-installed 5 times, i said twice. and i said i had windows xp sp2 installed and if that was the problem maybe?, and if you saw what i typed in above you would see it was in C:\mysql, not meaning to be rude but i would prefer it if you would read my posts thanks

[DaBeeeenster]

Ok, OK. I dont have time to read everything; I am busy with work as well as reading the forums.

If you want to pay me £60/hour you can have my individed attention

I've no idea to be honest mate. Sounds like something is very screwed up.

When you connect with the front end, can you view data/create databases etc?

Maybe try something like "mysqlfront". Or another gui. It could be that the mysql client dlls are screwed

[XA04]

Ok, OK. I dont have time to read everything; I am busy with work as well as reading the forums.

If you want to pay me £60/hour you can have my individed attention

I've no idea to be honest mate. Sounds like something is very screwed up.

When you connect with the front end, can you view data/create databases etc?

Maybe try something like "mysqlfront". Or another gui. It could be that the mysql client dlls are screwed

ok thanks for the reply, i feel like formatting my system so i might just do that. if i do, shall i install apache then php then mysql, or apache then mysql then PHP?. on this setup i did PHP first and from searching for hours..i found the odd few things about it been PHP, so just taking a guess it must be something conflicting, allthough somebody told me that it won't be....

[Iain]

Install Apache, then PHP, then MySQL. Do you use the Win32 installer from www.mysql.com to install i.e. the one here http://dev.mysql.com/get/Downloads/M...m/pick#mirrors

If not then I suggest you go through the uninstall process again and install using that file, just accept all the defaults.

After some investigation it looks like the setting you mention is in php.ini which is confusing as there is no inherent link between PHP and MySQL. It may be that having Apache running is loading in the PHP .dll which is opening a persistent connection to MySQL for reasons I can't begin to fathom. Try stopping Apache and renaming the php4ts.dll (or php5ts.dll if you are using php5) to php4ts.old and then try accessing MySQL via the command line again.

[XA04]

Install Apache, then PHP, then MySQL. Do you use the Win32 installer from www.mysql.com to install i.e. the one here http://dev.mysql.com/get/Downloads/M...m/pick#mirrors

If not then I suggest you go through the uninstall process again and install using that file, just accept all the defaults.

After some investigation it looks like the setting you mention is in php.ini which is confusing as there is no inherent link between PHP and MySQL. It may be that having Apache running is loading in the PHP .dll which is opening a persistent connection to MySQL for reasons I can't begin to fathom. Try stopping Apache and renaming the php4ts.dll (or php5ts.dll if you are using php5) to php4ts.old and then try accessing MySQL via the command line again.

yes that is correct (the version of mysql, win32 installer etc), i tried stopping apache and trying again but still says the same thing..

[Iain]

Just to check, can you specify the exact versions where I have an x

Windows XP SP2
Apache 2.x
PHP 5.x
MySQL 4.0.x

[Iain]

Actually if your Apache was running and you shut it down but a persistent connection had already been opened then it may still have an effect. Try turning the Apache service to manual startup, then reboot and try MySQL again

[XA04]

Just to check, can you specify the exact versions where I have an x

Windows XP SP2
Apache 2.x
PHP 5.x
MySQL 4.0.x

sure,
Apache 2.0.50 (latest i think)
PHP 5.0.0
MySQL 4.0.20d - win32 installer(Latest safe version)

[Iain]

Apache 2 is not the recommended product for PHP, it's Apache 1.x that's the official version. That being said I've used Apache 2 in the past with no issues. My biggest guess would be something to do with PHP 5. Try using PHP4 and see if the issue exists.

You've pretty much reached the limit of my suggestions I'm afraid.