Web Hosting Talk







View Full Version : mysql problems


Omair Haroon
06-02-2001, 12:44 PM
I just installed the mysql using this

http://pkg.nl.cobalt.com/i386/RaQ3-RaQ4-MySQL-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/cobalt_uninstall_howto.html

but mysql is still over there..

what to do now ?

I am getting confused..


Thanks,
Omair Haroon

TheRazor
06-02-2001, 01:15 PM
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?

Omair Haroon
06-02-2001, 01:18 PM
you can see the uninstall instructions at

http://pkg.nl.cobalt.com/howto/cobalt_uninstall_howto.html

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



Thanks,
Omair Haroon

Omair Haroon
06-02-2001, 01:20 PM
here is what I get..


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


Thanks,
Omair Haroon

TheRazor
06-02-2001, 01:22 PM
Is that what your doing to try to uninstall or trying to login to mysql?

Omair Haroon
06-02-2001, 01:49 PM
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 ??

broken
06-02-2001, 02:00 PM
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

Omair Haroon
06-02-2001, 02:04 PM
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,

Omair Haroon
06-02-2001, 02:16 PM
anyone ???


Please..


Help me.!1!! :(


Thanks,

TheRazor
06-02-2001, 07:57 PM
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...

Omair Haroon
06-03-2001, 04:54 AM
how to uninstall it ??

Omair Haroon
06-03-2001, 05:48 AM
anyone please help me out..


please..


Thanks,

Omair Haroon
06-03-2001, 07:27 AM
anyone ????





Thanks,

TheRazor
06-03-2001, 08:09 AM
http://pkg.nl.cobalt.com/howto/cobalt_uninstall_howto.html

Omair Haroon
06-03-2001, 08:14 AM
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 ??

TheRazor
06-03-2001, 08:42 AM
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?

Omair Haroon
06-03-2001, 11:47 AM
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,

Omair Haroon
06-03-2001, 12:00 PM
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

jks
06-03-2001, 04:00 PM
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/

hvdm_20
06-04-2001, 09:54 PM
be nice everyone

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

msn or icq.: 17947284

Omair Haroon
06-05-2001, 01:40 AM
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,

Omair Haroon
06-05-2001, 01:59 AM
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,

Chicken
06-05-2001, 03:38 AM
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.

Omair Haroon
06-05-2001, 03:50 AM
got it..


Thanks,