MySQL

[XA04]

Hey all hope i have a good time in the forums...

Right...to make a long story short, on my apache server (win32), i've installed PHP sucessfully, but mysql is a different story...i've had problems with system service not starting etc...but i fixed all that...but i just need to make a root password, but when i try i keep getting this error: "mysql: ERROR: unknown variable 'mysql.allow_persistent=On'"

i've googled it and i can't seem to find anything usefull..

ask if you need more info...i know i've missed something out ...

PS: yes i've tried stoping the server to do it also...,and when i first launched winmysqladmin.exe it didn't ask for username or password, thanks.

+ im a n00b to MySQL don't know much about it..thanks

[killgORE]

Download a new version of MySQL.. that is so that u are working from a clean and new setup.

Then go to MySQL\bin and execute mysql-nt.exe <- if the server is not running.
Then run MySQL.exe when the server is up.

Then type..

GRANT ALL PERMISSIONS on *.* TO 'username' IDENTIFIED BY 'password' WITH GRANT ;

That gives ALL permissions to a user on all databases <- thats the *.* bit.
It is late.. I am tired. I think that is what you are looking for.
*edit*
erm.. more info available linky

best of luck

[XA04]

Download a new version of MySQL.. that is so that u are working from a clean and new setup.

Then go to MySQL\bin and execute mysql-nt.exe <- if the server is not running.
Then run MySQL.exe when the server is up.

Then type..

GRANT ALL PERMISSIONS on *.* TO 'username' IDENTIFIED BY 'password' WITH GRANT ;

That gives ALL permissions to a user on all databases <- thats the *.* bit.
It is late.. I am tired. I think that is what you are looking for.
*edit*
erm.. more info available linky

best of luck

alrighty, it is a fresh install but i can try downloading it off there site again..im using windows xp, sp2 <--- maybe sp2 is the problem?, hmm il try anyway

oh and which mysql download you recomend i use, installer, or manual? ty

[XA04]

still brings up "mysql: ERROR: unknown variable 'mysql.allow_persistent=On'"

[Iain]

it's mysqld-nt.exe not mysql-nt.exe

Use the win32 installer. Also, since you've had a previous install remove any directories that may still exist and run a search for my*.cnf to remove any lurking MySQL configuration files.

Once you've run the installer open a command prompt, navigate to the bin directory where you installed MySQL and run "msqld-nt.exe --install" without the quotes. This will set up MySQL as a service so it is always running whenever your PC starts.

If you still get the issue try copying the file my-small.cnf from your mysql install dir to the root of your c:\ drive and rename it to my.cnf.

If you still can't get it working uninstall PHP, MySQL and Apache and use WAMP from http://www.en.wampserver.com/

It will set up PHP5, Apache and MySQL 4 automatically and should solve your problem

hope that helps

[XA04]

it's mysqld-nt.exe not mysql-nt.exe

Use the win32 installer. Also, since you've had a previous install remove any directories that may still exist and run a search for my*.cnf to remove any lurking MySQL configuration files.

Once you've run the installer open a command prompt, navigate to the bin directory where you installed MySQL and run "msqld-nt.exe --install" without the quotes. This will set up MySQL as a service so it is always running whenever your PC starts.

If you still get the issue try copying the file my-small.cnf from your mysql install dir to the root of your c:\ drive and rename it to my.cnf.

If you still can't get it working uninstall PHP, MySQL and Apache and use WAMP from http://www.en.wampserver.com/

It will set up PHP5, Apache and MySQL 4 automatically and should solve your problem

hope that helps

ok, i did what you said...and it still isn't working, BUT i don't see any my-small.cnf files...i think its because im using the latest 'safe' version, anyway i don't want to use WAMP, i want to learn how to do it myself, for the future if need be, im only 14 and i don't want to cheat my way around things . il try an older version of mysql, but i don't think its the win32 installer but il have a little go, but please keep posting. thanks

ive been trying to use version 4.0.20d

[XA04]

tried manual install, same problem still

[XA04]

http://www.zend.com/manual/ref.mysql.php

the error is on that page, seems to be some sort of conflict with PHP, how can i fix this? this is really anoying the living hell out of me

[Iain]

MySQL is not connected to PHP in any way, there's nothing in either of the applications configuration files to link them together. What I'm trying to say is that if there is a problem then it must be in your MySQL setup.

Whenever I install it I just grab the latest stable windows installer (something like 4.2.x if I remember correctly). Then you just run that installer and off you go. The only time I've had issues is if you pick a different installation path other than the suggested one and then you need to modify your my.cnf file to point to the data folder.

Are you using the command line method to attempt to change the root password ? Or some other GUI tool ?

[XA04]

MySQL is not connected to PHP in any way, there's nothing in either of the applications configuration files to link them together. What I'm trying to say is that if there is a problem then it must be in your MySQL setup.

Whenever I install it I just grab the latest stable windows installer (something like 4.2.x if I remember correctly). Then you just run that installer and off you go. The only time I've had issues is if you pick a different installation path other than the suggested one and then you need to modify your my.cnf file to point to the data folder.

Are you using the command line method to attempt to change the root password ? Or some other GUI tool ?

command line

[XA04]

bump

[DaBeeeenster]

What is the exact error mate? If there is no config file, you can create one yourself.

In the installation on my laptop, I have the config file named as "my.ini" in the windows directory. Try that?

http://dev.mysql.com/doc/mysql/en/Option_files.html

[Iain]

Also, post up the exact commands you are using to create a root password and I'll have a look

[XA04]

the commands are just about anything, just running the program mysql its self, it brings up the error as i described above, the my.ini file is in the windows dir which i made for PHP, but it does say mysql stuff at the bottom...

[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data



[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-nt.exe

think mysql and PHP are conflicting maybe? thanks

[DaBeeeenster]

mate you are not being very clear here.

can you very carefully describe exactly what you do, in steps, and exactly what happens?

[XA04]

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