Page 1 of 4 1234 LastLast
Results 1 to 16 of 49

Thread: MySQL

  1. #1
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts

    MySQL

    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

  2. #2
    Commander Keen
    Join Date
    Nov 2003
    Location
    217.27.240.214
    Posts
    624
    Thanks
    0
    Thanked
    0 times in 0 posts
    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

  3. #3
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts
    Quote Originally Posted by 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
    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
    Last edited by XA04; 14-08-2004 at 04:29 AM.

  4. #4
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts
    still brings up "mysql: ERROR: unknown variable 'mysql.allow_persistent=On'"

  5. #5
    HEXUS.net Webmaster
    Join Date
    Jul 2003
    Location
    UK
    Posts
    3,108
    Thanks
    1
    Thanked
    0 times in 0 posts
    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

  6. #6
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts
    Quote Originally Posted by Az
    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
    Last edited by XA04; 14-08-2004 at 04:46 PM.

  7. #7
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts
    tried manual install, same problem still

  8. #8
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts
    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

  9. #9
    HEXUS.net Webmaster
    Join Date
    Jul 2003
    Location
    UK
    Posts
    3,108
    Thanks
    1
    Thanked
    0 times in 0 posts
    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 ?

  10. #10
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts
    Quote Originally Posted by Az
    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

  11. #11
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts
    bump

  12. #12
    Goat Boy
    Join Date
    Jul 2003
    Location
    Alexandra Park, London
    Posts
    2,428
    Thanks
    0
    Thanked
    0 times in 0 posts
    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
    Last edited by DaBeeeenster; 17-08-2004 at 09:00 AM.
    "All our beliefs are being challenged now, and rightfully so, they're stupid." - Bill Hicks

  13. #13
    HEXUS.net Webmaster
    Join Date
    Jul 2003
    Location
    UK
    Posts
    3,108
    Thanks
    1
    Thanked
    0 times in 0 posts
    Also, post up the exact commands you are using to create a root password and I'll have a look

  14. #14
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts
    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

  15. #15
    Goat Boy
    Join Date
    Jul 2003
    Location
    Alexandra Park, London
    Posts
    2,428
    Thanks
    0
    Thanked
    0 times in 0 posts
    mate you are not being very clear here.

    can you very carefully describe exactly what you do, in steps, and exactly what happens?
    "All our beliefs are being challenged now, and rightfully so, they're stupid." - Bill Hicks

  16. #16
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,668
    Thanks
    85
    Thanked
    13 times in 11 posts
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Another MySQL Help Thread
    By r1zeek in forum Software
    Replies: 2
    Last Post: 11-07-2004, 07:32 PM
  2. Hi Scores and leaderboards in mySQL?
    By MD in forum Software
    Replies: 2
    Last Post: 13-06-2004, 01:26 PM
  3. Newbie questions about phpBB and MySQL
    By Allen in forum Networking and Broadband
    Replies: 6
    Last Post: 24-04-2004, 06:53 PM
  4. MySQL Control Center
    By TooNice in forum Software
    Replies: 3
    Last Post: 17-01-2004, 10:06 AM
  5. PHP and MySQL
    By Kezzer in forum Software
    Replies: 4
    Last Post: 28-10-2003, 02:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •