Results 1 to 24 of 24

Thread: mysql problems

  1. #1
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455

    mysql problems

    I just installed the mysql using this

    http://pkg.nl.cobalt.com/i386/RaQ3-R...-3.23.37-1.pkg

    file.. and then telnetted and change the password..

    now I have forgotten the password..

    I tried uninstalling the mysql with the help of this tutorial..

    http://pkg.nl.cobalt.com/howto/cobal...all_howto.html

    but mysql is still over there..

    what to do now ?

    I am getting confused..


    Thanks,
    Omair Haroon
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  2. #2
    Join Date
    Apr 2001
    Posts
    69

    What did the uninstall instructions tell you?

    What did the uninstall instructions tell you to do?

    Also when you say mysql is still there do you mean?

    A) you can still see it in the cobalt pkg panel

    Or

    B) once you reinstall the pkg your old password is there and not the standard password?

  3. #3
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    you can see the uninstall instructions at

    http://pkg.nl.cobalt.com/howto/cobal...all_howto.html

    and I can still the see the mySQL package in the cobalt pkg panel..



    Thanks,
    Omair Haroon
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  4. #4
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    here is what I get..


    [root@www /root]# mysql
    ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)


    Thanks,
    Omair Haroon
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  5. #5
    Join Date
    Apr 2001
    Posts
    69

    ?

    Is that what your doing to try to uninstall or trying to login to mysql?

  6. #6
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    I am trying that to login..


    [root@www /root]# mysql
    ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
    [root@www /root]# mysql --user=root --pass=mypassword
    ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)


    any idea whats going on ??
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  7. #7
    Join Date
    Apr 2001
    Location
    New York
    Posts
    29
    Omair,
    If MySQL is indeed still installed;
    Check out the MySQL manual for instructions on how to reset the root pw:
    http://www.mysql.com/doc/R/e/Resetting_permissions.html

  8. #8
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    well, I am extremely new to it.. hence can't get it what the mysql documentation says..
    how do I kill the Pid or whatever ??

    Please help!


    Thanks,
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  9. #9
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    anyone ???


    Please..


    Help me.!1!!


    Thanks,
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  10. #10
    Join Date
    Apr 2001
    Posts
    69

    Alright...

    Well the easiest way I can think of while maybe not the quickest is...

    1st uninstall the mysql pkg...

    after it is uninstalled go into /home/mysql

    type rd -rf mysql (this deletes the mysql database, and all tables....

    verify by typing ls and making sure mysql is gone (keep in mind this all deletes all users, so if you have any existing database the users, and permissions will be wiped out for them as well...)

    then do a reinstall of the pkg... That will get you back to your install admin password... if someone else has another way, that is quicker or easier join in...

    hope it helps...

  11. #11
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    how to uninstall it ??
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  12. #12
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    anyone please help me out..


    please..


    Thanks,
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  13. #13
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    anyone ????





    Thanks,
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  14. #14
    Join Date
    Apr 2001
    Posts
    69

    go here for directions on how to uninstall a pkg


  15. #15
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    Can't locate the uninstaller file in the uninstallers directory..

    and when I tried to install mysql again, the control apnel is giving an error that the file could not complete the installation..

    and I just installed WebAlizer..

    can any one help me out ?

    Please ??


    Thanks

    P.S: I emailed Tera Byte for my ips 3 days before, but have'nt got a reply from them yet..

    god knows whether they are alive or dead ??
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  16. #16
    Join Date
    Apr 2001
    Posts
    69

    I'm going to have to get back to you

    I will have to get back to you on mysql.... If I am not mistaken that with a raq4i from 4webspace that you only get one ip with the box and you have to order them in blocks of 30 for $10 bucks... at least that is what the sales rep told me?

  17. #17
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    Hello,

    The Razor, I have got a Raq3.
    Could you please contact me through

    ICQ: 44359020
    MSN: Omairharoon@hotmail.com
    AIM: CreativeOmair
    Yahoo!: SimplyOmair

    I emailed steve at steve@tera-byte.com that my tickets have not been replied but still no response from those guys.

    Please help me out in installing mySQL.

    This is what I get when I type mysql logged in as root

    [root@www /root]# mysql
    ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m
    ysql.sock' (111)

    Anybody ??

    Please ??


    Thanks,
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  18. #18
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455

    Re: Alright...

    Originally posted by TheRazor
    Well the easiest way I can think of while maybe not the quickest is...

    1st uninstall the mysql pkg...

    after it is uninstalled go into /home/mysql

    type rd -rf mysql (this deletes the mysql database, and all tables....


    are you sure

    rd -rf mysql is the right command ??


    and why is cobalt giving an error when i try to install the mysql package file again ??


    Thanks,
    Omair Haroon
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  19. #19
    Join Date
    Apr 2001
    Location
    Denmark, Europe
    Posts
    614
    Probably a typo - he meant "rm" instead of "rd".

    Please beware that this is a very dangerous command.


    --
    Jens Kristian Søgaard, Mermaid Consulting I/S,
    jens@mermaidconsulting.dk,
    http://www.mermaidconsulting.com/

  20. #20
    be nice everyone

    if you need help with install mysql
    contact my at hansm@dds.nl

    msn or icq.: 17947284

  21. #21
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    well,

    guys eventually, I was successful in installing mysql and php.

    but through telnet

    all I want is you guys to verify it..
    by going to

    http://216.234.186.28

    Thanks,
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  22. #22
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    and onething i want to ask is that

    localhost

    is the localhost that I have to enter when I should connect to the mysql database through php ?


    and anyone knows how to enable asp_tags in php ?

    Thanks,
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

  23. #23
    Join Date
    Jun 2000
    Location
    Southern California
    Posts
    12,136
    Disclaimer: I know very little about any of this so if this isn't helpful, you'll know why.

    localhost - from what you asked I'd say yes, and generally you'd just leave it as 'localhost' unless you are going to connect to a different machine.
    HostHideout.com - Where professionals discuss web hosting.

    • Chicken

  24. #24
    Join Date
    Feb 2001
    Location
    Pakistan Baby!
    Posts
    455
    got it..


    Thanks,
    36Host.com - reliable & affordable web hosting
    * Providing Affordable Small Business Web Hosting since 2003! *

Posting Permissions

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